cancel
Showing results for 
Search instead for 
Did you mean: 

what the different types of DSO

Former Member
0 Kudos

Hello friends ,

What are the different types of DSO and wht is difference between them >

Accepted Solutions (1)

Accepted Solutions (1)

former_member205352
Active Contributor
0 Kudos

Check this blog :

Check this too :

http://help.sap.com/saphelp_nw04s/helpdata/en/f9/45503c242b4a67e10000000a114084/content.htm

Hope this helps.

Edited by: Praveen G on Oct 23, 2008 2:46 AM

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi

Standard DSO

The standard DataStore object is filled with data during the extraction and loading process in the BI system

For usage check the below link

http://help.sap.com/saphelp_nw70/helpdata/en/80/1a60cae07211d2acb80000e829fbfe/frameset.htm

Write optimised DSO

A DataStore object that consists of just one table of active data. Data is loaded using the data transfer process.

The system does not generate SIDs for write-optimized DataStore objects and you do not need to activate them. This means that you can save and further process data quickly

For usage check the below link

http://help.sap.com/saphelp_nw70/helpdata/en/80/1a60cae07211d2acb80000e829fbfe/frameset.htm

Direct Update DSO

The DataStore object for direct update differs from the standard DataStore object in terms of how the data is processed.

In a standard DataStore object, data is stored in different versions (active, delta, modified), whereas a DataStore object for direct update contains data in a single version.

Therefore, data is stored in precisely the same form in which it was written to the DataStore object for direct update by the application.

In the BI system, you can use a DataStore object for direct update as a data target for an analysis process.

For usage check the below link

http://help.sap.com/saphelp_nw70/helpdata/en/80/1a60cae07211d2acb80000e829fbfe/frameset.htm

Hope this helps

Regards

Shilpa

Former Member
0 Kudos

There are 3 types of DSO

wirte optimized, standared and direct update.

when compare to ODS&DSO

Standared in both ver same

Write optimized same as transactional ODS

Direct update is new model it is used for staging purpose.

Edited by: Soma Venkateshwarlu on Oct 23, 2008 3:15 PM

Former Member
0 Kudos

Hi Nilesh,

As said, you have the 3 kinds of DSO.

The Write optimized DSO is in particular helpful, we you load an another standard DSO.

In the routine of the standard DSO, you can modify and upload directly another Write optimized DSO, from the datapackage.

You can upload in it whatever you want, no problem of delta or soever.

Kind Regards,

Mickael

Former Member
0 Kudos

Hi........

There are three types of DSO in BI 7.0........

Standard DSO

It consists of three tables.......activation queue,active table,and change log table.....It is completly integrated in the staging process.....Using change log table means that all changes are also written and are available as delta uploads for connected data targets.......

Write optimized DSO

It is integrated for warehouse level of architecture..........and has the advantage of quicker loads.has only active data table .(with delta capture capability) ...... SIDs are not generated

Check this :

http://www.biportal.org/Default.aspx?pageId=90410&mode=PostView&bmi=17541

Direct update DSO

It consists of active data table only. This means it is not easily integrated in the staging process...SIDs are not generated ......This DSO type is filled using API and can be read via BAPI......It is generally use for external application and APD...

Also check this :

http://help.sap.com/saphelp_nw04s/helpdata/en/f9/45503c242b4a67e10000000a114084/content.htm

Hope this helps........

Regards,

Debjani....

Edited by: Debjani Mukherjee on Oct 23, 2008 10:06 AM