PS Query & SQL

Good Morning Mital - There are several differences in Connected Query and Composite query, but the primary idea behind the two is the same. Both tools allow users to combine (in various ways) the results of multiple queries.  Both tools can be scheduled, with output going to a mounted drive, to an email address or to Report Manager. 

But, these tools differ in several important ways.  First, the UI is more user friendly in Composite Query.  It is easier and more intuitive, and once you become accustomed to how it works, it feels quite similar to Query Manager.  Second, Composite Query can create aggregate functions, expressions, and drilling queries  URLs.  This means you have the choice of creating some expressions in the initial queries, or in Composite Query as well as access to other functionalities.  Also, Composite Query can write to HTML, XML or Excel format, like Query Manager.  Finally, Connected Query produces XML output, and is used with BI Publisher. 

The Use Cases follow from these capabilities. 

• Connected Query is needed if you are creating a BI Publisher report. Or, it is often called upon if you need to create an XML file for an integration of some sort.  
• Composite Query is useful if you are creating a specific report and you need the results written into a spreadsheet format.  It is also easier to tweek and update, if you know a report will need to be changed over time. 

Take Care, and I am sure Dan will have other uses. 

Original Message:
Sent: 3/3/2025 6:25:00 AM
From: Tom Johnson
Subject: RE: Composite Query Field Reordering

Good Morning Mital - There are several differences in Connected Query and Composite query, but the primary idea behind the two is the same. Both tools allow users to combine (in various ways) the results of multiple queries.  Both tools can be scheduled, with output going to a mounted drive, to an email address or to Report Manager. 

But, these tools differ in several important ways.  First, the UI is more user friendly in Composite Query.  It is easier and more intuitive, and once you become accustomed to how it works, it feels quite similar to Query Manager.  Second, Composite Query can create aggregate functions, expressions, and drilling queries  URLs.  This means you have the choice of creating some expressions in the initial queries, or in Composite Query as well as access to other functionalities.  Also, Composite Query can write to HTML, XML or Excel format, like Query Manager.  Finally, Connected Query produces XML output, and is used with BI Publisher. 

The Use Cases follow from these capabilities. 

• Connected Query is needed if you are creating a BI Publisher report. Or, it is often called upon if you need to create an XML file for an integration of some sort.  
• Composite Query is useful if you are creating a specific report and you need the results written into a spreadsheet format.  It is also easier to tweek and update, if you know a report will need to be changed over time. 

Take Care, and I am sure Dan will have other uses. 

------------------------------
Tom Johnson
Sr Business Systems Analyst
Duke University
tom.johnson@duke.edu
"None of us is as smart as all of us"
------------------------------


Original Message:
Sent: 03-02-2025 11:46 AM
From: Mital Naik
Subject: Composite Query Field Reordering

Good Morning Mital - There are several differences in Connected Query and Composite query, but the primary idea behind the two is the same. Both tools allow users to combine (in various ways) the results of multiple queries.  Both tools can be scheduled, with output going to a mounted drive, to an email address or to Report Manager. 

But, these tools differ in several important ways.  First, the UI is more user friendly in Composite Query.  It is easier and more intuitive, and once you become accustomed to how it works, it feels quite similar to Query Manager.  Second, Composite Query can create aggregate functions, expressions, and drilling queries  URLs.  This means you have the choice of creating some expressions in the initial queries, or in Composite Query as well as access to other functionalities.  Also, Composite Query can write to HTML, XML or Excel format, like Query Manager.  Finally, Connected Query produces XML output, and is used with BI Publisher. 

The Use Cases follow from these capabilities. 

• Connected Query is needed if you are creating a BI Publisher report. Or, it is often called upon if you need to create an XML file for an integration of some sort.  
• Composite Query is useful if you are creating a specific report and you need the results written into a spreadsheet format.  It is also easier to tweek and update, if you know a report will need to be changed over time. 

Take Care, and I am sure Dan will have other uses.