2024-02-12 Reporting SIG Meeting notes

Announcements/Reminders

Changes in Reporting SIG Meetings

• Reporting SIG meetings will take place at 11am ET on the 2nd and 4th Mondays of the month only starting Monday February 12, 2024
  
• "Workshopping your queries" - part of each Reporting SIG meeting will be devoted to time to work through any query questions you may have

Impacts of New Fields and Features (Sharon)

• Are there any new fields or features we should know about from any of the functional areas that may impact reporting?
• Review and update the Impacts of New Fields and Features on Reporting grid 

FOLIO Analytics Update

• Poppy and FOLIO Analytics 1.7 were both released in December.

Upcoming meeting topics (tentative)

• Lehigh's use of the Reporting App, Lisa McColl - Feb 26
• Metadb Updates, Nassib Nassar - March 11

Any new members?

• Welcome/introductions

• Representative for the Documentation Working Group 
  • urgently needed
  • work with reporting documentation team to  update Reporting section of FOLIO documentation for each FOLIO software release 
  • see https://docs.folio.org/docs/reporting/
• Query developers
  
  • ongoing need
  • work on derived tables and report queries for the FOLIO Analytics repository and to support Metadb
  • see https://github.com/folio-org/folio-analytics

Workshopping Queries

Bring your questions on queries written for the LDP or Metadb so we can "workshop" them! 

• Working with the calendar tables in metadb. Exceptions and normal hours.
  • How to merge queries for the exception and normal hours. 
  • A similar report was tried in one of the subgroups that was able to extract interval times. 
    • S. Dombek provided an description of how this was done and the limitations of this solution. An example was provided.
• What is the schedule of the derived table updates and what are the issues?
  • Comments about
    • performance querying on the main tables - queries are timing out. performance on the derived tables is much more acceptable.
    • concern about mixing data between the static derived tables and the more real-time data of the main tables. 
    • more secure to use derived tables for dashboards, etc, because only limited permissions are required.
• How do we get data between the receiving app and orders? 
  • Has been forwarded to Nassib to discuss in the MetaDB users group.
• Has someone experience with sequence querying? 
  • How to create diagrams illustrating the difference between loans during the last year and distributions within the year. 
  • Could be a first good example for a sequence for historic data.
• How to add ordinality to an existing table?
  • Will post in SQL channel since no time. 

Consortia SIG and the DBS reports for D-Reporting are the next big task for the Reporting SIG

• Check overlaps between the reports from Consortia SIG and D-Reporting
• It is crucial to find the right method
  • Collect requirements via JIRA. Some missing features may still need to be implemented. The implementations should be via FOLIO rather than LDP. Example: Statistic codes
  • The data is stored very differently
    
  • Distribution type: Cookbooks, Scripts etc. with the possibility to set parameters