Skip to main content
D
DRider
September 25, 2024

Retrieve member values from GetDataCell using Dynamic Calculation?

  • September 25, 2024
  • 1 reply
  • 0 views

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)

1 reply

K
KarlT
October 3, 2024

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

Terms & ConditionsAccessibility statement