Analytics Objects
Using the Analytics Objects subject area, the Design Analytics user can create reports/dashboards concerning analytic objects and is able to answer the following types of business questions:
- How many of each object type does the institution have
- How many users added a widget to his / her dashboard
- How many users subscribed to a scheduled report or scheduled dashboard
- Names and locations of each object type
Star Diagram – Analytics Objects
Field Descriptions
The following lists the fields available in Analytics Objects.
Analytics Objects – Field Descriptions
Analytics Objects Measures
The Analytics Objects Measures table is a fact table that stores all measures relating to analytics objects.
| Field | Description | Additional Information |
|---|---|---|
| Num of Objects | The number of objects | |
| Num of Objects for Source Alma | The number of objects for source Alma | |
| Num of Objects for Source Primo | The number of objects for source Primo | |
| Num of Objects of Type Dashboard | The number of objects of type report | |
| Num of Objects of Type Dashboard - Active | The number of active objects of type dashboard | |
| Num of Objects of Type Dashboard - Not Active | The number of non-active objects of type dashboard | |
| Num of Objects of Type Report | The number of objects of type report | |
| Num of Objects of Type Scheduled Report | The number of objects of type scheduled report | |
| Num of Objects of Type Scheduled Report - Active | The number of active objects of type scheduled report | |
| Num of Objects of Type Scheduled Report - Not Active | The number of non-active objects of type scheduled report | |
| Num of Objects of Type Widget | The number of objects of type widget | |
| Num of Used Subscriptions | The number of users who subscribed to a scheduled report. | |
| Num of Users Subscribed to Dashboard (to be deprecated) | The number of users subscribed to a dashboard | This field will be deprecated in a future release |
| Num of Users Subscribed to Report (to be deprecated) | The number of users subscribed to a report | This field will be deprecated in a future release |
| Num of Users Subscribed to Scheduled Report (to be deprecated) | The number of users subscribed to a scheduled report | This field will be deprecated in a future release |
| Num of Used Widgets | The number of times the widget was used | The same widget is counted separately for each user that uses the widget |
Analytics Object Details
The Analytics Object Details table is a dimension table that stores all measures relating to analytics object details.
| Field | Description | Additional Information |
|---|---|---|
| Object ID | The object ID | |
| Object Type | The object type | |
| Object Name | The object name | |
| Object Title | The object title | |
| Object Description | The object description | |
| Report Location | The report location | |
| Scheduled Report Format | The scheduled report format | |
| Scheduled Frequency | The scheduled frequency | |
| Scheduled Status | The scheduled status | |
| Scheduled FTP | The scheduled FTP | |
| Source System | The source system |
Created By
The Created By table is a dimension table that stores all measures relating to the analytics objects creator.
The field descriptions can be found in the User Details shared dimension.
| Field | Description | Additional information |
|---|---|---|
| User ID | Stores the unique ID of the user | |
| Primary identifier | Stores the primary identifier that the user uses in order to log on to Alma | See the field location in Alma in the image below. |
| User Title | The title of the user | |
| User Type | Stores the values Internal and External. |
See the field location in Alma in the image below.
|
| User Group | Stores the group with which the user is associated such as Faculty, Graduate, or Student | See the field location in Alma in the image below. |
| User Record Type | Indicates if the user is a Public User or a Staff User | See the field location in Alma in the image below. |
| First Name | Stores the user’s first name | See the field location in Alma in the image below. |
| Full Name | The user's first and last name | There is no option to include the middle name. |
| Last Name | Stores the user’s last name | See the field location in Alma in the image below. |
| Middle Name | Stores the middle name of the user | See the field location in Alma in the image below. |
| Preferred First Name | Stores the user’s preferred first name | See the field location in Alma in the image below. |
| Preferred Last Name | Stores the user’s preferred last name | See the field location in Alma in the image below. |
| Preferred Middle Name | Stores the user's preferred middle name | See the field location in Alma in the image below. |
| Job Description | Stores free-form text that describes the function of the user in the library | See the field location in Alma in the image below. |
| Job Title | Stores the job category definition to which the user belongs based on the Job Categories code table | See the field location in Alma in the image below. |
| Gender | Possible values are taken from the Genders code table (Configuration > User Management > User Details > Genders) | See the field location in Alma in the image below. |
| Birth Date | Stores the birth date of the user | See the field location in Alma in the image below. |
| Campus Code | Stores the campus code of the user | See the field location in Alma in the image below. |
| Status Date | Stores the date on which the patron was registered in the institution | See the field location in Alma in the image below. |
| Status | Indicates if the user is active | See the field location in Alma in the image below. |
| Creation Date | Stores the date that the user was created in the system | See the field location in Alma in the image below. |
| Last Activity Date | The last date that a patron made a request or borrowed or returned an item | |
| Modified By | Stores the name of the user that modified the user record | See the field location in Alma in the image below. |
| Modification Date | Stores the date of the modification of the user record | See the field location in Alma in the image below. |
| Expiry Date | Stores the date on which the user is to expire and no longer be able to get service from the system | See the field location in Alma in the image below.
Changing the user expiry date is one way to control item due dates that extend beyond the end of a semester and must be shortened to the end of the semester. For more information, see How to Make Items Have Due Dates at the End of the Semester.
|
| Locked Out Date | Indicates the date on which the user is locked out. A user is locked out if he tries to access the Alma system several times with incorrect credentials. | |
| Purge Date | Stores the date on which the user record is to be deleted from Alma | See the field location in Alma in the image below. |
| Default Language | Stores the default language of the user | See the field location in Alma in the image below. |
| Failed Authentication | Stores the number of times that the user tried to access Alma with an incorrect password | |
| Creator | Stores the user name of the user that created the user in the system | See the field location in Alma in the image below. |
| External ID | Stores the ID of the user in the originating system | |
| Identifier 1 | Stores identifier 1. | The identifier field allows you to enrich the user details exported to Analytics with additional identifiers. Selecting a specific identifier to be included in the user details is done in Alma (in a table that is currently restricted to Ex Libris staff). For assistance in defining this field, contact Ex Libris Support.
Only one value per identifier is supported.
|
| Identifier 2 | Stores identifier 2. See details for the Identifier 1 field above. | |
| IdP Service in Use | Indicates if an identity provider service is in use | |
| Statistical Categories 1-5 | These fields allow you to map five statistical categories. This allows you to filter reports based on advanced user information typically stored in the statistical category fields. For more information, see Configuring Statistical Categories for Analytics. | |
| Resource Sharing Library Code | The code of the resource sharing library assigned to the user. | |
| Resource Sharing Library | The resource sharing library assigned to the user. | |
| Cataloger Level | The cataloger level of the user | |
| Has Role Other Than Patron | indicates if the patron has a role other than Patron | |
| Has Role Other Than Patron and Instructor | Indicates if the patron has a role other than Patron and Instructor | |
| Is Blocked | Indicates if the patron is blocked | |
| Patron Letters Opt In | The letters for which the patron has opted in | |
| Patron Letters Opt Out | The letters for which the patron has opted out | |
| User – Linked From Other Institution | Indicates if the user is linked from another institution | Possible values:
|
| User – Linked From Institution Code | The code of the institution from which the user is linked | |
| User – Linked From Institution Name | The name of the institution from which the user is linked | |
| Linked To Other Institution | Indicates if the user is linked to another institution | |
| User Group Code | The user group code |
Creation Date
The table is a dimension table that stores all measures relating to the analytics objects creation date.
| Field | Description | Additional Information |
|---|---|---|
| Creation Date | Stores the creation date in the date format 2/29/2012 | |
| Creation Start of Week | The date of the first business day of the week | |
| Creation Week Number | The number of the week of the year | |
| Creation 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 |
| Creation Month | Stores the month of the date in month description format such as February | |
| Creation Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
| Creation Quarter | Stores the quarter of the date in a display format such as Q1 | |
| Creation Year | Stores the year of the date in string format such as 2012 | |
| Creation Fiscal Month Key | Stores the fiscal year of the date in number format such as 2 for February. | |
| Creation Fiscal Year | Stores the fiscal year of the date in string format such as 2012 | |
| Creation Date Filter | Used to filter report results by date. | |
| Creation Date | Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific loan date. Using this column provides the user with the option to view the accumulative measures in each level of the hierarchy. |
Modification Date
The table is a dimension table that stores all measures relating to Analytics Objects modification date.
| Field | Description | Additional Information |
|---|---|---|
| Modification Date | Stores the modification date in the date format 2/29/2012 | |
| Modification Start of Week | The date of the first business day of the week | |
| Modification Week Number | The number of the week of the year | |
| Modification 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 |
| Modification Month | Stores the month of the date in month description format such as February | |
| Modification Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
| Modification Quarter | Stores the quarter of the date in a display format such as Q1 | |
| Modification Year | Stores the year of the date in string format such as 2012 | |
| Modification Fiscal Month Key | Stores the fiscal year of the date in number format such as 2 for February. | |
| Modification Fiscal Year | Stores the year of the date in string format such as 2012 | |
| Modification Date Filter | Used to filter report results by date | |
| Modification Date | Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific loan date. Using this column provides the user with the option to view the accumulative measures in each level of the hierarchy. |
Institution