Forum Discussion

FM's avatar
FM
New Contributor III
3 years ago

Cube View math operation error

I have a cube view where some of the mathematical operations in the last two columns on the right ( Difference and Percent Difference) are not working. The formula that I have in these last columns i...
Cube View
  • db_pdx's avatar
    db_pdx
    3 years ago

    Hi FM: this is a common issue where you have two GetDataCell calcs that will have a conflicting intersection. To have the report displayed correctly you'll need to tell OneStream to do a Row Override (or column override depending on the situation).

    From the Difference column of the report layout, select Row Overrides.  Specify the row names in the section called Row Range (Row1, Row5) and repeat your formula in the Member Filter: GetDataCell(BWDiff(CVC(OP) ,CVC(Actual)))

     

    The above is the easiest way to solve this reporting issue, but are other potential ways to solve this:

    Create a real hierarchy parent for those combination of accounts, use the real member in the cube view selection

    Create DynamicCalc accounts that performs the math in the dynamic account, use this dynamic account member in the cube view selection

    Create DynamicCalc U8 members that perform the scenario comparison math

     

    Lastly, if you want to learn more I remember there is an Academy Training on Cube View Overrides that might be helpful to review.

    Cheers,

    -db

db_pdx's avatar
db_pdx
Valued Contributor

Hi FM: this is a common issue where you have two GetDataCell calcs that will have a conflicting intersection. To have the report displayed correctly you'll need to tell OneStream to do a Row Override (or column override depending on the situation).

From the Difference column of the report layout, select Row Overrides.  Specify the row names in the section called Row Range (Row1, Row5) and repeat your formula in the Member Filter: GetDataCell(BWDiff(CVC(OP) ,CVC(Actual)))

 

The above is the easiest way to solve this reporting issue, but are other potential ways to solve this:

Create a real hierarchy parent for those combination of accounts, use the real member in the cube view selection

Create DynamicCalc accounts that performs the math in the dynamic account, use this dynamic account member in the cube view selection

Create DynamicCalc U8 members that perform the scenario comparison math

 

Lastly, if you want to learn more I remember there is an Academy Training on Cube View Overrides that might be helpful to review.

Cheers,

-db

FM's avatar
FM
New Contributor III
3 years ago
db_pdx
Thank you very much for your explanation and for taking the time to explain this to me. 
Have a great day!