OWC 10 Drillthrough Issue

[ASena]

We've been using the Drillthrough.htc file provided with the OWC10
toolpack for a while now with mixed results. The end-users of the
office web components have been put off by the inconsistent behavior
of the drillthrough. The code works about 20% of the time and when it
fails it returns the following error:

Could not get detail records for this aggregate.
Make sure that permissions to obtain drillthrough records are set
properly on the OLAP server.

Now, I have verified that the drillthrough is enabled on the cube and
can perform all drillthroughs through Analysis Server with no problems
at all.

I was wondering if anyone could tell me where the problem in the .htc
file lies and how to fix it? Even better, are there other ways to
perform a drillthrough on an OLAP cube, leveraging the OWC PivotTable
without having to rely on an .htc file?

Any insight on this would be GREATLY appreciated!!!

 

[Aymer]

The problem maybe the because the Analysis Server Times Out. Analysis Server Drillthrough has connection limit of 15 seconds. After 15 seconnds and the connection is not connected and the aggregation is not complete, then the drillthrough times out. The time can be increased to 30 seconds after installing sql server service pack 1.

To check for this notice how many seconds it is before the alert comes up. It is usually 30 seconds. This is a limitation of analysis server. Nothing can be done

If it is more than 30 seconds then it may be the client-to-server connection. If the connection is long, then the alert comes up. You can change this by not returning to much drillthrough information. Play around with the drillthrough where clause

I hope this helps
peace
ayme
aymerb1980[@]hotmail.com