PowerPlay Cube Documentation

TUG TRELLIS Reports Home
Search Reports Status Database

 

Cube File Name

cisti.mdc

Revision Date

2002-12-20

Cube Developer

Gail Sperling

Cube Newsbox

UW Reports and Cubes > ILL DD

Cube Description:

This cube contains UW CISTI counts and costs. Source data is maintained in the excel file CISTIall.xls found in R:\UW Statistics and Reports\Departmental Statistics\ILL-DD.

 

Measure Name

Description

# delivered

The number of articles delivered to users

# ordered

The number of articles requested by users

Cost/article

The cost of the article, not including copyright fees or taxes

Copyright Fee

The cost of copyright fees

$ Total cost

The article costs plus the copyright fees

Cost + GST The article costs plus the copyright fees plus GST

 

Dimension Name

Dimension Hierarchy

Description and Notes

Valid Measures

Alternate Hierarchy

Date

Year

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

  • # delivered
  • # ordered
  • Cost/article
  • Copyright Fee
  • $ Total cost
  • Cost + GST
 

Month

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

Faculty

Faculty

The faculty/department of the user

 

  • # delivered
  • # ordered
  • Cost/article
  • Copyright Fee
  • $ Total cost
  • Cost + GST

Department

status

status

The status (patron group) of the user

  • # delivered
  • # ordered
  • Cost/article
  • Copyright Fee
  • $ Total cost
  • Cost + GST

 

Account #

Account #

The account number of the user/user status

  • # delivered
  • # ordered
  • Cost/article
  • Copyright Fee
  • $ Total cost
  • Cost + GST

 

CISTI/LINK

CISTI/LINK

Origination of the request

  • # delivered
  • # ordered
  • Cost/article
  • Copyright Fee
  • $ Total cost
  • Cost + GST

 

 

PowerPlay Model File Name:

refstats.pyi