SAP Marketing Cloud - CDS View - Add the text/description field of a field

[former_member600860]

Hello Experts,

i want to create a custom cds view. As a basis i took the Campaign Success Cube.

From this Cube i also need the field "Interaction Type", but not only the value, also the description.

For Example:

Interaktonsart: Interaktionsart (Description)

EMAIL_OUTBOUND Ausgehende Email

Does anybody know how i could configure this?

I think it is something with the Text View, where i can map the description field. But unfortunately all my attempts have so far failed.

Do I have to join other associations? Or is there a completly other way how i could get not just the Interaction type and also the interaction type name?

Thanks in advance!

BR,

Caro

[marc_dorais · Accepted solution]

Hello Carolin,

You will have to define a join with the CDS view I_MKT_InteractionTypeText in your Custom CDS view.
See the following example

Then you will have to define the join condition

Best regards,
Marc