Skip to Content

in infocube Same request showing two record but in DSO Only one Record there

Hi,

I have Created DSO inside the Cube.

When I am loading the data from DSO to cube there is showing two record.

For Exp

Cube

Customer Action Date Request ID(DATA Package)

100 0 19.07.2016 8023

100 1 19.07.2016 8023

DSO

for Exp

Customer Action Date Request

100 1 19.07.2016 8022

In DSO Data has overwrite but in cube two data is showing but Data has loaded same day.

if the data has loaded in different day then both data be there in cube but same day and same request id, then why data is showing duplication

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jul 19, 2016 at 01:49 PM

    Hi,

    please check your DTP(which loaded data to cube) logs and time.

    At DSO also, please check how many requests are exist at DSO for today date?

    Cube is feeding data from DSO only or any other source as well?

    please check your cube data flow.

    from Cube-->manage-->request-->thru data mart symbol, please check from where your requests are loaded?

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 19, 2016 at 05:49 PM

    Hi Vinod,

    maybe this is due to the granularity of your model.

    If the maxium detail is CUSTOMER in your CUBE and in DSO you have additionally MAterial OR DOCUMENT, the system always will update cube with two records when the Customer summary information has a modifcation in your DSO, the first record with a minus with the old Qty or $ and the second with a + with the new Q or $.

    Hope this helps.

    Regards from Mx.

    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.