Types of Function Processing

Functions supported by the Intelligence Server are of three types:

• Those that can be processed only by the Analytical Engine, such as finance functions.

  If the Analytical Engine does not support a given function, a compound metric containing the function cannot be smart metric enabled. This is because smart metrics change the default order of metric evaluation and only the Analytical Engine can support such a change.

• Those that can be processed either by the Analytical Engine or by the database.

  If the database can perform the calculation, the SQL Engine sends the instructions to the database; otherwise, the Analytical Engine processes the task.