Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »



Discussion items

AttendanceUpdate Attendee List
Action ItemsReview and update Action Items
FOLIO Face-to-Face meeting plans

FOLIO Face-to-Face meeting plans -  

Working document for the Face to Face meeting:


  • Settle on what groups/individual should plan to attend

  • Discuss and decide on meeting times/organization

  • Identify any significant gaps in the program

German Folio Days and Data Warehouse Ideas

Veit presented his ideas from German Folio Days

  • eUsage app data model
  • how to “work” to a data model
  • problem of slowly changing dimensions


-Veit presented ideas from German FOLIO days

-problems with underlying data structure

  • UUIDs are string values, which have bad performance for joins (Nassib: UUIDs are Integers, so should be ok)
  • Create Mapping Tables: map UUID to DWID
  • recommend attributes with specific data types (e.g., Date, INT, String)
  • dimension examples: Time, Patron, Item

-markers for slowly changing dimensions, e.g.

  • service point
  • loan transaction

-database has a lot of redundant information

Thoughts from Nassib

-we are using keys for joins, but sometimes the UUIDs are there in case you want to join them

-would be helpful for technical feedback in terms of work that has already been done (bring to Nassib first)

Veit: Problem of Slowly Changing Dimensions

-state of data structure impacts reporting

-report on states of data such as as is, as of, as posted, comparable each render different results

Thoughts from Nassib

-by default, we currently have fact tables linked to specific dimensions and an effective record date is stored

-there is some flexibility in the way elements impacted by time are modeled

-data warehouse impacted by the development of streaming functionality in FOLIO

Thoughts from Tod

-every record needs a created date and an updated date 

RPWG Projects

Review RPWG Project List


-is "filtering" to build out the data elements just for reporting the most efficient way to develop?

-will we develop all 250 reports?

-what scaling can we do at our institutions to support report development

Circ Item Detail Report Prototype

-latest update on progress?

eUsage Project

Please take a look at the documentation for API data elements from the eUsage app development team.

eUsage API data elements documentation:

  • the "counter-reports" worksheet shows the metadata for the harvested reports.
  • for eUsage, we do not actually save the single data fields of each report, but the monthly reports as a whole, with metadata to identify them

eUsage UI presentation:
The eUsage UI design includes a statistics previews backend that queries specific reports (identified by provider, date range, metric type etc.) and then processes the full report

Here is a presentation explaining this design with an example:

Some General Questions (from last meeting)

-custom fields?

-how many of the reports do we develop?

-next priority reports?

For our next meeting...

Next Topics:

  • topic 1
  • topic 2
  • topic 3

Next meeting of the Report Prototype WG is scheduled for Monday, April 29 at 10:00am EST

Action Items

  • First
  • Second
  • No labels