August 1, 2007 at 10:59 am
I am trying to drill through and I get this error:
Unable to drill through.
The operation has failed because of an error in the COM component (Microsoft OLEDB Persistence Provider)
Unspecified error.
The original datasource is Oracle, I have rebuilt the cube since the error occured and this didn't help, and I restarted the OLAP service. This is on Analysis Services 2000 SP 3.
Any ideas of what to look at?
August 2, 2007 at 10:24 am
A couple of questions question to start with:
What storage model did you use? Start with MOLAP, until you've isolated your drill through problem.
What security credentials are you using? (i.e. an administrators?) If you're using a "users" or limited access account, make sure that drill through is enabled via the role definition.
What front end are your testing with?
Finally, I hate to say it, but I'd upgrade as soon as possible to AS 2005. You'll find better support and examples.
Good luck.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply