Enable Custom Attributes

Characteristics of the type Predefined Value and Ad Hoc Value may be exposed in Energy Water Data Intelligence subject areas so they can be used for analysis and data visualization.

About Characteristics and Dimensions

Custom values defined by characteristics types appear as columns in the dimension tables after they have been mapped to target dimensions in Energy and Water Data Intelligence. For example, in the image shown below, the Account dimension includes the characteristic type “Benchmark ID":

Screenshot of Benchmark ID Characteristic Type.

In Energy and Water Data Intelligence, characteristics are displayed at the end of the dimension below the separator ==Custom Columns== in a given subject area.

Screenshot of where custom columns appear in Energy and Water Data Intelligence.

Currently Energy and Water Data Intelligence supports custom attributes for the following dimensions and ranges:

Dimension Characteristics Range SKUs Availability
Account

Account Characteristics

CI_ACCT_CHAR

1 to 70 Customer (EWDI_CUST) , Device (EWDI_DVC) and Grid Insights (EWDI_GRID)
Person

Person Characteristics

CI_PER_CHAR

1 to 30 Customer (EWDI_CUST) , Device (EWDI_DVC)
Premise

Premise Characteristic

CI_PREM_CHAR

1 to 30 Customer (EWDI_CUST) , Device (EWDI_DVC)
Service Point

SP Characteristics

CI_SP_CHAR

1 to 30 Customer (EWDI_CUST)
Service Agreement

SA Characteristics

CI_SA_CHAR

1 to 30 Customer (EWDI_CUST) , Device (EWDI_DVC)
Service Agreement

SA Type Characteristic

CI_SA_TYPE_CHAR

71 to 75 Customer (EWDI_CUST) , Device (EWDI_DVC)

Map Characteristics to Dimensions

The underlying maintenance object of an analytics dimension supports a set of empty or free columns, as shown by the ranges mentioned above. These empty columns can be used by implementation teams to map characteristics to dimensions. Each of these empty columns has a unique identifier known as its Column Sequence number. To map a characteristic to a target dimension in Energy and Water Data Intelligence means to select a characteristic type of an analytics table in the source application, and to map it to an empty dimension column identified by its Column Sequence number from the supported set of ranges.

For example, the Service Agreement dimension supports characteristics mapping for the CI_SA analytics dimensions from range 1 to 30, and for the CI_SA_TYPE analytics dimensions from range 71 to 75. The Column Sequence number above these ranges are not supported. (The Column Sequence number determines the order in which characteristics are displayed in the dimension.)

WARNING:

During implementation it may be necessary to change the Column Sequence number of characteristics or even remove mappings by changing or deleting the column sequence number. However be aware that changing the column sequence number of a characteristics may break or modify the existing analytics canvas that uses the column's previous position or removed position. The change or removal of mappings of characteristics in the source application to dimensions in the application should be performed by application administrator.

To map a characteristic to a dimension:

  1. In the Search Menu of your enterprise application (such as Customer Cloud Service or Meter Solution Cloud Service), enter "Analytics Table". The Analytics Table Search page displays.
  2. Search for the dimension you want to map to. A set of results displays.
  3. Select the Description link of the table where you want characteristics mapped.
    img/descriptionlink.jpg
    Clicking the description link takes you to the Analytic Dimension page.
  4. Expand the Characteristic Mapping zone. This zone manages characteristic mapping extensions for the dimensions. By default, only mapped characteristics are listed.
  5. In the Characteristic Mapping zone, click the filter icon to search for a characteristic. To facilitate your search, use the options available to display all mapped and unmapped characteristics.
  6. Select one or more characteristic types that you want to map and click Update. This allows you to adjust your mappings for a selected list of characteristics.
  7. Specify a value for the Column Sequence to create a mapping. Since Column Sequences are unique identifiers of dimension columns, the values that you specify must also be unique. It is best to start numbering your column sequence starting at 1 and increasing by 1.

    Tip:

    If the characteristic mapping was done while you were editing a project, then to view the new characteristics, click Menu on the project toolbar and click Refresh Data Sets.

To remove a characteristic mapping to a dimension:

  1. In the Characteristic Mapping zone, press the filter icon to search for the characteristic.
  2. Select the characteristic types that you want to unmap and click Update.
  3. Delete the Column Sequence for the mapping and click Save.

Note:

Removing the Column Sequence of a characteristic will break the analytics canvases that used it.