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

values are getting doubled?

Posted on Aug 02, 2006 at 09:18 AM 10 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

BW Business Explorer (SAP BEx)
Add comment
10|10000 characters needed characters exceeded

2 Answers

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

    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 comment
    10|10000 characters needed characters exceeded

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

    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 comment
    10|10000 characters needed characters exceeded