SAP Knowledge Base Article - Public

3491088 - Getting incorrect result when importing query with hierarchies into a dimension in SAP Analytics Cloud (SAC).

Symptom

When importing data using datasource with hierarchies into a dimension, then display key is showing incorrect in SAC.

Environment

  • SAP Analytics Cloud version 2024.8.10
  • Import BW connection

Reproducing the Issue

  1. Login to SAC.
  2. Open the model.
  3. Switch to Data Management.
  4. Create new import from datasource.
  5. Select connection: SAP BW 
  6. Search for the query.
  7. Drag available data from the left menu to selected data.
  8. Select the hierarchy with a drill of 10.
  9. Press on create button.
  10. Notice that display key is showing incorrect.

Cause

The hierarchy parent node will always have this format by default in SAC because that is the way that member nodes are handled. BW will split the member node into a parent node and a leaf with the same info object member. In order to avoid non-unique member IDs and circular hierarchies, the node name of the parent node will be imported (e.g. info object name + internal key: Z_WBSELEMENT/A100000100000000). The leaf can use the external key (e.g. A.10.00001). 

Unfortunately at this time, SAC does not currently have the capability to display the external key in the node split from a member node.

Resolution

This issue permanent solution is being investigated by our development team. 

Workaround:

To remove the info object prefix, a transformation can be done during the wrangling stage during import to get rid of it, leaving just "A100000100000000".

See Also

Keywords

import, BW, SAC, hierarchy, display, model, key , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0