dbTalk Databases Forums  

Is possible to do What if.. ?

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


Discuss Is possible to do What if.. ? in the microsoft.public.sqlserver.olap forum.



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

Default Is possible to do What if.. ? - 02-19-2006 , 06:30 AM






Hi,
I am new to Analisys Services. I have made a cube
where i have computed the value of sales on severals dimensions,
like quarter of year, Customer, ArticleID,....

I'd like to do an analisys like this:
- If I change (+ or -10% for example) the price of article xyz
what appens to my business ?
So I'd like ho change the price of article xyz in the cube (not in
underlying DB !) ad recalculate the cube.
But now if i recalculate the cube SQL Server takes the official
price of article xyz, not the price I am simulating.

Is possible to do an analysis like this?
If possible, can anyone get me a tip to begin ?
Thanks in advance
Gianluca

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.