Link | Description |
---|---|
provides information about standards and guidelines for queries developed and maintained for the CUL FOLIO SQL Report Directories | |
How to Document Queries (DRAFT) | instructions for documenting queries on Confluence and Github |
instructions for using the local schemas that are available in Metadb and giving users permissions to use a table you have added to a local schema | |
list of tables that need data types fixed in order to be created by the metadb software running with FOLIO Poppy as a data source | |
instructions for converting Tableau dashboards that use queries written for LDP into Metadb format | |
examples and instructions for extracting data fields from JSON data arrays in Metadb | |
step-by-step instructions for reviewing code for a pull request for FOLIO Analytics | |
Making a Pull Request for FOLIO Analytics | step-by-step instructions for submitting a pull request for FOLIO Analytics |
Subjects and Series changes for Orchid | details on updates in FOLIO Orchid release to instance records for subjects and series to capture changes associated with authority control |
Scheduling Automated EXCEL reports with DBeaver EE | step-by-step instructions for scheduling automated EXCEL reports (including daily updates) and sending them to a BOX folder using queries via DBeaver EE |
Uploading Tableau Files (dashboards) to the Cornell Tableau Server (IN PROGRESS) |
Preparing a Canned Report or Ad Hoc Report for cul-folio-analytics | step-by-step instructions for preparing a canned or ad hoc query to be submitted to cul-folio-analytics |
Submitting a Canned Report or Ad Hoc Report to cul-folio-analytics | step-by-step instructions for submitting a canned or ad hoc query to be published on cul-folio-analytics |
Editing and Resubmitting a Canned Report or Ad Hoc Report to cul-folio-analytics | step-by-step instructions for |
editing and resubmitted a canned or ad hoc |
query to be published on cul-folio-analytics | |
Using the Local Schemas on the Cornell LDP | Guidelines for using the Local Schemas on the Cornell LDP (Library Data Platform) reporting database |
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 | |
Using the VTEST Voyager Historical Data Snapshot | all about the snapshot of Voyager historical data and getting access to use it |
Removing Unpurchased PDA/DDA title counts | Describes how A&P has been removing counts of unpurchased PDA/DDA (Patron Driven Acquisition/Demand Driven Acquisition) titles from annual data collection figures as requested by national definitions. |
Capturing Circulation Demographics | description of the workflow for capturing demographic data for circulation |
Fiscal Year Updates to Dashboards and Automated Reports | notes on how to update Tableau dashboards and automated reports just before the change to a new fiscal year |
Dashboard Permissions | instructions for setting permissions on Tableau dashboards |