Hi,
I am having real problems getting decent performance when including
properties on a query.

My query gets the top 20 products for the year and uses "DIMENSION
PROPERTIES xxx" to bring back the properties.

This takes over a minute.

Select NON EMPTY {{[Measures].[Sale Qty], [Measures].[Sale Value]}} on
columns , NON EMPTY {Order(TopCount({{Descendants([Product By
Group].[All Products],,LEAVES)}},20,[Measures].[Sale
Value]),[Measures].[Sale Value], BDESC)} DIMENSION PROPERTIES [Product
By Group].[Product].[PLU] on rows from [Sales] CELL PROPERTIES VALUE,
FORMATTED_VALUE, FORMAT_STRING, FORE_COLOR, BACK_COLOR, FONT_FLAGS

This however takes around 10 seconds:

Select NON EMPTY {{[Measures].[Sale Qty], [Measures].[Sale Value]}} on
columns , NON EMPTY {Order(TopCount({{Descendants([Product By
Group].[All Products],,LEAVES)}},20,[Measures].[Sale
Value]),[Measures].[Sale Value], BDESC)} on rows from [Sales] CELL
PROPERTIES VALUE, FORMATTED_VALUE, FORMAT_STRING, FORE_COLOR,
BACK_COLOR, FONT_FLAGS

The only difference is that the first includes a dimension property.


Properties are used heavily in my organisation and I desperate to find
some form of solution.

Thanks,
Peter

Pleas guys - is there anything I can do to make the retrieval of
properties faster?

Even if I only bring back two rows it takes for ever to bring back a
single property or each.

Anyone know how property retrieval works technically? ie. does it get
the results of the query and then retrieve the properties? Where are
the properties stored in the cube.

Thanks,
Peter