Units Cube Mapped in the Tabular View: This screen capture shows UNITS_CUBE
mapped to columns in the Global UNITS_FACT
table as follows.
UNITS_CUBE
has three measures with these mappings
UNITS
to GLOBAL.UNITS_FACT.UNITS
SALES
to GLOBAL.UNITS_FACT.SALES
COST
to GLOBAL.UNITS_FACT.COST
UNITS_CUBE
has four dimensions, all of them mapped to the detail level of the source.
MONTH
level of TIME
to GLOBAL.UNITS_FACT.MONTH_ID
.
CHANNEL
level of CHANNEL
to GLOBAL.UNITS_FACT.CHANNEL_ID
.
SHIP_TO
level of CUSTOMER
to GLOBAL_UNITS_FACT.SHIP_TO_ID
.
The PRODUCT
mapping is not shown.