 | |
Distributed Cubes at Several Servers
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Distributed Cubes at Several Servers -
01-03-2005
, 10:00 PM
#2
| |||
| |||
|
|
Dear All, I have several different cubes that are distributed in several servers. Now I want my users access only to one server but they can access cubes that are located in others server. Here's the ilustration: Server1 -> Receiving Cubes Server2 -> Shipping Cubes I want users only need access to Server1 but they can access Shipping Cubes at Server2 from Excel. Is that possible? FYI, I use MS SQL SERVER 2000 Standard Edition. Thank you... |
#3
| |||
| |||
|
|
Hi Resant You would be able to do this with Linked Cubes - but they require the Enterprise edition of SQL Server -- Yours sincerely Thomas Kejser M.Sc, MCDBA "Resant" <resant_v (AT) yahoo (DOT) com> wrote in message news:1104811258.749776.143480 (AT) z14g2000cwz (DOT) googlegroups.com... Dear All, I have several different cubes that are distributed in several servers. Now I want my users access only to one server but they can access cubes that are located in others server. Here's the ilustration: Server1 -> Receiving Cubes Server2 -> Shipping Cubes I want users only need access to Server1 but they can access Shipping Cubes at Server2 from Excel. Is that possible? FYI, I use MS SQL SERVER 2000 Standard Edition. Thank you... |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.