Creating New Analytics

If the additional report requirements are different from any of the base product reports, you can choose to build a completely new report from scratch.

This section describes how to use Oracle Analytics Server to add new analytics, including:

• Creating New Answers

• Adding New Labels

• Customizing Hierarchy Levels

Creating New Answers

Note: Before creating new reports, it is recommended to have knowledge of Oracle Analytics Server and Data Warehouse concepts. It is also recommended to have some working knowledge in developing reports using Oracle Analytics Server for a smoother implementation.

Oracle Utilities Analytics Warehouse provides out-of-the-box dashboards with rich and varied set of analytics for Credit and Collection Analytics, Customer Analytics, Distribution Analytics, Meter Data Analytics, Mobile Workforce Analytics, Outage Analytics, Revenue Analytics, Exception Analytics, and Work and Assets Analytics. However, if required, you can create new answers, or dashboards.

As described in the Customizing Existing Analytics section, the new answers should also be saved in a separate custom folder so that they are not overwritten when upgrading to newer versions of Oracle Utilities Analytics Warehouse later on.

You can create field labels for use in their answers, or the labels can be hard coded directly in the answer if there are no multilingual/localization requirements. If the product labels are used in an answer, they can get modified during upgrade to a newer Oracle Utilities Analytics Warehouse release. At the best, Oracle tries to limit the changes to the existing labels; however, there can be certain situations, when they are updated. Hence, in rare cases, if you are making use of the base labels, then you can expect to have an impact, when the label value changes in a newer release.

Adding New Labels

To use the label mechanism for new answers, the Custom Field Maintenance dashboard can be used to add, update, and delete custom labels. These custom labels can then be used in answers as well as in the presentation objects in the repository or RPD file.

Note: Only custom field labels, identified by a Customer Modification (CM) owner flag, can be updated or deleted. The new labels are created with a Customer Modification (CM) owner flag. A label that already exists cannot be created, so if a base labels already exists, you can update the override label as described in the preceding section Creating New Answers.

For more details, refer to the Administration Dashboards Maintenance section in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide available in the Oracle Utilities Analytics Warehouse documentation.

Customizing Hierarchy Levels

Usually, the Control Zone (CD_CTRL_ZONE) and Control Zone Secondary (CD_CTRL_ZONE_SEC) dimensions have data in all the 6 levels (PARENT_NCG_LVL1_NAME to PARENT_NCG_LVL6_NAME columns). If the data is not available for any level, it will be considered a missing level. Data is displayed incorrectly or it is missing.

These Control Zone and Control Zone Secondary prompts can be customized. The dashboards in Oracle Utilities Analytics Warehouse can be adjusted to display the available zone levels in the desired prompts and reports. This zone level mapping in configured in OAS RPD.

For detailed configuration steps, refer to the knowledge article “Customizing Hierarchy Levels in Oracle Utilities Analytics Warehouse (Doc ID 2273874.1)” available on My Oracle Support (https://support.oracle.com/).