Multiprovider.

[Aummad]

Hi,

I have a question,

i need to create multiprover, can i add "0INFOPROV" object or it is come automatical when i create the infoprovider.

Thanks

[Former Member]

Hi,

in bex:

0INFOPROV is available under 'datapackage' dimension.

u need to create a variable for the 0infoprov. just place this 0infoprov in the filter of the query and restrict it whatever cube u want to use.

cheers,

Swapna.G

[Former Member]

<b>Example</b>

If ur doing Variance Analysis - > Actuals versus Budget with Actuals coming from Actuals Cube n Budget frm an Integrated Planning Cube - Report is created on a Multiprovider - Even after restricting Amount with value types n version jst to make sure Actual Amounts will also be restricted Infoprovider - > Actuals Cube and so with Budget Amounts.

[Former Member]

Hi

It comes automatically which gives the number of infoprviders attached to the multiprovider

[Aummad]

Hi,

how do i use in the BEx,

Please explain me with the example.

Thanks

[Former Member]

Hi again,

usually we will use it in the querydesigner to filter the data

say multiprovider is getting the data from two cubes

,if our requirement is to run the report only on one infocube you can use this

Cheers,

Swapna.G

[Former Member]

Hi Rob

It comes automatically in the report in left hand side. Based on this field you can restrict query data according to infoprovider used in MP.

In ODS we have no. of record field which comes automatically.

Thanks

Tripple k

[Former Member]

Hi ROb,

How are you doing........

i guess it comes qutomatically

Cheers,

Swapna.G