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 |
|
||||
Default |
None |
||||
Required/Optional |
Optional |
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.
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.
Copyright © 1984, 2005, Oracle. All rights reserved.