Modeling 

Purpose

The tool you use for modeling is the Data Warehousing Workbench. Depending on your reporting requirements, different BI objects are available to you for integrating, transforming, consolidating, cleaning up, and storing data. BI objects enable the efficient extraction of data for analysis and interpretation purposes.

Process Flow

The following graphic shows how BI objects are integrated in the dataflow:

Data that logically belongs together is stored in the source system in the form of DataSources. DataSources are used for extracting data from a source system and transferring it into the BI system.

The Persistent Staging Area (PSA) is the inbound storage area for data from the source systems in the BI system. The requested data is saved, unchanged from the source system.

The transformation specifies how the data (key figures, time characteristics, characteristics) is updated and transformed from the source, into the InfoProvider or an InfoSource. The transformation rules map the fields of the source to at least one InfoObject in the target. The information is mapped in structured form using the InfoObjects.

You need to use an InfoSource if you want to execute two transformations after each other.

Subsequently, the data can be updated to further InfoProvider. The InfoProvider provides the data that is evaluated in queries. You can also distribute data to other systems using the open hub destination.

See also:

For information on displaying the data flow for BI objects, see the Data Flow Display section.