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

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
------------------------------

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
------------------------------

@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:
Sent: Thu September 22, 2022 10:01 AM
From: Kiran Passumarthi
Subject: Reporting from Multiple Packages

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
------------------------------