on 09-20-2006 5:26 PM
Hello Experts,
I built a query on a multiprovider that has 11 cubes.
I have to see if my query is using the pruning logic or not. So I went and ran my query in RSRT and there I dont know what options should I check to see ,if given a particular year and version combination if my query is going only to the cube required.
I already have the config table built where it says for sepcific version and year combination a particular cube needs to be used.
Please help me out with a solution.
Thanks
Lakshmi
I did check them but the point is it is directly going only to 1 cube and the query is not using aggregates on that cube though aggregates are present and are filled and switched on. There is no data in the cube . Is that the reason?
Till yesterday when I run RSRT it was going to each one of the cubes and then we could see whcih aggregate the query as using form each cube. only 1 cube was not using an aggregate and toady its going onlt to taht cube.
How should I check which cube is being used when a specifc combination of version and year are run?
Thanks
Lakshmi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Sri
Check box Multiprovider Explain in Execute and debug mode ,explain SQL,Display Data Stat if you wanna check Cache you can do that .Select Aggregates for Cubes too.
Hope this helps
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you can filter by 0INFOPROVIDER in your query to ensure it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.