Analytics Characteristic Mapping Table List Adjustments

The product provides characteristic mapping functionality for dimensions defined in the Analytics Table feature. The list of characteristic tables available when configuring the mapping sometimes displayed tables that were not supported by the analytics tool. In this release, characteristic tables included in the configuration are now in line with the tables supported by the analytics tool.

The list of tables is as follows:

  • Characteristic tables are only supported if the dimension's table is the primary table of the maintenance object. For example, there is a dimension for the Payment Segment table in Oracle Utilities Customer Care and Billing. This is a child table of the Payment table. The analytics tool does not support any characteristic mapping for this dimension. Previously, when configuring information for this dimension, the payment characteristics table was shown as available for mapping, incorrectly. This has been resolved.
  • Only characteristic tables that are a child of the primary table are supported. For example, there is a dimension for the Adjustment table in Oracle Utilities Customer Care and Billing. The analytics tool supports only the Adjustment Characteristics table for mapping. Previously, when configuring information for this dimension, the adjustment calculation line characteristics table was incorrectly shown as available for mapping. This has been resolved.
    • Note that there is a special exception to this rule for the Distribution Code dimension in Oracle Utilities Customer Care and Billing. In this case, the characteristic table is not a direct child, but it linked through an effective dated collection. This characteristic table is still supported for this dimension.
  • Log tables are not supported as part of characteristics mapping. These tables were incorrectly included in previous releases. This has been resolved.

Aligning the list of available characteristic tables to what is supported in the analytics functionality reduces confusion when you are defining the analytics configuration.

Steps to enable and configure

You don't need to do anything to enable this feature.

Tips and considerations

It is possible that you defined characteristic mappings for one of the tables that was not supported. Although the product allowed the mapping to be defined, it would not have been supported in the analytics tool. If you have any records like this they are not causing any issues, but they can be cleaned up by going to the Analytics Attribute Mapping table, search for the dimension and review the list of mapped characteristics to remove the ones that are for unsupported tables.