write optimized, direct , standard dso

[Former Member]

hi,

     plz tell me in which scenario we will use write optimized dso, direct dso, standard dso??? and the exact difference between all of the 

note:don't tell that standard have 3 tables,direct and write op are having 1 table

[Former Member]

Hi,

Standard DSO:This type of DSO is mostly used for Detailed level reporting and Detailed level data storage.  It can be used in scenarios of RRI (report to report interface) to refer the detailed level query from and summery query.

Write Optimized DSO: Mainly this type of DSO's are used for faster loading of large amount of data and then forward the delta to other data targets in BW. Mainly used at Data staging layer e.g. in AP, AR and GL scenarios data will be transferred from DSO to further cube.

Direct Update DSO: In these DSO's data loading through DTP's is not possible, and BAPI's are used to update this. Such DSO's are mainly used to store the APD analysis results.

Check these links for scenarios....

http://help.sap.com/saphelp_nw04s/helpdata/en/03/c97842b180c153e10000000a1550b0/frameset.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/b6/de1c42128a5733e10000000a155106/content.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/c0/99663b3e916a78e10000000a11402f/content.htm

Regards,

Aravind.