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

  • Published on
    16-Jan-2016

  • View
    24

  • Download
    0

DESCRIPTION

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. - PowerPoint PPT Presentation

Transcript

  • Connected Query Overview

    The basics of Connected Query

    How to use Connected Query

    Connected Query - Step by Step

    Use with XML PublisherMichael Stutz (360)757-2251michael@mscc.us (888)757-2616www.MSCC.us

  • Michael StutzConnected Query OverviewIndependent PeopleSoft ConsultantStarted Technical, but now do both Functional & TechnicalPrimary Focus on HCM and Campus Solutions25+ years of IT industry experience18 years of PeopleSoft consulting experiencePeopleSoft v.2.11 v.9.1Lost Track of the number of PeopleSoft Projects Ive been onHere to network . . . . . . and to share.Michael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company

  • AgendaThe Basics of Connected QueryHow to use Connected QueryConnected Query Step-by-stepUse with XML PublisherMichael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company Connected Query Overview

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

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

  • The Basics of Connected QueryMichael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company Parent QueryA 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 QueryA 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.Connected Query Overview

  • The Basics of Connected QueryMichael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company Sibling QueryA sibling query in a connected query is a child query that shares a parent with another child query

    Mapping Query FieldsMapping query fields establishes the filtering relationship between values of selected fields in a child query and the corresponding fields in the parent query.Connected Query Overview

  • The Basics of Connected QueryMichael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company EXAMPLE Parent QueryPerson NameEXAMPLE Child QueryPersons Phone NumbersEXAMPLE Sibling (also a child) QueryPersons eMail AddressesConnected Query Overview

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

  • The Basics of Connected QueryMichael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company When to use a Connected QueryAs a Data Source for XML PublisherAs a Data Source for other XMLWhen your adhoc reports need Hierarchy(and you dont want to bother IT for it)

    Connected Query Overview

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

  • How to use Connected QueryMichael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company Connected Query Quick StartConnected Query ManagerConnected Query ViewerSchedule Connected QueryConnected Query Overview

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

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

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

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

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

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

  • How to use Connected QueryMichael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company Connected Query ManagerInsert 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.Connected Query Overview

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

  • Connected Query Step-by-stepMichael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company Select Reporting Tools, Connected Query, Connected Query ManagerSelect 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.Connected Query Overview

  • Connected Query Step-by-stepMichael Stutz - (360)757-2251 - michael@mscc.us - Michael Stutz Consulting Company 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.Connected Query Overview

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • 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-2251michael@mscc.us (888)757-2616www.MSCC.us

    Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.Copyright 2007, SAS Institute Inc. All rights reserved.*Copyright 2007, SAS Institute Inc. All rights reserved.

Recommended

View more >