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

DRider's avatar
DRider
Icon for OneStream Employee rankOneStream Employee
1 year 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)

1 Reply

  • KarlT's avatar
    KarlT
    Icon for OneStream Employee rankOneStream Employee

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