Saturday, January 19, 2013

[OBIEE11g] - Creating Dashboard Traversing Through Graph


The general requirement asked for by customers is that they want to Click on the Main Dashboard Page’s Graph and be transferred to the other Dashboard Page or Tab on the Same Dashboard.
I will be creating 2 Dashboard Pages(Sales, Sales Details) and the first page(Sales) will contain a graph which will have clickable links to move to the second page(Sales Details) which will have “is prompted” prompts to display the table of the graph region where the user has clicked on.
  1. Start by opening the URL: http://localhost:9704/analytics and login using the administrator user “weblogic”
    First I will be creating the report for the second “Sales Details” page.
    On the main “Oracle BI Answers” menu select “New” -> “Analysis” -> “Sample Sales Lite” and select the columns as show below.
    Then click the “Save Analysis” icon to save the report under the folder “Shared Folders” -> “11g Shared” and enter “Sales Detail Report” for “Name” field.
  2. Click the “OK” button on the “Save As” window to close it.
  3. Select the “Per Name Year” options and select “Filter” and select “is prompted” for the “Operator” field as show below:
  4. Click the “OK” button to close the “New Filter” window.
  5. Select the “Brand” options and select “Filter” and select “is prompted” for the “Operator” field as show below:
  6. Click the “OK” button to close the “New Filter” window.
  7. Make sure all the “is prompted” filters are created as below:
  8. Click the “Save Analysis” icon to save the changes.
  9. Now onto create a “Dashboard Prompt” for your “Sales Details” dashboard page.
  10. On the main “Oracle BI Answers” menu select “New” -> “Dashboard Prompt” -> “Samples Sales Lite” and create the following prompts as below:
  11. Click on the “+” icon then select “Column Prompt…” .
  12. In the “Select Column” window select “Sample Sales Lite” -> “Time” -> “Pre Name Year” and click the “OK” button.
  13. In the “New Prompt: Per Name Year” window check the “Require User Input” checkbox.
  14. Select “Specific Values” option for the “Default selection”, click on the “+” icon and select “2009″ and “2010″ for the values.
  15. Click “OK” button on the “Select Values” window.
  16. Leave the other defaults in the “New Prompt : Per Name Year” window and click “OK” button.
  17. Create a similar prompt for the “Brand” column as shown below:
  18. Make sure the two prompts area created as shown in above screenshots and the final “Definition” screen is as show below:
  19. Click the “Save Prompt” icon on the top right corner and Save it with the name “Sales Prompt” under “Shared Folders” -> “11g Shared” as show below:
  20. Now onto creating the Graph to put into our first dashboard(Sales).
  21. On the main “Oracle BI Answers” menu select “New” -> “Analysis” -> “Sample Sales Lite” and select the columns as shown below.
  22. Select the “Per Name Year” column options and select “Sort” -> “Sort Descending”
  23. Click the “Save Analysis” icon and browse to “Shared Folders” -> “11g Shared” then enter “Sales Main Report” for the “Name”
  24. Click “OK” button to close the “Save As” window.
  25. Goto the “Results” tab and click on the “New View” icon then select “Graph” -> “Bar” -> “Vertical”.
  26. Once the Graph shows up, drag the “Graph” box above the “Table” box by clicking on the “Graph” Title bar and dragging it as show below:
  27. Click the “Edit View” on the “Graph” title bar.
  28. In the “Layout” section drag the “Brand” column to the “Vary Color By (Horizontal Axis)” section.
  29. Check the “Show in Legend” checkbox.
  30. Click on the “Edit Graph Properties” on the “Graph” window menu.
  31. Click on the “Style” tab.
  32. Select “Rectangle” for the Style field.
  33. For “Plot Area” “Background” enter “#6699CC”.
  34. Select the “Specify” for “Gridlines”
  35. For the “Major Grid” enter “#000000″.
  36. For the “Minor Grid” enter “#0000FF”.
  37. Leave the other defaults and click the “OK” button to close the “Graph properties” window.
  38. Click “Done” button above the “Graph” menu.
  39. Click on the “Remove view From Compound Layout” i.e “X” button on the “Table” Title bar.
  40. Click on the “Save Analysis” icon to save the changes.
  41. On the main “Oracle BI Answers” menu select “New” -> “Dashboard” and enter “Sales” for the Name, then click “OK” button.
  42. Drag the “Sales Main Report” from “Catalog” bottom left pane to the right “Drop Content Here” pane.
  43. Click on the “Save” icon.
  44. Click the “Run” button to test your dashboard.
  45. On the “Sales” dashboard select “Page Options” on the top right and select “Edit Dashboard”
  46. Click on the “Add Dashboard Page” i.e. “+” icon to add a new page.
  47. Enter the page name as “Sales Details” and click the “OK” button.
  48. Drag the “Sales Detail Report” from the bottom left “Catalog” Pane to the right “Drop Content Here” pane.
  49. Then Drag the “Sales Detail Report” from the “Catalog” pane to under the “Section 1″ “Sales Prompt” box as show below:
  50. Click the “Save” icon to save the Dashboard.
  51. Then click the “Run” icon to test that your second page is working.
  52. Now onto linking both our pages, so if we select something on the Graph on “Page 1″ we come to details on “Sales Details” page.
  53. Go to the “Catalog” on the main menu and select “Shared Folders” -> “11g Shared” folder on the left “Folders” pane.
  54. Select “Edit” link on the “Sales Main Report”.
  55. Click on the “Criteria” tab and select “Revenue” options “Column Properties”, then on the “Interaction” tab.
  56. Click on the “+” icon to add a “New Action Link …”.
  57. Select the first gear icon “Create New Action” then the “Navigate to BI Content”.
  58. In the “Select BI Content For Action” window, goto the “Shared Folders” -> “11g Shared” -> “Dashboards” -> “Sales” and select the “Sales Details” page.
  59. Click “OK” button and again “OK” button for the “Create New Action” window.
  60. Enter “Get Details” for the “Link Text” on the “New Action Link” window.
  61. Click the “OK” button and verify as below:
  62. Click “OK” to close the “Column Properties” window.
  63. Click on the “Save Analysis” icon to save your changes.
  64. Now on to test our “Sales” Dashboard.
  65. On the Answers main menu select “Dashboard” -> “Sales”
  66. You should now see your main Dashboard page as below, select the “2010″, “BizTech” blue bar to show the “Get Details” popup.
  67. Click on the “Get Details”.
  68. Now you should see the control taken to the “Sales Details” page on your “Sales” Dashboard, showing the “2010″ and “BizTech” table as show below:
Summary:
I have shown how to create an Action Link or Traversing link from the Sales Graph to the Related Sales Details Table.
By playing with options in your “Navigation” tab as show above you should be able to create much more interactive reports.