Preface

This material provides an introduction to working with Analytics for Alma, Primo and Leganto (AAPL[1]). It is aimed at librarians wishing to work with designing analytics and reporting using these products.

Ex Libris are a leading library systems vendor. Their products, Alma™, Primo™ and Leganto™ provide an analytics and reporting platform. The Ex Libris analytics platform is based on the Oracle Analytics Server (OAS) and Oracle Data Visualization (ODV) which in previous versions was Oracle Business Intelligence Enterprise Edition (OBIEE). This material, from libtics.org, provides an introduction to working with the platform.

Alma is the Ex Libris integrated library management system and most of this analytics material will use Alma. Much of the discussion will also be applicable to Primo and Leganto analytics, which also use OAS. There are separate chapters for Primo and Leganto to consider their specifics.

For copyright and licensing information and for access to different formats of this material see the appendices.

All trademarks acknowledged.

libtics.org

libtics.org is/will be a hub for library analytics development, training, discussion, exchange of experience, etc.

This material is hosted at https://libtics.org.

The author(s)

Contact details are in the appendices.

John Krug

Picture of John Krug
John Krug

I work as a consultant. Since early, partial, retirement in April 2017 I live near Granada, España where I indulge in dozing in the sun and cycling. Prior to retirement, I spent 15 years at Lancaster University Library as a library systems person. I helped to implement Aleph, Primo and Alma in the library. I was the first coordinator of the IGELU Analytics Special Interest Working Group (SIWG), which is now the Analytics Community of Practice group. In this role I was involved with and presented at ELUNA and IGeLU conferences and at IGeLU Developer Days. I have also organized, and presented at, analytics days and workshops on behalf of EPUG-UKI.

I am not a librarian by training so please excuse all my errors of librarianship. The aim of this material is for librarians to begin to develop capability in AAPL. Analytics capability supported by librarianship and a strong understanding of the libraries data should be a powerful combination. Let us know of any issues you have with this material, we am always looking for ways to improve future versions. The appendices have the necessary details.

Who is this resource for?

Librarians, and possibly their line managers, who are using Ex Libris library management solutions:

  • You may be a "systems librarian" and have, more or less, naturally inherited the role of analytics development at your institution.

  • You are familiar with your institutions library data and need to start getting to grips with reporting as it is a task that has been assigned to you.

  • You are interested in analytics and how to use your institutions available tools to make use of the information in your library data.

  • You need or want to develop reporting for your functional area, because nobody else is going to.

  • As a line manager you are responsible for your sections contribution to institutional reporting. You need to have some idea of the capabilities your systems provide.

OAS and ODV are complex, multi-functional products. The primary aim of the earlier chapters of this material are to show how to get started and to begin to produce useful information and reporting.

How to use this resource

Notation and conventions

Where something is common to Alma, Primo and Leganto the acronym APL, or AAPL for Analytics for APL is used.

Images in the text (figures) are clickable links to be able to see the full size image for clarity, where necessary.

If you see a text item styled like My Dashboard, it indicates something you should look for on the Analytics screens. Mostly this is only used when the item is introduced.

Text styled like,

Analysis  Stock  Loans,

with arrowheads, means follow a menu. So, select Analysis, then Stock, then Loans. Something like:

Ctrl+Shift+N

indicates a keyboard combination.

Computer code is shown in a block. Like:

while true
do
    analytics
done
bash

Data items/columns within "Design Analytics" will be indicated like

"Subject Area"."Dimension Name"."Data Column".

For example,

"Requests"."Request Measures (Average)"."Average Time to Available (Days)".

This is following on from the conventions, or syntax, in "Design Analytics" where these are referenced or used, such as within a function, like so:

FILTER("Requests"."Request Measures"."# of requests"
    USING (
        "Requests"."Request Status"."Request Status" = 'Active'
    AND
        "Requests"."Request Type"."Request Type Description" = 'Patron physical item request'
    )
)
sql

If the subject area context is clear then the subject area will often be omitted.

"Notes", "Tips", etc, and sidebars look as follows.

Note this
This is something of particular interest to be noted.
A tip you may find useful
Something useful.
A cautionary tale
Be careful.
A bit more caution.
Things can go wrong, be extra careful.
Important stuff
Something important.
This is a sidebar

It will contain things which may be worth noting but not as part of the main text.

Analysis vs. Report

The terms "analysis" and "report" are sometimes used interchangeably in this material. Strictly speaking, in OAS terms, "reports" are produced using BI Publisher. They are intended to be for published reporting purposes and to be pixel perfect. You may notice there is a menu link within OAS for creating a new "Report" but this functionality is not available to Alma, Primo or Leganto Analytics users. So, our use of terms more or less interchangeably, even if we try to avoid it, should cause no confusion.

Folder locations

The material was initially developed in partnership with the University of Leeds. There may be references in the text and videos, when using the analytics catalog to:

/Shared Folders/University of Leeds 44LEE_INST/AAPL Training.

The AAPL Training folder can be found at:

/Shared Folders/Community/Reports/Shared Reports/Consultants/libtics.org/AAPL Training

for Alma analytics. Please take a copy of anything you want to modify.

The material is being changed to reflect the new locations in /Shared Folders/Community.

Video tutorials

These accompany the text and figures and are useful in seeing exactly how a particular set of actions in designing analyses with AAPL takes place.

The videos are recorded at HD resolution, 1920x1080. If the videos are played in-page they may be viewable, depending somewhat on the content, but they are best viewed if the video is played back in full screen mode. There is an assumption that everybody, wanting to use this material, has a minimum specification PC monitor or laptop display that has a full HD, 1920x1080 resolution screen. Circa 2020, this is a reasonable assumption. YouTube may not always play the videos at HD resolution, you may have to select settings and manually select HD video. Often a video starts up quite grainy before switching to HD fairly quickly. I think this may be down to YouTube’s perception of the network quality between you and itself. It may also be the case that if YouTube has not served a video for a while it may need prompting to serve it at HD resolution.

The videos, often, do not reflect real life processing times while things are being processed in Oracle Analytics. Some processing delays have been edited out of the videos to improve the flow of the demonstrations.

Please excuse some occasional background noise in the videos, children playing, dogs barking, bread/fish/fuel vans tooting to drum up trade, etc. John lives in lively cul-de-sac, in a busy residential town and Spain is not known as the quietest country. Double glazing and curtains only provide so much sound proofing.

Video player controls
Use the video player controls to adjust the speed of playback. This might depend on your browser. In Firefox, right-click on the video and select "Play Speed". For Chrome, you may need to install an extension. With tutorial content it can be worthwhile to play back at 1.25 or 1.5 speed. Get through more (and you may find this improves the presenters glacial cadence). You can also turn on the auto-generated subtitles.

Other important sources of information

Ex Libris maintain the Knowledge Centre (KC)[elkc] and Developer Network (DN)[eldn]. The KC contains all the documentation and other material, such as customer contributions. In particular, look for the Analytics Guide and the System Administration Guide.

The DN has the API (Application Programming Interface) documentation and a useful API Console.

User organizations

It’s a good idea that institutions belong to the local, regional and international user group organizations. They provide great forums for exchanges of experience and meeting like-minded colleagues. Most organize conferences which are well attended by both Ex Libris and institutions using their software.

The two largest are the International Group of Ex Libris Users IGeLU and Ex Libris Users of North America ELUNA. There is overlap with institutions belonging to a combination of local, national and international user groups. If your institution is not already a member, please do consider persuading them to join.

The IGeLU Analytics SIWG provides a forum for looking after the concerns of Ex Libris customers regarding Analytics. It is worth keeping up to date with their activities and looking out for events at the various conferences.

Participation and contributing

This resource is developed using an open source model. Given the large, wide-ranging, and complex nature of the field it is extremely unlikely that the author(s) have got everything right. So make critiques, suggest improvements to structure and material, better ways of doing things, examples, exercises, and techniques. Suggest new topics to be implemented. Contribute a chapter, a worked example, etc. It will all go to make a genuinely comprehensive, useful, and carefully curated resource.

More information is at the libtics.org participation page.


1. Definitely not the Apple DOW stock ticker name.