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

Retrieve member alias for my DataExport File through DataManagement

edited May 18, 2020 3:48PM in Planning 10 comments

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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