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

Missing records in ODS

Hi all,

I have following problem. When I am uploading data from csv files into BW. Everything in monitor is OK. But when I am looking into administration of ODS, there is an information that transferred records is for example 20 and added records is for example 16. Supposing that records are not duplicated, what can cause this problem ???

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2005 at 08:20 AM

    Hi dear,

    if you don't have any deletion in your routine (but you can see that in some message of your detail monitor screen!), the reason can be only one:

    you have a key field combination in your ODS for which several records belong to a unique key field combination !

    If you have

    Material, month and qty in your file and in the ODS you have only material as key, you will have only one record for each material even if in your file you have three records for the same one (but one row for january, another one for feb...and so on!)

    Hope now is clearer...

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2005 at 08:14 AM

    Hi JJ,

    U will get added records are lesser than or equal to the total records. Bçoz u may doing some validation in Update Rules or overwriting of records in ODS. Its all depends upon ur data.

    Srini

    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.