dbTalk Databases Forums  

Invisible Olap database for Remote access

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


Discuss Invisible Olap database for Remote access in the microsoft.public.sqlserver.olap forum.



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

Default Invisible Olap database for Remote access - 09-14-2005 , 09:40 AM






Hi, I have a question regarding the configuration for accessing a cube on the
web in the SQL 2000 environment. I followed the instruction from tutorial for
its analysis service. I created a working Olap database in the Analysis
Manager... Then I tried to access it from a excel. When I tried to get the
external data, my Olap database is not in the Olap cubes list, But, the
foodmarket Olap database is in the list, it is configured during installation
for the tutorial. I would be appreciated for any hint. Thanks.
Peter

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

Default RE: Invisible Olap database for Remote access - 09-14-2005 , 10:52 AM






I found the answer myself. When expsoing a cube in the intranet, the
accessing security must be much more lower. After I did so, the OLap
database is visible in the list in a excel client. Thanks
Peter


"Peter" wrote:

Quote:
Hi, I have a question regarding the configuration for accessing a cube on the
web in the SQL 2000 environment. I followed the instruction from tutorial for
its analysis service. I created a working Olap database in the Analysis
Manager... Then I tried to access it from a excel. When I tried to get the
external data, my Olap database is not in the Olap cubes list, But, the
foodmarket Olap database is in the list, it is configured during installation
for the tutorial. I would be appreciated for any hint. Thanks.
Peter

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.