Date | Summary |
---|
6/13/24 | Reporting May 30 - June 13, 2024 - Working with subgroup of Reporting Team, Index Data devops, and EBSCO hosting team on Fixing Derived Tables for Metadb with Poppy
- Collaborating with Desktop Services and Systems to test CloudBeaver as possible replacement for Virtual DBeaver
- Collaborated with co-convener to prepare for and lead FOLIO Reporting SIG meetings
- XX Metadb report queries in progress to covert from LDP format, tested, and published to the cul-folio-analytics repository
- 4 new LDP report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- X new LDP report queries in progress for the cul-folio-analytics GitHub repository targeted for completion by 4/18/24, and more on the way
- several Metadb report queries for the cul-folio-analytics GitHub repository targeted for completion by 4/18/24, and more on the way
- XX Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- X Tableau dashboards in revision or test
- X Tableau dashboards in development
- 163 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, and need for more development of the Receiving app
- See 20240613 Full List of CUL Reports with Status for full status report
|
5/23/24 | Reporting May 9 - May 23, 2024 - Working with subgroup of Reporting Team, Index Data devops, and EBSCO hosting team on Fixing Derived Tables for Metadb with Poppy
- Collaborating with Destop Services and Systems to test CloudBeaver as possible replacement for Virtual DBeaver
- Collaborated with co-convener to prepare for and lead FOLIO Reporting SIG meetings
- 2 Metadb report queries in progress to covert from LDP format, tested, and published to the cul-folio-analytics repository
- 4 new LDP report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 2 new LDP report queries in progress for the cul-folio-analytics GitHub repository targeted for completion by 4/18/24, and more on the way
- several Metadb report queries for the cul-folio-analytics GitHub repository targeted for completion by 4/18/24, and more on the way
- 18 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 8 Tableau dashboards in revision or test
- 6 Tableau dashboards in development
- 163 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, and need for more development of the Receiving app
- See 20240523 Full List of CUL Reports with Status for full status report
|
4/4/24 | Reporting March 22 - April 4, 2024 - All reporting team members have completed review, categorization, and prioritization of both LDP reports and Tableau dashboards to be revised for Metadb
- Collaborating with Destop Services and Systems to test CloudBeaver as possible replacement for Virtual DBeaver
- Reporting team experimenting with AI tools for creating, converting, and testing SQL queries
- Worked with EBSCO hosting team and Index Data devops on account setups, schema permissions, software updates, configuration changes, troubleshooting, support requirements, scheduling, and data sources for new Metadb Test reporting database
- Collaborated with co-convener to prepare for and lead FOLIO Reporting SIG meetings
- 2 Metadb report queries in progress to covert from LDP format, tested, and published to the cul-folio-analytics repository
- 4 new LDP report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 2 new LDP report queries in progress for the cul-folio-analytics GitHub repository targeted for completion by 4/18/24, and more on the way
- several Metadb report queries for the cul-folio-analytics GitHub repository targeted for completion by 4/18/24, and more on the way
- 18 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 8 Tableau dashboards in revision or test
- 6 Tableau dashboards in development
- 163 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, and need for more development of the Receiving app
- See 20240404 Full List of CUL Reports with Status for full status report
|
3/21/24 | Reporting March 8 - March 21, 2024 - All reporting team members reviewing, categorizing, and prioritizing LDP reports to be revised for Metadb and preparing to write new queries for Metadb only
- Reporting team experimenting with AI tools for creating, converting, and testing SQL queries
- Worked with hosting team and Index Data devops on account setups, schema permissions, software updates, configuration changes, support requirements and data sources for new Metadb Test reporting database
- Collaborated with co-convener to prepare for and lead FOLIO Reporting SIG meetings
- 7 Metadb report queries converted from LDP format, tested, and published to the cul-folio-analytics repository
- 2 Metadb report queries in progress to covert from LDP format, tested, and published to the cul-folio-analytics repository
- 1 new Metadb-only report query written, tested, and published to the cul-folio-analytics repository
- 3 new LDP report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 3 new LDP report queries in progress for the cul-folio-analytics GitHub repository targeted for completion by 4/4/24, and more on the way
- several Metadb report queries for the cul-folio-analytics GitHub repository targeted for completion by 3/21/24, and more on the way
- 19 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 7 Tableau dashboards in revision or test
- 5 Tableau dashboards in development
- 162 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, and need for more development of the Receiving app
- See 20240321 Full List of CUL Reports with Status for full status report
|
3/7/24 | Reporting February 23 - March 7, 2024 - All reporting team members reviewing, categorizing, and prioritizing LDP reports to be revised for Metadb and preparing to write new queries for Metadb only
- Worked with hosting team on account setups, software updates, configuration changes, support requirements and data sources for new Metadb Test reporting database
- Collaborated with co-convener to prepare for and lead FOLIO Reporting SIG meetings
- 3 LDP report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 3 new report queries for the cul-folio-analytics GitHub repository targeted for completion by 3/21/24, and more on the way
- several Metadb report queries for the cul-folio-analytics GitHub repository targeted for completion by 3/21/24, and more on the way
- 19 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 7 Tableau dashboards in revision or test
- 5 Tableau dashboards in development
- 162 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, and need for more development of the Receiving app
- See 20240307 Full List of CUL Reports with Status for full status report
|
2/22/24 | Reporting February 9 - February 22, 2024 - Delivered "Part 2" of Metadb Rollout Plan and Training Materials to prepare reporting users for the upcoming transition from the LDP to the Metadb reporting database system
- Continued testing CloudBeaver as an alternative to the Virtual DBeaver reporting application
- Worked with reference librarians and library systems on SpringShare data integration
- Worked with hosting team on account setups, software updates, configuration changes, support requirements and data sources for new Metadb Test reporting database
- Collaborated with co-convener to prepare for and lead FOLIO Reporting SIG meetings
- 3 new report queries for the cul-folio-analytics GitHub repository targeted for completion by 3/7/24, and more on the way
- 19 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 7 Tableau dashboards in revision or test
- 5 Tableau dashboards in development
- 162 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, and need for more development of the Receiving app
- See 20240222 Full List of CUL Reports with Status for full status report
|
2/8/24 | Reporting January 26 - February 8, 2024 - Delivered "Part 1" of Metadb Rollout Plan and Training Materials to prepare reporting users for the upcoming transition from the LDP to the Metadb reporting database system
- Began testing CloudBeaver as an alternative to the Virtual DBeaver reporting application
- Worked with reference librarians and library systems on SpringShare data integration
- Worked with hosting team on account setups, software updates, configuration changes, support requirements and data sources for new Metadb Test reporting database
- Collaborated with co-convener to prepare for and lead FOLIO Reporting SIG meetings
- 2 report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 1 report query revised, tested, and re-published to the CUL report directory and cul-folio-analytics repository
- 19 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 7 Tableau dashboards in revision or test
- 5 Tableau dashboards in development
- 162 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, and need for more development of the Receiving app
- See 20240208 Full List of CUL Reports with Status for full status report
|
1/25/24 | Reporting January 12 - January 25, 2024 - Created Reporting Team Goals for 2024
- Worked on materials and plans for CUL presentations planned to cover upcoming transition from LDP to Metadb reporting database system
- Prepared for setup and testing for CloudBeaver as alternative to Virtual DBeaver
- Worked with reference librarians and library systems on SpringShare data integration
- Worked with hosting team on account setups, software updates, configuration changes, support requirements and data sources for new Metadb Test reporting database
- Collaborated with co-convener to prepare for and lead FOLIO Reporting SIG meetings
- 1 reports created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 3 new report queries for the cul-folio-analytics GitHub repository targeted for completion by 2/8/24, and more on the way
- 18 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 5 Tableau dashboards in revision or test
- 7 Tableau dashboards in progress or not started
- 158 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, and need for more development of the Receiving app
- See 20240125 Full List of CUL Reports with Status for full status report
|
1/11/24 | Reporting January 2 - January 11, 2024 - Worked on materials and plans for CUL presentations planned to cover upcoming transition from LDP to Metadb reporting database system
- Working with hosting team on account setups, software updates, configuration changes, support requirements and data sources for new Metadb Test reporting database
- Collaborated with co-convener to prepare for and lead FOLIO Reporting SIG meetings
- 4 reports created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 3 new report queries for the cul-folio-analytics GitHub repository targeted for completion by 1/25/24, and more on the way
- 18 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 5 Tableau dashboards in revision or test
- 7 Tableau dashboards in progress or not started
- 157 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, and need for more development of the Receiving app
- See 20240111 Full List of CUL Reports with Status for full status report
|
12/7/23 | Reporting November 23 - December 7, 2023 - Worked on materials and plans for CUL presentations planned to cover upcoming transition from LDP to Metadb reporting database system
- Reporting team user accounts created and tested for access to new Metadb Test reporting database
- Working with hosting team on account setups, software updates, configuration changes, support requirements and data sources for new Metadb Test reporting database
- Collaborated with co-convener to prepare for and lead FOLIO Reporting SIG meetings
- Several derived tables updated and merged for the folio-analytics GitHub repository merged for 1.7 Poppy release
- Several derived tables reviewed and tested for the folio-analytics GitHub repository submitted for 1.7 Poppy release
- 2 reports created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 4 new report queries for the cul-folio-analytics GitHub repository targeted for completion by 1/11/24, and more on the way
- 18 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 5 Tableau dashboards in revision or test
- 7 Tableau dashboards in progress or not started
- 155 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20231207 Full List of CUL Reports with Status for full status report
|
11/22/23 | Reporting November 9 - November 22, 2023 - Worked on materials and plans for CUL presentations planned to cover upcoming transition from LDP to Metadb reporting database system
- Contributed to and led the FOLIO Analytics Code Review Board for the 1.7 Poppy release
- Collaborated with co-convener to prepare for and lead FOLIO Reporting SIG meetings
- 1 derived table for the folio-analytics GitHub repository merged for 1.7 Poppy release
- 5 derived tables for the folio-analytics GitHub repository submitted for 1.7 Poppy release
- 5 derived tables for the folio-analytics GitHub repository reviewed for 1.7 Poppy release
- 1 report created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 7 new report queries for the cul-folio-analytics GitHub repository targeted for completion by 12/7/23, and more on the way
- 18 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 5 Tableau dashboards in revision or test
- 7 Tableau dashboards in progress or not started
- 155 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20231122 Full List of CUL Reports with Status for full status report
|
11/9/23 | Reporting October 27 - November 9, 2023
- Worked on materials and plans for CUL presentations planned to cover upcoming transition from LDP to Metadb reporting database system
- Launched the FOLIO Analytics Code Review Board for the 1.7 Poppy release
- Participating in BugFest for Poppy to test the Reporting App
- Collaborated with co-convener to prepare for and lead FOLIO Reporting SIG meetings
- 1 derived table for the folio-analytics GitHub repository merged for 1.7 Poppy release
- 5 derived tables for the folio-analytics GitHub repository submitted for 1.7 Poppy release
- 5 derived tables for the folio-analytics GitHub repository reviewed for 1.7 Poppy release
- 1 report created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 6 new report queries for the cul-folio-analytics GitHub repository targeted for completion by 11/22/23, and more on the way
- 18 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 5 Tableau dashboards in revision or test
- 7 Tableau dashboards in progress or not started
- 154 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20231109 Full List of CUL Reports with Status for full status report
|
10/26/23 | Reporting October 13 - October 26, 2023 - Worked on materials and plans for CUL presentations planned to cover upcoming transition from LDP to Metadb reporting database system
- Launched the FOLIO Analytics Code Review Board for the 1.7 Poppy release
- Participating in BugFest for Poppy to test the Reporting App
- Collaborated with co-convener to prepare for and lead FOLIO Reporting SIG meetings
- 1 derived table for the folio-analytics GitHub repository merged for 1.7 Poppy release
- 5 derived tables for the folio-analytics GitHub repository in progress for 1.7 Poppy release
- 5 derived tables for the folio-analytics GitHub repository in review for 1.7 Poppy release
- 3 reports created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 5 new report queries for the cul-folio-analytics GitHub repository targeted for completion by 11/9/23, and more on the way
- On the CUL section of Cornell's Tableau Server (libr-folio), replaced the "librgroup - folio - All Staff" Tableau permissions group with our the Active Directory Tableau permissions group "LIB-CUnivLibrary-AllStaff-gs" on each of our Tableau dashboards needing all-staff access, which means we no longer need to manually maintain our all-staff permissions group
- 18 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 5 Tableau dashboards in revision or test
- 7 Tableau dashboards in progress or not started
- 154 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20231026 Full List of CUL Reports with Status for full status report
|
10/12/23 | - Following the recent location changes in the FOLIO system, we noticed some location data that was making report results inaccurate or misleading, so we created and shared reports showing Location changes impacting data quality with the LTS data quality management and automation groups, who will follow up to fix the data
- Worked on materials and plans for CUL presentations planned to cover upcoming transition from LDP to Metadb reporting database system
- Worked with reporting product owner, LDP/Metadb director, and Reporting SIG report development teams to establish FOLIO Analytics code completion schedule and launch FOLIO Analytics Code Review Board for Poppy
- Collaborated with co-convener to prepare for and lead FOLIO Reporting SIG meetings
- Updated several queries to exclude inactivated locations from reports and dashboards
- Updated library location names and codes in the FOLIO Reports Filter Directory to match recent location updates in FOLIO Production
- 3 reports created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 2 new report queries targeted for completion by 10/26/23, and more on the way
- 18 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 5 Tableau dashboards in revision or test
- 7 Tableau dashboards in progress or not started
- 154 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20231012 Full List of CUL Reports with Status for full status report
|
9/28/23 | - Updated and Tested Locations Translation table in the local schemas in the LDP after library location names changed in FOLIO to ensure proper locations are shown in LDP reports and dashboards
- Worked on materials for presentations planned to cover upcoming transition from LDP to Metadb reporting infrastructure system
- Updating several queries to exclude inactivated locations from key record counts for reports and dashboards
- Updated library location names and codes in the FOLIO Reports Filter Directory to match recent updates in FOLIO Production
- 1 reports revised, tested, and published to the CUL report directory and cul-folio-analytics repository
- 5 new report queries targeted for completion by 10/12/23, and more on the way
- 18 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 5 Tableau dashboards in revision or test
- 7 Tableau dashboards in progress or not started
- 154 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20230928 Full List of CUL Reports with Status for full status report
|
9/14/23 | Reporting Sept 1 - September 14, 2023 - Delivered "Troubleshooting SQL" presentation at FOLIO Reporting SIG meeting on 9/7/23
- Testing changes to library location names and codes in FOLIO Test and LDP Test for impacts on queries and dashboards
- 2 reports revised, tested, and published to the CUL report directory and cul-folio-analytics repository
- 2 reports updated for fiscal year 2024 including automation updates
- 3 new report queries targeted for completion by 9/28/23, and more on the way
- 18 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 5 Tableau dashboards in revision or test
- 7 Tableau dashboards in progress or not started
- 147 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20230914 Full List of CUL Reports with Status for full status report
|
8/31/23 | Reporting August 18 - August 31, 2023 - Delivered 2 presentations at WOLFcon 2023: "Experiences of Institutions with FOLIO Reporting" and "Getting Started with FOLIO Reporting"
- Coordinated and moderated 5 WOLFcon 2023 reporting presentations on behalf of Reporting SIG and served on the WOLFcon 2023 planning team
- Testing changes to library location names and codes in FOLIO Test and LDP Test for impacts on queries and dashboards
- 1 new report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 2 reports revised, tested, and published to the CUL report directory and cul-folio-analytics repository
- 2 reports updated for fiscal year 2024 including automation updates
- 3 new report queries targeted for completion by 9/14/23, and more on the way
- 18 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 5 Tableau dashboards in revision or test
- 7 Tableau dashboards in progress or not started
- 146 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20230831 Full List of CUL Reports with Status for full status report
|
8/17/23 | Reporting August 3 - August 17, 2023 - Worked on planning, scheduling, and coordination of all Reporting SIG topics for upcoming WOLFCon 2023 conference
- Prepared content to deliver 2 presentations at WOLFcon 2023: "Experiences of Institutions with FOLIO Reporting" and "Getting Started with FOLIO Reporting"
- Updated several financial report queries to include data for new fiscal year FY2024
- Testing changes to library location names and codes in FOLIO Test and LDP Test for impacts on queries and dashboards
- 3 new report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 3 reports updated for fiscal year 2024 including automation updates
- 2 new report queries targeted for completion by 8/31/23, and more on the way
- 18 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 5 Tableau dashboards in revision or test
- 7 Tableau dashboards in progress or not started
- 146 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20230817 Full List of CUL Reports with Status for full status report
|
8/3/23 | Reporting July 7 - August 3, 2023 - Recruited Scott Perry, University of Chicago, to be new co-convener for the FOLIO Reporting SIG along with Sharon as Angela Zoss (Duke) leaves the position
- Worked on planning, scheduling, and coordination of all Reporting SIG topics for upcoming WOLFCon 2023 conference
- Moved to new versions of LDP software components on LDP Test – LDP 1.9.1 and Folio Analytics 1.6 – to support move to FOLIO Orchid release and to test and prepare for updating to these software components on LDP Production
- Updating several report queries and Tableau dashboards to include data for new fiscal year, FY2024
- Reviewing list of August updates to library location names and codes in FOLIO for impacts on queries and dashboards
- 4 new report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 3 reports revised, tested, and published to the CUL report directory and cul-folio-analytics repository
- 4 new report queries targeted for completion by 8/17/23, and more on the way
- 17 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 5 Tableau dashboards in revision or test
- 5 Tableau dashboards in progress or not started
- 143 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20230803 Full List of CUL Reports with Status for full status report
|
7/6/23 | Reporting June 23 - July 6, 2023 - Completed analysis of Metadb Development Priorities with operations and automation teams
- Preparing for move to Orchid 1.6 derived tables on LDP Test and LDP Production reporting databases
- Reviewing list of July updates to library location names and codes in FOLIO for impacts on queries and dashboards
- 5 new report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 1 report revised, tested, and published to the CUL report directory and cul-folio-analytics repository
- 2 new report queries targeted for completion by 8/3/23, and more on the way
- 15 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 5 Tableau dashboards in revision or test
- 6 Tableau dashboards in progress or not started
- 142 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20230706 Full List of CUL Reports with Status for full status report
|
6/22/23 | Reporting June 9 - June 22, 2023 - Preparing for move to Orchid 1.6 derived tables on LDP Test and LDP Production reporting databases
- Reviewing list of June-July updates to library location names and codes in FOLIO for impacts on queries and dashboards
- 1 new report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 7 new report queries targeted for completion by 7/6/23, and more on the way
- 13 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 6 Tableau dashboards in revision or test
- 8 Tableau dashboards in progress or not started
- New "one-stop-shop" grid for Access Services data added to FOLIO Reporting site
- 142 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20230622 Full List of CUL Reports with Status for full status report
|
6/8/23 | Reporting May 26 - June 8, 2023 - Completed FOLIO Reporting SIG's WOLFcon 2023 Submission of presentations, workshops, working meetings, panel discussions, etc.
- Preparing for move to Orchid 1.6 derived tables on LDP Test and LDP Production reporting databases
- Reviewing list of June-July updates to library names and library codes for impacts on queries and dashboards
- 4 new report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 3 new report queries targeted for completion by 6/21/23, and more on the way
- 13 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 6 Tableau dashboards in revision or test
- 8 Tableau dashboards in progress or not started
- New "one-stop-shop" grid for Annual Data Collection data added to FOLIO Reporting site
- 141 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20230608 Full List of CUL Reports with Status for full status report
|
5/25/23 | Reporting May 12 - May 25, 2023 - Preparing FOLIO Reporting SIG's submission of presentations, workshops, working meetings, panel discussions, etc. for WOLFcon 23 conference
- Preparing for move to Orchid 1.6 derived tables on LDP Test and LDP Production reporting databases
- Preparing for June-July updates to library names and library codes in queries and dashboards
- 5 new report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 7 new report queries targeted for completion by 6/8/23, and more on the way
- 13 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 6 Tableau dashboards in revision or test
- 8 Tableau dashboards in progress or not started
- New documentation added to FOLIO Reporting site
- 140 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 2023525 Full List of CUL Reports with Status for full status report
|
5/11/23 | Reporting April 28 - May 11, 2023 - Worked with Reporting SIG members and co-convener to gather reporting solution by institution listings
- New "local_protected" schema added to LDP Test and LDP Production to store tables capturing daily updates that cannot be deleted
- Preparing for move to Orchid 1.6 derived tables on LDP Test and LDP Production reporting databases
- Preparing for June-July updates to library names and library codes in queries and dashboards
- "Review of LDP Derived Table Updates for Orchid 1.6" presentation delivered to FOLIO Reporting Users Group meeting Monday, May 8, 2023
- 1 new report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 6 new report queries targeted for completion by 5/24/23, and more on the way
- 13 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 6 Tableau dashboards in revision or test
- 8 Tableau dashboards in progress or not started
- New documentation added to FOLIO Reporting site
- 140 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 2023511 Full List of CUL Reports with Status for full status report
|
4/27/23 | Reporting April 14 - April 27, 2023 - 2 new report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 3 new report queries targeted for completion by 4/27/23, and more on the way
- 13 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 6 Tableau dashboards in revision or test
- 8 Tableau dashboards in progress or not started
- 140 reporting help requests resolved via TDX since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20230427 Full List of CUL Reports with Status for full status report
|
4/13/23 | Reporting March 18 - April 13, 2023 |
3/30/23 | Reporting March 17 - March 30, 2023 - FOLIO Acquisitions and Electronic Resource Management Data Model Training developed and delivered over 2 Reporting SIG meetings
- 16 derived tables updated for LDP, converted to Metadb format, and submitted to the FOLIO-Analytics repository for the Orchid 1.6 of Folio Analytics (see Orchid 1.6 worksheet in full status report)
- 7 derived tables reviewed, tested, and approved for publication to the FOLIO-Analytics repository for the Orchid 1.6 of Folio Analytics (see Orchid 1.6 worksheet in full status report)
- Reporting Team has completed testing 60 queries on LDP Test for impacts and making code changes as needed to prepare for the move from Folio Analytics version 1.4 to version 1.5 on LDP Production
- Hosting services will update LDP Production to version ldpmarc 1.6.3 and Folio Analytics 1.6 on 3/31/23 (see LDP Software Update Schedule)
- 4 new report queries targeted for completion by 4/13/23, and more on the way
- 13 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 4 Tableau dashboards in revision or test
- 7 Tableau dashboards in progress or not started
- 139 reporting help requests resolved since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20230330 Full List of CUL Reports with Status for full status report
|
3/16/23 | Reporting March 3 - March 16, 2023 - Reporting Team has been testing 60 queries on LDP Test for impacts and making code changes as needed to prepare for the move from Folio Analytics version 1.4 to version 1.5 on LDP Production
- 1 report query created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 3 new report queries targeted for completion by 3/30/23, and more on the way
- 13 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 3 new Tableau dashboards completed
- 4 Tableau dashboards in revision or test
- 5 Tableau dashboards in progress or not started
- several derived tables updated for LDP, converted to Metadb format, and published to the FOLIO-Analytics repository for the Orchid 1.6 of Folio Analytics
- 139 reporting help requests resolved since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20230316 Full List of CUL Reports with Status for full status report
|
3/2/23 | Reporting February 3 - March 2, 2023: - Milestone: 100 report queries developed, tested, and published by the FOLIO Reporting Team!
- "Troubleshooting SQL Queries" presentation delivered to FOLIO Reporting Users Group on 2/27/23
- 1 report query revised, tested, and published to the CUL report directory and cul-folio-analytics repository
- 11 new report queries created, tested, and published to the CUL report directory and cul-folio-analytics repository
- 2 new report queries targeted for completion by 3/16/22, and more on the way
- 13 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 3 new Tableau dashboards completed
- 4 Tableau dashboards in revision or test
- 5 Tableau dashboards in progress or not started
- several derived tables converted to Metadb format and published to the FOLIO-Analytics repository for Orchid 1.6
- 139 reporting help requests resolved since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on the availability of a MetaDB Test instance
- See 20230302 Full List of CUL Reports with Status for full status report
|
2/2/23 | Reporting January 20 - February 2, 2023: - 3 report queries revised, tested, and published to the CUL report directory and cul-folio-analytics repository
- 3 new report queries targeted for completion by 3/2/22, and more on the way
- 14 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 3 new Tableau dashboards completed
- 3 Tableau dashboards in revision or test
- 3 new Tableau dashboards in progress or not started
- several derived tables converted to Metadb format and published to the FOLIO-Analytics repository for Orchid 1.6
- 138 reporting help requests resolved since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on official release of MetaDB
- See 20230202 Full List of CUL Reports with Status for full status report
|
1/19/23 | Reporting December 21, 2022 - January 19, 2023: - 1 new report query developed and published to the report directory
- 2 new report queries targeted for completion by 2/2/22, and more on the way
- 14 Tableau dashboards active on the libr-folio section of Cornell's Tableau server
- 3 new Tableau dashboards completed
- 3 Tableau dashboards in revision or test
- 3 new Tableau dashboards in progress or not started
- 138 reporting help requests resolved since 7/1/21
- some report development blocked due to FOLIO application development issues (see LDP Known Issues), lack of access to eHoldings data, need for more development of the Receiving app, and dependence on official release of MetaDB
- see 20230119 Full List of CUL Reports with Status.xlsx for full status report
|