3680102 - Data in one dimension is displayed in a compounded format with data from another dimension instead of a non-compounded way in Datasphere Analytic Model

In the Datasphere Analytic Model, data from one dimension is presented in a combined format with data from another dimension, rather than being displayed independently. For example:

In Preview mode of the Analytic Model, after dragging a dimension (e.g., Source Ledger) to Rows, the data values in Source Ledger are displayed in a combined format with values from another dimension (e.g., Compony code), such as "A01/0A". Here, "0A" and "A01" originate from Source Ledger and Compony code, respectively. However, this format does not show values individually, such as just "0A". 


"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

SAP Datasphere

1. Open the Analytic Model.
2. Navigate to the Preview mode.
3. Add a dimension to the Rows.
4. Observe the result: data in this dimension is displayed as a combined format.

The display in the Preview mode is working as designed due to the presence of a compound key in the view with Semantic Usage type as Dimension from which the dimension Source Ledger originates.

To display the data in a non-composed way, the following options are available:

1. Delete the dimension Source Ledger, which has been set to the Representative Key in Compound Key, in Analytic Model:
   
   
   1. Open the Analytic Model.
   2. In the Properties panel, check on the Source Ledger in Dimension section.
   3. Click on delete button:
      
   4. The setting of Compound Key has been deleted, with retaining the dimension in the Analytic Model:
      
   5. Save and deploy the Analytic Model.
      
      
2. Create a new calculated column for the dimension view, which the dimension Source Ledger originates:
   
   
3. 1. Open the dimension view from the Analytic Model:
      
   2. Create a new calculated column (e.g., ledgercopy) for this view, and add the Source Ledger dimension to the Expression field:
      
   3. Save the Deploy this view.
   4. Navigate back to the Analytic Model and deploy it.
   5. In the Preview mode, drag the dimension ledgercopy to the Rows, and it will be shown as a individual format of the Source Ledger:
      

analytic model, calculated column, composed, compounding, un-compounded, display, represented , KBA , DS-MD-AM , Analytic Model , DS-MD-VIW , Views , Problem