F
fredmart3
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
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