XFGetMemberProperty
Hi Team,
How does XFGetMemberProperty works in Excel AddIn?
The fields in the formula I have are -
MemberNameorScript
PropertyName
VaryByCubeTypeName
VaryByScenarioTypeName
VaryByTi...
Forum Discussion
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.