cancel
Showing results for 
Search instead for 
Did you mean: 

RSRT

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

Checkl the generated SQL (as mentioned baove) and manually try and do the union and joins yourself on other sessions - you will soon find the join failure

Former Member
0 Kudos

Actually my collegue (ramana) has got something to add (he is better at the fine detail than me)

Because there is no data - the aggregate can't be rolled up and is thus not active - so the SQL will bypass the aggregate and hit the cube

Former Member
0 Kudos

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

Former Member
0 Kudos

you can filter by 0INFOPROVIDER in your query to ensure it.