Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Alma

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Alma
    3. Knowledge Articles
    4. Analytics Union Report - How To report on portfolios with or without POLines

    Analytics Union Report - How To report on portfolios with or without POLines

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    4. Attachment
    • Article Type: Q&A
    • Product: Alma
    • Relevant for Installation Type: Total Care; Dedicated-Direct; Direct; Local

    Question

    Creating a report on portfolios in Analytics gives expected results. However, when adding the column of PO line reference number (in fact, any columns from PO lines) for information to see if any portfolios are paid, then this informational column immediately acts as a filter column - It only returns 5 portfolios with PO lines. those that do not have PO lines are excluded.

    What should be done to just add the PO line reference as an INFORMATION column, but not a filter column?

    Answer

    The way to get all portfolios is by creating a UNION between two reports.

    1. One report contains portfolios with "PO Line Reference" information, and the other report doesn't have it.
    2. The UNION creates one big de-duplicated list.
    3. The number of columns should be identical in each report.
    4. The report without POLine information needs to have a "dummy" column (please see more in the attached Word Document or the SQL below)
    5. The filters should be identical

    Here is a picture of the results: http://screencast.com/t/t7dFrgjbd

    Additional Information

    Attached is a Word document, kindly shared by Pauline Smith of the the Eastern Washington University Libraries.

    Alternatively, it is possible to use SQL. 

    Please feel free to add your comments or suggestions and we will incorporate them.

    Please also note that UNION reports exist in the shared Analytics folders (find them by using this keyword, "union").

    Attachment

    Attached file

    Category: Analytics

    Subject: Reports


    View article in the Exlibris Knowledge Center
    1. Back to top
      • Analytics Subjects field under Bibliographic Details cut off at 255 characters
      • Analytics Users report combining two different fields under the “Select only one of the below” section - how to?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Documentation
      Language
      English
      Product
      Alma
    2. Tags
      1. Analytics
      2. contype:kba
      3. Dedicated-Direct
      4. Direct
      5. Local
      6. Reports
      7. Resource Management - Alma
    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