PowerCube dimensions

The data collected by IBM® Collections is stored in a PowerCube that is administered by IBM® Cognos® Business Intelligence. The PowerCube stores data in dimensions, which provide descriptive information as well as quantitative measures of the data. When designing reports for displaying Metrics data in IBM® Connections, you can include data from both the Regular (categories) and the Measure dimensions.

Regular dimensions

Regular dimensions represent descriptive data that provides context for the data that is modeled in the Measure dimensions. Each dimension contains categories; for example, the SOURCE dimension provides the name of the Connections application that triggered an event.

DATE
This is a time dimension, which indicates the time that an event was generated. This dimension break down time into year, month, week, and day levels.
SOURCE
This dimension indicates the application that generated the event.
SCOPE
This dimension indicates the scope of the content that is referred to by the event.
ITEM
This dimension indicates the type of the content that referred by the event.
EVENT
This dimension indicates the action of the event.
COMMUNITY
This dimension indicates the community that the event happens.
UNIQUE EVENT
This dimension indicates the action of the event in the calculation of unique people and content.
ATTRIBUTE1
The categories of this dimension comes from the specified attribute of profile, and this can be customized by system administrator.
ATTRIBUTE2
The categories of this dimension also comes from the specified attribute of profile, and this can be customized by system administrator.
ATTRIBUTE3
The categories of this dimension also comes from the specified attribute of profile, and this can be customized by system administrator.

Measure dimensions

Measure dimensions represent the quantitative data described by regular dimensions; for example, the MONTHLY_UNIQUE_CONTENT provides a count of unique content events for a month, and can be associated with a Regular dimension such as COMMUNITY to provide the number of unique content items generated for a particular community in a specified month.

EVENT_COUNT
This measure dimension is used for the calculation of event counting.
DAILY_UNIQUE_USER
This measure dimension is used for the calculation of unique user number in day level.
WEEKLY_UNIQUE_USER
This measure dimension is used for the calculation of unique user number in week level.
MONTHLY_UNIQUE_USER
This measure dimension is used for the calculation of unique user number in month level.
DAILY_UNIQUE_CONTENT
This measure dimension is used for the calculation of unique content number in day level.
MONTHLY_UNIQUE_CONTENT
This measure dimension is used for the calculation of unique content number in month level.
WEEKLY_UNIQUE_CONTENT
This measure dimension is used for the calculation of unique content number in week level.
INITIAL_COUNT
This measure dimension is used for the calculation of initial count.
ZERO
This measure dimension represents 0 in the calculation.