Skip to Content

strange issue

Hi All

I have changed the ODS design

Upon testing in System, The output from ODS (XXX) shows actuel value ,which i have changed Material group from F10104 to F10103.

As per new design report on ODS, Here we can see recent values

The output from Multi provider , It shows the incorrect values ,while updating the values from ODS to Cubes the ratios comming with negative values For initial Record (F10104).

As per new design report on Multi provider, Here we can see recent values and old values with negative values .

as per the ODS it should be only delta record F10103 on Mutiprovider

Can any one help me.

Thanks,

Mohan


Image.png (59.4 kB)
image2.png (40.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Nov 28, 2013 at 12:48 PM

    Hi,

    Is is evident that negative value record is coming from cube.Please check the data in cube and validate the value.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 28, 2013 at 12:51 PM

    Hi,

    recheck at cube level, keep filter on material group - F10104 and check it. how it look like.

    if its -ve then need dig further on it. you can cross check at LISTUCBE also.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2013 at 01:00 PM

    Hi,

    Do you have the DSO directly on the multi provider or u load it to any Info cube from DSO.

    If there is a cube then u need to selectively delete the data from the cube before loading it again from the DSO.

    Thanks,

    Sathya

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2013 at 02:44 PM

    Hi Mohan

    Can you tell if Material group is a data field in the ODS?

    That could be the reason the Infocube is showing negative values - as you are also

    viewing based on this characteristic

    Regards

    Anoop

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Anoop,

      As per Sathya said record has loaded wrongly in Cube hence we can selectively remove from cube.

      Your Point of view, yes Material group is a data field in ODS.

      I have changed material group from A102050 to A501060 in ECC and loaded to BW the report is showing old records also as i have marked as Blue color. as per user want to show the record as like ECC material group like A501060 it should be only one record as i have marked as Record color below attachment. I want to eliminate old material groups from reporting

      Thanks,

      Mohan

      image3.png (16.8 kB)

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.