Skip to Content
0
Former Member
Dec 05, 2007 at 05:38 PM

Cross Product modelling question

17 Views

Hello

I have two ODSs whose structure is as mentioned below.

ODS-1

-


A(Key) B(Key) C(Key)

-


01 01 X1

01 01 X2

ODS-2

-


A(Key) B(Key) D(Key)

-


01 01 Y1

01 01 Y2

C & D column values will be multiple in their respective ODS2 and there is no relation ship between them.

My report requirement is as shown below. X2& Y2 values are under C & D columns.

-


A B C D

-


01 01 X1 Y1

X2 Y2

If I creaet a infoset on above two ODSs by joining fields AB. I am getting result as shown below. X1&X2 are under C and Y1,Y2 are under D column.

-


A B C D

-


01 01 X1 Y1

Y2

X2 Y1

Y2

I will be glad, if you can guide me to resolve this.

Regards

MB