Excel Add-in Member Description using XFGetMemberInfo
Originally posted by Karen Liau How do retrieve Account member description when using Spreadsheet XFGet info formula?
Forum Discussion
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
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!
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
