Has anyone else experienced this?

The cube itself doesnt have much data yet, however has some very large
dimensions (in excess of a million members). Opening it takes about two
minutes, however once it's open it's quite snappy.

Any solution to get it to open faster?

Hi Jesse,

please, could you tell me what type of the connection do you use?
Did you monitor the communication between Proclarity and AS2005 with the SQL
Server Profiler?
It could show meny interesting things.

Thanks,
Vladimir Chtepa

"Jesse O." <jesperzz (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:OckkMcwmGHA.1576 (AT) TK2MSFTNGP05 (DOT) phx.gbl...

Ah good idea.

I'm so used to the AS2000 world I keep forgetting about the ability to run a
trace. So nice!

Turns out it looks like it has to return some very large dimensions (excess
of three million members).

Any idea how I can restrict this on the dimensional end to only return the
first 1000 or so?


"Vladimir Chtepa" <vc.nospam (AT) diacom-systemhaus (DOT) nospam.de> wrote

Hi,

it depends on behavior of PClarity. It is complex to answer without
knowledge of how your's cube design.

Vladimir Chtepa

"Jesse O." <jesperzz (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:un67wY6mGHA.3588 (AT) TK2MSFTNGP04 (DOT) phx.gbl...