dbTalk Databases Forums  

Drillthrough error - AS 2000 with BO XI

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Drillthrough error - AS 2000 with BO XI in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
lmcphee
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.