Forum Discussion

NHarington's avatar
NHarington
New Contributor
2 months ago

Dynamic Calculations inside a nested member

Hello,

I am new to building cubes in OS, I am attempting to build a calculated column based on data from two other columns, I have created a nested member which correctly brings in all the data. When I attempt do use GetDataCell I return errors that it cannot find my named Column.

In the screenshot you can see the member filters (highlighted are the same rows)

Here you can see the output when I run the cube view.

Please let me know if I cannot reference in this way and how I may solve the problem

Cube View
  • T_Kress's avatar
    T_Kress
    Valued Contributor
    2 months ago

    I have not written a GetDataCell in a cube view in a while but I believe the name in your formula is not the name that you called it after :Name but instead the actual column or row name in your cube view: