Skip to main content
F
FM26
Newcomer
August 22, 2022
Solved

Cube View column difference issue

  • August 22, 2022
  • 1 reply
  • 0 views

Hello,

 

I have this cube view that I made, in which I am having issues in the secon to last column. I am trying to see what the difference between each quarter is between the forecast and budget scenarios.
When I run my cube view, I get a single difference between Q1 forecast and Q1budget only, and Q2 trough Q4 are nowhere to be found. I was expecting that what I typed would give me the difference between each quarter, not just the first.

FM_0-1661199146063.png

FM_1-1661199165809.png

 

FM_2-1661199182448.png

FM_3-1661199199639.png

 

 

Can you share what your thoughts on what I am doing wrong please?
Your time and input is appreciated in advance!

Best answer by db_pdx

Hi FM: modify your last column block (FYDELTA) to be Time: T#POVYear.Quarters, Scenario: GetDataCell(BWDiff(S#Fcsts, S#Budget)):Name(Variance)

That should give you the member expansion for all quarters while also calculating the variance.  In general, the CVC's are column block specific and do not work well with member expansions.

Cheers,    -db

1 reply

D
db_pdxAnswer
Contributor
August 22, 2022

Hi FM: modify your last column block (FYDELTA) to be Time: T#POVYear.Quarters, Scenario: GetDataCell(BWDiff(S#Fcsts, S#Budget)):Name(Variance)

That should give you the member expansion for all quarters while also calculating the variance.  In general, the CVC's are column block specific and do not work well with member expansions.

Cheers,    -db

    F
    FM26Author
    Newcomer
    August 23, 2022

    db_pdx , Thank you for explaining that to me. It works great now and definitely shows the results as intended! Have a great day.

    Terms & ConditionsAccessibility statement