1 / 39

Connected Query Overview The basics of Connected Query How to use Connected Query

Connected Query Overview The basics of Connected Query How to use Connected Query Connected Query - Step by Step Use with XML Publisher. Michael Stutz (360)757-2251 michael@mscc.us (888)757-2616 www.MSCC.us. Michael Stutz. Connected Query Overview.

grant
Download Presentation

Connected Query Overview The basics of Connected Query How to use Connected Query

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Connected Query Overview • The basics of Connected Query • How to use Connected Query • Connected Query - Step by Step • Use with XML Publisher Michael Stutz (360)757-2251 michael@mscc.us (888)757-2616 www.MSCC.us

  2. Michael Stutz Connected Query Overview • Independent PeopleSoft Consultant • Started Technical, but now do both Functional & Technical • Primary Focus on HCM and Campus Solutions • 25+ years of IT industry experience • 18 years of PeopleSoft consulting experience • PeopleSoft v.2.11 – v.9.1 • Lost Track of the number of PeopleSoft Projects I’ve been on • Here to network . . . • . . . and to share. Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  3. Agenda The Basics of Connected Query How to use Connected Query Connected Query – Step-by-step Use with XML Publisher Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  4. The Basics of Connected Query Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  5. The Basics of Connected Query Connected Query Overview • Query on Steroids Hierarchy • Adds the element of Hierarchy to Query • Ability to use as an XML Source • Allows complex data input for XML Publisher with a GUI type creation mechanism • Why the new tool? • Query alone didn’t quite cut it, especially for Hierarchical Reporting • Part of “migration” from Crystal Reports to XML Publisher Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  6. The Basics of Connected Query Connected Query Overview • Parent Query • A parent query in a connected query is a query that has one or many child queries. The top level query in a connected query is the parent query. • Child Query • A child query in a connected query is a query that has a single parent query. A child query can also serve as a parent query if it has one or more child queries in the Connected Query definition. A child query can have one or more sibling queries. Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  7. The Basics of Connected Query Connected Query Overview • Sibling Query • A sibling query in a connected query is a child query that shares a parent with another child query • Mapping Query Fields • Mapping query fields establishes the filtering relationship between values of selected fields in a child query and the corresponding fields in the parent query. Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  8. The Basics of Connected Query Connected Query Overview • EXAMPLE – Parent Query • Person Name • EXAMPLE – Child Query • Person’s Phone Numbers • EXAMPLE – Sibling (also a child) Query • Person’s eMail Addresses Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  9. The Basics of Connected Query Connected Query Overview • Keys and Foreign Key • Pieces of data (fields) that define the relationship between Parent information and Child information • EXAMPLE: Employee ID Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  10. The Basics of Connected Query Connected Query Overview • When to use a Connected Query • As a Data Source for XML Publisher • As a Data Source for other XML • When your adhoc reports need Hierarchy • (and you don’t want to bother IT for it) Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  11. How to use Connected Query Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  12. How to use Connected Query Connected Query Overview • Connected Query Quick Start • Connected Query Manager • Connected Query Viewer • Schedule Connected Query Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  13. How to use Connected Query Connected Query Overview • Connected Query Quick Start Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  14. How to use Connected Query Connected Query Overview • Connected Query Quick Start Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  15. How to use Connected Query Connected Query Overview • Connected Query Quick Start Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  16. How to use Connected Query • Connected Query Quick Start Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  17. How to use Connected Query • Connected Query Quick Start Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  18. How to use Connected Query Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  19. How to use Connected Query Connected Query Overview • Connected Query Manager Insert a new query as a child of the selected query. Insert a new query as a sibling of the selected query. Delete a selected query. Open a related field selection section. Open a selected query in Query Manager in read-only mode. Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  20. Connected Query – Step-by-step Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  21. Connected Query – Step-by-step Connected Query Overview Select Reporting Tools, Connected Query, Connected Query Manager Select the Add a New Value tab. Enter a name in the Connected Query field. Define query ownership using the Public check box. Select the status of the connected query using the Status drop-down list box. Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  22. Connected Query – Step-by-step Connected Query Overview Optionally, enter description and comments for the connected query using the Description and Comments fields. Select a parent query using the Parent Query field. Optionally, click the View Query button to view the selected query. Optionally, continue building your connected query by adding child queries, linking fields between parent and child queries, and so on. Save your connected query. Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  23. Use with XML Publisher Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  24. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  25. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  26. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  27. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  28. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  29. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  30. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  31. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  32. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  33. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  34. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  35. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  36. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  37. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  38. Connected Query Overview Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  39. Connected Query Overview • THE END • The basics of Connected Query • How to use Connected Query • Connected Query - Step by Step • Use with XML Publisher Michael Stutz (360)757-2251 michael@mscc.us (888)757-2616 www.MSCC.us

More Related