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
No comments:
Post a Comment