
Chapter 2. DB2 Cube Views: scenarios and benefits 29
2.2 Feeding metadata into DB2 Cube Views
In order to derive any benefits from DB2 Cube Views, the job of mapping your
relational star schema objects into OLAP metadata objects must be
accomplished. There are basically three ways to do this, and each one carries its
own unique benefits. You can feed the metadata mappings into DB2 Cube Views
from back-end tools, such as data modeling or ETL tools, whose metadata
already contains all or part (fact and dimensions only) of the needed information.
Alternatively, you can feed it in from front-end tools, such as MOLAP or reporting
tools, whose metadata ...