I am having severe memory and performance issues when trying the
following type of query over long date ranges:


with
member [Measures].[31 Jul 2005] as 'Sum([Calendar Time].[01 Aug
2004]:[Calendar Time].[31 Jul 2005],[Measures].[Daily Profit Fund])'

select {[Measures].[31 Jul 2005]} on columns,
non empty {[Instruments].[Instrument Short Name].members} on rows

from [Positions by Instrument]

where ([Fund].[A],[Trader].[1])


A query like this uses up about 300MB of client system memory and takes
a few minutes to execute.. is this to be expected?

have you check your aggregation by using the aggregation wizard?
if there is a lack of aggreagtion then the performance decrease.

try adding these info in the connectionstring:
cache policy=7;cache ratio=0.001;cache ratio2=0.001;non empty threshold= 1

normally you'll see an improvment.

"Nav" <nav.daheley (AT) gmail (DOT) com> wrote