Skip to Content
0
Former Member
Apr 12, 2010 at 02:47 PM

Infocube/query: more than a record by item

49 Views

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