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:

Insurance.mdc

Revision Date:

2004-06-08

Cube Developer:

Gail Sperling

 

Cube Description:

This cube contains limited information about Acquisitions order and invoice information. It is used by UW to estimate average item costs for insurance purposes. Note: Orders and invoices for "Returned" or "Pending" status are not included in this cube. Orders attached to funds in the "UW Gifts" ledger or with the order type "Gift" are also not included.

Measure Name

Description

Drill Through Reports

Order count

The number of order records. This excludes "Returned" or "Pending" orders. This is the default measure used when a new report is created. If an order is paid for by multiple funds then the order count for each fund is based on the percentage each fund is assigned. ( e.g. if one fund is assigned 30% and one fund 70% then the first fund will have an order count of .3 and the second fund will have an order count of .7)

Amount paid (CAD)

Amount invoiced converted to Canadian Dollars

n/a

Avg. Cost (order) The amount paid in Canadian Dollars divided by the number of orders. It is best not to include the dimension "Date" as a row, column, layer or filter in a report that uses this measure. n/a
Cost/item (average) The amount paid in Canadian Dollars divided by the number of items. It is best not to include the dimension "Date" as a row, column, layer or filter in a report that uses this measure. n/a

Received Issue Count

The number of checkin issues received on a title. Open monograph series orders also have each title checked in as an issue. Some multi-volume monograph orders have volumes checked in as issues. Serial orders will have issues checked in as each issue is received.

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.

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
  • Amount Paid CAD
  • Avg. Cost (order)
  • Cost/item (average)
  • Items (on orders)
  • Received Issue Count
  • Pieces

The UW Gift ledger is excluded from this cube.

Department Name

Fund Name

By Department Drill Path

  • Institution
  • Department Name
  • Fund Name
  • Unique Fund Name

Unique Fund Name

There are also special categories for

  • UW monograph replacement funds
  • UW back issue fund

Date

Year

Date associated with the order, invoice, item

  • Order Count
  • Amount Paid CAD
  • Avg. Cost (order)
  • Cost/item (average)
  • Items (on orders)
  • Received Issue Count
  • Pieces
  

Term

Locations

Institution

The location at the item record level

  • Order Count
  • Amount Paid CAD
  • Avg. Cost (order)
  • Cost/item (average)
  • Items (on orders)
  • Received Issue Count
  • Piece

 

Library

Item Location Name

Order Location

Institution

The order location (happening) the operator logged on to when the order or invoice was created.

 

  • Order Count
  • Amount Paid CAD
  • Avg. Cost (order)
  • Cost/item (average)
  • Items (on orders)
  • Received Issue Count
  • Pieces

 

Order Location

Order Status

Order status

The status of the order based on the Purchase Order status and the Line Item status.

Current = receipts are still expected on this order

Complete = no more receipts expected on this order (may include cancelled orders, especially cancelled serials)

Claimed = the order has been claimed (applies to monograph orders only)

Cancelled = the order has been cancelled

  • Order Count
  • Amount Paid CAD
  • Avg. Cost (order)
  • Cost/item (average)
  • Items (on orders)
  • Received Issue Count
  • Pieces

 

Order Types

Monographic/Serial

Order type and line item type from the order record

 

  • Order Count
  • Amount Paid CAD
  • Avg. Cost (order)
  • Cost/item (average)
  • Items (on orders)
  • Received Issue Count
  • Pieces

Order type "Gift" is excluded from this cube

Order type
Order type/line item type

Item Types

Media

Item type associated with the item record

 

  • Items (on orders)
  • Pieces

Special category for "Current" orders

Item Type Name

 

PowerPlay Model File Name:

Selectors.pyi