Cube_Library_Item Cube_Library_Item

Introduction

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
Dim_Library_Item

Item,

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

 

Measures

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