Skip to Content
0
Former Member
Jul 28, 2006 at 04:40 PM

Display multiple liked data in same column (one-to-many relationship)

33 Views

Hi All,

Allow me to illustrate my problem with an example.

Suppose I have a cube with the following infoObejct and data:

<u>0EMPLOYEE</u>....<u>ZDEGREE1</u>....<u>ZDEGREE2</u>....<u>ZAMT</u>

1......................AA.................BS.................3000

2......................BA.................MS.................5000

Is there any way whereby BEx can display the data as follows:

<u>Employee</u>......<u>Degree</u>....<u>Amount</u>

1...................AA.........3000

.....................BS

2...................BA.........5000

.....................MS

Please any help will be much appreciated.

Thanks in advance,

Binh