Hi All,
I have got a new project that requires me to build a BI tool capable of following:
1) What if analysis scenarios
2) Dynamically change data and results (example: extra hours, more incentives, see how new paycheck looks if hours are increased and so on)
3) Roll back the calculations if not fitting the bill
For this I chose SQL Server SSAS feature and want to build great dashboards in ASP.NET website (No SharePoint, licensing issues)
First of I want to know if I have made the right decision or should I choose some other technology.
If I am write, how do I change the SSAS cube dimension values dynamically at runtime to see varied results. Please guide me I am totally new to SSAS.
Example of what I have to build :
https://www.anaplan.com/
Go to the complete details ...