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 |