BI: Open Access Dashboard (CDS)

1. [BI-OA: Open Access KPI](https://github.com/cern-sis/Library-Notifications-Service/issues/7)
* Queries
* Subset 1: Closed publications:
https://cds.cern.ch/search?ln=en&cc=Published+Articles&p=%28affiliation%3ACERN+or+595%3A%27For+annual+report%27%29+and+year%3A2023+not+980%3AConferencePaper+not+980%3ABookChapter+not+595%3A%27Not+for+annual+report%27+not+540__a%3A%27CC+BY%27+not+540__a%3A%27CC-BY+not+540__f%3ABronze%27+not+540__3%3Apreprint%22+not+8564_y%3Apreprint+not+8564_y%3A%27Accepted+manuscript%27&action_search=Search&op1=a&m1=a&p1=&f1=&c=Published+Articles&c=&sf=&so=d&rm=&rg=10&sc=1&of=hb

* Subset 2: Bronze OA publications:
https://cds.cern.ch/search?ln=en&cc=Published+Articles&p=%28affiliation%3ACERN+or+595%3A%27For+annual+report%27%29+and+year%3A2023+not+980%3AConferencePaper+not+980%3ABookChapter+not+595%3A%27Not+for+annual+report%27+and+540__f%3ABronze&action_search=Search&op1=a&m1=a&p1=&f1=&c=Published+Articles&c=&sf=&so=d&rm=&rg=10&sc=1&of=hb
* Subset 3: Green OA publications: https://cds.cern.ch/search?ln=en&cc=Published+Articles&p=%28affiliation%3ACERN+or+595%3A%27For+annual+report%27%29+and+year%3A2023+not+980%3AConferencePaper+not+980%3ABookChapter+not+595%3A%27Not+for+annual+report%27&action_search=Search&op1=a&m1=a&p1=&f1=&c=Published+Articles&c=&sf=&so=d&rm=&rg=10&sc=1&of=hb
And we need to take only records which have: ```(In
contains ‘preprint’ or ‘Accepted manuscript’
OR
In
contains ‘preprint’)
BUT NOT
(In
contains ‘CC-BY’ or ‘CC BY’
AND contains ‘publication’)```

* Subset 4: Gold OA publication: Query same as green access but we need to take only those records which have: ```In
contains ‘CC-BY’ or ‘CC BY’
AND contains ‘publication’```

* Visualisation: Pie chart WITH SPECIFIC COLORS (More info in[ google doc](https://docs.google.com/document/d/11fQu-WiiYJ4VjjUP2nVk0sEiLHL0_BylaTZ_ZMKxO0Q/edit))
2. [BI-OA: Open Access Gold mechanisms](https://github.com/cern-sis/Library-Notifications-Service/issues/8)
* Queries:
* Subset 1: SCOAP3: Add "540__f:'SCOAP3'" https://cds.cern.ch/search?ln=en&cc=Published+Articles&p=%28affiliation%3ACERN+or+595%3A%27For+annual+report%27%29+and+year%3A2023+not+980%3AConferencePaper+not+980%3ABookChapter+not+595%3A%27Not+for+annual+report%27+and+540__f%3A%27SCOAP3%27&action_search=Search&op1=a&m1=a&p1=&f1=&c=Published+Articles&c=&sf=&so=d&rm=&rg=10&sc=1&of=hb

* Subset 2: Other collective models: Add "540__f:'Collective'” https://cds.cern.ch/search?ln=en&cc=Published+Articles&p=%28affiliation%3ACERN+or+595%3A%27For+annual+report%27%29+and+year%3A2023+not+980%3AConferencePaper+not+980%3ABookChapter+not+595%3A%27Not+for+annual+report%27+and+540__f%3A%27Collective%27&action_search=Search&op1=a&m1=a&p1=&f1=&c=Published+Articles&c=&sf=&so=d&rm=&rg=10&sc=1&of=hb

* Subset 3: CERN Read and Publish agreement: Add "540__f:'CERN-RP'" https://cds.cern.ch/search?ln=en&cc=Published+Articles&p=%28affiliation%3ACERN+or+595%3A%27For+annual+report%27%29+and+year%3A2023+not+980%3AConferencePaper+not+980%3ABookChapter+not+595%3A%27Not+for+annual+report%27+and+540__f%3A%27CERN-RP%27&action_search=Search&op1=a&m1=a&p1=&f1=&c=Published+Articles&c=&sf=&so=d&rm=&rg=10&sc=1&of=hb

* Subset 4: CERN individual APCs
Add "540__f:'CERN-APC'"
https://cds.cern.ch/search?ln=en&cc=Published+Articles&p=%28affiliation%3ACERN+or+595%3A%27For+annual+report%27%29+and+year%3A2023+not+980%3AConferencePaper+not+980%3ABookChapter+not+595%3A%27Not+for+annual+report%27+and+540__f%3A%27CERN-APC%27&action_search=Search&op1=a&m1=a&p1=&f1=&c=Published+Articles&c=&sf=&so=d&rm=&rg=10&sc=1&of=hb

* Subset 5: Others. Add "540__f:'Other'" https://cds.cern.ch/search?ln=en&cc=Published+Articles&p=%28affiliation%3ACERN+or+595%3A%27For+annual+report%27%29+and+year%3A2023+not+980%3AConferencePaper+not+980%3ABookChapter+not+595%3A%27Not+for+annual+report%27+and+540__f%3A%27Other%27&action_search=Search&op1=a&m1=a&p1=&f1=&c=Published+Articles&c=&sf=&so=d&rm=&rg=10&sc=1&of=hb

* Visualisation: Pie chart