dbTalk Databases Forums  

Linked cube for network performance issues or OLAP replication options

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


Discuss Linked cube for network performance issues or OLAP replication options in the microsoft.public.sqlserver.olap forum.



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

Default Linked cube for network performance issues or OLAP replication options - 08-22-2003 , 05:59 AM






Hi All

I have built a Financials cube on a analysis server based in Toronto.
Our company is a multinational one and we have subsidiaries in
Germany, UK, Asia. The cube on the central server is needed by staff
in our subsidiaries to access for analysis. The network bandwidth
between our office in Canada to Europe and ASIA is bad so analysis
users on a remote link suffer performance problems due to network
latency when we in Toronto do not have any problems. I thought of the
concept of using Local cubes or archiving the cube in Toronto server
and shipping and restoring these archives in Europe and ASIA local
analysis servers and users in each of these areas can use the local
analysis server which gets a new updated archive everyday to
minimise/avoid wide area network latency issues.

How does linked cube work does it copy the central cube to the local
servers or using a linked cube will it still cause ongoing network
issues. Any other idea/views on replicating the central cube to local
servers to minimise network bandwidth issues.

Thanks
Belinda

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.