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
Solved
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...
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
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
