multiprovider query

[Former Member]

Hi experts,

How to restrict the results of a multiprovider query so it will display results from only one cube?

My MP has 2 cubes.

Thanks

[Former Member · Accepted solution]

Hi Krishna,

When you create a query on a multiprovider, you can make use of one infobject characteristic called 0infoprov which can be used for restricting the query to one of the infocubes by selecting the name of the infocube as the value for the 0infoprov and restricting by that.

For more information on this please refer the link below:

http://help.sap.com/saphelp_nw70/helpdata/en/43/5617d903f03e2be10000000a1553f6/content.htm

Hope this solves your concern...

Regards,

Habeeb

Assign points if helpful..:)

[Former Member]

You can do this on Report - Find Infoprovider from the Datapackage Dimension - Restrict it to the reqd Infoprovider.

If u need to derive keyfigure values from both cubes - Create seperate selections -> Restrict them to Infoprovider - > Give the Infoprovider Name