1. Administering Oracle Fusion Analytics Warehouse
  2. Configure Oracle Fusion Analytics Warehouse Data
  3. About Report Parameters

About Report Parameters

Set up the report parameters to specify how data is presented on the KPI decks, visualizations, dashboards, and reports in Oracle Fusion Analytics Warehouse.

About the Reporting Configuration for Enterprise Resource Planning

You specify values for these parameters as you configure reporting for Enterprise Resource Planning:

  • Calendar: This parameter specifies the reporting calendar used in Oracle Analytics Cloud. All time options seen in the reporting layer are based off the calendar chosen in the configuration.
  • Chart of Accounts: This parameter controls the list of ledgers used for reporting and is used in tandem with the Calendar parameter.
  • Ledgers: This parameter restricts the ledgers in the reporting layer and in the security setup. The list of values for this parameter are the ledgers that share the same calendar and the chart of accounts selected in the previous two parameters. The ALL option selects all ledgers that share the calendar and the selected chart of accounts.
  • Ledger Sets: This optional parameter restricts the ledger sets in the reporting layer and in the security setup. The list of values for this parameter are the ledger sets that share the same calendar and the chart of accounts selected in the previous two parameters.
  • Allow Financial Category Upload: This parameter provides the ability to upload the financial category in Oracle Fusion Analytics Warehouse and maintain the mapping independent of Oracle Applications Cloud. The default value is No; in which case Oracle Fusion Analytics Warehouse uses the financial Category mapping defined in Oracle Applications Cloud.

About the Reporting Configuration for Human Capital Management

You specify values for these parameters as you configure reporting for Human Capital Management:

  • Human Capital Management Analytics parameters:
    • Worker Age Band: This parameter specifies the grouping of the ages of workers by certain ranges. For example, less than 30, 30 to 50, and greater than 50 years. KPIs and analyses related to the headcount of the workers use these age bands. For example, the percentage of workers who are aged 50 and older.
    • Tenure Band: This parameter specifies the grouping of the service years of workers by certain ranges. For example, less than 5, 5 to 10, and greater than 10 years. KPIs and analyses related to the headcount or diversity factors of the workers use these bands. For example, you can use this parameter to answer a business question such as "Show me the percentage of workers in my organization of various years of service."
    • Performance Band: This parameter specifies the grouping of the performance ratings of workers by certain ranges. For example, high, medium, and low. KPIs and analyses related to the performance rating of the workers use these performance bands. For example, you can use this parameter to answer a business question such as "Who are the top performers for the current review period in my organization".
    • Potential Band: This parameter specifies the grouping of potential ratings under various headers. For example, High, Medium, and Low. You can configure the rating ranges under these bands.
    • Compa-Ratio Band: This parameter specifies the grouping of worker compa-ratios under various headers. For example, Band 1 with range as 0-80 and Band 2 with range as 81-120.
    • Risk of Loss Band: This parameter specifies the grouping of risk of loss ratings under various headers. For example, High, Medium, and Low. You can configure the rating ranges under these bands.
    • Impact of Loss Band: This parameter specifies the grouping of impact of loss ratings under various headers. For example, High, Medium, and Low. You can configure the rating ranges under these bands.
  • Succession Management parameter specifies the grouping of readiness levels of worker for their change in career under various headers. The values for these groups can be selected from the list of values. Care must be taken to select unique single value under each of these.
  • Workforce Management parameter specifies the reason for reorganization to compute the headcount gain or losses based on the reorganization factor.