Forum Discussion

Nitishkrish16's avatar
Nitishkrish16
New Contributor III
11 months 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

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

Nitishkrish16's avatar
Nitishkrish16
New Contributor III
11 months ago

Hi BenThompson , 
This is such an amazing idea!! But, few accounts used here are dynamic. So it would create complexities if the alternate hierarchy is created. Thanks a lot for your input 🙂