Data warehousing requires the extraction, transformation, and loading of data from operational systems to a data warehouse database. You can map PDM objects to represent links between operational and data warehouse data and from the data warehouse data and OLAP cubes.
You can model operational and data warehouse data structures in PDMs, and specify mappings to identify the operational data sources of the data warehouse. These mappings can be used to generate extraction scripts to populate the data warehouse with operational data:
The following table lists the objects that are mapped in this kind of relational-to-relational mapping:
You can map physical objects to OLAP objects, and use these mappings to generate cube data in text files to be loaded by OLAP engines. The mapping for a physical object (dimension or fact) is used to supply data for the cube dimensions or cube measures in OLAP databases. The tables in the data source need not be of dimension or fact type. Once the source tables or views are identified, you can define mappings between attributes or measures and table columns:
When you use the Rebuild Cubes feature to create cubes and dimensions from fact and dimension tables, the mapping between source tables and OLAP objects is automatically performed.
The Select sub-tab displays the entire SQL statement used to select data in the data source. This statement is automatically generated. The Generate Cube Data feature uses this SQL statement to fill the text files used to populate cubes in an OLAP database.
For more information about rebuilding cubes and generating cube data, see the Building Multidimensional Diagrams chapter in the Data Modeling guide.