In SAP Analytics Cloud (SAC), planning models store data at the most granular levelāknown as leaf members. When entering or adjusting data in planning tables, understanding how SAC handles leaf vs. parent members is key to maintaining data accuracy and leveraging SACās disaggregation engine.Ā
What Are Leaf and Parent Members?
Leaf Member – The lowest level in a dimension hierarchy. Data is stored here.Ā
Parent Member – A higher-level aggregate based on its child (leaf) members. Cannot directly store raw data but reflects the sum or calculation of its children.Ā
Example
- In a regional sales hierarchy, āVancouverā and āTorontoā are leaf members, while the parent āCanadaā aggregates their totals.
Booking Data to Leaf Members
- Direct entry to leaf members is straightforward.Ā
- The values entered are stored directly in the model without any redistribution.Ā
- Ideal for precise planning inputs at the most detailed level.Ā
How to do it:
1
Open the planning story and select the table.Ā
2
Filter to display leaf members (if needed).Ā
3
Enter your planning values directly into the editable cells.Ā
Booking Data to Parent Members (Disaggregation)
When you enter values at a parent level, SAC automatically disaggregates the value down to its child members using predefined rules or proportions based on existing data.Ā
Disaggregation Logic:
- Equal split across children if no prior data existsĀ
- Proportional distribution based on historical or related values if availableĀ
Example
If āMarketing Expensesā is the parent of three subcategories and you enter 300 at the parent level:Ā
- With no existing values in the subcategories, each one receives 100.Ā
- If the subcategories already have values of 50, 100, and 150, SAC allocates the 300 proportionally according to those amounts.Ā
Best Practices for Disaggregation
- Use disaggregation only when necessary ā Prevents accidental data overridesĀ
- Ā Review disaggregated values after input ā Ensures outcomes align with business intentĀ
- Ā Lock specific members before disaggregating ā Maintains data integrity and prevents unwanted changesĀ
