Using unformatted cell values it may improve query performance

Using unformatted cell values it may improve query performance

Rate This
  • Comments 2

If a report does not use formatted cell values, query time can be reduced.  An example is a Reporting Services report that does its own formatting and therefore would not use the formatted values from SSAS.  By returning only the value of the cell and not its formatted value in MDX, you can achieve better queries performance, sometimes between 5-20%, depending on the size of the cell set.   The default properties include FORMAT_STRING and FORMATTED_VALUE, and can be omitted by specifying a list of properties.  An example is to add "cell properties VALUE" at the end of every query.

 

select [Measures].[Internet Sales Amount]

on columns

from [adventure works]

cell properties value

Leave a Comment
  • Please add 6 and 4 and type the answer here:
  • Post
Page 1 of 1 (2 items)