cancel
Showing results for 
Search instead for 
Did you mean: 

Best Practice to Create BEX Query on Infocube or Multi Provider ?

aluri_hemanth
Participant
0 Kudos

Hi,

Could some one share me the best practices to create BEX Query on Infocube or Multiprovider ?

In which scenarios we need to take the decision BEX query has to be created on which Inforprovider's ?

Thanks,

HA

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi H A,

No doubt, its always better to create query on a multiprovider.

There is no scenario as such to create a query over an IP, but if all the fields you may need in the query, if u can find it in a single Info Cube, then u can go ahead.

But in a general sense its always better to create over a multiprovider because the system uses parallel processing when queries on a Multi Provider are executed and not only that it allows for inclusion of any other infocube at a later stage...etc..

Br,

Shreesh.

Answers (6)

Answers (6)

former_member182196
Contributor
0 Kudos

This message was moderated.

Former Member
0 Kudos

Hi,

If you having an infocube which having data which is sufficient for reporting then you can go for BEx Reporting based on this infocube.

But Consider if Reporting requirment is having report on data which belongs to multiple InfoProviders like InfoCubes/DSOs then its better to go for MultiProvider. Its Doesn't store data physicaly. You can apply conditions as per requirment on your multiple Infoproviders, fetch the data into MultiProvider and finish your reorting requirment using BEx.

Hope this Helps.

Thanks,

Santosh.

aluri_hemanth
Participant
0 Kudos

Thanks All,

I understand that considering the future requirement it is always better to create on top of Multiprovider. But do we have any caution in terms of performance if we create BEX query on multiprovider even though we have only one info cube on multiprovider ?. If yes, can anyone give an example how it impacts on performance ?

Former Member
0 Kudos

Dear H A,

No need of any caution if you create a query on a multiprovider even thou u have a single cube inside that MP(except that the consultant may some the time & efforts in creating the MP). Otherwise in fact its recommended. Because even if u have sever cubes inside a MP but your query may seem to fetch data from a single cube, then u can put a restriction for that particular cube in the filters section....this is what is being followed normally!

BR,

Shreesh.

former_member199945
Active Contributor
0 Kudos

Hi,

We will create M.P only in Particular cases, we won't create M.P if we have only one infocube/DSO.

M.P : is combination of 2 targets (Union)

kindly refer below doc clearly explains when we will prefer M.P/CUBE/DSO and performance .

Thanks.

former_member202718
Active Contributor
0 Kudos

Hi HA,

Go through LSA Data flow.

We will have  MP in place irrespective we have one Cube or multiple cubes....we are making things SCALABLE...you may design the flow ..but at the same time we have to see to it that after 3-4 years if some other consultant wants to work on that or gets some changes it should be done with least difficulty.We need to consider for all future requirements aswell and then design.

Sometimes  it helps in Authorization naming and bifurcation also.

regards

SVU123

KodandaPani_KV
Active Contributor
0 Kudos

Hi,

if you create the query on MP it will connect multiple info cubes.- it will work based on the union operation and sap recomanded under MP we can use the 12 info cube

i used the MP under 4 cubes and if you develop the query on MP you will get the data form multiple sources.

if you create on the query on infocube you will get the only one info cube.

Thanks,

phani.

Former Member
0 Kudos

Hi,

Best Practice what we followed, create BEx queries always on top of multiproviders. if you want bring some extra fields to your report you can minimize work using multiprovider. if you have single infocube also add it into multiprovider.

So, always try to create on top of multiprovider.  

RamanKorrapati
Active Contributor
0 Kudos

Hi,

Multi provider is used when we need to do report on multiple targets which are possible club them(data of multiple targets) at reporting level. Multi provider works on union based.

If you have single cube then you can create report on cube it self.

Thanks