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

Ioana's avatar
Ioana
New Contributor III
3 years ago

Cube view check rows

Hello,

I have a question in regards to cube views - I have multiple rows in the report, some of them including member extensions, and I am gonna write here an example:

Row 1: A#Rent

Row 2: A#Penalties.Children

Row 3: A#OPEX

Check that I want to make: GetDataCell(CVR(Rent) + CVR(Penalties) - CVR(OPEX)):name(Check)

Instead of getting 0 on the check row, I get to have a difference due to tha fact that the formula only takes into consideration the first child of Penalties, ignoring the rest of the children.

How to accomodate/change the formula in order to have all the children into consideration?

 

Thank you,

Ioana

Cube View

2 Replies

  • Cosimo's avatar
    Cosimo
    Contributor II
    3 years ago

     Hi Ioana,

    Unless I'm missing something, just do the math with the 3 accounts in your Check row with a GetDataCell:

    GetDataCell(A#Rent + A#Penalties - A#OPEX):name(Check)

  • Sai_Maganti's avatar
    Sai_Maganti
    Contributor II
    3 years ago

    Maybe you should use

    Row 2: A#Penalties, A#Penalties.Children

    OR do another row for A#Penalties.Children