Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Reporting from Multiple Packages

    Posted Wed September 21, 2022 01:59 AM
      |   view attached

    I have a question when reporting from multiple packages (CA 11.2.2). I tried to create a JOIN from queries from different packages and it wasn't allowed. Not sure if this is due to security, a bug, or if it's intended to prevent joining data from different packages.

    Thanks,




    ------------------------------
    Mauro Santos Otero
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Reporting from Multiple Packages

    Posted Wed September 21, 2022 03:24 AM
    Hi Mauro,

    This is from the documentation:
    "Query set operations (join, union, intercept, except) are supported only for the default package or data module."

    Here is the URL:
    Add data to a report by loading packages or data modules in IBM Cognos Analytics - Reporting.

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------

    Original Message


  • 3.  RE: Reporting from Multiple Packages

    Posted Thu September 22, 2022 10:02 AM
    HI Mauro

    You can add all the required packages to a data module (no relationships needed) and use the data module for your report. You will then be able to create each query from different package and join / union them in report. 

    Hope that helps. 

    Regards

    ------------------------------
    Kiran Passumarthi
    www.linkedin.com/in/kiranpassumarthi
    ------------------------------

    Original Message


  • 4.  RE: Reporting from Multiple Packages

    Posted Thu September 22, 2022 08:41 PM
    @Patrick Neveu many thanks for pointing me to the correct information. It's useful to know exactly how it works.

    @Kiran Passumarthi thanks for the workaround !!

    ------------------------------
    Mauro Santos Otero
    ------------------------------

    Original Message