Skip to Content
author's profile photo
Former Member

Scenerio..

Oct 06, 2005 at 08:46 AM | 12 Views

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

BW (SAP Business Warehouse)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Best Answer
    author's profile photo
    Former Member
    Oct 06, 2005 at 08:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Oct 06, 2005 at 09:26 AM

      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

  • author's profile photo
    Former Member
    Oct 06, 2005 at 08:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 06, 2005 at 09:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Oct 06, 2005 at 10:00 AM

      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

  • author's profile photo
    Former Member
    Oct 06, 2005 at 10:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Oct 06, 2005 at 10:58 AM

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

  • author's profile photo
    Former Member
    Oct 06, 2005 at 10:55 AM

    Continutation to my previous statement

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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 06, 2005 at 11:19 AM

    Hi,

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

    sachin k

    Add comment
    10|10000 characters needed characters exceeded