Configure the Calendar and Time Dimensions

In order to align Oracle Utilities Analytics Visualization with the calendars leveraged in the source business application, the Calendar Dimension and Time Dimension must be populated within the source application.

On this page:

Overview of the Calendar Dimension

The calendar dimension holds all the dates that can be used in a report or as a filter. The dates in the calendar dimension must be the same as the dates for which you have data in your transactional application. If the calendar dimension does not have all the dates that are in the data, reports will not show data for the dates missing from the calendar dimension

For example, consider a report that shows the number of bills created, each day, of a selected month. Below are some scenarios of how this information will be displayed based on whether the calendar dimension is configured properly.

  • Scenario 1: Suppose your application has bill data for 2021 and 2022, and the calendar dimension is populated with dates for 2021 and 2022. In this case, users will be able to see the number of bills created, each day, of any month in 2021 or 2022

  • Scenario 2: Suppose the calendar year 2023 starts, and the calendar dimension is not updated with dates for 2023. In this case, unless the calendar dimension is updated with dates from 2023, users will not be able to view data for 2023 in the report.

Back to Top

Load Time Dimension

  1. Sign in to the source Oracle Utilities application.
  2. In the search bar at the top of the screen, search for the "Add Batch Job Submission" menu.
  3. Click on the search icon next to Batch Control.
  4. In the Description field, search for the “Generate Time Dimension” batch.
  5. Enter any other desired configuration for the batch run.
  6. Run the batch.
  7. To check that the batch loaded the data successfully, follow the steps in Check Loading of Dimensions below.

Back to Top

Load Calendar Dimension

Prerequisite: For each source application connected to Oracle Utilities Analytics Visualization, you must first populate one or more calendars (account, financial, or work calendar) for the entire calendar interval for which the Calendar Dimension will be loaded. For example, a calendar might need to be populated for 01-01-2014 to 12-31-2020. Failure to do this will result in a load error, and the calendar dimension will not be populated.

  • For the Customer Cloud Service, the account and financial calendar must be populated.
  • For the Meter Solution Cloud Service, the account calendar must be populated.
  • For the Work and Asset Cloud Service, the work calendar must be populated.

For instructions on how to define the account and financial calendar, go to the documentation library of any of the Oracle Utilities enterprise SaaS applications. Once there, search for and select the Administrative User Guide link, and then go to the section ‘Defining the Account Calendar.'

Once the calendar has been configured, proceed with the steps below.

  1. Sign in to the SaaS Oracle Utilities application.
  2. In the search bar at the top of the screen, search for the "Add Batch Job Submission" menu.
  3. Click on the search icon next to Batch Control.
  4. In the Description field, search for the “Generate Calendar Dimension” batch
  5. Enter the three parameters for Period Start Date, Period End Date, and Fiscal Calendar that correspond to the desired calendar range and fiscal calendar.
  6. Enter any other desired configuration for the batch run.
  7. Run the batch.
  8. To check that the batch loaded the data successfully, follow the steps in Check Loading of Dimensions below.

Back to Top

Check Loading of Dimensions

  1. Sign in to the source Oracle Utilities application.
  2. In the search bar at the top of the screen, search for the Calendar and Time Dimensions menu.
  3. Ensure the data you're expecting is available by using the filter options available within each Zone.

Back to Top