Web Analysis Studio leverages server-based Essbase attribute calculations in the client. Server-based calculations are performed by the server before returning the OLAP query result set. This minimizes the result set and network traffic.
To use attribute calculations, you must use Data Layout to select the attribute calculations dimensions to participate in the query. You must use Dimension Browser to select the server-based calculations to be returned by the query result set.
You can reproduce attribute calculations in Web Analysis Studio, but the onus is on you to define these calculations, and the client to process the result set. |
Consider the use of attribute members in these calculations:
You can select, aggregate and document on data sharing common attributes.
You can select attributes by their data types: text, numeric, Boolean, and data type.
You can use sum, count, min, max, and average functions on the attribute calculations dimension automatically generated by Essbase.
You can use numerical attribute values from calculation scripts and member formulas in calculations.
You can create crosstabs of attribute data for one dimension, and analyze the dimension in terms of each attribute.