
Chapter 2. DB2 Cube Views: scenarios and benefits 49
Figure 2-20 ROLAP scenario: report
Low administrative effort
Administrative benefits can be achieved when DB2 Cube Views is used in
conjunction with ROLAP tools, both on the metadata side and on the data side.
On the metadata side, once the DB2 Cube Views metadata has been populated,
the task of building all or most of the metadata layer of the ROLAP tool is
reduced to a metadata transfer via a bridge. After the metadata transfer, your
tool’s semantic layer of tables, columns, joins, facts, dimensions and hierarchies
has been automatically built to match the DB2 Cube Views environment and ...