Cube File Name:

carlarl.mdc

Revision Date:

2004-04-08

Cube Developer:

Gail Sperling

Measure Name

Description

Drill Through Reports

Title Count

Number of bibliographic records on TRELLIS (includes those that have been suppressed from OPAC)

• bib-drill

Mfhd count

Number of MFHD (holdings) records on TRELLIS (includes those that have been suppressed from OPAC)

• mfhd_drill-bibid_sort
• mfhd_drill-callno_sort
• mfhd_drillLC
• mfhd_drillLC-callno_sort

Item count

Number of item records on TRELLIS (includes items records that do not have barcodes)

• item_drill
• item_drill_LC

Net Item Count

This measure excludes withdrawn items from the item count. To get the number of items active in TRELLIS OPAC add the filter of "Suppress in Opac" = N

n/a

Pieces

The piece count from the item record. Most items will have a piece count of 1. For materials like microfiche the piece count may reflect the number of fiche the item record represents.

• item_drill
• item_drill_LC

Net Pieces

This measure excludes withdrawn pieces from the piece count. To get the number of pieces active in TRELLIS add the filter of "Suppress in Opac" = N

n/a

Electronic Title Count

The count includes holdings (mfhd) records with an internet location

The count also includes bibliographic records that have a URL link in the Bib record MARC tag 856 and do not have a holding record (mfhd) with an internet location

n/a

Withdrawn Items

The number of item records with the "withdrawn" status applied.

n/a

Withdrawn Pieces

The piece counts from the item records with the "withdrawn" status applied.

n/a

Dimension Name

Dimension Hierarchy

Description

Valid Measures

Alternate Hierarchy

Date

Year

April 1998 is the record create date for bibliographic, holdings and item records converted to TRELLIS.

• Title Count
• Mfhd Count
• Item Count
• Net Item Count
• Pieces
• Net Pieces
• Electronic Title Count
• Withdrawn Items
• Withdrawn Pieces

Term

Locations

Institution

The location associated with the Mfhd (holdings) record or item record.

• Mfhd Count
• Item Count
• Net Item Count
• Pieces
• Net Piecest
• Withdrawn Items
• Withdrawn Pieces

• Annex
• ARL/CARL
• UW Rare Books

An alternate drill path "By Institution" separates colleges and satelite locations from the TUG institutions

Library

Location Name

Suppress in Opac

Y or N

Indicates whether the bibliographic record or holdings record is suppressed from the OPAC. To get counts of records that are in the OPAC filter this dimension = N

• Title Count
• Mfhd Count
• Item Count
• Net Item Count
• Pieces
• Net Pieces
• Electronic Title Count
• Withdrawn Items
• Withdrawn Pieces

Owning Library

This is the owning library as assigned to the bibliographic record level which determines whether a bibliographic record is shared between TUG institutions. It does not apply to item related measures because this would inflate the item record counts for "Bound With" items.

• Title Count
• Mfhd Count
• Electronic Title Count

Item Types

Media

The item type associated with the item record.

• Item Count
• Net Item Count
• Pieces
• Net Pieces
• Withdrawn Items
• Withdrawn Pieces

Item Type Name

Mono - Serial

Bibliographic record type

The bib format of the bibliographic record as defined in the MARC 008 tag of the bibliographic record. This dimension does not apply to item related measures because counts would be inflated for "Bound With" items.

• Title Count
• Mfhd Count
• Electronic Title Count

Bib format

Electronic or Print

Categories include;

• Electronic and Print
• Electronic Only
• Print Only

"Electronic only" indicates that there are only holdings (mfhd) records for internet locations.

"Electronic and Print" indicates that there are holdings records for both internet and non-internet locations or that the bib record has a URL in the 856 tag and there is a non-internet location

• Electronic Title Count