Drillthrough error - AS 2000 with BO XI -
11-16-2006
, 09:31 AM
Executing drillthrough from a report in BusinessObject's (BO) OLAP
Intelligence designer or from my own app using OLEDB Provider for OLAP
Services 8.0 on a calc-member I get the expected error: "Can't drillthrough
on calculated member".
But when I drillthrough from the same BO report after it has been published
I first get the error "The drillthrough operation cannot be performed because
it is not supported by the cube." Subsequent attempts give the error:
"Failed to execute the command (Connection to server is lost)" We see on the
OLAP/SQL server in the App event log an error saying that msmdsrv.exe has
crashed and is attempting to restart.
I am guessing that the error occurs from published report but not from
designer because either
1) Designer is run from login account, whereas from published report it will
be via account under which BO services are running, or
2) Designer and published report are querying differently - one using OLEDB
Provider for OLAP vs MSXML or...?
Anyone seen this problem?
lmcphee |