I need one help regarding one requirement ,would appreciated if you can help me on this.
Requirement :- Sensitivity Analysis
Customer want to have one report where he should see the change in Crude oil price impact on the over all revenue .
Like If Crude oil Price is 85 $ ; 80 $ , 75 $ , 70 $ 65 $ what would be the impact ( set of accounts like Totals Sales , COGS , Net Profit etc)
Can you pls suggest the way of handling it .
I am thinking to add these variables in one Dimension(say Future 1) since in report i want these on Column and Account members( P & L) in Row.
Kindly suggest if there is any easy way of achieving this
Better post this in Planning & Budgetting forum.
You can calculate them using scenarios(whatif) or member formulas incase if there are any dependant values on the price etc..