Deletion of InfoCube data based on Source

[Former Member]

Hello All,

We have an InfoCube, loading data from 3 DSOs (say DSO1, DSO2 &DSO3) on daily basis. Now, we need to change the definition of KeyFigure (KF) InfoObject definition which is present in the InfoCube.

To modify the definition of that KF InfoObject, we need to delete the entire data present in the InfoCube. as I mentioned, data is loading from 3 DSOs on daliy basis. Out of 3 DSO's, the DSO2 is not supplying any data to that particular KF in the InfoCube. ie., there is no mapping in Transforamtion.

Question:

Is there a way to delete only DSO1 & DSO3 data in the InfoCube level instead of deleting the whole data?

Many thanks for your answers in advance!!!

Best Regards

Venkat...

[Former Member · Accepted solution]

Thank you all for your suggestions!

I deleted the contents from context menu, no other way since the other ways are a bit complicated

Best Regards

Venkat...

[KodandaPani_KV]

Hi,

please check the below document how to delete the records form cube particular count.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/4001f4b1-189f-2e10-bcb3-87bb0fb42...

Thanks,

Phani.

[RamanKorrapati]

Hi,

Selective deletion is time consuming one. You need to find the request ids which are from DSO1 and DSO2.its not good practice.

if you have options on data source based at selective deletion then that be good idea to go ahead.

Another way: write custom program and use selections on data source(request tab-->data source, it contains source DSO name). Based on data source(DSO name) try to delete the data. it might be useful.

if your DSO(historic data) holds very less data then delete whole data form cubes and reload it. Reloading whole data with in the bw doesn't take much time.

check Tx/program - DELETE_FACTS..

Thanks

[former_member186053]

Hi Venkat,

Do you have infoproivder field in Cube, just thinking if you have you can do selective deletion based on infoprovider.

If you have done compression you can not delete selectively based on request id.

lets wait for others comment on this.

Regards,

Vengal.

[Former Member]

Hi,

You can delete the data populated from the DSO1 and DSO3 without deleting data from the DSO2 by using the selective deletion on the "Request ID field" in the Info cube where you want to delete data.

Hope this helps.

Thanks and Regards,

Mahesh