Forum Discussion

DDrider's avatar
DDrider
New Contributor III
3 months ago

Retrieve member values from GetDataCell using Dynamic Calculation?

I have a UD8 dynamic calculation that returns different results based on the UD2 member value. E.g. If UD2 = Houston, return "A#:Total_Expenses:S#Plan...."

This works well using api.pov.UD2.Name for normal member intersections, but it's not applying correctly for GetDataCell calculations. By using the Cell POV button on the cube view, I can see that the GetDataCell rows have a POV set to the cube view POV. How can I have my Dynamic Calc read the UD2 value inside the GetDataCell?

There is only one UD2 member referenced inside the GetDataCell. The GetDataCell format is as follows: GetDataCell(A#Total_Expenses:S#Actual:U2#Texas - A#Operating_Expenses:S#Actual:U2#Texas):name(Net Texas)

Cube View
Reports
  • KarlT's avatar
    KarlT
    Contributor III
    3 months ago

    You could possibly use a row override in that column and add the UD8 dynamic member into your get data cell.