A script-enabled browser is required for this page to function properly.

Child Dimension property

The Child Dimension property indicates whether a group is a child dimension group in a nested matrix data model. By identifying which groups are child dimensions, you eliminate empty rows or columns in your matrix.

Applies to

Dimension groups in a single-query, matrix data model

Values

 

Yes

Identifies the group as a child dimension in a nested matrix report.

No

Identifies the group as not a child dimension in a nested matrix report.

Default

None

Required/Optional

Optional

Restrictions

Use of Child Dimension property

Usage notes

Examples

Example 1: Child Dimension set to No

For the matrix below, the group containing deptno (G_DEPTNO) had Child Dimension set to No. Note how all rows are printed even if they contain no values.

matrix depicting Child Dimension property set to No

Example 2: Child Dimension set to Yes

For the matrix below, the group containing deptno (G_DEPTNO) had Child Dimension set to Yes. Note how only rows that contain values are printed.

matrix depicting Child Dimension property set to Yes