Symptom
When importing data using datasource with hierarchies into a dimension, then display key is showing incorrect in SAC.
Environment
Reproducing the Issue
- Login to SAC.
- Open the model.
- Switch to Data Management.
- Create new import from datasource.
- Select connection: SAP BW
- Search for the query.
- Drag available data from the left menu to selected data.
- Select the hierarchy with a drill of 10.
- Press on create button.
- 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
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Keywords
import, BW, SAC, hierarchy, display, model, key , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem