ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   OLAP Offline Cube - How Many Multiple Concurrent Users (https://www.excelbanter.com/excel-programming/364764-olap-offline-cube-how-many-multiple-concurrent-users.html)

fredmart3

OLAP Offline Cube - How Many Multiple Concurrent Users
 
Using Excel MS Query I've created an offline OLAP cube that will be on a
shared server. The data source for the cube was a 150,000 record Access
database. I have built a pivot table using the offline cube as the external
data source. Performance is fantastic - even from Europe!

My question is how many concurrent users can an offline OLAP data cube
safely handle? I've read somewhere that, unlike Analysis Server cubes, this
is not a true client-server model, so file-sharing errors may occasionally
result when multiple clients concurrently access the same cube. Have any of
you had experience using this approach? If so, did you have the
aforementioned problem? How many clients/users can this model safely support?

Thanks in advance,

Fred M3


All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com