Forum Discussion

JenJessel's avatar
JenJessel
New Contributor III
3 years ago
Solved

Cube Views with multiple GetDataCell formulas

I am trying to create a Cube View that has 2 GetDataCell formulas.  The formulas work separately but if I add them both to the same Cube View, one will not work.  I am using XFBR in Columns (Time) and GetDataCell in Rows (Accounts).  Is there a way both formulas will work in the same Cube View?

 

 

 

Methodology
  • JackLacava's avatar
    JackLacava
    3 years ago

    Ok, if both produce results rather than expanding members, only one of the two can "win". The priority should be (from lowest to highest) POV -> Columns -> Rows -> Column's Row-Overrides -> Row's Column-Overrides . I don't know if the XFBR messes with things somewhat.

3 Replies

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    3 years ago

    Ok, if both produce results rather than expanding members, only one of the two can "win". The priority should be (from lowest to highest) POV -> Columns -> Rows -> Column's Row-Overrides -> Row's Column-Overrides . I don't know if the XFBR messes with things somewhat.

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    3 years ago

    Er, yes, there is no limit to the number of formulas you can have, as far as I know... I think we'll need more details to help further. Can you post a screenshot of your columns and rows definitions that don't work, specifying which one fails?

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

    Yes, below is the column and row definition I am using.  Individually they both work but if I put them in the same cube view, it picks up the column formula not the row.