dbTalk Databases Forums  

Excel cannot find OLAP cube .... Either the OLAP database has chan

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


Discuss Excel cannot find OLAP cube .... Either the OLAP database has chan in the microsoft.public.sqlserver.olap forum.



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

Default Excel cannot find OLAP cube .... Either the OLAP database has chan - 06-08-2006 , 10:38 AM






Some users on our OLAP web intranet server have started getting this error:
"Excel cannot find OLAP cube .... Either the OLAP database has changed or
you don't have permissions to connect to the cube".
Although the cube that they are accessing have not changed, and they had
access to Export to Excel utility in the past, now they have started to get
this message.
They are correctly added as a member to the role that have a access to the
cube. The message appears if they are accessing the cubes from within the
Excel file or they are creating a new view in our browser utility.
All the other IIS and database users and roles seem correct.

Any suggestions???

Thanks


Reply With Quote
  #2  
Old   
AT
 
Posts: n/a

Default Re: Excel cannot find OLAP cube .... Either the OLAP database has chan - 06-08-2006 , 05:05 PM






check the clientside PTS?

give us more information?

reinstall office service pack?

hth

-Aaron


Denis wrote:
Quote:
Some users on our OLAP web intranet server have started getting this error:
"Excel cannot find OLAP cube .... Either the OLAP database has changed or
you don't have permissions to connect to the cube".
Although the cube that they are accessing have not changed, and they had
access to Export to Excel utility in the past, now they have started to get
this message.
They are correctly added as a member to the role that have a access to the
cube. The message appears if they are accessing the cubes from within the
Excel file or they are creating a new view in our browser utility.
All the other IIS and database users and roles seem correct.

Any suggestions???

Thanks


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.