Map Smart List in BSO to Dimension in ASO - Text Account Display as Text not Essbase ID
Summary:
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