How to clean data from infocube

[Former Member]

I need to clean all data from my infocube and re-load data into it. Which setting(s) can help me to delete current data from infocube?

Thnaks,

Mike

[former_member189638 · Accepted solution]

Right click the Infocube -> Delete Data

Make sure you don't click on Delete because that is to delete the Infocube. You need to select Delete Data

[Former Member]

THanks so much for all of your help!

[Former Member]

hi,

you can delete the data from infocube by selecting your infocuberight clickselect delete data.

otherwise,select your infocuberight clickmanagethen select the contents tabthen select delete selective--so based on the request you can delete the data.

hope this help you

regards

harikrishna N

[chemicala_srimallikarjuna]

Hi,

you can use "complete deletion of data target " process type before you schedule ur load in PC.or if the cube is being fed from diff sources, you can use "delete overlapping requests" process type.There is no need to write any routines.it clears everything from the cube.

Steps for process Chain

Start

Delete Index ( for Cube )

IP1*.....

Delete Overlapping Requests from InfoCube*

Create Index ( for Cube )

IP1 - Infopackage - Datatargets - Automatic loading of similar or identical requests - Select Deleting Existing Requests - Flag Full or Initial Load - Flag Datasources are same - Selections Are " Same or Comprehensive " - Save .

Delete Overlapping Requests from InfoCube - In this process type - Object Type - Execute Infopackage - Select the one in use for Full with the Tech name - Click on Deletion Selections at the bottom - Set the same selections as in the Infopackage

Hope this helps,

regards

CSM Reddy.