dbTalk Databases Forums  

How to do 'Forecasting' & 'What-if Analysis' with MSAS ?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss How to do 'Forecasting' & 'What-if Analysis' with MSAS ? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kristanto
 
Posts: n/a

Default How to do 'Forecasting' & 'What-if Analysis' with MSAS ? - 02-23-2005 , 11:08 PM






Hi All,

So far the MSAS application/cube I develope only the typical slice &
dice into multidimensional summarized data.
I read somewhere that another type of OLAP application is :
'Forecasting' & 'What-if Analysis'.

Could any body here pls give me some starting point :

1) How can I create 'Forecasting' & 'What-if Analysis' with MSAS2k ? is
there any articles/docs/tutorial/book somewhere ?

2) does that 'Forecasting' & 'What-if Analysis' application depend on
the client application ?
(currently I use Crystal Analysis 9/10, but I am considering Excel
Add-In)

Thank you very much for your help.

regards,
Krist

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote
  #2  
Old   
Ajit Singh
 
Posts: n/a

Default Re: How to do 'Forecasting' & 'What-if Analysis' with MSAS ? - 02-26-2005 , 07:46 AM






Using Linear Regression MDX functions for forecasting

http://www.mosha.com/msolap/articles/mdxlinreg.htm

Something to get you started.

Ajit Singh
www.hostanalytics.com


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.