Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sagaryvm
Starting Member
2 Posts |
 Posted - 2009-05-21 : 08:16:40
|
| Hi Friends,We are using SQL Server 2008 Enterprise edition. I had a requirement to provide users 'what-if analysis/simulation' on the multidimension data cube(MOLAP). I have searched in net to find out a solution for this but couldn't get any solution. Is there is any tool(third party tool is also fine) which can provide this functionality.And also want to know if there is any possibility to partially process the cube based on one dimension(as processing the entire cube consumes a lot of time every time). If it is possible, pls let me know how is it possible.Any help/suggestion is highly appreciated.Thanks & Regards,Sagar. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-22 : 04:44:32
|
| can you elaborate on what all you mean by 'what-if analysis/simulation'? |
 |
|
|
sagaryvm
Starting Member
2 Posts |
Posted - 2009-05-22 : 06:50:04
|
| Hi,Briefing my requirement:We have a multidimensional cube(MOLAP) which hold various projects related fact data like Budgeted man months, Actual man months, Budgeted travel cost, Actual travel cost, Overall Score, etc..And the dimensions are Projects, Employees, Locations, Time, Service type, etc...Using this data user want to simulate and analyze the data by changing some of the above data and see the overall score of the project. And user wants to have multiple simulation like Simulation 1, Simulation 2, Simulation 3, etc without changing the base data for the project.I wanted to know if this kind of functionality can be provided by any tool.I am thinking an alternative approach like: if we add the required simulation in the data base and process the cube only for the required project (thru .Net code). Pls suggest if this is possible and is this is a good approach for this requirement.Thanks & Regards,Sagar. |
|
|
|
|
|
|
|
|
What-if Analysis/simulation on the data cube