BI-OA: Open Access KPI - Githubissues

Collect all needed queries from Anne for collecting needed data, google doc:

After collecting the feedback from Anne, we found out that initial query was not fully correct, however, Anne is not sure how the wanted query should look like. S̶h̶e̶ ̶c̶o̶n̶t̶a̶c̶t̶e̶d̶ ̶C̶D̶S̶.̶ ̶I̶f̶ ̶t̶h̶e̶y̶ ̶a̶r̶e̶n̶'̶t̶ ̶b̶e̶ ̶a̶b̶l̶e̶ ̶t̶o̶ ̶p̶r̶o̶v̶i̶d̶e̶ ̶t̶h̶e̶ ̶q̶u̶e̶r̶y̶ ̶w̶e̶ ̶n̶e̶e̶d̶,̶ ̶w̶i̶l̶l̶ ̶n̶e̶e̶d̶ ̶t̶o̶ ̶w̶r̶i̶t̶e̶ ̶t̶h̶e̶ ̶p̶a̶r̶s̶e̶r̶ ̶w̶h̶i̶c̶h̶ ̶w̶i̶l̶l̶ ̶h̶e̶l̶p̶ ̶t̶o̶ ̶g̶e̶t̶ ̶d̶a̶t̶a̶ ̶w̶e̶ ̶n̶e̶e̶d̶. We need to write a parser. In this case: green_open_access = these_articles - overlapping gold_open_access_article

[ ] Gold access
1. The same problem as before. We need a query that let us take the articles that have 5403:'publication' AND 540a:'CC-BY' in the same 540 field, or 5403:'publication' and 540a:’CC BY’ in the same 540 field. The current query returns articles that have wanted fields, but not necessarily in the same 540 field.

Setup Airflow workflow:

Feedback regarding results

[ ] Ask Anne for feedback regarding the results we are getting from CDS. Adjust if needed

Colors

Anne wants to have specific colors for the pie chart pieces:

closed_access -> 🔵 green_open_access -> 🟤 bronze_open_access -> 🟢 gold_open_access -> 🟡

However, we have limitations on the superset side. Most likely we will need to add config on Kubernetes side: chat

Deploy

cern-sis / Library-Notifications-Service