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

Errors in reports

Hai,

I am working with FI-AR data thats coming from two different R/3 systems(say I and II). The data is extracted from datsources from R/3(each R/3 has different datasource) and finally consolidated in a ODS, a special program is run to check some conditions and delete unwanted records(as per the criterion) and then loaded into a cube.Once the data is in ODS, from then everything is same for both the data till the end(like the objects, change routines). My problem is when I am running reports, the results with data from the system I is perfect but there are errors in results from system II. Can anybody suggest me what the probable reasons are and how to solve this problem?

I am thinking of the following:

1.Extractor or datasource is not picking up properly for II?

2. Delta update is not catching up?

3. Extractors in R/3 needs to be checked for consisteny?

4. Initial data loads problem??

I appreciate any kind of help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 22, 2005 at 05:42 PM

    Hi,

    We too had a similar kind of problem.

    What we did is got the erroneous records from the report and with a top down approach traced those records from cube then ODS and so on..

    Our error lied in the ODS due to some inconsistencies in data.

    You might try doing the same..

    Hope this helps..

    Ashish.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 23, 2005 at 04:36 AM

    Visu,

    what is the error , I assume that:

    1. You have no errors in data loading

    2. The result is not what you expect .

    What could be wrong is :

    1. CHeck your update rules for overwrite / Addition , in most cases that might be the culprit since there is not too much clarity in how records are stored in R/3 - as to whether they are overwritten or stored in a different record when changed.

    2. Check the logic of your transformation with an end to end use case , that would solve all your problems.

    I would suggest you put effort into an end to end use case and try to validate it at every step.

    Arun

    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.