Scenario for DataStore Objects 

The diagram below shows how DataStore objects are used in this example of updating order and delivery information, and the status tracking of orders, meaning which orders are open, which are partially-delivered, and so on.

There are three main steps to the entire data process:

...

       1.      Loading the data into the BI system and storing it in the PSA

The data requested by the BI system is stored initially in the PSA. A PSA is created for each DataSource and each source system. The PSA is the storage location for incoming data in the BI system. Requested data is saved, unchanged, to the source system.

       2.      Processing and storing the data in DataStore objects.

In the second step, the DataStore objects are used on two different levels.

                            a.      On level 1, the data from multiple source systems is stored in DataStore objects. Transformation rules permit you to store the consolidated and cleaned up data in the technical format of the BI system. On level 1, the data is stored on the document level (for example, orders and deliveries) and constitutes the consolidated database for further processing in the BI system. Reporting is therefore not usually carried out on the DataStore objects at this level.

                            b.      On level 2, transfer rules subsequently combine the data from several DataStore objects into a single DataStore object in accordance with business-related criteria. The data is very detailed, for example, information such as the delivery quantity, the delivery delay in days, and the order status, are calculated and stored per order item. Level 2 is used specifically for operative reporting issues, for example, which orders are still open from the last week. Unlike OLAP reporting, where very large quantities of data are selected, here data is displayed and analyzed selectively.

       3.      Storing data in the InfoCube

In the final step, the data is aggregated from the DataStore object on level 2 into an InfoCube, meaning in this scenario, that the InfoCube does not contain the order number, but saves the data, for example, on the levels of customer, product, and month. OLAP reporting using the BEx Query is also run on this data. You can still display the detailed document data from the DataStore object whenever you need to. Use the report/report interface from a BEx query. In this way, you are able to analyze the aggregated data from the InfoCube, and target the specific level of detail you want to access in the data.