ROLLUPCHILDREN
Description:
This function is used to roll up (aggregate) values across the children of a specified member using a given aggregation function. It supports an extended rollup mode (FULL) to control how current context are included in the aggregation.
Syntax:
ROLLUPCHILDREN(Level_Expression, Scalar_Expression, Aggregation_Function, Rollup_Mode)
Return type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Level_Expression | A valid MDX expression that returns a level or member. Represents the child context whose parents are considered for rollup as per the child context. |
Scalar_Expression | A valid MDX scalar expression that evaluates to a member or numeric context. Typically used to: Shift time (e.g., previous period, parallel period). |
Aggregation_Function | Specifies how values from the rolled-up members are aggregated. Common supported functions: SUM, AVG, MIN, MAX, COUNT |
Rollup_Mode | How current context are included in the aggregation and this is optional and by default its value is PARTIAL. (FULL / PARTIAL) |
Example:
with member [Measures].[P] as ROLLUPCHILDREN([Time].[Time Hierarchy].[Month],ParallelPeriod([Time].[Time Hierarchy].[Year],1,[Time].[Time Hierarchy].CurrentMember),SUM,FULL) SELECT [Measures].[P] ON 0,[Time].[Time Hierarchy].[Month] on 1 FROM [Benchmarking]