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 |