on 2007 Aug 28 5:37 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
cheers
Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you only have data from 3 cubes you can use the infoprovider infoobject and filter only the infoproviders that you want
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.