Data Wizard: Cell page
To specify the cell fields for a matrix report:
- Click a field in the Available
Fields list.
- Click the appropriate button for the function
you want to apply to the field. An entry with the field and function name
appears in the Matrix Cell Fields
list.
Note: If you do not want to apply a function to the field, you can
click
to move
the field into the Matrix Cell Fields list without applying a function. Tis
is useful when your query already performs a function on the field’s source
column, for example, SUM(SAL) and you do not need to apply another function to it.
- Repeat Steps 1 and 2 for all of the desired matrix
cell fields.
- (Optional) To remove a field from the Matrix
Cell Fields list, click it then click
.
Usage notes
- Not all Oracle database datatypes are supported
at this time.
will identify the datatype as unknown in
the wizard if your query selects an unsupported Oracle database datatype. - Column objects and Ref columns cannot be used
as matrix cell fields. Therefore you cannot select them from the Available
Fields list.
- Attribute columns in the Matrix Cell Fields list
use underscore notation to indicate their parentage (for example, ADDRESS_ZIP).
Copyright © 1984, 2005, Oracle. All rights reserved.