Skip to Content
author's profile photo Former Member
Former Member

0RECORDMODE

Hi All,

I have an ODS where I need to add up a particular Key figure if the Keys match in the same datapacket or in subsequent data packets.

So whenever the keys match I need to aggregate a particular Keyfigure.Pls help me out on how to get this done.

Thanks

Ashish.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2004 at 03:47 PM

    Thanks for your inputs..

    We are using a custom extractor in which the recordmode is comming in blank.

    Is there any way that i can add up these key figures..

    Thanks

    Ashish.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ashish,

      if your record comes up without recordmode, I think your KF is filled with the new image (that is the actual updated amount)....so, why don't you use the overwrite update method ???

      Bye,

      Roberto

      (please don't forget to reward the answers that contributors gave to you by clickin'on the yellow stars !!!)

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2004 at 11:00 PM

    1) make sure you have the correct key field on the ODS i.e. all the fields you call keys.

    2) make sure that the update type is "Addition" for the KF's in the update rule.

    The 0recordmode is used not nessecary here, but you need it if you want to delete a row, i.e. recordmode = 'R'

    Regards

    Kristian

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2004 at 03:42 AM

    Hi All,

    Setting the Key figure to additive delta ..the original record is still getting over written by the new Key figures..

    Like for the same set of Keys..

    Amt 500

    Amt -200

    The result is -200

    But I need to add them both up to get 300.

    How do I achieve this??

    Thanks

    Ashish.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2004 at 12:00 PM

    Hi Ashish,

    As per your requirement, you wish to add the two KF's in ODS using delta mechanism. In order to achieve that, first check the type of the delta method which is associated with the data source from where you are pulling the data in BW.

    In BW, delta method classifies the data source wrt record mode and based on Record mode in delta method, OLTP system supplies image/s to BW.

    LetÂ’s take an instance, You require 500200=700 after second data load. But data source has record mode equal to an additive image (-300) or before image (-500) and after image (200) then you will get 200 only irrespective of ODS setting like overwrite or add.

    Hope it helps you.

    Thanks and Regards,

    ~Ketan Patel.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.