Cognos Analytics with Watson

 View Only
  • 1.  Reporting from Multiple Packages

    Posted 12 days ago
      |   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
    ------------------------------


  • 2.  RE: Reporting from Multiple Packages

    Posted 12 days ago
    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
    ------------------------------



  • 3.  RE: Reporting from Multiple Packages

    Posted 11 days ago
    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
    ------------------------------



  • 4.  RE: Reporting from Multiple Packages

    Posted 10 days ago
    @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
    ------------------------------