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
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