| Previous | Table of Contents | Next |
An end user of a data warehouse engages in an analytic session with a multidimensional or relational database through the
OLAP layer. The user navigates cubes and dimensions and selectively launches OLAP queries. At some point, the user decides
to drill-down from a consolidated value to lower levels of detail in an OLAP hierarchy, possibly down to the lowest level
input value(s) in the hierarchy.
Leveraging CWM’s inherent ability to preserve data lineage, the user may view the operational detail, which formed the input
value(s). The original data sources can be identified from the CWM Warehouse Operation that recorded the production of the
input value(s).