Forum Discussion

pratyaydas's avatar
pratyaydas
New Contributor
3 days ago

XFGetMemberProperty

Hi Team,

How does XFGetMemberProperty works in Excel AddIn?

The fields in the formula I have are -

  • MemberNameorScript
  • PropertyName
  • VaryByCubeTypeName
  • VaryByScenarioTypeName
  • VaryByTimeorTimeDimProfileName

I want to pull the properties for Text 1 to Text 8 from OneStream Production for Entity, for different Time Periods like Default, 2023, 2024 and 2025.

Now the properties I pulled at Default are giving correct result.

But when trying to pull at year level like 2023, 2024 and 2025, I am not getting the correct data. It is only showing the data present at Default.

But in OneStream Prod, I do have data in 2023, 2024 and 2025 for the Text Tags.

In my formula, I was setting VaryByTimeorTimeDimProfileName = "2023". And so on for 2024 and 2025

I am getting the same thing for XFGetMemberPropertyVolatile formula as well.

In OneStream my year values are stored in 'Stored Property Value'

Can someone please help me here ?

No RepliesBe the first to reply