Run scenarios on the information coming out of SSAS 2005 cube - Analysis Services

Learn Microsoft BI Forum Core Servers Analysis Servic... Run scenarios on the information coming out of SSAS 2005 cube

5/21/2009 7:18 PM

	Qazafi
51 posts

Run scenarios on the information coming out of SSAS 2005 cube

Hi All

I am just wondering is it possible so that we could run scenarios on the information coming out of SSAS 2005 cube. What I am looking for actually, I have some information coming out of cube and my user are using Excel 2007 as a client tool. They would like to run different scenarios on the information coming out of cube to see what will be the impact.

For Example

If you have measure called

Current Interest Rate and you would like to know what could be your Future Interest rate based on different scenarios on Current Interest Rate. Is it any way I could achieve this using Excel 2007 with SSAS 2005 cube

I really appreciate your help

Many thanks

Qazafi

5/27/2009 6:57 PM

	cutley
363 posts

Re: Run scenarios on the information coming out of SSAS 2005 cube

Have you looked at the Data Mining Add-ins for Office 2007? If you use these there is a Scenario Analysis button added to Excel. I am not a data mining expert so I don't know if it will meet your needs but you should try it out.

Page 1 of 1

Learn Microsoft BI Forum

Core Servers

Analysis Servic...

Run scenarios on the information coming out of SSAS 2005 cube