Complex Calculations on Hierarchies from SAP BW to SAC

[sasm97]

Hi,

I'm facing a data mismatch issue on parent nodes in an SAC Model imported from BW.

My BW Query uses complex formulas for parent node values. SAC reads the leaf nodes and then uses its internal SUM aggregation for parent nodes, resulting in incorrect totals on the parent hierarchy levels. But The BW formula is too complex to replicate in SAC.

Is there a configuration in SAC or a best practice to force SAC to read and use the pre-calculated, aggregated parent node values directly from the BW Query? Or some configuration in BW?

[N1kh1l]

@sasm97 

I think this is currently a limitation. SAC will only show aggregation of leaf members and not the formula based value on nodes.

373126 - Unable to use local calculations in combination with hierarchies in SAC BW live connection story

https://userapps.support.sap.com/sap/support/knowledge/en/3373126

Hope this helps !

Nikhil