Forum Discussion

pratyaydas's avatar
pratyaydas
New Contributor
2 months 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 ?

Excel Add In

1 Reply

Sort By
  • chul's avatar
    chul
    Contributor III
    2 days ago

    These are the settings for the fields in the XFGetMemberProperty formula that work for what you're trying to return.

    DimTypeName: Dimension type (e.g. Entity)

    MemberNameOrScript: Member name (e.g. Houston)

    PropertyName: Property you're retrieving (e.g. Text2)

    VaryByCubeTypeName: Cube type (e.g. Standard)

    VaryByScenarioTypeName: Scenario type (e.g. Actual)

    VaryByTimeOrTimeDimProfileName: Time (e.g. 2023)

    My 2023 formula is shown in the formula bar. 2022 works the same except it uses 2022.