How to join ID and description in Data warehouse cloud?

[YanGerzon]

Hi,

Lets say I have two columns in my view in Data warehouse cloud , "Company ID" and "Company Text".
What do I need to do so that when I export a view from Data warehouse Cloud into SAC, in the SAC story I will see these two as ID and Description of a single "Company" Dimension?

Thanks in advance.

[amoghkulkarni · Accepted solution]

Hello,

This could be achieved by editing the Attributes of the dataset (pencil icon for the attributes)

Set the "Semantic Type" as "Text" for the text attribute and set the newly configured text attribute as the "Label Column" for the ID column as follows :

When the ID column is selected in SAP Analytics Cloud, text attribute for the ID column is visaulized instead.

If this answers your original question, please mark this as the best answer.

Regards,

Amogh K