Modeling in SAP BI

  Modeling in SAP BI

Purpose

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

Process Flow

The following figure outlines how BI objects are integrated into the dataflow:

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

The Persistent Staging Area (PSA) in the BI system is the inbound storage area for data from the source systems. 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 an InfoProvider or 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 one after the other.

Subsequently, the data can be updated to further InfoProviders. 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 more information about displaying the data flow for BI objects, see Data Flow Display section.