Symptom
- Not Assigned Members in BW Hierarchy will not be expanded when importing to model
Environment
- SAP Analytics Cloud Enterprise
Reproducing the Issue
- Check a query in BW side which has some members that are not in the hierarchy.
- Create an import job with this BW query using the same hierarchy in Model Data Management.
- After import, check from Model data, there is no member from unassigned node. They are aggregated and being displayed as one node (Not Assigned Member)
Cause
This is currently a designed behavior.
The SAC agent does not support expanding the unassigned node (all members that are not in the hierarchy) for model import.
The unassigned node will be expanded for dimension import.
Resolution
Please create enhancement request(see 2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud?) if you need this feature to expand unassigned node in model import.
Keywords
missing members, not assigned members, hierarchical dimensions, sap analytics cloud, bw query, import connection, live connection, data acquisition, manufacturer dimension, missing records, hierarchy issue, data import , KBA , LOD-ANA-AQU-BW , Data Acquisition from BW , Problem
SAP Knowledge Base Article - Public