SAP Knowledge Base Article - Public

3380781 - Importing Account Hierarchy from BW results rejected the rows unexpectedly in SAC

Symptom

Importing Account Hierarchy from BW results inconsistent number of rows loading into SAC Planning model.

Some of the rejected rows with below error message:

  • Must be leaf node in hierachy
  • Data cannot be imported to new non-leaf node

Environment

SAP Analytics Cloud 2023.8.18

Reproducing the Issue

  1. Go to model->Data management
  2. Select a NEW Query from BW.
  3. Grep some dimensions into Panel.
  4. Set the Hierarchy and specify the drill number as 7, then save it.
  5. Edit the query and run the job, it shows less records.
  6. Some of the records get rejected with unknown reasons.

Cause

This issue is currently under investigation of development team.

Resolution

This issue is currently under investigation of development team.

Keywords

Your feedback is important to help us improve our knowledge base. , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud all versions