Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Esploro

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Esploro
    3. Product Documentation
    4. Esploro Online Help (English)
    5. Esploro Analytics
    6. Introduction to Analytics and Terminology
    7. Analytics Database Refresh

    Analytics Database Refresh

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    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.png

    • 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.
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Subject Area Terminology
      • Working with Esploro Analytics
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Documentation
      Language
      English
      Product
      Esploro
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved