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.