There are three tables in SDSO, they are:
> New data table
> Active data table
> Change log table
In this screenshot, we have a request loaded to DSO, and we will analyse how the three tables behave, when we load another request to this DSO.
Now, we will load another request with the same set of characteristics, but the keyfigure values are changed.
Firstly, We will analyse data for keyfigures with the overwrite mode of aggregation. We will check the new data table, active data table and change log table for the changes.
Secondly, we will change the keyfigures material cost, bill amount, and profit of sales to summation in the transformation rules, and keyfigure material quantity is left unchanged as overwrite mode, and then we will again analyse the change log table and active data table.
The setting to change keyfigure from overwrite to summation is available in transformation.
Go to the transformation –> click change –> double-click on rule type –> click dropdown box of Aggregation –> select summation.
New data table:
Newly loaded data is available in new data table before activation of the DSO.
You can see in the below screenshot, that we have loaded another request, and it is not activated yet.
Now, we will check the data in the New data table by going to the contents tab. Click the ‘new table’ and execute, to check the data in the table.
You need to go to the requests tab of the Infoprovider administration, and click on ‘Active’ to activate the DSO.
After the activation of DSO, we will check the three tables and we are going to discuss the changes in the tables.
Now, you can see that the data in the newly loaded request is activated, and it is ready for reporting.
Go to the contents tab, and check the new table for the data.
As you can see in the above screenshot, there are ‘0’ records in the new data table after the activation of the request.
Change log table:
After the activation of the request, changes are stored in change log table.
Now, you can see the change log table has 90 entries. You can see the records from the previous load are shown. Now, the same records for the current load will be shown below.
You can see when the second request is activated, the change log has multiplied record one with “-“, then record two is the new record. Because DSO is in overwrite mode, these are the changes made to overwrite the previous data.
For Bill amount of ‘C0001’
- 5000 – 5000 = 0.
- 5000 overwritten by 1000 = 1000.
For Profit of sales (/BIC/zprf_sls)
- 3000 – 3000 = 0.
- 600 overwrites 3000 = 600.
The end result is written to the active data table.
Now, let’s see the result for the same data, but in the summation mode of the keyfigures.
You can see in the below screen, that change log contains 150 records, because we have loaded the request before in overwrite mode, and then we have deleted the request, But the entries in the change log are not deleted. However active data table is adjusted with the deletion of the request.
So, the 90 previous records, and 60 for the recent load with the summation mode, total 150 records are available in the change log. Below you can see the recent request changes that change log has made.
You can see for the customer ‘C0001’ Bill amount is -5000 in the first entry, and 6000 in the second entry.
What exactly happens is:
When you load the first request change log has the entry 5000 for the Bill amount. When you load delta with the Bill amount 1000, system adds up the delta entry ‘1000’ to the previous load, and then subtracts the previous entry.
For the data already exists, the system multiplies the data with ‘–ve’, and then replaces the previous result.
For the Customer ‘C0001’ – /BIC/zbillamt
- 5000– 5000 = 0.
- 5000 + 1000 = 6000.
The end result 6000 for Customer ‘C0001’ Bill amount field is available in the active data table.
For the customer ‘C0001’ – /BIC/Zprf_sls
- 3000 – 3000 = 0.
- 3000 +600 = 3600.
The end result 3600 is written to the active data table.
Active data table:
The data after the activation of the DSO is stored in the active data table.
The result shown below is for the overwrite mode of the DSO, so it has overwritten the old values with the new values of the keyfigure.
The result shown below is for the summation mode of the DSO, with the same request which we loaded before.
The keyfigures of the both requests are summed up, and the result is shown in the Active data table.
Here, as you see in the above screenshot, the result is shown in the active data table. The data in the active data table is the final resultant data of the Standard DSO. This is the data which will be updated to the further infoproviders.
For SAP BI videos, please visit my youtube channel below.
Please visit my personal website for more information about me.