Database Reference
In-Depth Information
porting Services calculate the sum of the values in the report. This comes in handy
when no aggregates are returned from the data source, as is the case when the re-
port is connected to a relational database. However in this case, you are running
your reports against a cube that contains the aggregated values or that easily can
calculate aggregates when running the query.
Having Analysis Services calculate the values may be much faster; to change the
report so that this will happen can be done by right-clicking on the textbox con-
taining the
[Sum(Sales_Amount)]
expression and set the expression to
=Ag-
gregate(Fields!Sales_Amount.Value)
instead
of
=Sum(Fields!Sales_Amount.Value)
.
If you do this, you need to change your reports so that the result set contains values
for every level in the report.
Note
More information about how to optimize your reports against a cube can be
found in the following white paper released from the SQLCAT team:
ht-
is%20and%20Reporting%20Services,%20Design%20and%20Implementation%20A%20SQL%20Server%202008%20Technical%20Case%20Study.docx
.
Search WWH ::
Custom Search