write-optimized DSO to CUBE

[Former Member]

Hello experts,

i have a question moving data from WODSO --> CUBE

Here in WODSO settings i have checked the checkbox as donot check uniqueness of data and loading data(semantic key BillNo) and loading from WODSO to CUBE

so i have records like

Bno  qty   amt

b10  20   200

b20  10   300       for first time

in cube data will be for first time 

b10  20   200

b20  10   300

and for second time data in wodso

b10  10  300

and if iload data for second time,data in cube will be 

b10  30  500

b20  10  300

my question is the data in the cube now is correct or wrong ?? or it should be loaded to standard dso and then to cube to have the correct data.

loading data to standard dso it picks data from changelogtable

b10 20 200 N

b20 10 300 N

b10 -20 -200 X(before image)

b10 10  300 space(after image) and it takes data from changelog table,then the data in cube will be

               Data in cube  -->     b10 10 300

                                               b20  10 300

pls clear me,can we load directly from WODSO to CUBE or we have to load to Standard DSO first and then to CUBE if donot check uniqueness of data is CHECKED.

I think it should me loaded to standard dso and then to cube.

pls, correct answers are assigned points.

[former_member186082 · Accepted solution]

HI Sheela,

Your conclusion is exactly right.

It is always better to load data to Standard DSO before loading to cube. The delta will pick data from changelog table which makes the delta work perfectly. By doing so the data will be fine without any inconsistencies. Else the data will be duplicated as in your example

Regards

Chandu

[Former Member]

Please check  the following documentation

Write-Optimized DataStore Object

http://help.sap.com/saphelp_nw73/helpdata/en/4a/44c79fc6bf0451e10000000a421937/frameset.htm

Scenario for Using Write-Optimized DataStore Objects

http://help.sap.com/saphelp_nw73/helpdata/en/4c/7072c77a7f3414e10000000a42189c/content.htm

[Former Member]

Thankyou guys for your quick reply,i have another doubt,even if i uncheck the otpion DoNot check Uniqueness of data then also the data should go through Standard DSO or can it be loaded directly to CUBE?

[former_member210724]

Hi,

As our friends said, data loading from WODSO to Infocube wont give you correct data so, add a standard DSO in between WODSO and Infocube.

WODSO is used for quick process, data that is loaded into WODSO is available for further processing but not for reporting.

if you do not check the check box"Do not check Uniqueness of data"  the data coming from source is checked for duplication,i.e., if the same record (semantic keys) already exist in the DSO, then the current load is terminated

regards,

anand.

[Former Member]

Thanks Anand,

i have a question that,i have read a document in which it is written

"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."

even if you you chech and uncheck the option  "DoNot check the uniqueness of data" it should go through the standard dso to cube?

[former_member186082]

WDSO don't store data in image level. It will overwrite the data by technical key settings. So the delta will be based on Req id

In order to maintain details history of the changes of a record, it should be loaded to standard DSO so that the changelog holds the same

Regards

Chandu

[former_member210724]

Hi,

It should go through SDSO.

[Former Member]

Hi,

As u said in write optimized dso data stored in request wise as in psa. Delta only pick new requests if any after the last delta load.

You have to check uniqueness of data if you are sure that there is no duplicate records that means changed records. If only new records will arise every time then u can check for uniqueness other wise the data load will not be successfull.

Regards,

Aravind.

[former_member188080]

Hi Sheela,

WO DSO contains only active data table so they are not suitable for delta management..there more or less behavious is like cube.. they store data against technical keys..so there can be same data also in two requests..

so data if goes to cube it wil never be correct..

as per design guidelines it is always better to have standard DSO after WO DSO.

So this DSO has three tables and change log table will help you to create before and after image of records and create necessary delta record.

I hope this is clear..

Thanks and regards

Kiran