Automating Alma Analytics for Librarians with VBA Macros for Excel and Power BI This VBA macro streamlines the process of downloading and parsing XML reports from Alma Analytics via its REST API. It dynamically extracts column headers and row data, then populates them into an Excel worksheet—perfect for librarians looking to automate data retrieval and simplify…

Audience: You work with electronic resources in Alma. You should have some experience running Analytics reports and be familiar with using the results of one report in another report.ScenarioYour library has a DDA (Demand Driven Acquisitions) program with Provider A but also purchases perpetual titles through Provider B. The perpetual titles are in multiple electronic…

Conditional formatting of text is very useful for highlighting certain bits of data. However, it is lacking the contains any operator. This is not very useful when you would like to highlight fields with a lot of variance. (For example, if you would like to highlight all Proquest e-collections) There is a workaround if you…

Author: Hisham Makki, Assistant Director for Data Quality.Required knowledge: Advanced Alma Analytics; HTML; URL; SQLContents:GO (URL Command)SQL ParameterFormat ParameterOptions ParameterStyle ParameterExample ReportGenerate ReportAdd Action LinkRun and TestWrap Up and SummaryDid you know that you can run a report on-the-fly, and without the need to save it in your Analytics folder? Let me show you how.In this blog,…

In this blog post we will, as the title suggests, create one data visualization workbook with multiple canvases.This is advantageous because when there is a lot of data to display it can be displayed to the consumer in one workbook rather than making the consumer view multiple different workbooks. By using multiple canvases the consumer…

Note that if you do copy/paste here make sure the quotation marks transfer correctly. Question How can I display the numerical page numbers from the field "Bibliographic Details"."Local Param 03" which appear before the string "pages" or "leaves" or "unnumbered pages" or "unnumbered leaves"? If the string "pages" or "leaves" does not appear then I…

Note that if you do copy/paste here make sure the quotation marks transfer correctly. Introduction This blog post explains how to display the MMSID in an Alma Analytics report without including the first two and last four digits. Thus instead of, for example, this: 9944494600121 We would have this: 4449460 The regular expression syntax can…

IntroductionIn the "Funds Expenditure" subject area, in the "Fiscal Period" folder, there is a pre-made filter to use on the Fiscal Period.However, it is limited in that it includes "Current Fiscal Year", "Previous Fiscal Year" and "Two Fiscal Years Ago".         There may be cases where the institution wants to make a report, for example,…

 Note that if you do copy/paste here make sure the quotation marks transfer correctly. See also related blog: Alma Analytics Regular Expression examples to filter by values which do or do not have certain strings Often when displaying the "852 MARC" field from "Holding Details" folder it is not desired to display the field in…

This blog post is relevant for member institutions of a network zone consortia.In the example below we will show the following situation:In the Network Zone institution electronic collection "Taylor & Francis Journals Complete" with multiple portfolios is "Available for" Member Institution "Alma University".  The "Available for" functionality (which uses Inventory Network Groups)  is being used…