product-texts-view

Create Product Texts View

In this exercise you will learn, how to create and configure Views of type Text.

Text View: In SAP Data Warehouse Cloud Text Views typically interplay together with Dimension Views, and enable the support of multiple languages for textual columns. With Text Views users are able to view the master data on the reports and stories in their preferred language. The column which determines the language should comply with ISO 639-1 (https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes), e.g. en, de, fr. Please note: for SAP ABAP systems, the one digit language will be automatically mapped against the ISO codes and will work out of the box, too!

Exercise

1. Navigate to the Repository Explorer
2. Click on Create - Graphical View Button to create a new view
   
   
   
   
3. Drag and drop the table CSV_ProductTexts into the canvas
   
   
4. Select the Output Node in the canvas and configure the following properties:
   • Business Name: V_PRODUCT_TEXTS
   • Technical Name: V_PRODUCT_TEXTS
   • Semantic Usage: Text
   • Expose for Consumption: ON
     
     
5. Set the primary keys to:
   • PRODUCTID
   • LANGUAGE
     
     
6. Click on Edit Attributes
   
   
   
   
7. Adjust the attributes properties as the following:
   • LANGUAGE: set the semantic usage to Language
   • MEDIUM_DESCR: set the semantic usage to Text
   • PRODUCTID: set label to MEDIUM_DESCR
     
     
8. Select the Output node in the canvas, and click on Data Preview from the context menu to display the data of the view.
   
   
9. Click on deploy button to deploy the view