1 / 64

Week 12 April 19

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

pparsons
Download Presentation

Week 12 April 19

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

  21. Enter SQL for the second graph Host variable

  22. Data Set for the Line Graph

  23. Add the Drill-Down Graph

  24. Select the Graph Type and Subtype

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

  26. New Settings

  27. Select the Dependent Variable

  28. Initial Graph

  29. Test the Graph Default or initial value

  30. Line Graph for Atlantic

  31. Line Graph for GRP Records

  32. Generate the OGR File

  33. In Form Builder

  34. Attach og.pll to the library

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

  36. New Chart Item

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

  38. Create the Trigger for the Push Button

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

  40. Create the Trigger for the Next Drill-Down

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

  42. Test the Form and Graph Initial graph

  43. After Adjusting the Form and Graph

  44. Drill-Down

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

  46. Executive Information Systems

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

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

More Related