When a user opens a large cube, it take a good 30 seconds for the cube to
come back. Once the user starts drilling down it's fast (aggregations,
slices).

Any ideas in fixing this? They've become spoiled in that the cubes they use
now are small and thus open quickly.

Hmm - that's usually a problem when it comes to large cubes because of the
Olap metadata that needs to be passed from the server to the pivot so that
way the pivot can function. I take it this is a client to server scenario
where the users are reading a cube on a remote server - anyway to increase
the network bandwidth :-). You could always do something like use Office
Web Components which has a Excel PivotTable object such that its a
server-to-server thing and the Olap metadata is cached better so the access
is much faster.

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote