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

Wrong invoice figures

Hi All,

In our bw system, Sales data has been sent twice from a faltfile to ods and then to cube.

our customer proposed to put a -ve in front of sales invoice value to cancel out the duplication. Is this recommended? Is the quantity also stored in the cube and therefore should this too be negated?

What is recommended here to get rid of duplicate data?

Thanks,

V.Singh.

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 Sep 07, 2011 at 01:49 PM

    Hi

    You can load the flat file again with -ve invoice values.after you load this request to CUBE, do not forget to compress the data in CUBE.

    If you do not compress the data in CUBE, as the request ID is different for earlier request and present request data will not get aggregated.

    Regards,

    Venkatesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2011 at 01:48 PM

    Hi,

    If the request in cube is not compressed then simply you can delete the duplicate request from manage tab, but if the compression has already done then you will have to go for selective deletion of duplicate data and then do a reload from DSO.

    Regards,

    Durgesh.

    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.