Aleph Reporting and Statistics
OIS reporting services for Aleph users include access to pre-defined reports as well as a report authoring system. OIS also publishes regular reports and statistical counts in selected areas (budgets, Accounts Payable activity, etc.).
If you are looking for past year statistics for circulation, tech services activity or HOLLIS Public Catalog activity go to Aleph/HOLLIS Statistics.
About ad hoc reporting using the Library Reporting System
The HOLLIS Library Reporting system allows users to report on data that is extracted from Aleph and stored on a dedicated reporting server. The data can currently be accessed in one of two ways: using a desktop query tool (BI/Query), or by using the web-based Cognos Connection application.
What does the Library Reporting System contain?
The Library Reporting System is a data warehouse that includes acquisitions (orders, arrivals, subscriptions, encumbrance transactions, invoice headers, invoice lines, invoice transactions, order and subscription logs), budget report data, items, circulation event history data used for statistics, loans and loan history, active requests, reserves courses, reserves bibliographic data, and selected tags from the MARC bibliographic and holdings data.
When is the Library Reporting System available? How often is data in the warehouse refreshed?
The Library Reporting System is available every day from 7am to midnight. There are no updates scheduled on Friday and Saturday nights. Library Reporting System data is refreshed by 7am every business day.
How do staff get access to the Library Reporting System query tool?
Bi/Query
The BIQuery application is being phased out and will be replaced by Cognos. Although an exact timetable has not been set, no new BIQuery installations are available.
Cognos Reportnet
Designated library staff create reports and/or access a set of pre-defined reports using the web-based Cognos Reportnet System. The HOLLIS Library Reporting System training program offers an introductory class to the web-based Cognos Reportnet system and demonstrates how end users can view, print, save and email pre-defined reports. There is also an introductory report authoring class that will be supplemented with hands-on workshops led by members of the Aleph Reporting Working Group. The Library Reporting System training is open to staff who have been identified by their library as reporting system end users. Only those who have been designated as reporting end users may register for training classes at this time. Pre-registration is required. See the Library Reporting System training registration page to see the list of available dates, documentation and to register for a training session.
About mediated reporting
To ask a question about customizing reports or request a report from OIS, submit a request via the Aleph Support Center. As much as possible, report requests should specify the selection criteria (characteristics which all records in the report will have in common) and the data that ideally you would like to see on the report.
Circulation activity reports
OIS is generating statistics on daily Aleph circulation events in each Harvard sublibrary. These statistics are reported in basic and detailed formats; results are emailed in two separate daily messages to Circulation Managers.
Basic circulation statistics:
A text file containing columns for date, sublibrary, circulation event, and event totals. Each daily basic report contains counts of events sub sorted by sublibrary.
Advanced (detailed) circulation statistics:
A text file containing columns for date, sublibrary, circulation event, item status, patron status, and event totals. Each daily advanced report contains counts of events sub sorted by sublibrary.
These and other circulation reports are also available as predefined reports in the Cognos Library Reporting System and can be customized and scheduled according to individual needs. If you have a question about circulation activity reports, send a request via the Aleph Support Center.
Harvard Depository Tracking Reports
OIS and HD staff created two tracking reports to ensure that both new accessions and items returned to HD after being recalled by the owning library are coded correctly in Aleph. These reports should be reviewed daily, and items should be created/corrected as necessary. The descriptions of the reports, and urls to the index pages for each report are listed below and are posted at:
http://hul.harvard.edu/ois/systems/aleph/docs/hd_aleph_reports.html