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

MitPower01's avatar
MitPower01
New Contributor II
2 years ago
Solved

Looking for sample Excel Add-in function XFGetMemberInfo for Account

I tried using this function to pull the account description but keep getting an error.  I'm sure because I am using the wrong fields.  I looked for samples but can't find any.  XFGetMemberInfo Thi...
Excel Add In
  • aricgresko's avatar
    aricgresko
    2 years ago

    XFGetMemberInfo only has 3 arguments.  If you wanted the description for an account called "Revenue", you would use this syntax.
    =XFGetMemberInfo("Description","Account","Revenue")

RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
2 years ago

For those who find this looking for the same thing, here is the correct API:
XFGetMemberInfo(string memberInfoType, string dimTypeName, string memberName)

Valid options for memberInfoType:

Currency
CurrencyId
Description
DimId
DimName
Id
Name
NameAndDescription
NameOrDescription

 

Valid options for dimTypeName :
Note: DimTypeId in parentheses is just for reference, don't include it in XFGetMemberInfo:

Entity (0)
Consolidation (1)
Scenario (2)
Time (3)
View (4)
Account (5)
Flow (6)
Origin (7)
IC (8)
UD1 (9)
UD2 (10)
UD3 (11)
UD4 (12)
UD5 (13)
UD6 (14)
UD7 (15)
UD8 (16)

 

  • WillVitale's avatar
    WillVitale
    Contributor II
    1 year ago

    Hey Robb,

    Is there way to pull the "Text" section using XFGetMemberInfo? Like any of the Text 1 to Text 8 fields?

    Thanks,

    Will