error ! Not a leaf node when data is imported in SAC model

[former_member585658]

Hello my beloved SAP colleagues and SAC Specialists!

In our grand implementation of an SAC planning solution, we are facing issues.

Current scenario : we have 2 hierarchy . one is DivisionDepthStructure(29400)Records Dimension and another one is Territorial Depth Structure which is also (29000+) Records. Both are dimensions with nested parent child hierarchy.

we imported them in to our model! and we tried to import the data into the models and we couldn't and we got an error stating that Not a leaf node.

Attaching Screenshots

Attaching second dimension

This is very Critical issue we are stuck in the project . i request your help to identify what could be the issue. Because when we imported the parent child data in to SAC dimensions. SAC itself make some additions of adding base member along with new Child members in ID column which is a subparent.we have found no issues of data rejection during creation and import of data into this parent child hierarchy Dimensions .

Br,

Gabriel.

[former_member585658 · Accepted solution]

Hello People,

It seems this is a data issues. So only the child nodes should contain data and not the parent nodes. this is in a parent child hierarchy.

[former_member6443]

Firstly, do you plan to plan on this model if the answer is no, then you can use the Analytic Model . Analytic Model enable you to load data at a consolidated level.

[former_member585658]

Yes absolutely planning to plan the model. we found a temporary fix for this in planning solution during data import. We made a all dimensions flat and then added the hierarchy to all dimensions. This is not a right approach again.This is a particular limitation with SAC and there has been incident raised with SAP. Surely will let you know if any solution happens to arrive, cheers!