Retrieve member alias for my DataExport File through DataManagement
SummaryRetrieve member alias for my DataExport File through DataManagement
I need to export on my data export to file, via Data Management, the member alias of my Scenario.
I am using this link as a reference : https://john-goodwin.blogspot.com/2019/09/data-managementfdmee-extracting-data.html
However i am not being able to retrieve the alias. Any sugestion of what am I doing wrong?
(SELECT DISTINCT ALIAS FROM AIF_TARGET_APPL_MEMBERS WHERE DIMENSION_ID = (SELECT DIMENSION_ID FROM AIF_TARGET_APPL_DIMENSIONS WHERE APPLICATION_ID = (SELECT APPLICATION_ID FROM AIF_TARGET_APPLICATIONS WHERE APPLICATION_NAME ='NewAPP') AND TARGET_DIMENSION_NAME='SCENARIO') AND MEMBER_NAME = UD3)