| Category | Topic | Description |
|---|---|---|
| Reporting System Status | current status FOLIO reporting database systems | current status of availability of LDP Production and LDP Test FOLIO reporting database systems |
Getting Started | Getting Starting with FOLIO Reporting | summary of the FOLIO reporting methods, environment, and tools |
| Joining the Reporting Users Email List | instructions for joining the CUL-REPORT-USERS-L email list to stay informed on reporting features, server outages, and other updates | |
Getting Access | Requesting Access to FOLIO Reporting | how to request access to the CUL FOLIO LDP reporting database to run and/or build reports |
| Connecting Virtual DBeaver to the CUL LDP Reporting Database | instructions for configuring Virtual DBeaver to connect to the CUL LDP (Library Data Platform) reporting database | |
| Running Report Queries with Virtual DBeaver | instructions for running, modifying, and saving FOLIO report queries with Virtual DBeaver connected to the CUL LDP (Library Data Platform) reporting database | |
SQL Query Directories for Reports | FOLIO Canned Reports Directory | directory of all CUL FOLIO canned reports with links to the report queries and descriptions |
| FOLIO Reports Filter Directory | list of options for all parameters that can be used in report queries to filter results, e.g., location, item status | |
| FOLIO Ad Hoc Reports Directory | directory of all CUL FOLIO ad hoc reports with links to the report queries and descriptions | |
| Using the CUL FOLIO Analytics Report Repository | instructions for accessing and using queries on the Cornell Library's FOLIO Analytics report repository, a GitHub repository of SQL report queries and documentation written for the Cornell Library | |
| FOLIO Archived Report Queries Directory | directory of both canned and ad hoc queries for FOLIO reports that have been archived | |
Getting Help | Requesting Reporting Help | instructions for using our online form to make a new report request, get help with running reports, and ask other reporting questions |
| FOLIO Application Support | information, announcements, and support for the Cornell Library FOLIO Application environments | |
| Reporting Training Session Recordings & Slides | recordings and slides for past FOLIO Reporting session training sessions and Reporting User Group presentations offered to CUL staff members | |
| DBeaver Tips and Tricks | tips and tricks for using the DBeaver reporting application | |
| step-by-step instructions for filtering results in an Excel spreadsheet data download | ||
| SQL Training Resources | list of links to SQL training resources | |
| SQL Tips and Tricks | tips and tricks for writing queries using SQL with the CUL FOLIO LDP reporting database | |
Annual Data Collection Dashboards & Excel Reports | data dashboards on Cornell's Tableau server that are related to Annual Data Collection, Excel data downloads, associated SQL queries, and documentation | |
Access Services Tableau Dashboards & Excel Reports | data dashboards on Cornell's Tableau server and Excel reports that are related to Access Services | |
Reference & Instruction Dashboards | Reference & Instruction Interactions | data dashboards on Cornell's Tableau server that show counts of reference interactions from LibInsight as well as from the previously used CountIt system Access Services Tableau Dashboards & Excel Reports Access Services Dashboards & Excel Reports data dashboards on Cornell's Tableau server and Excel reports that are related to Access Services |
Selector Tableau Dashboards & Excel Reports | data dashboards on Cornell's Tableau server that are of interest to Selectors and associated Collection Development staff (restricted access) | |
| Excel data downloads of Collection Development reports for all teams and individual teams from the CUL LDP (Library Data Platform) reporting database that are automatically updated on a daily basis | ||
Finance and Budget Office Dashboards | Finance and Budget Office Dashboards | data dashboards on Cornell's Tableau server that are of interest to the Finance and Budget Office team. |
Collection Management Excel Reports | set of downloadable Excel files for collection management that is automatically updated on a daily basis | |
Reporting Specifications | standards and specifications for obtaining data from FOLIO | |
Advanced Features | instructions for using advanced features of Cornell's reporting environments, such as importing data into local schemas in the LDP and connecting to the Voyager Historical reporting database | |
LDP System Administration | resources for Library Data Platform reporting system administration, such as documentation and communication channels to support implementation, troubleshooting, and software release schedules | |
| Information about and schedule for data from FOLIO Test to be transferred to LDP Test and for data from FOLIO Production to be transferred to LDP Production | ||
| LDP Software Update Schedule | Schedule for LDP software updates for LDP Production and LDP Test instances | |
| LDP Known Issues | current LDP issues impacting reporting | |
| Transitioning from LDP to Metadb | Metadb is a new reporting database architecture in beta release that will eventually replace LDP software | |
LDP Data Permissions Structure | description of the Cornell Library's policies for granting permissions to use data delivered by the Library Data Platform reporting database through various reporting tools in different formats | |
FOLIO Reporting Team | list of members of the FOLIO Reporting Team | |
updates on the progress of reports, dashboards, derived tables, and other FOLIO Reporting Team projects | ||
internal documentation for the FOLIO Reporting Team |