DATA WAREHOUSE

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 ACTs 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 DataLinks Web page.
You can access DataLink from UCSDs Blink
website. Click on the Technology tab. Go to the
LinkFamily.
5
To activate QueryLink,click on the Queries
button.
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 qualifying
parameter 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 elements 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.
51
SUBMITTING YOUR QUERY
This section shows how to submit a Query and
presents some additional options that you may
find useful.
52
You can Submit your query, Close your Query
Model, or display the Help screen by using these
buttons.
53
Click the happy or sad face to contact the
Data Warehouse team.
54
This is a sample of the happy face Did You Get
What You Wanted e-mail form.
55
You have completed the Basic QueryLink
Tutorial. If you would like to learn more on
the options available from QueryLink go the
Advanced Querylink Tutorial. If you have any
questions, please contact the ACT Help Desk _at_
x41853 or x43187
CONGRATULATIONS