Versions Compared

Old Version 5

changes.mady.by.user Jacob Mathews

Saved on

compared with

New Version 6

changes.mady.by.user Jacob Mathews

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Version published after converting to the new editor

This section describes how Autoperf uses stored procedures to perform scheduled performance calculations. Autoperf uses three stored procedures:

...

  1. This stored procedure checks which Autoperf Profiles are set up for the entity.

  2. It submits a Performance Calculation for any Autoperf Profile with a Frequency option of Daily or Monthly and that also has the Position check box selected.
    NOTE:  It does not run Profiles with a Frequency option of Monthly using Daily because the Hierarchy is not set (Hierarchy=-1).

  3. The Performance Calculation report calculates and commits Daily or Monthly returns.
  4. Upon committing returns, the report calls the UPDATE_PERF_FEED_STATUS stored procedure with Type of Data Feed = "PERFORMANCE" and sets the Hierarchy (that is, the report rule ID).

...