TUG-Libraries Staff Web StaffWeb: UG | UW | WLU
Libraries: UG | UW | WLU
Campus: UG | UW | WLU
Home TUG Statistics & Reports
Documents Contacts Search

PowerPlay Cube Documentation

Search Reports Status Database

Cube File Name

transactions.mdc

Revision Date

2006-04-27

Cube Developer

Gail Sperling

 

Cube Description:

This cube contains statistical data on circulation charge, renew and discharge transactions.

Measure Name

Description

Drill Through

Charges

A count of the charge transactions (circulations) that occur on TRELLIS.

transactions_drill

Renewals

A count of the renewal transactions that occurred on TRELLIS. (includes self-renewals through OPAC)  

Charges + Renewals

A total of the charge and renewal transactions that occurred on TRELLIS  

Renewed Charges

A count of the number of charge transactions that were renewed (regardless of the number of times renewed).  

Term loans

A count of the charge transactions that were charged for term loan.  

Discharges

A count of the charge transactions that were discharged. Browse discharges are not included in these counts.

discharges_drill

Recalls

A count of the charge transactions that were recalled.

 

Recall Notices

A count of the number of recall notices sent for recalled charges.

 

Overdue Notices

A count of the overdue notices sent for charged items.

 

Over Recall Notices

A count of the overdue recall notices sent for recalled items.

 

ILL Charges

A count of the charges to special patron groups used for ILL Charges

 

 

Dimension Name

Dimension Hierarchy

Description

Valid Measures

Alternate Hierarchy

Date

Year

Date the charge, renewal or discharge transaction occurred.

Year is fiscal year starting May 1 and indicates the year at the end of the fiscal year (e.g. 1999 = 1998/1999)

  • Charges
  • Renewals
  • Charges + Renewals
  • Renewed Charges
  • Term Loans
  • Discharges
  • Recalls
  • Recall Notices
  • Overdue Notices
  • Over Recall Notices
  • ILL Charges

 

Term

Month

Week (weeks split between months will be split between the months by date)

All Locations (happening)

Institution

The processing location where the charge, renewal or discharge occurred.

  • Charges
  • Renewals
  • Charges + Renewals
  • Renewed Charges
  • Term Loans
  • Discharges
  • Recalls
  • Recall Notices
  • Overdue Notices
  • Over Recall Notices
  • ILL Charges

 

By Institution alternate dimension includes affiliates as part of top level institution

Library

Processing Location

All Locations (item)

Institution (UW college locations etc. kept separate)

The location at the item record level

 

  • Charges
  • Renewals
  • Charges + Renewals
  • Renewed Charges
  • Term Loans
  • Discharges
  • Recalls
  • Recall Notices
  • Overdue Notices
  • Over Recall Notices
  • ILL Charges

 

  By Institution alternate dimension includes affiliates as part of top level institution

Special grouping for Annex locations

 

 

Library

Item Location Name

All Patron Groups

Institution

The patron group of the patron who charged or renewed the item

  • Charges
  • Renewals
  • Charges + Renewals
  • Renewed Charges
  • Term Loans
  • Discharges
  • Recalls
  • Recall Notices
  • Overdue Notices
  • Over Recall Notices
  • ILL Charges

 

Patron Group

All Item Types

Media

  The item type of the item charged, renewed or discharged

  • Charges
  • Renewals
  • Charges + Renewals
  • Renewed Charges
  • Term Loans
  • Discharges
  • Recalls
  • Recall Notices
  • Overdue Notices
  • Over Recall Notices
  • ILL Charges

 

Circulating/Non-Circulating alternate drill path

Item Type Name

Day

Monday… Sunday

The day of the week that the charge or renew transaction occured

  • Charges
  • Renewals
  • Charges + Renewals
  • Renewed Charges
  • Term Loans
  • Discharges
  • Recalls
  • Recall Notices
  • Overdue Notices
  • Over Recall Notices
  • ILL Charges

Hour

00…23

The hour of the day that the charge or renew occured

  • Charges
  • Renewals
  • Charges + Renewals
  • Renewed Charges
  • Term Loans
  • Discharges
  • Recalls
  • Recall Notices
  • Overdue Notices
  • Over Recall Notices
  • ILL Charges

Operators

Public or staff

Indicates whether the transaction was done by the patron or staff

  • Charges
  • Renewals
  • Charges + Renewals
  • Renewed Charges
  • Term Loans
  • Discharges
  • Recalls
  • Recall Notices
  • Overdue Notices
  • Over Recall Notices
  • ILL Charges

 

Charge Renewal Count

0, 1 to 5, 6 to 10, 11 to 20 .... > 80

Renewal count ranges for charges

  • Charges
  • Charges + Renewals
  • Renewed Charges
  • Term Loans
  • Recalls
  • Recall Notices
  • Overdue Notices
  • Over Recall Notices
  • ILL Charges