Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Introduction to Analytics and Terminology

    Ex Libris Analytics enables you to run reports on library activities. You can use out-of-the-box reports that are provided by Ex Libris or you can create your own reports. Groups of reports can be displayed in dashboards that you customize. You can share reports and dashboards that you create with other users in your institution or in other institutions. These reports help you understand the activities that your library performs, which allows you to make informed decisions on how to run the library.
    Analytics is built on Oracle Analytics Server (OAS). Every day, a full database refresh (also known as an ETL) takes place in Esploro Analytics. This process may take several hours to be completed. The time it takes to complete it depends on various factors, such as the changes made to the data.
    Typically, the ETL starts in the evening and the data is available by the beginning of the following work day. This is the case for all data except for a few subject areas such as Titles and Benchmark.The staff user can see when the data was extracted from Esploro and when it was loaded to Esploro Analytics from the Analytics menu in Esploro. For example:


    • Data available as of is the time that the load of the data to Esploro Analytics was completed.
    • Data updated as of is the time the data was extracted from Esploro.

    In the example above, the data was extracted on Dec. 21, 2019 at 10:00 PM and the load of this data to Esploro Analytics was completed on Dec. 22, 2019 at 06:28 AM.

    • The format of the time here (and in other places in Esploro) is configured by the system_time_format parameter at Configuration Menu > General > General Settings > Other Settings. For more information, see Configuring Other Settings.
    • You can create analytics reports with the Data available as of and Data updated as of fields, which are located under the Institution folder of the various subject areas.
    The following table displays the start times of the ETL and the time at which a message will be posted on the Status Page. If the process is not completed by a certain time, a message is posted on the Status Page. To view the Data Refresh Delay Reports page, click here.
    Instance Start Time Status Page Message if the Process Has Not Been Completed
    APXX 12:00  UTC 21:00 UTC
    CNXX 12:00  UTC 21:00 UTC
    EUXX 20:00 UTC 07:00 UTC
    NAXX 00:00 UTC 13:00 UTC
    CAXX 00:00 UTC 13:00 UTC
    After a monthly release or a service pack update, an additional ETL might be run.
    This help describes unique aspects of this tool for Ex Libris customers and basic analytics activities. For a thorough description of all the activities available in Analytics, select Help to view the online help and Oracle documentation or refer to the Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1) at
    This guide describes how to perform basic activities such as building, formatting, and customizing reports and how to provide reports to others, both internally and externally, by creating and updating dashboards.
    • Was this article helpful?