Facilitate use of ISSNs?

[bmkramer]

The OLAP server is very useful to access OpenAPC data programmatically, thanks for making it available!

One thing that would be great to have is the ability to drill down/cut on ISSNs rather than (or in addition to) journal title. Is this something that would be worth adding to the database?

[cbroschinski]

That's no big issue, I just added the issn field as a separate OLAP dimension. It is now available on the live system:
https://olap.openapc.net/cube/openapc/aggregate?drilldown=issn
It should be noted, however, that the OpenAPC dataset contains 4 different types of ISSN: issn, issn_print, issn_electronic and issn_l. The first 3 originate from crossref (with issn being the primary identifier), while issn_l is the Linking ISSN provided by the ISSN organization. Unfortuately the relation between those is not always consistent, issn is sometimes the same as the print version, sometimes the same as the electronic version and in rare cases even something completely different.
Let me know if this is sufficient for you or if I should add the other ISSN fields as well.

[bmkramer]

Thanks for the quick implementation @cbroschinski! For optimal matching, it would indeed be good to have all ISSN fields if that's possible.

This will be very useful, so thanks again!