Description of the illustration map_cube.gif
Units Cube Mapped in the Tabular View: This screen capture shows the mapping section for the UNITS_CUBE
cube. At the top of the section are icons for the following tools:
-
Graphical Mapping View
-
Table Mapping View
-
Auto Arrange Mappings
-
Auto Map Star Schema
-
Remove All Mappings
-
Refresh Tables, Views, and Synonyms from Database
At the top right is the Group By list with the aggregate function SUM
selected.
The UNITS_CUBE
cube is mapped to columns in the Global UNITS_FACT
table as follows.
-
UNITS_CUBE
has three measures with these mappings -
UNITS
toGLOBAL.UNITS_FACT.UNITS
-
SALES
toGLOBAL.UNITS_FACT.SALES
-
COST
toGLOBAL.UNITS_FACT.COST
UNITS_CUBE
has four dimensions, all of them mapped to the detail level of the source. In the schema tree the Aggregate From Level symbol Sigma Up Arrow appears after the name of the detail level of each dimension.
-
MONTH
level ofTIME
toGLOBAL.UNITS_FACT.MONTH_ID
. -
CHANNEL
level ofCHANNEL
toGLOBAL.UNITS_FACT.CHANNEL_ID
. -
SHIP_TO
level ofCUSTOMER
toGLOBAL.UNITS_FACT.SHIP_TO_ID
. -
ITEM
level ofPRODUCT
toGLOBAL.UNITS_FACT.ITEM_ID
.
The join conditions for the dimensions are the following:
-
GLOBAL.TIME_DIM.MONTH_ID = GLOBAL.UNITS_FACT.MONTH_ID
-
GLOBAL.CHANNEL_DIM.CHANNEL_ID = GLOBAL.UNITS_FACT.CHANNEL_ID
-
GLOBAL.CUSTOMER_DIM.SHIP_TO_ID = GLOBAL.UNITS_FACT.SHIP_TO_ID
-
GLOBAL.PRODUCT_DIM.ITEM_ID = GLOBAL.UNITS_FACT.ITEM_ID
The Filter row is empty.
At the bottom of the mapping section are the following buttons:
-
Help
-
Show SQL
-
Apply
-
Revert