Scenerio..

[sachin_kulshrestha2]

Hi,

I have data loads to the ODS and from ods using data mart data goes to the cube

I want to remove couple of years of data from the ODS

what should be the steps

Sachin K

[Former Member · Accepted solution]

Sachin,

you can reset the datamart status for your ODS and delete the init channel between ODS and cube, then delete the request you consider not useful and then execute an init without datatransfer to reactivate the delta flow between ODS and cube!

Hope it helps!

Bye,

Roberto

[Former Member · Accepted solution]

Sachin,

did you try transaction delete_facts for your ods?

Siggi

[Former Member · Accepted solution]

Hi,

There are two points mentioned in the following link may be some what similar to your current scenario.

The points are:

1) If you only want to delete individual fields instead

of an entire request, choose Delete Selectively. With

this, you can delete data, for example, from a time

period that is no longer used. In doing so, only data

from the table for active data is deleted, while the

change log remains unchanged.

2) If you only want to delete data from the change log,

choose Delete from the Change Log. With this, you can

reduce the scope of the change log if several requests

have already been loaded, and only a limited history

needs to be retained. Thus, the data volume of the

change log is reduced.

http://help.sap.com/saphelp_bw32/helpdata/en/2d/677b3c513d3311e10000000a114084/frameset.htm

With rgds,

Anil Kumar Sharma .P

[sachin_kulshrestha2]

Hi,

Roberto thanks for discussion will open new thread if some new query pops up

sachin k

[sachin_kulshrestha2]

Continutation to my previous statement

Sorry not by deleting the int request by removing the data mart status.

[sachin_kulshrestha2]

Hi roberto,

In my dev. environment i am trying to remove the init channel from the ods by deleting the init request

system is giving me error

Req.no xxx is not the last request to have been updated.

Sachin K

[Former Member]

Sachin,

you don't have to delete the init request from the ODS !

Delete the init channel (between ODS and Cube) means:

go intoto the infopackage of the generated datasource "8nameofyourODS", then go to menu Scheduler->Initialization Options for Source System->highlight the row and delete.

In my previous post I said "Anyway, if you delete the init channel, automatically datamart status doesn't make sense (and you don't need to perform any additional activity on it!)".

So, delete the init channel and don't mind about datamart status.

Hope it helps!

Bye,

Roberto

...dear, don't forget to reward the answers...

[sachin_kulshrestha2]

Hi roberto

Thank you for your reply

Let me give you more details on it.

We have init done on ODS with multiple data selection on 0FISCPER. All the request was sent to cube in one go.

We have to transfer all data to some other data target from ODS and keep only this year data in ODS.

1. So if we delete the DM status from the ODS for init requests there is no effect on the cube request data still remains?

2. We Can again setup init without datatransfer between ODS and Cube so there will be two request which will be show in the cube with initialization.

3. All the request in the ODS has no effect even after removing the DM status of the init.

4. Can we use selective deletion in this case to delete the data.

Sachin K

[Former Member]

1. Sure, you would delete only the init channel and not related data

2. No problem in the cube with two init requests (in the cube you can load everything

3. No, you will not see anymore only the green flag related to datamart status for every request

4. Sure, and if you delete the init channel you don't have to take care about changelog tables !

Anyway, if you delete the init channel, automatically datamart status doesn't make sense (and you don't need to perform any additional activity on it!)

Hope now is clearer...

Bye,

Roberto

[Former Member]

do u mean that u want to remove(restrict) couple of yrs of data from the ods before feeding to cube. if yes then u can create a start routine which will restrict the ods from sending those data to cube.

Message was edited by: Ravi Raj