I'm looking for a control that I can put on top of an already existing OLAP star schema to allow the user to define their own "queries" and generate reports. Right now I have some predefined reports built on top of the cubes, but I'd like to allow the user to define their own criteria based on the cubes that I've created. I've found lo...
I will start a reporting tool for some local ERPs about sales, invoices, orders, customers, inventory, etc. I wonder if exist a sample schema appropriated for this case (in star or snowflake form) so I can have a solid foundation. I have understanding about basic BI desing, but taking in account this is a common problem, I wonder if ex...
I'm trying to create an OLAP Cube in Project Server based on a snowflake schema. I'm doing this programatically on the OnCubeBuilt event. I'm not using anything strictly related to Project Server, only the classes in the Microsoft.AnalysisServices namespace, but I wanted to be clear about what I'm trying to implement. Has anyone worked w...