Variance Analysis in Cube View
I'm working on a cube view that does a variance analysis between 2 difference scenarios. The scenarios will always vary based on the scenario member selected by the user.
Some of the rows use the f...
Forum Discussion
Hi CCI01
I've worked on a few VAR analysis reports - might have some ideas we can try.
Can you share a small snippet of your report? Just wanna see the rows & columns.
Solution1:
Have you tried using this as your member filter? Set you dimension to 'scenario' and insert this expression.
You can replace S#Scenario with your scenario parameter that you built.
GetDataCell(S#Scenario1-S#Scenario2):Name(Difference)and, create a new member line, add all accounts underneath it.
For Example -
Solution2:
I see your Col4 is calculate by dividing col3/col2. Please confirm
So maybe try --
GetDataCell(Divide(CVC(Col3Name),CVC(Col2Name)))CVC for columns, and CVR for rows.
Example: