Skip to Content
0
Former Member
Dec 15, 2012 at 04:48 PM

How to Implement this complex logic in BW?

21 Views

Hello Experts,

Need all of your expert help to implement this below complex logic.

Multiprovider has been created above a cube which has the following sample data fromat


Question_ID

Response1

Response2

Response3

1

M1

#

#

1

M2

P1

#

1

#

#

C1

1

#

#

C2

2

M1

#

#

2

#

P1

#

2

#

P2

#

2

#

#

C1

Need all of your expert help to implement this below complex logic.

All column data should be displayed in the same line item against each unique ID (suppressing the #(Not Assigned) value) in the target object(table) as given below:


Question_ID

Response1

Response2

Response3

1

M1

P1

C1

1

M2

#

C2

2

M1

P1

C1

2

#

P2

#

To implement above scenario, we wrote start routine between DSO and Cube, but result was displayed like this format truncating multiple responses:


Question_ID

Column1

Column2

Column3

1

M1

P1

C1

2

M1

P2

C1

Any ideas anybody plz. If using start routine/expert routine, we can implement this then can someone pl help me out with how to go about it.

Thanks..