Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
CWM2_OLAP_TABLE_MAP, 10 of 18
This procedure creates the join relationships between a fact table and a set of dimension tables. A join must be specified for each of the dimensions of the cube. Each dimension is joined in the context of one of its hierarchies.
For example, if you had a cube with three dimensions, and each dimension had only one hierarchy, you could fully map the cube with one call to MAP_FACTTBL_LEVELKEY
.
However, if you had a cube with three dimensions, but two of the dimensions each had two hierarchies, you would need to call MAP_FACTTBL_LEVELKEY
four times to fully map the cube. For dimensions Dim1
, Dim2
, and Dim3
, where Dim1
and Dim3
each have two hierarchies, you would specify the following mapping strings in each call to MAP_FACTTBL_LEVELKEY
, as shown below.
Dim1_Hier1, Dim2_Hier, Dim3_Hier1 Dim1_Hier1, Dim2_Hier, Dim3_Hier2 Dim1_Hier2, Dim2_Hier, Dim3_Hier1 Dim1_Hier2, Dim2_Hier, Dim3_Hier2
Typically the data for each hierarchy combination would be stored in a separate fact table.
MAP_FACTTBL_LEVELKEY ( cube_owner IN VARCHAR2, cube_name IN VARCHAR2, facttable_owner IN VARCHAR2, facttable_name IN VARCHAR2, storetype IN VARCHAR2, dimkeymap IN VARCHAR2, dimktype IN VARCHAR2 DEFAULT NULL);
Parameter | Description |
---|---|
|
Owner of the cube. |
|
Name of the cube. |
|
Owner of the fact table. |
|
Name of the fact table. |
|
For more information on storetype, see Joining Fact Tables with Dimension Tables. |
|
A string specifying the mapping for each dimension of the data in the fact table. For each dimension you must specify a hierarchy and the lowest level to be mapped within that hierarchy. Enclose the string in single quotes, and separate each dimension specification with a semicolon. Each dimension specification must be in the following form:
This string must also be specified as an argument to the |
|
This parameter is not currently used. |
The following call to the MAP_FACTTBL_LEVELKEY
procedure maps a cube named ANALYTIC_CUBE_AW
in the schema XADEMO
to a fact table named XADEMO_AW_SALES_VIEW_4
in the same schema. The fact table stores lowest level data and embedded totals for all level combinations. The cube has four dimensions: PRODUCT
, CHANNEL
, TIME
, and GEOGRAPHY
.
cwm2_olap_table_map.Map_FactTbl_LevelKey ('XADEMO', 'ANALYTIC_CUBE_AW','XADEMO', 'XADEMO_AW_SALES_VIEW_4', 'ET', 'DIM:XADEMO.PRODUCT_AW/HIER:STANDARD/GID:PRODUCT_GID/LVL:L4/COL:PRODUCT_ET; DIM:XADEMO.CHANNEL_AW/HIER:STANDARD/GID:CHANNEL_GID/LVL:STANDARD_1/COL:CHANNEL_ET; DIM:XADEMO.TIME_AW/HIER:YTD/GID:TIME_YTD_GID/LVL:L3/COL:TIME_YTD_ET; DIM:XADEMO.GEOGRAPHY_AW/HIER:CONSOLIDATED/GID:GEOG_CONS_GID/LVL:L4/COL:GEOG_CONS_ET;');
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|