Hi All,

I was trying to optimize a mdx query through the Performance monitor
DSN Requested and DSN Used counters. Now, if I dont have any
aggregations built in the cube, I get
DSN requested = 31312e+17
DSN used = 32322e+17

If I build the exact aggregations 313121111...., through partition
manager manually, reaggregate, restart analysis services and then run
the mdx query again, I still get
DSN requested = 31312e+17
DSN Used = 32322e+17.

Why doesn't it use the new aggregation. Any help would be appreciated.

Thanks

Milind

The DSN Requested/DSN Used counters got much less useful when they started
getting displayed in scientific form - I can only assume that either the
query you're running doesn't actually hit the aggregation you've built, or
there's some functionality in there governing when aggregations are used
which no-one knows about. Without being able to see the value of DSN
Requested it's almost impossible to work out the exact aggregation you need
to build.

Chris

--
I blog about Microsoft BI here:
http://spaces.msn.com/cwebbbi/
Do you need help with Analysis Services or MDX? I'm available for hire:
http://www.crossjoin.co.uk/


"Milind" wrote: