The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

CCI01's avatar
CCI01
New Contributor
4 years ago

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...
Cube View
Mustafa_A's avatar
Mustafa_A
Contributor II
4 years ago

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: