DrillThrough - Impossible to connect to the DB or open the results.

Hi to all,

I've copied an application and modified the query of drill-through...quite much, it's a very complex query (with subqueries, convert, union all, order by, and so on...).

When I try this query by simply opening it into Excel, it works. If I try to drill-through with BPC, it fails saying that it cannot connect to the database or open the results.

Is there any kind of limits for driling-through?

Thanks

Daniele