7Building and Using Dashboards
Building and Using Dashboards
Dashboards
Dashboards provide personalized views of corporate and external information.
A dashboard consists of one or more pages. Pages can display anything that you can access or open with a Web browser, including the following:
-
The results of analyses
The results of an analysis is the output returned from the Oracle BI Server that matches the analysis criteria. It can be shown in various views, such as a table, graph, and gauge. Users can examine and analyze results, print as PDF or HTML, save as PDF, or export them to a spreadsheet.
-
Alerts from agents
-
Action links and action link menus
-
Images
-
Text
-
Views of folders in the Oracle BI Presentation Catalog
-
Links to Web sites
-
Links to documents
-
Embedded content (such as Web pages or documents)
-
Edit the dashboard, if you have the appropriate permissions and privileges.
For more information on the Dashboard Builder, see "Dashboard Builder".
-
Display various options for working with a "Dashboard page", such as printing the current page. See "Opening and Using a Dashboard".
Dashboard Builder
The Dashboard builder lets you add dashboard pages to a dashboard and edit the pages in a dashboard. You can add objects to and control the layout of dashboard pages.
Pages contain the columns and sections that hold the content of a dashboard. Every dashboard has at least one page, which can be empty. Dashboard pages are identified by tabs across the top of the dashboard. Multiple pages are used to organize content. For example, you might have one page to store results from analyses that you refer to every day, another that contains links to the Web sites of your suppliers, and one that links to your corporate intranet.
The objects that you can add to a dashboard page include:
Dashboard objects — Items that are used only in a dashboard. Examples of dashboard objects are sections to hold content, action links, and embedded content that is displayed in a frame in a dashboard. See Table E–2, "List of Dashboard Objects".
-
Catalog objects — Objects that you or someone else has saved to the Oracle BI Presentation Catalog (for example, analyses, prompts, and so on) and for which you have the appropriate permissions.
In a dashboard, the results of an analysis can be shown in various views, such as a table, graph, and gauge. (The results of an analysis are the output that is returned from the Oracle BI Server that matches the analysis criteria.) Users can examine and analyze results, save or print them, or export them to a spreadsheet.
What Controls the Look of a Dashboard
The look of a dashboard, such as background colors and the size of text, is controlled by:
-
Skins — Skins control the way the Oracle BI EE interface is displayed, such as background colors, corporate logos, and the style sheets to use. Skins can be automatically assigned to users when they log on. Administrators can customize the default skin and create new skins.
-
Styles — Styles control how dashboards and results are formatted for display, such as the color of text and links, the font and size of text, the borders in tables, the colors and attributes of graphs, and so on. Styles are organized into folders that contain Cascading Style Sheets (files with a .css extension), images, and graph templates. Administrators can customize some style sheets and create new style sheets. Users can override some elements in style sheets, such as table borders and text size, when formatting results in the Results tab.
-
Cosmetic formatting — Cosmetic formatting affects the visual appearance of results and dashboards. You can apply it to results, columns, and sections.
For more information, see "Formatting Dashboard Pages".
Creating a Dashboard
BI Author Developer
BI Tenant Administrator
Now, then the new dashboard, which contains one blank page, is displayed in the "Dashboard builder" for editing.
Later, then an empty dashboard is created (but not displayed) to which you can add content later.
Editing a Dashboard
BI Author Developer
BI Tenant Administrator
Adding New Pages to a Dashboard
BI Author Developer
BI Tenant Administrator
After you add a new page, you can add content to it. See "Adding Content to a Dashboard"
Dashboard Content
You can add the following content to dashboards:
-
Dashboard objects, including objects that let you lay out the content, such as columns and sections, as well as objects such as text, folders, action links, and so on. Table E–2 lists and describes the dashboard objects that you can include on a dashboard page.
-
Objects that you or someone else has saved to the Oracle BI Presentation Catalog and for which you have the appropriate permissions, such as analyses, prompts, and so on.
Adding Content to a Dashboard
BI Author Developer
BI Tenant Administrator
Dragging and Dropping Objects to the Page Layout Area in the Dashboard Builder
When you drag and drop objects to the "Page Layout area" of the "Dashboard builder", keep in mind the following:
-
As you drag an object in the Page Layout area, a blue bar is displayed to indicated the drop location relative to another object. When you hover over a valid target in which to drop the object, the border of the target container changes to orange.
-
When you drop an object that does not have a name to the Page Layout area, it is assigned a default name, such as Section 1, Link 1, and so on. You can rename some objects to assign meaningful, descriptive names.
-
When you hover the mouse pointer over an object that has been dropped to the Page Layout area, it is highlighted with an orange border and its toolbar is displayed.
-
Columns are used to align content, while sections within columns hold the actual content. If you drag and drop an object to an empty Page Layout area, or drag and drop an object to a column without first adding a section to hold it, then the proper containers for it are created automatically. For example, if you drag and drop a section to an empty Page Layout area, a column is created automatically. If you drag and drop an analysis, then both the column and section are created automatically.
-
When you drag and drop an analysis to the Page Layout area, the compound view is shown by default. If you want to show another view, then click the Properties button for the analysis, select Show View, and select the view that you want.
-
When you drag a second object to a section, you can drop it either horizontally or vertically within the section, which sets the layout for the section. Additional objects that you drag and drop have that layout. To change the layout after it has been set, you can use the Horizontal Layout and Vertical Layout buttons on the section toolbar.
-
If you drag a section from one column into another column, then any content in that section is also included.
Changing the Properties of a Dashboard and its Pages
You can change the properties of a dashboard and its pages. Specifically, you can:
Change the style and description of the dashboard
Add hidden named prompts to the dashboard and to its pages
Specify which links (Analyze, Edit, Refresh, Print, Export, Add to Briefing Book, and Copy) are to be included with analyses at the dashboard level. Note that you can set these links at the dashboard page level and the analysis level, which override the links that you set at the dashboard level. For more information, see "Report Links dialog"
Rename, hide, reorder, set permissions for, and delete pages.
Specify which accounts can save shared customizations and which accounts can assign default customizations for pages, and set account permissions.
Specify whether the Add to Briefing Book option is to be included in the Page Options menu for pages.
Changing the Properties of a Dashboard and its Pages
BI Author Developer
BI Tenant Administrator
Changing the Properties of an Object Added to a Dashboard Page
BI Author Developer
BI Tenant Administrator
Deleting Objects on Dashboard Pages
If you add an object that you later decide that you do not want, then you can delete it. Keep the following points in mind when deleting objects:
When you delete an object that contains other objects, such as a column or section, you also delete all objects in that container.
When you delete a column, other columns on the page might resize automatically to maintain column alignment.
For objects that are saved in the catalog, the object is deleted from the dashboard page only. It is not deleted from the catalog. (Users with the appropriate permissions can edit the contents of the catalog. For information, see Chapter 13, "Managing Objects in the Oracle BI Presentation Catalog.")
Deleting an Object on a Dashboard Page
BI Author Developer
BI Tenant Administrator
-
Edit the dashboard. For information, see "Editing a Dashboard".
-
Navigate to the page that contains the object to delete.
-
Hover the mouse pointer over the object in the Page Layout area to display the object's toolbar and click the Delete button.
Deleting the Current Dashboard Page
BI Author Developer
BI Tenant Administrator
-
Edit the dashboard. For information, see "Editing a Dashboard".
-
Navigate to the page to delete.
-
Click the Delete Current Page toolbar button.
-
Confirm the deletion.
Deleting One or More Dashboard Pages
BI Author Developer
BI Tenant Administrator
Saving Dashboards by Other Names and In Other Locations
You can save a dashboard:
-
By another name
The new name for the dashboard must not exist in the destination folder, otherwise, the save operation fails.
-
Anywhere in the Oracle BI Presentation Catalog
If you save the dashboard in the Dashboards subfolder directly under /Shared Folders/first level subfolder, then the dashboard is listed in the Dashboard menu in the global header. If you save it in a Dashboards subfolder at any other level (such as /Shared Folders/Sales/Eastern), then it is not listed. The dashboard is also not listed if you save it in a subfolder under the Dashboards subfolder, such as /Shared Folders/Sales/Dashboards/Eastern.
If you choose a folder in the Dashboards subfolder directly under /Shared Folders/first level subfolder in which no dashboards have been saved, then a new "Dashboards" folder is automatically created in that folder in which to save the new dashboard. For example, if you choose a folder named /Shared Folders/Sales in which no dashboards have been saved, a new Dashboards folder is automatically created and the Location entry changes to /Shared Folders/Sales/Dashboards. (A new "Dashboards" folder is not automatically created if you choose a folder at any other level.)
Saving a Dashboard by Another Name or in Another Location
BI Author Developer
BI Tenant Administrator
Edit the dashboard. For information, see "Editing a Dashboard"
Click the Save Dashboard As toolbar button to display a dialog, where you specify the save criteria.
Opening and Using a Dashboard
BI Consumer
BI Author Limited
BI Author Developer
BI Tenant Administrator
What are Saved Customizations for Dashboard Pages
Saved customizations allow users to save and view later dashboard pages in their current state with their most frequently used or favorite choices for items such as filters, prompts, column sorts, drills in analyses, and section expansion and collapse. By saving customizations, users need not make these choices manually each time that they access the dashboard page.
Users with the appropriate permissions and dashboard access rights can perform the following activities:
Save various combinations of choices as saved customizations, for their personal use.
Specify a saved customization as the default customization for a dashboard page, for their personal use.
Switch between their saved customizations.
For information on using saved customizations, see "Applying Saved Customizations" and "Clearing Your Current Customization".
For information on saving customizations and editing saved customizations, see "Saving Customizations" and "Editing a Saved Customization"
Saving a Customization
BI Consumer
BI Author Limited
BI Author Developer
BI Tenant Administrator
Applying a Saved Customization
BI Consumer
BI Author Limited
BI Author Developer
BI Tenant Administrator
Editing Saved Customizations
BI Consumer
BI Author Limited
BI Author Developer
BI Tenant Administrator
Publishing Dashboard Pages
You can publish a dashboard page to a shared dashboard location so that you can share the page with others.
When you publish a dashboard page:
Personal content (such as analyses, prompts, and so on) is copied to a destination location that you specify and references updated as appropriate.
References to shared content are retained.
If you have made changes to the page but have not saved them, then the unsaved changes are published along with the saved changes.
Ensure that other users who might display the published dashboard page have the appropriate privileges for the objects on the page. For example, if the page contains a BI Publisher report, then users must have the appropriate privilege to see that report.
Publishing a Dashboard Page
BI Author Developer
BI Tenant Administrator
The dashboard page is copied to the destination location.
Dashboard Page Links
You can create links to dashboard pages, if allowed at your organization. This lets you, for example, save a link as a bookmark or copy and send a link to other users in email.
There are two types of links that you can create — bookmark links and prompted links.
Bookmark Links
A bookmark link captures the path to a dashboard page and all aspects of the page state, for example:
http://localhost/10.1.3.2/saw.dll?Dashboard&_ scid=7ndOC-SjmWo&PortalPath=%2Fusers%2Fadministrator%2F_ portal&Page=p2&PageIdentifier=7fsg0r2sdssvgen4&BookmarkState=r78an1mbj0fj4lmqhdjfn dvvai
After you create a bookmark link, you can:
Save the link as a bookmark so that you can return to the exact same page content at a later time.
Copy and send the link to other users who then can view the exact same content that you are viewing, providing they have the same permissions as you and have access to the page.
When you create a bookmark link, the state of a dashboard page is saved in the catalog as a hidden bookmark object for the amount of time that your organization specifies. The default is 30 days. Because the state of a dashboard page is saved when you create a bookmark link, you can continue to modify the content of the page after you create the link.
Prompted Links
A prompted link captures the path to a dashboard page and a simplified presentation of the dashboard prompts, for example:
...Action=Navigate&col1=Products.Color&val1="Armory"+"Clear"&col2=Periods."Month"& op2=gt&val2="05/01/1998%2012:00:00%20AM"
When you create a prompted link, you can manually or programmatically manipulate the link, such as by adding different values for the prompts.
The prompted link syntax is as follows:
<Content Path>, Action=Navigate, Column1 (col1), Operator1 (op1), Values1 (val1), Column2 (col2), Operator2 (op2), Values2 (val2)…
Use plus signs to separate values.
Use the same operators as those for the Go URL. For a list of these operators, see Oracle Fusion Middleware Integrator's Guide for Oracle Business Intelligence Enterprise Edition
Optionally omit the operator parameter for equal (eq).
Optionally omit the double quotes if there are no white spaces inside the values.
Creating a Dashboard Page Link
BI Consumer
BI Author Limited
BI Author Developer
BI Tenant Administrator
Open the dashboard in which you want to create a link to a dashboard page. For information, see "Opening and Using a Dashboard".
Navigate to the page for which you want to create a link.
-
Note:
If you drill in an analysis that has been set to replace the dashboard with the new results (rather than show the new results directly in the dashboard), then the Create Bookmark Link option is displayed as a link below the new results rather than as an option on the Page Options menu. (To specify how drilling works in an analysis, you use the Drill in Place option on the Properties menu for a section. For more information, see "Properties Buttons for Objects".
Click the Page Options toolbar button on the dashboard page and:
To create a bookmark link, select Create Bookmark Link.
To create a prompted link, select Create Prompted Link.
Bookmark link, then you can save the it as a bookmark or copy and send it to other users.
Prompted link, then you can manually or programmatically manipulate the link.
Briefing Book
This is a short description.
A briefing book is a collection of static or updatable snapshots of dashboard pages and individual analyses.
You can:
Add the content of dashboard pages (including pages that contain BI Publisher reports) or individual analyses to new or existing briefing books. See "Adding Content to a New or Existing Briefing Book"
Edit briefing books to reorder content, delete content, and change the content type, navigation link properties, and content description. See "Editing a Briefing Book"
Download briefing books in PDF or MHTML format for printing and viewing. See "Downloading a Briefing Book". The PDF version of a briefing book contains an automatically generated table of contents. For information about the table of contents, see "Briefing Book PDF Version Table of Contents"
Add a list of briefing books to a dashboard page. See "Adding a List of Briefing Books to a Dashboard Page"
Update, schedule, and deliver briefing books using agents, if your organization licensed Oracle Business Intelligence Delivers. See "Delivereing Briefing Books via Agent"
Briefing Book PDF Version Table of Contents
The PDF version of a briefing book contains a table of contents that is automatically generated. It contains an entry for each dashboard page, analysis, and report in the briefing book. Each of these entries includes a time stamp and the page number within the PDF file. The time stamp value depends on how the content was saved to the briefing book. If the content was saved as updatable, then the time stamp is current. If the content was saved as a snapshot, then the time stamp is the time of the snapshot.
Indented beneath each entry for a dashboard page are any briefing book links included on that page, up to a maximum of nine links. These entries do not include timestamps. For example:
Table of Contents My Dashboard Page 7/11/2008 9:15:20 AM . . . . . .1 Years to Dollars Dashboard . . . . . . . . . .2
The administrator can modify the template for the table of contents so that the table of contents that is generated in your briefing books might have a different look.
Adding Content to a New or Existing Briefing Book
BI Author Limited
BI Author Developer
BI Tenant Administrator
The content is added to the briefing book.
Editing a Briefing Book
BI Author Limited
BI Author Developer
BI Tenant Administrator
Downloading a Briefing Book
BI Consumer
BI Author Limited
BI Author Developer
BI Tenant Administrator
Navigate to the briefing book to download.
Perform one of the following actions:
To download the briefing book in PDF format, click PDF and then open or save the file.
Note: The Adobe Reader application is required to view or print a briefing book PDF file.-
To download the briefing book in MHTML format, click Web Archive (.mht) and then open or save the file.
Downloaded briefing books are saved with an .mht file extension and can be opened in a browser. You can then email or share the briefing book.
Adding a List of Briefing Books to a Dashboard Page
BI Author Developer
BI Tenant Administrator
The folder is added to the dashboard.
Delivering Briefing Books via Agent
BI Author Developer
BI Tenant Administrator
-
Create or edit the agent to be used to deliver the briefing book. For information, see "Creating Agents".
-
In the "Agent editor: Delivery Content tab", click Browse to select the briefing book.
When the agent runs, the briefing book is delivered.