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
kmd
3 years agoContributor II
Cube View - Row/Column Intersection calculation using GetDataCell() and CVRC()
Looking for anyone who has used the CVRC() function successfully in their Cube Views.
If so, is there anything special you are doing with the syntax for the Row or Column Index #?
According to the OS documentation, I should be able to simply do this: GetDataCell(CVRC(RowName,RowIndex,ColumnName,ColumnIndex).... ETC.)
Example: GetDataCell(CVRC(MyRowA,1,MyColA,2) + CVRC(MyRowB,2,MyColD,4)
But even with the most basic test cube view, the result is always giving me an Invalid Index error.
Is there some special way to express the row or column Index # that I'm missing here?
Thanks in advance for any advice
1 Reply
- kmdContributor II
Please ignore - I discovered the issue and as it turns out, I managed to get this resolved using a different method.
Related Content
- 2 years ago
- 1 year ago
- 2 years ago