hello to all! I am developing a data warhouse as my final year project. I have made my star schema succesfully. Now i want to make a query interface for end users so that they run their desired queries. But i am unable to understand that what type of interface should i provide them so that they can run parameterized queries? I think about interface like ms access but that is so complex to implement . Please guide me about developing the interface.
For example end user want to know that how much total fee was collected from students of bscs program in year 2012.
Manually it is so easy to write these queries for us developers. But what interface should we provide to end users?
Note: i am using java programming language and sql server 2008