You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Map Smart List in BSO to Dimension in ASO - Text Account Display as Text not Essbase ID

Accepted answer


We are exploring the use of the functionality to map a Smart List to an ASO dimension via data map so that a report can be pulled in Management Reporting using the Smart List values as metadata members. This proof-of-concept setup is working for the most part, but a couple of the needed accounts are text/comment accounts. For these accounts, the Essbase numerical ID is showing instead of the text value when pulling an ad hoc or the report.

Content (required):

Once the data map runs to map the Smart List over to the ASO cube's dimension, it appears that the text is being reverted back into the Essbase text ID values at the Planning layer. Is there any way to map the Smart List to an ASO dimension while still supporting the display of text instead of the numerical ID? I considered trying a member formula on another member to perform the reverse of [[PlanningFunctions.getIdForString("text")]], but I did not find a suitable function and was not even sure if this would be workable anyways. Thanks in advance for any support

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!