Populate Description of Prompted Member Instead of Name
I am creating a dashboard that compares two different scenarios (one of which is the prompted scenario). I want the header of the chart to display the description of the member instead of the name (i.e., "Forecast 3+9" instead of "FORECAST_3_9." If I input the prompt name into the description field ("|!Prompt_Scenario!|") it will return the name. Is there any way to update this to populate the description instead?
Try using the XFMemberProperty function:
XFMemberProperty(DimType=Scenario, Member=|!Prompt_Scenario!|, Property=Description)
Hope this helps.
