ID and Description in SAP Datasphere using Business Builder

[marcel2016]

Hello,

I would like to build a report in the SAP Analytics Cloud based on a data model from SAP Datasphere, which among other things has the dimension "Product". The product should be able to be displayed as an ID and / or as a Description.
Therefore, I have created all the necessary tables, text tables and views in the Data Builder in SAP Datasphere and linked them together. If I now create an Analytic Model in the Data Builder (assigning the semantic relationships of attributes and texts) and use this in SAP Analytics Cloud, I can choose between ID and Description there.
Instead of the Data Builder, I would like to create a Consumption Model with the Business Builder and use it in SAP Analytics Cloud, with which the ID-Description-assignment unfortunately does not work; only the ID is displayed.
I have made the following configurations for this:

• Attribut "ARTNR" (describes the product) within Fact
  
• Attribute "ARTNR" cannot be selected in Cosumption Model: There are two attributes "ARTNR.ID" and "ARTNR.TEXT" now ("ARTNR.TEXT" can't be selected)
  
• Attribute "ARTNRID" within Cosumption Model
  
• Preview of "ARTNRID" only shows the IDs
  

I would like to ask for support.

Thanks in advance!

Best regards,

Marcel

[Martin_Kuma]

Marcel, do not use Business Builder. Just do not :). Analytic Model is you way forward. 

But... in SAC you can try to script. IDandDescription method for the Dimension. 

I did try a while ago Business Builder, but Analytic Model is just better. Status (released, depreciated), the only functionality I found better in Business Builder, is already integrated in Data Builder .

Cheers, Martin