2026

SAP Datasphere Hierarchies with unassigned nodes

Unassigned nodes in BW query are a common case. This wasn't available in SAP Datasphere for a long time and leads to some incorrect data while displaying the aggregated data in hierarchy form.

 

There is also an influence request in the influence portal. SAP still hasn't implemented yet a good soulation and the request is still open but there is a hint for a SAP online help entry how to solve the issue. The request is 304831.

 

It is only available through the validation rules. The validation rules allow you to identify missing or enhanced hierarchy notes in your hierarchy. 

 

The help entry is found under the name "Collect Unassigned Fact Records for Inclusion in Aggregations and Visualizations". It has no link to the Hierarchy with Directoy entry nor is it linked with the Creating Analytic Model page. 

 

With click on the validation of the fact view you get the information about missing hierarchy nodes in my GL Account hierarchy.

Read More 0 Comments