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

values are getting doubled?

Posted on Aug 02, 2006 at 09:18 AM 18 Views

Hi All,

I have a following scenario

I have a key figure STN value in a CUBE for which i have update routine from where it is looking up from a different ODS. Unfortunately the pesron who loaded the data to ODS has done twice.

No when i run any report i am getting the values doubled, like in r/3 if it is 150 and report it is coming as 300

Hopu u got me.

Now you tell me without doing anything to that ODS, how do i get the correct value as it is R/3.

Thanks in advance..

Ram

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 09:24 AM
    1

    Hi Ram,

    are all values twice in ODS? I think there are two options without correcting data in ODS

    - loading the data to InfoCube and divide every value by 2 in update rules

    - creating reports based on caluculated key figures and dividing the source value by 2 in key figure definition in query designer

    Best regards,

    Björn

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 09:33 AM
    1

    Hello Ram,

    If it's a full update to ODS, just delete the second request from it if both the request are not clubbed together and activated.

    Else delte both requests and reload it once again.

    Hope it helps..

    thanks,

    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.