Skip to Content
author's profile photo
Former Member

Partitions on ODS

Hi everbody,

I Hope and pray everyone is good and doing well. Could anyone tell me is it possible to Make partitions on ODS like cubes. Be frankly speaking, i don't have much knoweldge on Partitions, please let me know the main purposes and usage and handling of those. I am very thankful and appreciate to who will give peachy replies. Have a nice day

Thanks

satya

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 05, 2005 at 02:00 PM

    Hi!

    The purpose is simple it is easier and faster to search in partitions. I thik Roberto has already given the way to partion ODS.

    with regards

    ashwin

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 05, 2005 at 01:55 PM

    Hi dear!

    sure,you can partition Active Data table...

    look here for more details...

    http://help.sap.com/saphelp_nw04/helpdata/en/e6/bb01580c9411d5b2df0050da4c74dc/content.htm

    Hope it helps!

    Bye,

    Roberto

    (please, then reward the answer...it's THE way to say thanks here!)

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 06, 2005 at 07:14 PM

    Partitioning an ODS is done for two reasons -

    1) to improve query performance by allowing the DB to ignore portions of the table that are not relevant, e.g. you partition an ODS on 0FISCYEAR because almost all queries only ever look at one year.

    2) to ease data administration burdens when dealing with large tables, e.g. you want to archive off data that is more than 4 years old. The archive process can simply drop partitions rather than having to run delete query.

    ODS design does not use partitions to improve loading as the cubes do. Instead it has a separate table that new data is loaded to, and which is then subsequently inserted/updated to the Activated table during the Activation process.

    InfoCubes - the F fact table is partitioned to faciliates the loading of data. The E fact table could be partitioned on 0CALMONTH or 0FISCPER (these are currently the only options for cubes), and would be partitioned for the same reasons mentioned above.

    Cubes can be partitioned from within the BW Admin Workbench (cube MUST be empty). A DBA must perform partitioning of an ODS.

    Before considering partitioing an ODS, yo uwould want to now about the ODS size, what queries exist, how they are restricted/filtered, etc. Typically, an ODS is partitioned on a time characteristic, e.g 0FISCYEAR, or 0FISCPER, but could also be partitioned on something like Business Area, or could even be partitioned on 0FISCYEAR then Business Area. The queries really drive that decision. Not going to try to explain all the options, that's really something to review with your DBA.

    Add comment
    10|10000 characters needed characters exceeded