Multiprovider Query Filter
I created a query based on a multiprovider. Now I want to filter in this query but only for the Infoobjects of one infocube and not for the whole query.
How can I realise it?
Thanks for your help!
Sven Muntermann replied
hmmm, tricky, the cube bases on a UNION ....
a.) try to assign the desired value/variable to 0SOURSYSTEM AND(!) the value "#".
if this doesn't work try the following:
create a query onto the multiprovider by selecting on 0SOURSYSTEM (and the INfoCube ZA_XA). Use this query as a prequery.
create antother query WITHOUT using 0SOURSYSTEM. for this query use variables of the type "REPLACEMENTPATH" where the values should be filled out of the prequery.
but first try the "#" thingy...