DSO : Data in DSO

[Former Member]

Hello,

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

Thanks

Regards

Praveen

[Former Member · Accepted solution]

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 · Accepted solution]

Thank you. It has solved the problem.

Regards

Praveen

[former_member345199]

Hi,

Standard DSO has three tables.

New data table.

Active data table and

Change log

You can see the activated records in Active data table.

New data table will show you requests that are yet to be activated and change log will track all the changes made to data.

Refer

/people/raj.alluri/blog/2006/11/24/the-tech-details-of-standard-ods-dso-in-sap-dwh

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/eb8f1895-0501-0010-73ad-e0bef4a2...

http://help.sap.com/saphelp_nw2004s/helpdata/en/f9/45503c242b4a67e10000000a114084/frameset.htm

You can see the data from ODS > Manage > Contents > Active data table or directly from SE16 > /BIC/<DSONAME>00.

Try Searching in SDN for this Topic and you will find much detailed info as this is discussed very frequently.

thanks,

JituK

[Former Member]

Thank you.

Let me check and I shall get back to you.

Regards

Praveen

[edwin_harpino]

hi Praveen,

do you mean display DSO data ?

right click your DSO and 'display data' ?

hope this helps.