The cube used was a subset of the cube model and is depicted in FigureE-2.
Figure E-2 The cube
Tables in the star schema
The dimension tables are:
Dimension name: Consumer as described in
Table name: STAR.CONSUMER
The fields are described in .TableE-1.
688DB2 Cube Views: A Primer
Table E-1 Consumer dimension
Attribute NameBusiness Name
ACQ_SRC_TYPE_CODEAcquire Source Type Code
ACQ_SRC_TYPE_DESCAcquire Source Type Description
AGE_RANGE_CODEAge Range Code
AGE_RANGE_DESCAge Range Description ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.