Transcript Week 13 April 26 • Pseudo Drill-Down Graphs R. Ching, Ph.D. • MIS Area • California State University, Sacramento.

1
Week 13
April 26
• Pseudo Drill-Down Graphs
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Problem with Multiple Years
• The drill-down graph requires two parameters
– Host variable for the specific slice in the pie
– Lexical reference variable to the column
• Only one parameter can be sent to the drill-down graph
with OG.MOUSEDOWN
– Symptom: When a slice is clicked, the drill-down graph
reverts to its default values
• Solution: Two separate graphs controlled by list boxes
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
2
3
The Work-Around
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
What the Form Will Look Like
Specifies the year
Two chart areas
Specifies the record label for the year
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
4
5
Change the year
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Create Two Chart Items
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
6
7
In Graphics Builder…
First Graph
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Create the First Graph
Data model
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
8
Refined Graph
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
9
Create Lexical Reference Variable
 Click on create (“+”)
 Create the lexical reference variable
 Select “Parameters”
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
10
Lexical Reference Variable
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
11
12
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
13
Replace column name with
lexical reference variable
Execute the query
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Test the Graph
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
14
Create OGR File
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
15
16
In Graphics Builder…
The Second Graph
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Create Lexical Reference Variable
Host variable
(will be used
to specify a
particular
record label)
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
17
18
Lexical
reference
variable (will
be used to
specify the
sales revenue
year column)
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Initial Data Model
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
19
Select Graph Type
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
20
Change Independent Variable
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
21
Change Independent Variable
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
22
Initial Graph
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
23
24
In Form Builder…
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Program the Trigger for the First Graph
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
25
PL/SQL Code
Commented out
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
26
Test the Graph
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
27
Program the Trigger for the Second Graph
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
28
PL/SQL Code
2 parameters
Use for debugging
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
29
30
Use for debugging
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Test the Form
31
Default line graph
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
32
R. Ching, Ph.D. • MIS Area • California State University, Sacramento