Hi again group.

Im having trouble with very slow performance when querying a cube for its
dimensions and levels using adomd in ASP.
The cube has 8 dimensions. The cubes biggest level has around 10K members,
the others range from 10 to around 500 members.
I use the adodmd.catalog object to get to the cube through its cubedefs
colllection. I then loop through the dimensions accessing every level and
the level's ".name" and ".members.count" properties.
To list all 8 dimensions with their levels the application uses almost 1 1/2
minutes.

Is this normal?

Are you using parent child dimensions? If yes your
performance problem will almost certainly be there.
Parent child dims do not preaggregate.
Try to get rid of them if possible.

Another reason could be large dimensions with low
hierarchies.

HTH
Lutz

Hi All,

We are using C# and ASP.NET
We also experience such performance problems.

Strangely we find that
1) Traversing the CellSet for the first time takes more
time than traversing it in the second run.
2) Even during the first time traversal, some Cell items
takes longer than the rest. (Sometimes its taking about
1.5 seconds to read the value of one cell... We have got
some complex Cell Security MDX though)

Any Ideas / thoughts

Regards,
Sankaranarayanan M G