You can define matrix groups in the Data Wizard or create them manually.
To create a matrix (cross-product) group using the Data Wizard:
In the Data Model view, right-click and choose Data Wizard.
On the Query page, select the Matrix query check box.
Follow the wizard to select the columns for the matrix group(s), rows, columns, and cells.
To create a matrix (cross-product) group manually:
In the Data Model view, drag the title bar of the group object down.
Drag the "row" column and "column" column out of the group object into the space to create two new groups.
Single-click
in the tool palette.
Drag a box around the groups you want to include in the matrix (cross-product) group.
If the cell group is a separate query from the matrix (cross-product) groups, create the appropriate links between the columns in the matrix groups and the cell group.
Next step
Creating a default layout for a report
About matrix with group reports
Creating a nested matrix report
Copyright © 1984, 2005, Oracle. All rights reserved.