Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Multiprovider Query Filter

Hello,

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!

replied

Hi,

hmmm, tricky, the cube bases on a UNION ....

first

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...

hth

cheers

sven

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question