Show TOC

Function documentationVariance Analysis Locate this document in the navigation structure

 

A variance is the difference between two data values for predefined categories, such as actual versus budget, for a given period based on a predefined percentage. If there is a variance (either favorable or unfavorable) in the current time period for a KPI, the cell displays a special variance formatting, which you can click to see the Variance Analysis window.

Features

Variance Analysis shows the following information:

  • Summary - Shows the data values for the variance categories and the variance amount.

  • Reasons - Shows the reasons, or the dimension members from the account that contributed to the variance. For each member, the actual and budget values, the amount of the variance, and the impact are displayed. You can display up to six members and show members by ID or description.

  • Root Cause - For each KPI, Insight attempts to find events occurring outside the database that contribute to a variance. The system then lists the top three events as root causes of the KPI variance, and displays the following:

    • The name of the transaction that contributed to the variance

    • The date of the transaction, the entity member that contributed to the variance

    • The value of the member

  • Variance Context - To be included in a variance analysis, documents must first be posted to the Content Library in Interface for the Web. After synchronization, Insight compresses the documents into an unformatted string of words that it analyzes for frequency of terms. If a match is found to the account description of a KPI (or the account descriptions of any relevant accounts), the Variance Context pane of the Variance View contains a link to that document.

  • Actions - Shows actions for this KPI. Actions are annotations users create for a KPI to address concerns with thresholds reported by Insight.

Activities

To analyze a variance, click a variance cell within the dashboard. The system provides reasons, root causes, contexts, and actions for the variance.