Hi

I have a MDX query which takes 2 minutes to execute

with member measures.getlaststatus as
'tail(nonemptycrossjoin([Reference].members), 1).item(0).item(0).name'
select {measures.getlaststatus} on columns,
nonemptycrossjoin({[Person].members}) on rows
from answercube
where ([Client].[BOA])

Is there a way to speed up this query.

TIA

Milind

try to specify a measure in your nonemptycrossjoin

try to use the "non empty person.members on rows" instead-of the
nonemptycrossjoin
verify that your measure is aggregated at the reference & person levels
(maybe use a dedicated cube)

try to change your connection string by adding:
cache policy=7;cache ratio=0.001;cache ratio2=0.001;non empty threshold=1


"Milind" <milind.bhabal (AT) gmail (DOT) com> wrote