640 likes | 656 Views
Week 12 April 19. Embedding a Drill-Down Graph in a Form Executive Information Systems. A Few Easy Steps. In Graphics Builder Build the first graph Build the drill-down graph Create the ogr file In Form Builder Create the chart item that will receive the graph
E N D
Week 12April 19 Embedding a Drill-Down Graph in a Form Executive Information Systems
A Few Easy Steps • In Graphics Builder • Build the first graph • Build the drill-down graph • Create the ogr file • In Form Builder • Create the chart item that will receive the graph • Create the push button and add the PL/SQL code • Create a trigger for the chart item and add the PL/SQL code • Test the form
Data Model for Pie Chart Paste the SQL into the text box Click on “Execute”
Select Graph Type and Subtype Pie chart 3D pie chart
Group Small Slices Together Click on a pie slice, Right-mouse click, and Select Frame
Select Enter a value Click on OK
Start Building the Graph Click on the pie slice, Right-mouse click, and Select Properties
Select “Drill-down” tab Click on “New”
Enter the parameter (host variable) name and an initial value
Select a column name (or alias) from the list of items (to set the host variable to)
Enter SQL for the second graph Host variable
Select the Independent Variable (x-axis) Change to “Month” Set subcategory to “Record_label_code”
Test the Graph Default or initial value
Create the Chart Item Select “Build a new chart manually”
Object Navigator Note the block and item names (will be used in the PL/SQL)
PL/SQL to Launch the Graph og.open(display, item, clip-option, refresh-option) clip-option True (clip the chart to fit the dimensions of the chart item), False (match the dimensions of the chart item) refresh-option True (update graphics display), False (static bitmap display)
Test the Form and Graph Initial graph
Hint to Making Graph Fit Draw a white line to give a false right side of the graph
Information Systems • Transaction Processing Systems (TPS) • Support the completion and monitoring of an organization’s transactions • Generation of standard documents and reports • Objectives: • To process with a high degree of accuracy • To generate documents and reports in a timely manner • To increase and/or enhance services
Information Systems • Objectives (cont.) • To increase labor efficiency and productivity • To maintain data and information integrity • To increase revenues • To reduce costs • To support more efficient and effective operations