Drill-through disabled in CA

[yashgt]

I am using Crystal Analysis Professional 10 to display a cube stored in MS Analysis Services 2000. In the cube roles, Drill through is enabled. Also the cube has drill through enabled with all columns from the fact table selected.
With this setup, the cube is reprocessed and opened using a Crystal Analysis report. The cube data is seen correctly. But when I right-click on a cell, the Drill-through menu item appear greyed out.

Can somebody suggest what may have to be done to let me drill-through using Crystal Analysis?

Thanks
Yash

 

[AMJackson]

Sure I've used this before, but can't recall exactly off the top of my head.
I recall that if you are too high through the hierarchies in the dimensions, then the results for the drill through get very large very quickly - almost making them unusable - that's a data problem not a program problem.
If you're drilling through so that say you're only getting a thousand or so rows, then it should happen pretty quickly; if the result is going to be too large then expect to wait a while waiting for the results to come back.

I think there might be issues also if you have multiple partitions