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

    Working with Overlap and Collection Analysis

    Translatable
    To work with overlap analysis, you must have one of the following roles:
    • Purchasing Operator
    • Purchasing Manager
    • Repository Manager
    • Electronic Inventory Operator
    With Overlap and Collection Analysis, Alma generates reports that can provide you with the following kinds of information about your electronic collections, using an Alma set of records or an Excel spreadsheet with a list of identifiers for the analysis:
    • Set Comparison Analysis Reports (Alma set of records)
      • Matching titles with identical coverage dates in the Institution Zone
      • Matching titles with partially overlapping coverage dates in the Institution Zone
      • Matching titles with mutually exclusive coverage dates in the Institution Zone
      • Titles in the Institution Zone that are unique to the source set you created for the comparison
      • Comparison of titles from a single electronic collection in the Institution Zone with the titles of one or more electronic collections in the Institution Zone or in the Community Zone
        This comparison matches Alma records at the title level using identifiers like ISSN or ISBN and compares the coverage information at the portfolio level. See Performing Overlap Analysis for a Set for more information.
    • Selected Titles Analysis Reports (Excel spreadsheet containing a list of identifiers)
      • Matching titles that exist more than once in the Institution Zone
      • Matching titles that exist only once in the Institution Zone
      • Titles that do not have any matches, not in the Alma database in the Institution Zone
      • Matching titles that exist in the Community Zone
      • Titles that do not exist in the Community Zone
      With the Selected Titles analysis you can determine:
      • What electronic resources you have in the Institution Zone compared with the list of resources that you identify in an Excel spreadsheet
      • What electronic resources are available in the Community Zone compared with the list of resources you identify in an Excel spreadsheet
      • What electronic resources do not exist in either the Institution Zone or the Community Zone compared with the list of resources you identify in an Excel spreadsheet

    When you perform an overlap analysis using either of these two methods, the analysis searches for matching electronic collections that have a service type of FullText or SelectedFullText.

    For more information, see the Overlap Analysis Expanded to Include Community Zone Analysis video (1:35 min.).
    For more information about Overlap Analysis, refer to the Electronic Collection Overlap Analysis video (7:46 mins).
    For information about performing Overlap Analysis on selected titles using an import file, see the Electronic Collection Overlap Analysis Using Import File video (6:41 mins).

    Performing Overlap Analysis for a Set

    Select to compare two Alma electronic collections and use the procedure below to find titles with overlapping coverage dates in these collections.
    The comparison generates the reports described in Set Comparison Analysis Reports. In the Excel files generated as the result of the comparison (you can access these files from the job report), the column headings identify the source and target resources being compared. See Overlap and Collection Analysis Job Reports for more information.
    To perform overlap analysis for a set:
    1. Open the Overlap and Collection Analysis page (Resources > Advanced Tools > Overlap and Collection Analysis).
    2. Select Submit New Report. Alma defaults to the Set Comparison type of report.
    3. Select Next. The Compare Electronic Collections page appears.
    4. Select Source Electronic Collection and find the source electronic collection in the Institution Zone:
      1. Complete a repository search.
      2. From the search results list, select an electronic collection and select Add Selected.
      3. Select Done. Alma displays your source selection on the Compare Electronic Collections page and identifies the scope of your selection.
    5. Select Institution Zone or Community Zone to identify the type of comparison/analysis you want in your report.
      Target_Electronic_Collections_Zone_Selection_04_TC.png
      Target Electronic Collections Zone Selection
      If you select several target electronic collections, they all must be from the same zone - either the Institution Zone or the Community Zone.
    6. Select Target Electronic Collections and find the target electronic collection(s) in the Institution Zone or in the Community Zone:.
      1. Complete a repository search.
      2. From the search results list, select an electronic collection and select Add Selected.
        Repeat this step for each target electronic collection you want to use in your analysis.
      3. Select Done. Alma displays your target selections on the Compare Electronic Collections page and identifies the scope of your selections.
        Compare_Electronic_Collections_Selections_04_TC.png
        Compare Electronic Collections Selections
    7. Select Next.
    8. Enter the following to match your requirements:
      • Report name
      • Report description
      • Match method (ISSN, ISBN, Title, LCCN, or 035)
      • Use date coverage information in the comparison.
        Select the checkbox to use this information. When you select it, the Reference year for calculating the embargo parameter becomes an active parameter.
      • Reference year for calculating the embargo.
        Select one of the options such as Current Year, Current +1, Current +2, and so forth from the drop-down list.
    9. When finished setting the parameters, select Submit. Alma displays a message confirming that your job has been successfully submitted.
    10. Use the Monitor Jobs page (see Viewing Running Jobs) to track the progress of your Overlap Analysis report.
    11. View information about the job report on the Job Report page. For more information, see Overlap and Collection Analysis Job Reports.

    Performing Overlap and Collection Analysis for Selected Titles

    Use the procedure below to compare titles in the Institution or the Community Zone to a list of titles included in an Excel input file. With the Selected Titles type of analysis, you are able to evaluate the resources in both your Institution Zone and the Community Zone.
    To complete an overlap and collection analysis for selected titles:
    1. Select Submit New Report on the Overlap and Collection Analysis page (Resources > Advanced Tools > Overlap and Collection Analysis).
    2. From the Choose Report Type section, select the Selected Titles option and select Next.
    3. Complete the parameters for step 2 of the wizard as per the below:
      Overlap and Collection Analysis - Wizard Step 2
      Parameter Description
      Select File Browse to locate the Excel file containing the unique identifiers for the titles you want to compare against the Institution Zone or the Community Zone.
      The column heading in the Excel file must be one of the below to identify the method for comparing the records:
      • ISBN
      • ISSN
      • LCCN
      • TITLE
      The Excel file must be a single-column file:
      The Excel file cannot be larger than 10 MB.
      Detect overlap based on the following population Select one of the following options:
      • Do not include titles from the Community
        Alma compares the Excel file with the electronic resources in the Institution Zone.
        This option generates the following reports:
        • Selected Titles – Title Overlap Report
        • Selected Titles – Unique Titles Report
        • Selected Titles – Not in DB Report
        See Viewing the Overlap Analysis Job Report for more information.
      • Include titles from the Community that are not in the Institution
        The comparison is done in two stages: (1) Alma compares the titles in the Excel file with the electronic resources in the Institution Zone (both local and activated). (2) If the Excel file includes also titles that do not exist in the IZ, then Alma compares the Excel titles that do not exist in the IZ with the non-activated resources in the Community Zone.
        This option generates the following reports:
        • Selected Titles – Title Overlap Report
        • Selected Titles – Unique Titles Report
        • Selected Titles – Not in DB Report
        • Selected Titles – Not in CZ report.
          The Excel titles that were not found neither in IZ (first stage) nor in CZ (second stage)
        • Selected Titles – In CZ report 
          The not-activated Excel titles that were not found in IZ (first stage) but were found in CZ (second stage). 
        See Viewing the Overlap Analysis Job Report for more information.
      • Include all titles from the Community
        The comparison is done twice: (1) Alma compares the titles in the Excel file with the electronic resources in the Institution Zone, including the activated resources. (2) Then Alma compares the Excel titles with the Community Zone resources (including the activated). 

        This option generates the following reports:
        • Selected Titles – Title Overlap Report
        • Selected Titles – Unique Titles Report
        • Selected Titles – Not in DB Report
        • Selected Titles – Not in CZ report
          The Excel titles that were not found neither in IZ nor in CZ
        • Selected Titles – In CZ report
          The activated and not-activated Excel titles that were found in CZ. 
        See Viewing the Overlap Analysis Job Report for more information.

      Do not include titles from the Community option.png

      Do not include titles from the Community option - the title set in blue (both shades) is compared to the titles in the Excel file
       
       
       
       
      Include all titles from the Community option.png
      Include titles from the Community that are not in the Institution option - (1) the title set in blue (full and partial blue) is compared to the titles in the Excel file, and then (2) the title set in green is compared to the titles in the Excel file. 
       
       
       
       
       
       
       
       
       
       
       
      Include_titles_from_the_Community_that_are_not_in_the_Institution_option.png
      Include all titles from the Community option -  
      (1) the title set in blue (full and partial blue) is compared to the titles in the Excel file, and then (2) the title set in green (full and partial green) is compared to the titles in the Excel file.
    4. Select Next.
    5. Complete the following information on the Compare Electronic Collections page:
      • Report name – Enter a unique name or use the default that is supplied.
      • Report description – Enter a description to further identify the report generated by Alma.
    6. Select Submit. Alma displays a message confirming that your job was successfully submitted and displays your report job in the Report History section of the Overlap and Collection Analysis page.
    7. On the Overlap and Collection Analysis page, select View to see the job results or use Monitor Jobs (Admin > Manage Jobs and Sets > Monitor Jobs) to view the job results. For more information, see Viewing the Overlap Analysis Job Report.
    After the Overlap and Collection Analysis job completes, an Overlap and Collection Analysis Letter is sent to the staff user to indicate that the job has completed. For information on configuring the letter, see Configuring Alma Letters.

    Comparing All Your Activated Electronic Resource Holdings Against a Non-Active Database

    For cases where you want to compare all of your activated electronic resource holdings against a non-active database, first obtain a list of the ISSNs/ISBNs of the new electronic collection (that you do not have activated), and then select Submit New Report.
    On the first page of the Overlap and Collection Analysis wizard, select the Selected Titles option; and select Next.
    Selected_Titles_02.png
    Selected Titles Option
    Select the file of ISSNs/ISBNs that you obtained earlier, and choose the Do not include titles from the Community option.
    Select_ISSN_ISBN_File_02.png
    Select ISSN/ISBN File
    Complete the remainder of the wizard and select Submit.
    Alma compares the ISSNs/ISBNs of your Excel file against the entire electronic inventory of your institution.