Report Dimensions
In reporting terms, a dimension is a set of related properties based on available data, which can be made use of in a report. Most dimensions have attributes that express some aspect of the dimension.
For example, the license model dimension includes the attributes of license model name, type, description and license technology.
List of Dimension Tables
The FlexNet Operations reporting database includes the following dimension tables:
Note:The EVENT_TYPE_DIMENSION table also exists in the reporting database, but it is not used by FlexNet Operations reporting. This table is a simple lookup table to look up event types by their event type ID.
Custom Attributes and Custom Host Attributes in Dimension Tables
In addition to the columns listed in the dimension tables, you may include your custom license model attributes and custom host attributes in your reporting model.
|
•
|
Custom license model attributes are supported in reports only for fulfillment-time and entitlement-time attributes. Entitlement-time custom license model attributes are carried in the LINE_ITEM_DIMENSION table. Fulfillment-time custom license model attributes are carried in the FULFILLMENT_DIMENSION table. |
|
•
|
Custom host model attribute columns are carried in the DEVICE_DIMENSION table. |
Because of the nature of custom attributes, you must track them independently of the standard dimensions.