Forum Discussion

FM's avatar
FM
New Contributor III
3 years ago

Cube View column difference issue

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...
Cube View
  • db_pdx's avatar
    db_pdx
    3 years ago

    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

db_pdx's avatar
db_pdx
Valued Contributor
3 years ago

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

  • FM's avatar
    FM
    New Contributor III
    3 years ago

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