Bex constant selection on multiprovider with several infoproviders

[ramesh_duraisamy]

Hi Gurus,

Is there any way to use constant selection on multiprovider with 3 infoproviders,

1. We have 3 keyfigures each one coming from different infoproviders. We are getting the query output in 3 different lines,we used constant selection on 2 infoproviders and able to merge the output? But not able to use constant selection on all the 3 inforproviders at a time?!

Can you suggest any alternative solution on this issue?!

[Former Member]

Hi,

in such a case we have to use 2 uncommon char as a constant selection in the multiprovider level.

for example IP1 and IP2 having customer as not a common char in Info provider level. so use customer as constant selection and make customer as not equal to not assigned in the selection.

now we have common values in IP1 and IP2 so make this as IP12. then compare IP12 with IP3.

there must be one uncommon char in IP3 which we are going to use in the report. for example material

is uncommon for IP12 and IP3. here again make material as constant selection and include not equeal to not assigned in the selection.

hope this will work.

best regards,

Bashkar.

[yasemin_kilinc]

Hi Ramesh,

In such cases I generally follow this procedure:

I create selections for key figures. For each key figure I assign the infoprovider to the selection and I also assign the characteristics with constant selection which does not exist in that infoprovider. For example suppose you have

Cube_01 with  zchar1, zchar2, zkyf1

Cube_02 with  zchar1, zchar3, zkyf2

Cube_03 with  zchar3, zchar4, zkyf3

For zkyf1, I create a selectıon ZKYF1 I add zchar3 and zchar4 both with constant selection and infoporvider as Cube_01.

For zkyf2, I create a selectıon ZKYF2 I add zchar2 and zchar4 both with constant selection and infoporvider as Cube_02.

For zkyf3, I create a selectıon ZKYF3 I add zchar1 and zchar2 both with constant selection and infoporvider as Cube_01.

It works in my cases.

Hope it helps

Yasemin...