May 21, 2009 at 6:34 am
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.
May 21, 2009 at 7:38 am
am pretty sure that the OLAP Add In for Excel 2003 had some what-if capability. not sure if this mad eit across to office 2007, you'd have to check the context menu.
There are definitely ways to process subcomponents of the cube, such as Dimension:Refresh; or a single partition from a measure group. This is but one of the many pages on msdn that has info on the subject.
Steve.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply