You can leverage server-based Analytic Services attribute calculations in the client. Because server-based calculations are performed before OLAP query results are sent to clients, network traffic and the result set are minimized.
To use attribute calculations, you use Data Layout to select the attribute calculations dimensions to participate in the query. Then you use Dimension Browser to select the server-based calculations to be returned by the query result set.
Note: | You can reproduce many attribute calculations on the client, but you are responsible for defining the calculations, and the client is responsible for processing the result set. |
Reasons to use attributes in calculations:
To select, aggregate, and report on data that shares attributes
To select attributes by data type: text, numeric, Boolean, and data type
To group numeric data types into statistical ranges
To use sum, count, min, max, and average functions on the attribute calculations dimension automatically generated by Analytic Services
To use numerical attribute values from calculation scripts and member formulas in calculations
To create crosstabs of attribute data for a dimension and analyze the dimension in terms of each attribute