cancel
Showing results for 
Search instead for 
Did you mean: 

Write Optimized DSO

Former Member
0 Kudos

Hello Guru's

we have a datasource which is not delta capable .

Data flow is from data source to write optimised DSO and from Write optimised DSO to Cube.

My question is how to load delta loads every day to Write Optimised DSO ?

Can any one plz tell me how to approch for this scenario

thanks

pk

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

solved

Former Member
0 Kudos

Hi

Since you dont have the datasource as delta enabled . It is not possible to extract the delta data from the source system by using that datasource .

What you can do is , do the full load daily to DSO and from DSO to cube , do the delta dailiy . Because you have write optimized DSO , this DSO will have only two tables(Active and New Data table), there is no change log table in write optimised DSO . And write optimized DSO will support large amount of data . So do the daily full load to the write optimized DSO and from DSO to Cube, do the delta load.

If you have any question please feel free to contact me .

regards

mohammed

former_member182563
Participant
0 Kudos

Hi,

As i am very new TO SAPBI...As i know that write optimized dso have only active data table but not new data table......I am not sure but i feel to post it.......

So try to clarify my doubt.........

Former Member
0 Kudos

Hi,

Yes you are right there is no NEW TABLE in write optimized DSO.

Data that is loaded into Write-Optimized Data Store objects is available immediately for further processing. The activation step that has been necessary up to now is no longer required. Note here that the loaded data is not aggregated. If two data records with the same logical key are extracted from the source, both records are saved in the Data Store object, since the technical key for the both records not unique. The record mode (0RECORDMODE) responsible for aggregation remains, however, the aggregation of data can take place at a later time in standard Data Store objects. Write-Optimized DataStore does not support the image based delta, it supports request level delta, and you will get brand new delta request for each data load.

Since write-optimized DataStore objects do not have a change log, the system does not create delta (in the sense of a before image and an after image). When you update data into the connected InfoProviders, the system only updates the requests that have not yet been posted.

Write-Optimized Data Store supports request level delta. In order to capture before and after image delta, you must have to post latest request into further targets like Standard DataStore or Infocubes.

/people/martin.mouilpadeti/blog/2007/08/24/sap-netweaver-70-bi-new-datastore-write-optimized-dso

-Vikram