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

Nitishkrish16's avatar
Nitishkrish16
New Contributor III
2 years ago

Can we define a column/row range in a GetDataCell?

Hey folks,  We have a requirement to define range of rows in a GetDataCell. For example: GetDataCell(CVR(Row1) + CVR(Row2) + CVR(Row3)..... CVR(Row100)) Instead of defining it manually till Row10...
Cube View
Reports
BenThompson's avatar
BenThompson
New Contributor III
2 years ago

Hello Nitishkrish16 ,

I am interested to hear what others have to say on this.  If this is something they use multiple times, would it be better to just create an alternate hierarchy for the aggregation of those specific accounts?  That way the client can also adjust it in the future easily.  

Just a thought,

Ben

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

This is really the right answer. As soon as one has to manually define 100 rows in a CV, one is in "we're doing it wrong" territory. It's better to create an alternate hierarchy; as well as being easier to reference and maintain, it will likely be faster to display in Cube Views.

  • phollander's avatar
    phollander
    New Contributor III
    2 years ago

    Agreed, although I am not sure if the 100 row count in a Cube View was just an example or a real-life case, as that would be quite an extreme amount of rows for one definition. One issue with the use of an alternate (account) hierarchy is when the underlying children are set up as DynamicCalc. In that case, I believe you will need to have a DynamicCalc on the top parent of the hierarchy to sum of the retrieved amounts of its children (might be different ways of dealing with this, but the point is towards DynamicCalc as part of a roll-up).

    For most use cases, using an alternate hierarchy is the way to go.