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 ?