Cube_Library_Item Cube_Library_Item


This cube holds details about the library items, including summary information about loans.  Use cube_library_loan for a more detailed breakdown of the loans taken out.

Shared Dimensions 

Shared Dimension Name in Cube Notes


Item Classmark,

Item Bibliographic Info


The dimension has been split up into other dimensions on the cube, for ease of use. 


Cube Specific Dimensions

Item Other

This holds additional columns used for analysis and reporting purposes. 

Column Name Data Type Description Derivation
Item Loan Number Src integer The total number of loans recorded for the item Based upon z30_no_loans
Loan Count On Aleph varchar  Total number of loans recorded on Aleph Number of records for item in z36 & z36h tables.
Max Loan Date Sk integer Latest date item was loaned out Latest loan date based upon z36_loan_date & z36h_loan_date
Max Loan Returned Date Sk integer Latest date item was returned Latest item return date based upon z36_returned_date and z36h_returned_date



Measure Name  Derivation
Loan Total Count The total number of loans recorded against the item.
Loan Aleph Count Number of loans in the selection
Loan Date Max The latest (max) loan date.  Note: Displayed currently in YYYYMMDD format, which matches Aleph formatting.
Loan Returned Date Max The latest date the item has been returned