Hi everybody,
Please review this issue and kindly suggest a solution. I have an InfoCube feeded by 3 DSOs, here I go with the structures:
Zo01
ZDOCNR (Key)
ZPOSNR (Key)
ZDOCTP (Key)
ZREQNR
ZPOSRQ
ZIND
ZKYF01
ZKYF02
Zo02
ZDOCNR
ZPOSNR
ZREQNR (Key)
ZPOSRQ (Key)
ZKYF03
ZKYF04
Zo03
ZDOCNR (Key)
ZPOSNR (Key)
ZREQNR
ZPOSRQ
ZKYF01
ZKYF02
(Key) are the keys for each one of the DSOs, as you can see, each one of them has different key combinations. Now, my InfoCube let's supose has this structure:
Zic01
ZDOCNR
ZPOSNR
ZDOCTP
ZREQNR
ZPOSRQ
ZIND
ZKYF01
ZKYF02
ZKYF03
ZKYF04
We want to generate a report over this InfoCube having the info which comes from the 3 mentioned before DSOs but when reporting more than a record appears for each item. Let's supose this sample:
Zo01
ZDOCNR ZPOSNR ZDOCTP ZREQNR ZPOSRQ ZIND ZKYF01 ZKYF02
0001 1 X 1 1 LIB 123 456
Zo02
ZDOCNR ZPOSNR ZREQNR ZPOSRQ ZKYF03 ZKYF04
0001 1 1 1 789 012
Zo03
ZDOCNR ZPOSNR ZREQNR ZPOSRQ ZKYF01 ZKYF02
-no data-
the results in the InfoCube and therefore in the query is as follows:
Zic01
ZDOCNR ZPOSNR ZDOCTP ZREQNR ZPOSRQ ZIND ZKYF01 ZKYF02 ZKYF03 ZKYF04
0001 1 X 1 1 LIB 123 456
0001 1 1 1 780 012
I would like you to suggest how can I design the model so I can get these results (in the InfoCube and therefore at the report output):
ZDOCNR ZPOSNR ZDOCTP ZREQNR ZPOSRQ ZIND ZKYF01 ZKYF02 ZKYF03 ZKYF04
0001 1 X 1 1 LIB 123 456 780 012
Thanks a lot in advance. With best regards,
Bernardo