When View SQL mode is selected after a report has executed, the analytical functions performed buy the Analytical Engine are listed at the end of the SQL, as shown below:
The Analytical Engine performs executions of the derived metrics using multi-dimensional storage in memory. This includes storage of the data passed to the Analytical Engine by the SQL Engine (via the Query Engine) and other data storage necessary for the completion of the calculation in memory.
In 3-tier mode, the computations are executed in memory on the Strategy Intelligence Server 10.x machine and the pre-cross-tabbed results are cached on the Strategy Intelligence Server 10.x machine as well.
In 2-tier mode, the computations are executed in memory on the client machine and the results are not cached.
By design, it is not possible to see the internal calculations when this action is performed. To understand how some analytical functions are performed refer to the following Strategy Knowledge Base technical notes:
An enhancement request has been logged to add the detail of this calculation at the end of the SQL generated.
All of these calculations are done via code and not via SQL.
Strategy will continue to investigate and post updates as soon as they are available.
