Deleting all the request from DSO and Info-cube but still some data can be found in that target.

[former_member206066]

Hello Experts,

Deleting all the request from DSO and Info-cube but still some data records can be found in that DSO and Info-cube.

Is it a normal behaviour of DSO and Cube??

[havanur123]

HI ,

Could you please check this link , it might help to delete all the data .

https://blogs.sap.com/2013/10/24/how-to-delete-all-request-from-info-cube-and-dso-in-a-single-click/

BR

[former_member182878]

Hi Ipsita,

Right click on DSO/Cube and press delete data this will delete entire data in dso/cube.

Regards,

Prakash

[former_member206066]

Hello Prakash,

The flow is like: it is loading data from DSO1 to DSO2 with "Full" DTP type and then loading Delta from DSO2 to Cube1.

I have delete entire data in dso2,cube1 by Right clicking on DSO2,Cube1 and pressing delete data.

After that when I am loading data to DSO2 and Cube1,it is adding 0 number of records and no no is uploading to the DSO2 and Cube1.

How can I solve the issue??

Thanks,
Ipsita

[former_member182878]

Hi Ipsita,

Please elaborate in which environment you are doing this activity (DEV, QA, PROD) and why you are deleting data.

As a work around please follow below steps to load data.

1. As you mentioned DSO1 loads data with full DTP to DSO2. You can load data to DSO2 as usually using full DTP.

2. Create Full DTP between DSO2 to Cube1 and load the data.

Regards,

Prakash K

[former_member206066]

Hello Prakash,

I am doing this in dev.

After deleting all data from DSO2 and Cube1, the full DTP (which loads data from DSO1 to DSO2,) is loading successfully but no data is adding to the DSO2.Added records are showing 0 records.

Same issue for the load of DSO2 to Cube1, After executing delta DTP ,0 number of data are adding to the cube.

I dont know if the DTP is corrupted .Do you have any idea

Thanks,

Ipsita