Skip to Content
author's profile photo Former Member
Former Member

Multiprovider Issue

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 28, 2007 at 04:56 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 28, 2007 at 05:16 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 28, 2007 at 05:25 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2007 at 03:33 AM

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

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2007 at 04:55 AM

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

    cheers

    Sunil

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 29, 2007 at 05:06 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2007 at 05:48 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.