Defining Analytics Dimensions

This portal is used to maintain metadata for Analytics Dimension tables. A dimension record exists for each table in the operational system that represents a dimension table in the Operational Analytics product.

Refer to Understanding Operational Analytics for more information.

You can access the portal from theAdmin Menu > Analytics Configuration > Analytics Table. You are brought to a query portal with options for searching for a specific record. Once a dimension record has been selected you are brought to this portal to view and maintain the selected record.

The following zones may appear as part of the portal's Main tab page

• Analytics Table. This zone provides information about the selected dimension record.
• Fields. This zone lists all the fields that define the dimension table. Fields may be selected from the dimension’s underlying operation table using the Excluded Fields zone or added as computed fields.
• Dimensions. This zone lists dimension tables that this dimension references via foreign key constraints.
• Referenced By. This zone lists dimension and fact tables that reference this dimension via foreign key constraints.
• Characteristic Mapping. This zone manages characteristic mapping extensions for the dimension. Refer to analytics attribute mapping for more information.
• Excluded Fields. This zone lists fields from the dimension’s operational table that are not included in the dimension table.