Retrieve member values from GetDataCell using Dynamic Calculation?

DDrider
New Contributor III

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)

0 REPLIES 0