variable values from values of multiprovider.

[Former Member]

Hi expert,

      I created a bex query on multiprovider, which including 2 infoset. and I restricted a character of multiprovider to get on specific values by setting "provider-specific property'.  and also I set for this character as follows. finally I create a variable for this character in bex query.

also I set this character in bex query as follows:

 

I just want prompt for this variable only include the values I restricted for the multiprovider, but unfortunately , this variable includes all values from master.  please help to figure out what 's wrong with my operation.

Many Thanks,

Bo

[fcorodriguezl · Accepted solution]

Hi Zhang!

Maybe help you, that document. Regards.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20ecb78c-374a-2d10-c6af-f024f19b7...

[Former Member]

Query execution Filter value selection: <>
This mode is valid ONLY for info cubes and DSO and multi-providers ( that consist of info cubes and DSO). Mode D also will not work if the characteristic is a Line Item Dimension.

Regards

Las