11.2 List of Reports

Trend and Composition Reports

Table 11-1 Details about Trend and Composition Reports

Parameters Description
Analysis Name Trend and Composition Reports
Report Level Filters
  • Project Name
  • Run Date
  • Project Execution ID
  • MIS Date
  • Scenario Name

    Note:

    The dimensions are also listed as filters so that you can view reports at dimension level.
  • Measure
Analysis Description These reports analyze the changes and patterns over time, as well as the composition of certain variables or elements within a dataset. They look at long-term changes and structural composition. For example, in business, a trend report might analyze sales growth over several years, while a composition report might break down sales by product categories or regions. It involves longitudinal studies, time-series analysis, and demographic segmentation to highlight how certain trends develop and what elements constitute a larger picture.
Reports Covered This analysis is presented through a combination of the following reports:
  • Trend of Actuals report - This analysis presents the actual numbers of how a selected measure varies across incremental MIS dates.
  • Trend of Variance % report - This analysis presents the change in percentage of how a selected measure varies across incremental MIS dates.
Composition Reports
  • Composition of Primary Measure - these reports analyze the changes and patterns over time, as well as the composition of certain variables or elements within a dataset. They look at long-term changes and structural composition. It represents the composition of the trend report at a dimension level.
  • Concentration Analysis of Primary Measure/Secondary Measure- this analysis represents the composition of the trend report between the primary (option selected in the measure filter) and secondary measures.

Variance Between Scenarios

Table 11-2 Details about Variance Between Scenarios

Parameters Description
Analysis Name Variance Between Scenarios
Report Level Filters
  • Project Name
  • Run Date
  • Project Execution ID
  • MIS Date
  • Scenario 1
  • Scenario 2

    Note:

    The dimensions are also listed as filters so that you can view reports at dimension level.
  • Measure
Analysis Description This type of report is used to compare two different scenarios to understand how varying conditions or decisions affect outcomes. It shows the difference between two scenarios in value and in percentage. Also, you can view the variance reports for the secondary measure using the Secondary Measure drop-down menu.
Reports Covered
  • Primary Measure Change Analysis - these reports show a graphical representation of the scenarios and the variance between these two scenarios. You can view the reports for each dimension of a scenario.
  • Scenario 1 - these reports show the granular data of a scenario by each dimension. You can view granular data up to six dimensions.
  • Concerning Variance - these reports show the data for each dimension against the secondary measure.

Variance Between Two Dates for a Given Scenario

Table 11-3 Details about Variance Between Two Dates for a Given Scenario

Parameters Description
Analysis Name Variance Between Two Dates for a Given Scenario
Report Level Filters
  • Project Name
  • Run Date
  • Project Execution ID
  • Measure
  • MIS Date
  • Comparison MIS Date
  • Scenario Name

    Note: The dimensions are also listed as filters so that you can view reports at dimension level.

Analysis Description This type of report is used to analyze the changes that occur within a specific scenario over two distinct points in time. This report shows the actual and percentage difference between two dates in the same scenario across six dimensions. Also, you can view the variance reports for the secondary measure using the Secondary Measure drop-down menu.
Reports Covered
  • Primary Measure Change Analysis - this report shows a graphical representation of the difference between the dates in the same scenario and the variance between these two dates in the same scenario.
  • MIS Date 1 EOP Balance - this report shows the values of each dimension against a defined measure.
  • Variance - this report shows the value of each dimension against a defined measure.
  • Variance % - this report shows the percentage value of each dimension against a defined measure.
  • MIS Date 2 EOP Balance - this report shows the values of each dimension against a defined measure.
  • Concerning Variance - these reports show the data for each dimension against the secondary measure.

Variance from Base Reference Date

Table 11-4 Details about Variance from Base Reference Date

Parameters Description
Analysis Name Variance from Base Reference Date
Report Level Filters
  • Project Name
  • Run Date
  • Project Execution ID
  • Base Date
  • MIS Date
  • Scenario Name
  • Measure
  • Comparison MIS Date
  • Scenario Name

    Note: The dimensions are also listed as filters so that you can view reports at dimension level.

Analysis Description This type of report is used to measure how much a variable has deviated from a specific starting point or baseline. This report shows the actual and percentage difference between the base date and MIS date. The Primary Measure Change Analysis report shows a graphical representation of the difference between the base date and MIS date and the variance between these two dates. Also, you can view the reports for each dimension of a scenario. You can view the variance reports for the secondary measure using the Secondary Measure drop-down menu.
Reports Covered
  • Primary Measure Change Analysis - this report shows a graphical representation of the difference between the dates in the same scenario and the variance between these two dates in the same scenario.
  • Base EOP Balance
  • Variance
  • Variance - this report shows the value of each dimension against a defined measure.
  • Variance % - this report shows the percentage value of each dimension against a defined measure.
  • MIS Date - these reports show the values between MIS date dimension against a measure.
  • Concerning Variance - these reports show the data for each dimension against the secondary measure.