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

ODS Issue

Hi All,

<b>CASE</b>: We are loading the datafile from non sap system into BW for a file called Billing datafile(ascii).

Our objective is to build Billing Cube from Billing ODS.

<b>situation:</b> Billing data file is loaded in the Billing ODS.

Billing Update data file is then loaded, where each row leads to update of billing ODS row already loaded.

Billing Cube is then built from data in Billing ODS

<b>Problem facing </b>:

Bill cube shows duplicate rows for a billing line item (where single row is expected) with only one fieldÂ’s value repeating and all other field values being 0 in duplicate record.ODS shows single row for the billing item in question.If Billing cube is dropped and re-created, duplicate rows go away.

What is the possible best solution to avoid duplicate records and to load all other fields values.

Points will be assigned on reply

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2006 at 12:03 AM

    Hi,

    How about building an aggregate?

    Cheers,

    Gimmo

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Assume that your cube has :

      Documentnumber and Netsales.

      And Asume that you had a record in the Cube and ODS like

      100000 100

      And assume That the above record is changed in ODS as like below:

      100000 200

      So the delta records available for the delta uload to Cube from ODS are:

      100000 -100

      100000 200

      So after this delta load to Cube you will have the records in the cube as follws:

      100000 0

      100000 200

      With rgds,

      Anil Kumar Sharma .P

  • author's profile photo Former Member
    Former Member
    Posted on Aug 28, 2006 at 11:11 PM

    Is the load to the cube a full load or a delta?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 29, 2006 at 05:11 AM

    Kim,

    Welcome to SDN,

    1. When loadin to a cube , all fields ( characteristics in the update rules ) are key fields.

    2. Anil kumar sharma has given a very good explanation of how the records get stored in the cube

    3. Please view the contents of the cube either by request ( if you do not want to see any report ) or through a report , the records would automatically get summarized (0+200 is still 200)

    4. Also if you do not want to see the duplicate rows , compress the cube.

    My 0.02

    Arun

    Assign points if useful

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2006 at 09:45 AM

    Hi Kim,

    It seems that you are loading "full update" mode from ODS to infocube. If this is the case then you need to delete the entire data from infocube and then reload the data from ODS to infocube with "initial update" and in the next load select to "Delta update". Using this your problem will be solved.

    Hope this helps you!

    SAM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2006 at 09:17 PM

    Question or rather a clarification from Anil Kumar Sharma on one of the earlier posts in this thread.

    Anil,

    In your example, you have stated the following:

    "So after this delta load to Cube you will have the records in the cube as follws:

    100000 0

    100000 200"

    Assuming that the document number is the only characteristic in the cube, would there be one row or two rows after the negative and the positive amounts are applied?

    Because if the document number is the key for the fact table, how can the fact table contain two duplicate rows for the same key? Am I safe to assume there will be only one row for "100000 200" instead of the two for 0 and 200. Just curious.

    Thanks.

    Abdul

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Abdul,

      If I have not mistaken, Anil's explanation is based on the Package dimension.

      I think Anil meant that the first record is coming with the Request ID from the first load while the second record has it's own Request ID.

      Unless these two requests are compressed, fact table will have 2 different rows.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2006 at 12:42 PM

    Mahesh,

    In that case, there will be two records for 100 and 100 instead of 0 and 200.

    Request id 1 100000 100

    Request id 2 100000 +100 (summation of -100 and +200).

    What am I missing?

    Abdul

    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.