Building Drill-Down Graph in Form Executive Information System

1. Week 12April 19 Embedding a Drill-Down Graph in a Form Executive Information Systems

2. 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

3. Build the First Graph

4. Table Descriptions

5. SQL for Pie Chart

6. Data Model for Pie Chart Paste the SQL into the text box Click on “Execute”

7. Data Set for the Graph

8. Select Graph Type and Subtype Pie chart 3D pie chart

9. Select the Independent Variable

10. Select the Dependent Variable

11. Initial Graph

12. Group Small Slices Together Click on a pie slice, Right-mouse click, and Select Frame

13. Select Enter a value Click on OK

14. New Graph

15. Build the Drill-Down Graph

16. Query for the Line Graph

17. Start Building the Graph Click on the pie slice, Right-mouse click, and Select Properties

18. Select “Drill-down” tab Click on “New”

19. Enter the parameter (host variable) name and an initial value

20. Select a column name (or alias) from the list of items (to set the host variable to)

22. Enter SQL for the second graph Host variable

23. Data Set for the Line Graph

25. Add the Drill-Down Graph

26. Select the Graph Type and Subtype

27. Select the Independent Variable (x-axis) Change to “Month” Set subcategory to “Record_label_code”

28. New Settings

29. Select the Dependent Variable

30. Initial Graph

31. Test the Graph Default or initial value

32. Line Graph for Atlantic

33. Line Graph for GRP Records

34. Generate the OGR File

35. In Form Builder

36. Attach og.pll to the library

37. Create the Chart Item Select “Build a new chart manually”

38. New Chart Item

39. Object Navigator Note the block and item names (will be used in the PL/SQL)

40. Create the Trigger for the Push Button

41. 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)

42. Create the Trigger for the Next Drill-Down

43. PL/SQL to Launch the Next Drill-Down

44. Test the Form and Graph Initial graph

45. After Adjusting the Form and Graph

46. Drill-Down

47. Hint to Making Graph Fit Draw a white line to give a false right side of the graph

48. Executive Information Systems

49. 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

50. 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