Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
CWM2_OLAP_DIMENSION , 3 of 14
The CWM2_OLAP_DIMENSION
package contains procedures that establish dimension entities within the OLAP 2 Catalog.
Creating dimensions is the first step in creating the OLAP metadata for a dimension. Typically you will create hierarchies and dimension attributes after creating the dimension and before creating the dimension levels and level attributes. Once the levels and level attributes are defined, you can map them to columns in one or more warehouse dimension tables.
Once you have created a dimension, you will need to call procedures in the following packages to fully define the dimension's metadata:
To be valid, a dimension must have at least one level. If the dimension is a time dimension, it must also have the END DATE
and TIME SPAN
dimension attributes mapped for all levels.
All the dimension's levels and level attributes must be mapped to columns in dimension tables. Each level must map to one or more columns in one or more tables. If a level maps to multiple columns, they must be in the same table. Each level attribute must map to a single column in the same table as its associated level. If any of these columns is inaccessible, the dimension is not valid.
To test the validity of your dimensional metadata, use the VALIDATE_DIMENSION
procedure in the CWM2_OLAP_VALIDATE
package.
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|