What's new in Customer Journeys?

Connect and learn more! ×
How can I get column name for Attribute in AIF_TARGET_APPL_MEMBERS table. — Cloud Customer Connect
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.

Received Response
31
Views
1
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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