Now it is possible to extract a member of a dimension and its Alias information using EPM Cloud Data management in EPBCS/PBCS/FCCS Applications.
Follow the process to use the option > Data Export to File, A target application gets created as Data Target type and complete the setup process,
For extracting the Alias - which is part of metadata use the below SQL command to extract the details
Like Mapping -- * to #SQL
(
SELECT DISTINCT ALIAS FROM AIF_TARGET_APPL_MEMBERS WHERE UDX = MEMBER_NAME
)
--- Note: Replace UDX with the actual UD number from the target application dimension class.
No comments:
Post a Comment