Hello,

I have a relatively simple MDX query where I am selecting a the top 10
members by a certain measure (usingTOPCOUNT) on ROWS. I would also like a
total for the rows which I am trying to get via VISUALTOTALS.

Without the VISUALTOTALS function, the query returns accurate results in
about 10 seconds. When I wrap the TOPCOUNT with a VISUALTOTALS function the
query takes pver 10 minutes.

I dont know how to improve this situation without using a subcube (which
gets me the all member over the limited subset).

I am using SSAS 2005 SP1.
Am I doing this correctly?
Is there a good reason why VISUALTOTALS is so slow in this case.
Is there another function I can use?

Please help if you can

--
Thanks in advance
Mgale1

Hello,

I'd like to withdraw / cancel this question.

Further investigation has revealed that VISUALTOTAL performance only seems
to be an issue when used in conjunction with one particular dimension.

There are already other issues with that dimension and thus I think that the
visual total performance is almost certainly a red -herring and that it is
the dimension in question at fault.

Apologies for any inconvenience.
Mgale1