Modeling

In modeling, you can create and edit all the objects and rules of the Administrator Workbench that are needed for data transport, update and analysis. You can also execute functions related to these.

The objects are displayed in modeling in a tree structure. The objects are sorted here according to hierarchical criteria.

Using the context menu for the objects, you can select the corresponding maintenance dialog for the objects or carry out the relevant functions . Double clicking on an object brings you to the corresponding maintenance dialog.

The following graphic shows how the various objects are connected in BW:



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 for transferring data into the BW.

The Persistent Staging Area (PSA) is the input storage for data from the source systems in SAP BW. The required data is then saved in the sources systems in unchanged form.

An InfoSource describes the quantity of all the data available for a business transaction or a type of business transaction (for example, cost center accounting).

The individual fields of the DataSource are assigned to the relevant InfoObjects in it. The  data can then be transformed using transfer rules. The information is mapped in structured form using the InfoObjects.

Update Rules specify how the data (key figures, time characteristics, characteristics) is updated to an InfoSource in Data Targets (in the example above, an ODS object) from the communication structure of an InfoSource. The data can also be transformed in the update rules.

Afterwards, the data can be updated to other data targets / InfoProviders (in the example above, in an InfoCube). The InfoProvider provides the data for evaluation in queries.

Comments

Popular posts from this blog

SAP Datasphere Architecture

SAP Datasphere Data Integration - Part 1 - Introduction and Integration using Remote Tables

SAP Datasphere Spaces