Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
4 years ago

Excel Add-in Member Description using XFGetMemberInfo

Originally posted by Karen Liau How do retrieve Account member description when using Spreadsheet XFGet info formula?
Excel Add In
OSAdmin's avatar
OSAdmin
Valued Contributor
Originally posted by David Baumgartner

Hi Karen:

Formula structure is:

=XFGetMemberInfo(memberInfoType,dimTypeName,memberName)

 

Example using my company's environment:

=XFGetMemberInfo("Description","Account","AC_400000")   = "NET SALES"

 

The syntax for memberInfoType is not readily apparent, but can be viewed in the Grid View of any Dimension.  To get there, go: Application > Dimensions > (select your dimension) > Grid View > Grid Settings.  You'll see the naming convention here.

 

Additional formula documentation is available in the Design and Reference Guide under the "Navigating the Excel Add-In" section, but its a bit sparse.

 

- Dave

 

jakefells's avatar
jakefells
New Contributor
3 years ago

Hello - Is there a way to retrieve an alternate description using this (or another) formula, such as a different culture?  I'm looking for a solution to alternate account descriptions in a file that uses XFGetCells.  Thank you!

  • Martin_Gebhartl's avatar
    Martin_Gebhartl
    New Contributor III
    3 months ago

    Sorry to dig in the past: did you find a solution for this? We are searching for a way to setup excel files so that for example the account description is displayed on the culture setting.

     

    Regards

    Martin