Once a report's SQL query is executed against the data warehouse, and data is brought back from the warehouse, the data is processed by the Analytical Engine before the report is displayed to the end-user. The Analytical Engine performs mathematical and logical calculations on data returned from the data warehouse. Calculations performed by the Analytical Engine include:
For a given report, the Analytical Engine may perform a number of different calculations. The order in which the calculations are performed is the Analytical Engine Calculation Plan.
The Analytical Engine Calculation Plan in the report SQL View
The Analytical Engine Calculation Plan can be seen at the end of the SQL View, after the report SQL:
The order of steps can be controlled using the Evaluation Order section of the Report Data Options dialog box in Strategy Developer.
