Share via

2.2.5.2.8 OLAP Grouping

  • Article

Grouping in an OLAP PivotCache (section 2.2.5.2) is the associating of multiple OLAP members that belong to the same OLAP level of an OLAP hierarchy and have the same OLAP member parent. When OLAP members in a particular OLAP level are grouped, a parent grouping OLAP level exists. Each group is represented in the parent grouping OLAP level by one parent grouping OLAP member, and one or more child OLAP members in the OLAP level that the grouping is applied to.

The sequence of records that conforms to the PCDHGLEVELS rule (defined in section 2.1.7.38) specifies grouping for the associated cache hierarchy (section 2.2.5.2.7), which MUST be associated with an OLAP hierarchy. Each sequence of records that conforms to the PCDHGLEVEL rule (defined in section 2.1.7.38) specifies a grouping for one OLAP level with the same zero-based ordinal as the zero-based index of the PCDHGLEVEL rule in the PCDHGLEVELS rule.

The set of groups for one OLAP level is specified by a sequence of records that conforms to the PCDHGLGROUPS rule (defined in section 2.1.7.38) in the PCDHGLEVEL rule (defined in section 2.1.7.38). Each individual group is specified by a sequence of records that conforms to the PCDHGLGROUP rule (defined in section 2.1.7.38) in the PCDHGLGROUPS rule. The set of OLAP members for a group is specified by the sequence of records that conforms to the PCDHGLGMEMBERS rule (defined in section 2.1.7.38) within a PCDHGLGROUP rule. Membership in the group is specified by the sequence of records that conforms to the PCDHGLGMEMBER rule (defined in section 2.1.7.38) within the PCDHGLGMEMBERS rule.