Here are the top 5 uses for the connected query
1. Simplify the writing of reports for business users. A business user can create a set of linked simple queries to collect data from multiple tables instead of creating a complicated query with multiple equal, outer joins, and grouping conditions.
2. For duplicating the left outer join functionality. Connected Query enables you to collect data similar to query performing left outer joins. In contrast to query, Connected Query enables you to link multiple queries to a single parent query.
3. Replace Crystal Reports that contains Sub Queries with an XML Publisher report. Crystal reports can include the main reports and a set of subreports that could be combined in the same template. Using Connected Query, you can replace a Crystal reports having main reports and sub-reports with XML Publisher reports.
4. When the output of your Queries needs to be in a hierarchical and structured XML file.
A simple query (including a query with multiple joins) creates a tabular plain layout. To have a hierarchical output, you need to use multiple grouping conditions that involve complicated logic and is not always straight forward. Connected Query processing creates a hierarchical output where a single row of data from parent query results in a set of rows in a child query. This data is processed row by row and produces structured data. It has similarity with SQR and Application Engine nested loops processing.
5. As an alternate Data Source for XML Publisher. Instead of using Application Engine or SQR to collect data for file processing by XML Publisher, you can create a Connected Query to use as the data source because no conditional logic is involved in this process.
Connected Query comes with a Quick Start wizard like page that walks you through the process quickly and easily along with a Connected Query Manager, Viewer, and Scheduler.
In order to use a Connected Query you will need to get access to the pages through the Permission List PTPT2700.
No comments:
Post a Comment