This subject area replaces the former Events subject area, which reported on a very large number of events, some of them redundant or not used. This made it very difficult to produce effective reports on events that run in a reasonable amount of time. The current System Events subject area includes only a select number of events, so that reports can be run quickly and efficiently.
The events in the System Events subject area has been collected from a list that includes:
- Event that are used in reports that the institution created and ran at least once in the past year.
- Events in out-of-the-box reports under Alma/shared/events/reports
- Events related to the creation, deletion, and update of invoice lines and invoices
For a list of the events available in the System Events subject area, see List of Events in the Alma Analytics System Events Subject Area.xlsx.
Data for this subject area begins from July 1, 2019 and is retained for three years. Data is deleted weekly from more than 3 years previous.
System Events - Star Diagram
The following lists the fields available in System Events:
System Events – Field Descriptions
The Event Measures table is a fact table that stores the number and duration of events.
|Number of Events||Stores the calculated fields that count all the unique events (by distinct event ID). Each event can have several entries in the table with different keys and values.|
|Event Duration||Stores the duration of the event in seconds|
The Event Details table is a dimension table that stores additional details about the event.
|Event Category||Stores the category of the event|
|Event Creator||Stores the creator of the event||To have this field anonymized, contact Ex Libris support|
|Event Description||Stores the description of the event with parameters|
|Event ID||Stores the unique ID of the event|
|Event Key Name||Stores the key name – a category of event, such as Account Type and Action|
|Event Key Value||Stores the key value – a member of the key name such as Public and Staff||To have this field anonymized, contact Ex Libris support|
|Event Message||Stores the message with fillers for the parameters|
|Event Module||Stores the module of the event|
|Event Purge Policy||Stores the purge policy of the event|
|Event Severity||Stores the severity of the event|
|Event Sub Module||Stores the sub module of the event|
|Session ID||Stores the session ID|
The Event Date table is a dimension table that stores details about the date of the event such a month, year, and quarter. Key fields may be used when calculations are required. Descriptions fields may be used for formatting the display of the report.
Using this dimension, users may drill down from year to month to the specific event. The number of events are accumulated to the relevant level in the hierarchy.
|Event Date and Time||The date and time of the event|
|Date Key||Stores the date in the format 2/29/2012|
|Start of Week||The date of the first business day of the week|
|Week Number||The number of the week of the year|
|Month Key||Stores the month of the date in number format such as 2 for February||This field is useful when you want to sort by month|
|Fiscal Month Key||Stores the fiscal month of the date in number format such as 2 for February||This field is useful when you want to sort by month|
|Month Desc||Stores the month of the date in month description format such as February|
|Year Key||Stores the year of the date in string format such as 2012|
|Fiscal Year Key||Stores the fiscal year of the date in string format such as 2012|
|Year Desc||Stores the year of the date in string format such as 2012.|
|Full Month Desc||Stores the month and the year of the date in a display format such as Feb 12|
|Full Month Key||Stores the month in a number format such as 9 for September and the year|
|Full Quarter Desc||Stores the quarter of the date in a display format such as Q1 and the year|
|Full Quarter Key||Stores the quarter of the date in a display format such as 1 and the year|
|Quarter Desc||Stores the quarter of the date in a display format such as Q1|
|Quarter Key||Stores the quarter of the date in a display format such as 1|
|Date Filter||Used to filter report results by date.|
|Event Date||Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific event date. Using this column provides the user with the option to view the accumulative measures in each level of the hierarchy.|
The Security Events table is a dimension table that stores details of security events generated by Alma. This table stores events associated with CATEGORY=SECURITY and MODULE=USER_MANAGEMENT. Using this dimension, a user may create the FERPA (Family Educational Rights and Privacy Act) reports that indicates which users in Alma may view details of other users.
|Accessing User ID||Stores the user ID of the user that accessed other user information||To have this field anonymized, contact Ex Libris support|
|User ID||Stores the user ID of the user whose details have been seen||To have this field anonymized, contact Ex Libris support|
|User Accessing Operations||Indicates when the Viewed operation was used to access the information|
|User Subentity List Name||Describes the entity that has been seen such as address, email, and so forth.|
The shared Institution dimension allows the Network Zone to view reports according to institution. It is available in every subject area. It contains the following fields:
|Institution Code||The code of the institution.|
|Institution Name||The name of the institution.|
|Institution Timezone||The timezone of the institution|
|Data Available As Of||When the data became available to analytics|
|Data Updated As Of||When the data was taken from Alma|
If an analytics report is run from the Network Zone in a collaborative network implementing a Network Zone, all member institutions are included in the report for Institution Code and Institution Name.
If an analytics report is run from an institution that is not part of a collaborative network implementing a Network Zone, only the single institution from which the report is run is included in the report for Institution Code and Institution Name.
Reports involving data across a collaborative network implementing a Network Zone may take longer to run than reports within one institution.
Shared Dimensions with Other Subject Areas