Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

How can I get column name for Attribute in AIF_TARGET_APPL_MEMBERS table.

in Integration 1 comment

I need to extract Attribute details of entity dimension in a column while exporting data. I am able to extract details of Alias (or parent name using PARENT_NAME instead of ALIAS) using below SQL query in Data Management but I want the Attribute tagged to each Entity member instead of Alias for which I need the column name for Attribute. Is there any way to fetch column details of AIF_TARGET_APPL_MEMBERS table in cloud as I couldn't find any document with the details.

(SELECT DISTINCT ALIAS

FROM AIF_TARGET_APPL_MEMBERS

WHERE DIMENSION_ID = 

(SELECT DIMENSION_ID FROM AIF_TARGET_APPL_DIMENSIONS

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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