Drill Down not working in case of MDX
I dont know how many have experienced this.. some functionalities get executed in SSRS when SP is used rather than MDX queries. The probel i face is , i developed a POC wherein i have used SP to obtain a Recursive Drill down, the performance was bad , but i chieved the drill down. When i implement the same Recursive drill down using an MDX query, i dont seem to get it. I have followed the exact steps to get a recursive drill down. Still i dont get the drill down.
What i have done is : 1) In the detail rows edited the group and Grouped the (Say) ClassId to its parent classId
2) Togglled the visibility
I have done the above two steps and i have got the Drill down working when i am using an SP but the same is not working for an MDX, though i am obtaining the same O/P for both cases.
Thanking you in advance
Regards
Sai
