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

[Former Member]

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

[Former Member]

Similar issue here...cannot connect to DB via ODE connection for Oracle. When we set it up, we enter ID and password and connect to table. We specify criteria and tables are populated. However, when we try to drill from our BPC excel report (basemember info), we get "cannot connect" error message. We have checked the Web info and it appears correct. Wondering if the connection is our issue...Also, our %TIME% parameters are not working. Thoughts appreciated????

[sorin_radulescu]

It doesn't seems to be a problem regarding the query.

It seems you have a problem with connection string to database where you are doing Drill trough.

Please go into web admin page and edit dill trough table and check the parameters one more time.

Regards

Sorin Radulescu

[Former Member]

Hi Sorin,

thank you for your answer. I've double-checked the username and password, and they are correct. I've switched to a SQL View which does most of the job, and now it works perfectly.