We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Sharing Queries and Reports with the Reporting Marketplace

00:00

Formal Metadata

Title
Sharing Queries and Reports with the Reporting Marketplace
Title of Series
Number of Parts
18
Author
Contributors
License
CC Attribution 4.0 International:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
As soon as research information is collected in a research information system, even if this system was originally intended for a different purpose such as research profiles, the administration of research institutions often realises very quickly that there is potential here to cover reporting obligations. Some of these reporting obligations are standardised, such as the “Guidelines for Transparency in Research” in Lower Saxony or the reporting of the institutes of the German Leibniz Association. In past years, various approaches have been presented at the VIVO conference on how these reporting obligations can be addressed technically at the institutional level. One of these approaches is the Vitro Query Tool, which can export Data from VIVO in predefined Excel or Word templates. This idea gained traction in the German speaking VIVO community, and potential for synergies was discovered. In this presentation we will introduce the Reporting Marketplace, a gitHub repository and an open platform, where reports and their components like SPARQL queries and templates can be collaboratively worked on, discussed and shared. The Reporting Marketplace is also one of the milestones of the TAPIR (Partially Automated Persistent Identifier-based Reporting) project - the joint project of the TIB Hannover and the University Osnabrück.
Computer animation
Transcript: English(auto-generated)
Thank you very much. So in my talk, I would like to give you a short introduction of the reporting marketplace and talk about sharing theories and reports with the reporting marketplace.
So I think I'll skip the agenda. Well, a couple of words about the background and motivation for this project. Public funded scholarly and research institutions in Germany have several standardized recurring reporting obligations.
These requirements are often related with very tedious manual preparation because the data is decentralized, saved and the people should collect
it and collect it in multiple files for the same for various reports, the same data and it has to be done. Each year in you. So, in past years, various approaches have been developed on how this reporting obligations can be addressed technically, and one of the technical means which should facilitate the reporting task tasks.
It's vitro query tool and it has already been presented at your conference 2019. We were extended with vitro query tool allows to reuse get the data and
generate customized reports and also to use queries, as well as templates for reporting. Annually, so this idea gained traction among the German institutions and as a result, there is a growing German speaking community which chooses we were to fulfill their reporting duties with vivo and vitro query tool and.
Yes. There is apparently a great potential of facilities and mutual support. And one more motivation fact factor to be mentioned here is the top year project which has already been introduced or presented. I think yesterday in the top year project.
It is one of the central issue to. Yes, to create this, this kind of marketplace, where the research reports could be shared with other stakeholders with other interested parties.
So the results from the. Okay, so, and with all this in mind, we set up a platform, a kind of marketplace, where we can exchange queries and templates for reports.
So, I've mentioned the vitro query tool as the technical means for for this project. It was developed by Graham tricks as an extension of the existing reporting tools and vivo such as temporal graph for example or sparkle theory interface, it is based on the data distribution API.
It provides on the one hand, a user interface for configuring queries or configuring data in the so called data distributors here you can see two screenshots.
The first one shows you construct your graph to this one of the distributors which generate a graph for the required data output and the second one is the select from graph distributor which gets the data from this graph and process the output in Jason.
So, on the other hand, the vitro query tool allows the configuration of output in three common formats and Excel word and open dope by means of template engines and here you can see user interface for the configuration of report output.
So, now to the reporting marketplace itself. It's a GitHub repository a platform for collaborative documentation and subsequent reuse of reports. It contains general information about the vitro query tool and data distribute distributor on the landing page.
And there are also subsections for reports with their components like manuals queries for data distributors and templates. Since the platform is oriented on the German people community.
It's, it's in German. So, but when we gain more contributors or people from other countries who are who are interested in this collaborative work will provide the information in other languages, of course. So I also have to mention that of course the reporting marketplace is still work in progress, and
left. Yes, we are very grateful for any feedback and suggestions for improvements, we would appreciate it very, very. Yes, we would very appreciate your feedback.
And if you got interested in the reporting marketplace. If you also have any ideas about its further development please join the discussion in Slack channel reporting. Thank you very much. If you have questions, please feel free to contact me, and yes and our team.