Retrieve member alias for my DataExport File through DataManagement

Summary

Retrieve member alias for my DataExport File through DataManagement

Content

Hey all,

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?

Version

20.04.58

Code Snippet

(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)