ProRataHierarchy
Description | Select a hierarchy for Pro-Rata Russian Doll allocation |
---|---|
Variations |
|
This context value enables “Russian Doll” calculation for a Pro-rata measure along the selected hierarchy. Please note that ProRataLeafLevel context value must be set to “NONE”.
Once you select a hierarchy from the list:
- [Booking].[Books]
- [Booking].[Desks]
- [Organization].[BookHierarchy]
- [Organization].[Legal Entities]
- [Organization].[LegalEntityHierarchy]
The pro-rata measure will compute capital allocation recursively, so that the sum at each level in the hierarchy is equal to the Pro-Rata capital allocation of the parent level.
Consider this example:
- SBM Risk Charge Pro-Rata and SBM Risk Charge measures are on columns,
- the multi-level [Organization].[BookHierarchy] is on the rows and selected in the context value.
Result:
- SBM Risk Charge and SBM Risk Charge Pro-Rata are equal on the Enterprise level.
- SBM Risk Charge Pro-Rata values at lower levels are additive, see for instance, that the total for books under “Developed Markets” is equal to the desk total (
1.002.912
).