cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

DSO : Data in DSO

Former Member
0 Likes
310

Hello,

I am new to BW and would like to know if I can see anytime data in a DSO.

Thanks

Regards

Praveen

View Entire Topic
Former Member
0 Likes

Dear Praveen,

U can see the data in DSO ,.,RIght Click on DSO -> Manage -> Contents -> And select the table u need..

The detailed info of tables is given below...

Standard DataStore objects consist of three tables:

• Active Data table

This is where the current status of the data is stored. This table contains a semantic (business-related) key that can be defined by the modeler (order number, item, or schedule line, for example). It is very important that the key be correctly defined by the modeler, as a match on the key initiates special

delta processing during the activation phase . Also, reporting via the BEx uses this table.

• Change Log table

During the activation run, changes are stored in the change log. Here, you can find the complete history of the changes, since the content of the change log is not automatically deleted. The connected targets are updated from the change

log if they are supplied with data from the DataStore object in the delta method. The change log is a PSA table and can also be maintained in the PSA tree of the Data Warehousing Workbench. The change log has a technical key consisting

of a request, data package, and data record number.

• Activation Queue table

During the DTP, the records are first written to this table. This step is necessary due to the complex logic that is then required by the activation process.

Hope this helps u..

Assign points if helpful...

Best Regards,

VVenkat..

Former Member
0 Likes

Thank you. It has solved the problem.

Regards

Praveen