on ‎2008 May 02 3:30 PM
Hello,
I am new to BW and would like to know if I can see anytime data in a DSO.
Thanks
Regards
Praveen
Request clarification before answering.
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..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 8 | |
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.