Selectors Cube Documentation

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:*	selectors.mdc
*Revision Date:*	2003-06-17
*Cube Developer:*	Gail Sperling

Cube Description:

This cube contains information about Acquisitions order and invoice information. It also contains information on TRELLIS items attached to order records. Circulation information for items attached to order records is also included. If TRELLIS circulation information is required for all item records the cube "transactions+items.mdc" should be used.

Measure Name	Description	Drill Through Reports
Order Count	A count of orders placed on TRELLIS Acquisitions. If multiple funds are assigned to an order the order count is proportional to the amount being paid by the fund. E.G. if one fund is assigned 70% of the allocation and another 30% the order counts will be .7 and .3 respectively.	orders_drill orders_drill_LC
Invoice Count	The number of invoice lines. Credit invoice lines count as an invoice. If an invoice line is paid by multiple funds the invoice count is based on the percentage assigned to each fund.	n/a
Amount Paid CAD	The amount paid for an order converted to Canadian Dollars. The amount is proportional to the funds assigned to the invoice for the order. E.G. if an order is being invoiced $100 and paid 70% by one fund and 30% by another fund the amount will be $70 and $30 respectively for each of the funds. (the conversion rate used to calculate this amount may vary slightly from the conversion rate used by TRELLIS when the invoice is paid)	n/a
Avg. Cost (order)	Amount paid (CAD) divided by Order count. Note: it is best not to include the Invoicer Date dimension (as a row, column, layer or filter) in a report that uses this measure.	n/a
Cost/use (average)	Amount paid (CAD) divided by Circulations. Note: it is best not to include the Invoice Date dimension (as a row, column, layer or filter) in a report that uses this measure.	n/a
Items (on orders)	The number of item records on a bibliographic record to which an order is attached. This count could be inflated for orders that have multiple funds attached to them. Note: Items on open order titles that are catalogued separately are not included in these counts unless Acquisitions has added the separately cataloged records to dummy orders.	orders_items_drill orders_items_drill_LC
Amount Paid (Foreign)	Amount invoiced in the currency used on the invoice	n/a
Charges	The number of times an item (attached to an order record) has circulated on TRELLIS. This count could be inflated for orders that have multiple funds attached to them. Note: Circulations on items on open order titles that are catalogued separately are not included in these counts unless Acquisitions has added the separately cataloged records to dummy orders.	orders_charges_drill orders_charges_drill_LC
Received Issue Count	The number of checkin issues received on a title. Serial orders will have issues checked in as each issue is received. Open monograph series orders also have each title checked in as an issue. Some multi-volume monograph orders have volumes checked in as issues.	n/a

Dimension Name	Dimension Hierarchy	Description and Notes	Valid Measures	Alternate Hierarchy
Funds	Institution	The fund associated with the order or invoice. The first dimension hierarchy is arranged by acquisitions ledger. The alternate dimension hierarchy is arranged by department name. The fund name which appears in the cube may be the parent fund of the fund assigned to the order or invoice in order to keep donor names confidential.	Order Count Invoice Count Amount Paid CAD Avg. Cost (order) Cost/use (average) Items (on orders) Amount Paid (Foreign) Charges Received Issue Count	By Department Drill Path Institution Department Name Fund Name Unique Fund Name
	Budget (ledger)
	Department Name
	Fund Name
	Unique Fund Name			By Fund Type Drill Path Institution Fund Type Unique Fund Name
				There are also special categories for UW monograph replacement funds UW back issue funds
Dates	Year	Date associated with the creation of the order, invoice, item or issue Year is fiscal year starting May 1	Order Count Invoice Count Amount Paid CAD Avg. Cost (order) Cost/use (average) Items (on orders) Amount Paid (Foreign) Charges Received Issue Count
	Term
Locations	Institution	The location at the holdings or item record level	Order Count Invoice Count Amount Paid CAD Avg. Cost (order) Cost/use (average) Items (on orders) Amount Paid (Foreign) Charges Received Issue Count	There is also a special category for UW Periodical locations
	Library
	Item Location Name
LC Class	LC Class	The LC Class of the holdings/item record if the item is catalogued with an LC call number.	Order Count Invoice Count Amount Paid CAD Avg. Cost (order) Cost/use (average) Items (on orders) Amount Paid (Foreign) Charges	By First Letter Alternate drill down First Letter LC Class
LC Number	Thousands	The LC number of the holdings/item record if the record has been catalogued with an LC call number.	Order Count Invoice Count Amount Paid CAD Avg. Cost (order) Cost/use (average) Items (on orders) Amount Paid (Foreign) Charges
	Hundreds
	Tens
	LC number (rounded)
	LC Number (to decimal level)
Invoice Date	Year	Date associated with the approve of the invoice Year is fiscal year starting May 1	Invoice Count Amount Paid CAD Amount Paid (Foreign)
Date (charge)	Year	Date associated with the charge transaction Year is fiscal year starting May 1	Charges
	Term
Order Locations	Institution	The order location (happening) the operator logged on to when the order or invoice was created.	Order Count Invoice Count Amount Paid CAD Avg. Cost (order) Cost/use (average) Items (on orders) Amount Paid (Foreign) Charges Received Issue Count
	Order Location
Order Status	Order status	The status of the order based on the Purchase Order status and the Line Item status or the vendor assigned to the order. Current = receipts are still expected on this order Complete = no more receipts expected on this order (may include cancelled orders, especially cancelled serials) Pending = the order has not been sent to the vendor Returned = the received item has been returned for credit Claimed = the order has been claimed (applies to monograph orders only) Cancelled = the order has been cancelled (may include serial orders that do not have the cancelled status on TRELLIS)	Order Count Invoice Count Amount Paid CAD Avg. Cost (order) Cost/use (average) Items (on orders) Amount Paid (Foreign) Charges Received Issue Count	Please note: The TRELLIS system does not accomodate serial cancellations and statistics for "Complete" or "Cancelled" serial orders may not be accurate.
Order Types	Monographic or Serial	Order type and line item type from the order record	Order Count Invoice Count Amount Paid CAD Avg. Cost (order) Cost/use (average) Items (on orders) Amount Paid (Foreign) Charges Received Issue Count
	Order type
	Order type/line item type
Use Range	Use ranges	Can be used to determine low and high use items by ranges of use. (includes historical charges from the Geac system for UW items)	Items (on orders)	Use ranges of 0, 1-5, 6-10, > 10
Currency Code	Order/invoice currency	The currency associated with the order or invoice.	Order Count Invoice Count Amount Paid CAD Avg. Cost (order) Cost/use (average) Items (on orders) Amount Paid (Foreign) Charges Received Issue Count
Vendors	Institution	Vendor associated with the order or invoice	Order Count Invoice Count Amount Paid CAD Avg. Cost (order) Cost/use (average) Items (on orders) Amount Paid (Foreign) Charges Received Issue Count	By Vendor Code alternate drill path Institution Vendor Code Vendor Name
	Vendor Name first character
	Vendor Name
Item Types	Media	Item type associated with the item record	Items (on orders) Charges
	Item Type Name
Pub Date	Century	The MARC tag 008 date 1 field from the bibliographic record.	Order Count Invoice Count Amount Paid CAD Avg. Cost (order) Cost/use (average) Items (on orders) Amount Paid (Foreign) Charges
	Decade
	Publication Date
Language	Language Name	The MARC 008 tag language code from the bibliographic record.	Order Count Invoice Count Amount Paid CAD Avg. Cost (order) Cost/use (average) Items (on orders) Amount Paid (Foreign) Charges
	Language code

PowerPlay Model File Name:

Selectors.pyi