1 / 55

DATA WAREHOUSE QueryLink TUTORIAL

This tutorial provides an overview of QueryLink, a tool used to retrieve campus data for departmental use. Learn how to navigate the point-and-click environment, customize the query, and utilize its functions. Prepared by ACT's Data Warehouse team.

hbeard
Download Presentation

DATA WAREHOUSE QueryLink TUTORIAL

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. DATA WAREHOUSE QueryLink TUTORIAL QueryLink is used to retrieve Campus data for Departmental use. This tutorial presents an overview of the point and click environment of QueryLink. The purpose of the tutorial is to acquaint you with QueryLink, its use and its functions. Prepared by ACT’s Data Warehouse team 03/20/2003

  2. TABLE OF CONTENTS • Where to Start? • Navigating Within the Query Model • Customizing the Query • Using Tabs • Selecting Field Names • Using Drop Down Menus • Entering Values to Qualify Data • Query Options • Row Count • Saving your Query • And More…. • Submitting your Query

  3. WHERE TO START ? This section of the Tutorial presents steps you can follow to access the Data Warehouse QueryLink.

  4. This is DataLink’s Web page. You can access DataLink from UCSD’s Blink website. Click on the Technology tab. Go to the LinkFamily.

  5. To activate QueryLink,click on the Queriesbutton.

  6. All models available to the Campus will be accessible from DataLink. Models can be related to any UCSD business data such as Financial, Student, Employee. New models are developed depending on campus needs and requests for data.

  7. Queries buttons are also located on other ‘Link Family’ web applications where you can access ‘subject related’ Query Models.

  8. In this case, you can access query models to retrieve Employee data.

  9. To display ‘help information’ for a specific Query Model, click on its associated i button.

  10. This is the ‘help information’ for the Index Query. The Product Features section explains the ‘general functionality’ applicable to all Query Models.

  11. Click on a Model to select it. We are selecting the Index Query Model.

  12. The login screen will appear next. Enter your User Id and Password.

  13. This is the Index Query Model. Once your login is successful, the Query Model displayed will be the query you selected.

  14. NAVIGATING WITHIN THE QUERY MODEL CUSTOMIZING THE QUERY This section explains how to Navigate within a Query Model and how to customize your Query.

  15. A Query Model is made up of ‘parts’ such as screens, tabs, field names,drop down menus, text entry boxes, selection check boxes and buttons.

  16. USING TABS

  17. All Query Models have at least one screen. Each screen has an associated Tab.

  18. Dates is the Tab for this screen. The data elements on this screen are related to Dates data.

  19. Click on a tab to move to the next screen.

  20. Index is the Tab for this screen. These data elements are related to INDEX data.

  21. SELECTING DATA ELEMENTS

  22. Any data element that is selected with a check mark in the selection box will be returned in the results set of the query.

  23. Sometimes a screen will appear with a pre-selected data element. Data will automatically be displayed in the results set for this data element.

  24. If you submit your query and have not entered or selected a value for a required field, a message will display and the Query will not execute.

  25. Clicking on a data element will display the definition of that data element.

  26. This page is displaying the definition of Index. You can access ‘DataLink’ for additional information.

  27. USING DROP DOWN MENUS This section describes the different Drop Down Menus and how to use them.

  28. A Drop Down Menu is indicated by a downward pointing arrow. In this case you can select a ‘value’ from the drop down list and use it to customize your query.

  29. In this case, you can select a qualifyingparameter that you can use to customize your query.

  30. In some cases, you can choose one or more selections from a list.

  31. ENTERING VALUES TO QUALIFY DATA This section describes ways to customize your query by entering ‘values’ for data elements.

  32. If a data element’s text entry box displays as empty,without any downward pointing arrows or scroll bars, you can enter a value for that data element. This is a value for the ‘Organization’ field.

  33. Selecting the in list parameter allows you to enter more than one ‘value’ for the field.

  34. Use the List Wizard to enter the values you desire. Click OK.

  35. The parameter displays as ‘in list’ and the values display in the text entry box.

  36. You may want to use the advanced parameter option.

  37. With the Advanced Wizard you can enter combinations of qualifying parameters with specific values. Click OK to activate.

  38. The parameter displays as ‘advanced’ and the values’ display in the text box.

  39. QUERY OPTIONS This section describes additional Query Options that are available for you to select.

  40. Query Options that supply a variety of additional functionality are available from this drop down list.

  41. The View Query Wizard allows you to review what fields were selected to be returned and what fields were used to qualify your query.

  42. With the Save Wizard you have the ability to name and save your query for future use. Check this box if you would like your query to be available to other campus clients.

  43. The Saved Query Manager allows you to load, rename or delete queries you have saved.

  44. The Order Column Wizard allows you to customize the order the data will be displayed in the results set.

  45. To customize the Order of the data in the results set, use the add button to move the field names to the box on the right. Place them in the order you desire.

  46. The Sort Order Wizard allows you to sort the fields that are displayed in the results set. Use the add button to move the field names you would like for the sort to the box on the right.

  47. The Subtotal Wizard allows you to subtotal the returned data. Use the add button to move the field names you wish to subtotal to the box on the right.

  48. This data is totaled on the primary field in this case Sub-Account followed by fund and index.

  49. Selecting the Turn SQL Displayer On (Off) provides you the option of viewing the actual SQL that the Query Model constructs to execute your Query. The default value for this option is ‘OFF’

  50. The default value for ‘Results Rows’ is 2000. Currently there is a maximum row count of 50,000. The Results Row Count Wizard allows you to regulate the amount of rows returned from your query.

More Related