Multiprovider Issue

[Former Member]

Hi Experts,

I have created a Multiprovider (union of 5 cubes) and generated 3 querys. One Query is accessing data from three cubes? If i execute the Query it is going the read all the 5 cubes data and based upon the Query definition it is going to retrive the data from olap. How can improve the performance of this query? Can any one explain it in brief?

Thanks in Advance

Vara

[Former Member · Accepted solution]

take a copy of the Query. Consider infpackage IO also into Query. Filter your Infopackage ID to required Infoproviders.

Give a try and let us know. Please check the Quality of Data first.

Nagesh Ganisetti.

• Assign points if it helps.

[Former Member]

Hi Varam,

Chintu here... When ever we talk abt the Query performance the we need to check,

1. Whether database parameters are set properly or not

2.Degenerate Indexes

3.Check out with Partitioning

4.Check the read mode of the queries

5. If you are generating the queries based on only 3 cubes then restrict the cubes in the Query designer.

6.Try to run the Queries based on Pre Calc Value sets and Pre Calc Web Templates.

Please check all these parameters and let me know whether your problem got solved or not..

Assign Points if it helps..

Thanks,

Gattu.

[former_member185071]

Hi Varaprasad nese

Just have trail with the following just go to query there in the left panel under

Datapackage Dimension u will the infoobject 0INFOPROVIDER drag to Filter area

and double click on it select the info providers from which u want to see the data

and then say ok save it and execute .it will fetch the records only from those

infoproviders.

Hope itz Helps..!

Regards

KISHORE M REDDY

**Winners Don't Do Different things,They Do things Differently...!**

> Hi Experts,

>

> I have created a Multiprovider (union of 5 cubes) and

> generated 3 querys. One Query is accessing data from

> three cubes? If i execute the Query it is going the

> read all the 5 cubes data and based upon the Query

> definition it is going to retrive the data from olap.

> How can improve the performance of this query? Can

> any one explain it in brief?

>

> Thanks in Advance

>

> Vara

[Former Member]

Hi ,

There are three solutions to gain efficiency:

1.Set a characteristic as a constant value of InfoProvider

2.Include characteristic InfoProvider (0INFOPROV) in query filter conditions

3.Restrict the technical InfoObject 0INFOPROV automatically

Have a look into this link which says how to create efficient multiprovider queries

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/751be690-0201-0010-5e80-f4f...

cheers

Sunil

[Former Member]

If you only have data from 3 cubes you can use the infoprovider infoobject and filter only the infoproviders that you want

Regards

[Former Member]

Review and analyse how the data is organised in the basic cubes. If you think, the data is read only from one cube that constitute the multi provider, then put a filter on that cube by using 0INFOPROV char.

Also, run RSRT by chosoing execute + debug mode and click multi provider explain.

Ravi Thothadri

[Former Member]

Your query performance is based on the query you created, make sure you optimized the query

1. Avoid putting all query results in the rows.

2. As much as possible avoid Exclusions or replace exclusion by inclusion.

Cube:

1. Try to compressed your underlying cubes in the MP.

2. Create reasonable aggregates.

3. If you are in 7.0 you can partition the cube while data still sitting there.

4. Make sure you utilize query caching appropriately.

And if all this doesn't help you, then consider creating precalculation on the query.

thanks.

Wond