This chapter describes dashboards and explains how to build and use them. It contains the following topics:
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)
Oracle BI Publisher reports
When you open a dashboard, the content of the dashboard is displayed in one or more dashboard pages. Dashboard pages are identified by tabs across the top of the dashboard. A toolbar at the top right contains buttons that let you:
Edit the dashboard, if you have the appropriate permissions and privileges.
For more information on the Dashboard Builder, see "What Is the Dashboard Builder?"
Display various options for working with a "Dashboard page", such as printing the current page. See "Opening and Using Dashboards".
The ability to create dashboards is controlled by the Manage Dashboard privilege, which is managed by the administrator.
Dashboard editing, which is performed in the "Dashboard builder", is allowed for users with the appropriate permissions and privileges to the dashboard and to objects that can be added to a dashboard page. For more information, see "Assigning Permissions". For information about administering privileges, see Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
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 B-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.
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.
For information about skins, see Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
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.
For information about styles, see Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
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 "Applying Formatting to Dashboard Pages".
You use the "Dashboard builder" to create (and edit) dashboards. For more information on dashboards, see "What Are Dashboards?"
To create a dashboard:
In the global header, click New, then select Dashboard.
The "New Dashboard dialog" is displayed.
In the dialog, enter a name and description for the dashboard.
Select the location for the dashboard.
Note:
If you save the dashboard in the Dashboards subfolder directly under /Shared Folders/first level subfolder, then the dashboard will be 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 will not be listed.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.)
Specify whether you want to add content to the new dashboard now or later.
Click OK.
If you specified that you want to add content:
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.
You can edit dashboards to which you have appropriate permissions and privileges.
To edit a dashboard:
In the global header, click Catalog to display the "Catalog page".
Navigate to the dashboard that you want to edit and click the Edit link.
The dashboard is displayed in the "Dashboard builder".
Perform one or more of the following tasks, as needed:
Add a dashboard page. See "Adding New Pages to Dashboards".
Delete a dashboard page. See "Deleting Dashboard Pages".
Add content. See "Adding Content to Dashboards".
Use the options available on the Tools toolbar button of the Dashboard builder to:
Set dashboard and dashboard page properties.
Specify page settings, and header and footer content for the PDF output, when printing a dashboard.
Set the report links for a dashboard page.
Specify whether to allow users to create personal saved customizations on the page.
Publish the page to a shared dashboard location so that you can share the page with others. See "Publishing Dashboard Pages".
For more information about these options, see "Dashboard builder".
Perform one of the following steps at any time:
To preview the dashboard page, click the Preview toolbar button.
To save your changes, click the Save toolbar button.
To exit the Dashboard builder and return to the Dashboard, click Run.
You can add new pages to dashboards.
To add a new page to a dashboard:
Edit the dashboard. For information, see "Editing Dashboards".
Click the Add Dashboard Page toolbar button in the Dashboard builder.
The "Add Dashboard Page dialog" is displayed.
In the dialog, enter a name and description for the page, and click OK.
The page is displayed as a new tab in the "Dashboard builder".
Click the Save toolbar button.
After you add a new page, you can add content to it. See "Adding Content to Dashboards".
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 B-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.
Note:
Dashboard modification is reserved for users with the appropriate permissions and privileges.To add content to a dashboard:
Edit the dashboard. For information, see "Editing Dashboards".
Add the objects that you want to include on the page. To add an object, select it from the "Dashboard Objects pane" or the "Catalog pane", and then drag and drop the object to the "Page Layout area".
For information on dragging and dropping objects, see "Dragging and Dropping Objects to the Page Layout Area in the Dashboard Builder".
Tip:
To locate an object in the Catalog pane, you can browse either by the catalog folder in which the object is stored or by the dashboard on which the object is displayed.For information on adding Oracle BI Publisher reports, see "Adding Oracle BI Publisher Reports to Dashboard Pages".
When you drag and drop a scorecard object to the Page Layout area, the "Dimension Pinnings dialog" might be displayed, where you pin (or set) values for KPI dimensions that are associated with the scorecard object.
Set the properties of each object, as appropriate. To do so, hover the mouse pointer over the object in the Page Layout area to display the object's toolbar and click the Properties button.
What is displayed depends on the type of object. For some objects, a properties dialog is displayed. For other objects, a menu of options is displayed. For more information, see "Properties Buttons for Objects".
Click the Save toolbar button.
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 already 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 already 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 will 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.
This section describes how to add Oracle BI Publisher reports to dashboard pages. It contains the following topics:
Note:
If you use Microsoft's Internet Explorer browser version 7, then you might experience problems viewing BI Publisher reports that are embedded in analyses or dashboards, depending on the privacy settings of the browser. When you display the page from Oracle BI EE in the browser, you might find that the BI Publisher report is missing. This problem is encountered on browsers with a medium-level of privacy and popups blocked. To work around this problem, use a different browser than Internet Explorer version 7, or view the report in BI Publisher rather than in Oracle BI EE, or reduce the privacy setting of the browser.This section contains the following topics:
This section contains the following topics:
For general information on BI Publisher, see "Integration of Oracle BI EE with Oracle BI Publisher".
You can run, view, and interact with a BI Publisher report on a dashboard page. When included on a dashboard page, the BI Publisher report can include a toolbar that can offer options for selecting a layout template, changing the BI Publisher report's output format, exporting the BI Publisher report, sending the BI Publisher report to an available destination (for example, printer, fax, e-mail, or FTP), scheduling the BI Publisher report, and analyzing the data.
Because reports can be scheduled, you can select the latest run of the report that you want to include on the dashboard page. The report run that you select also determines whether dashboard prompts can be used, as described in the following list:
When a report that is not scheduled or has no previous version is included on the dashboard page, the report will be executed and generated when you access the dashboard page. You can use the dashboard prompts to regenerate the report and display updated data.
When you add a report that is scheduled or that has a previous run to a dashboard page, you can specify whether you want the most recently generated version of the report to be displayed on the dashboard. (To do so, you use the View Latest Version box in the "BI Publisher Report Properties dialog".) If you specify that you want the most recently generated version of the report, because this report has been run by the scheduler, you cannot use the dashboard prompts to regenerate the report from the dashboard.
If you plan to print a dashboard page that contains a BI Publisher report or to include the page in a briefing book, then you must keep the following points in mind:
If you print the briefing book as PDF and if the output format of the BI Publisher report is PDF, then the BI Publisher report is printed after the other objects on the page. If you print a dashboard page that contains a BI Publisher report as PDF, but the dashboard page is not part of a briefing book, then the BI Publisher will not be printed.
If you print the dashboard page or briefing book as MHTML, then the BI Publisher report will not be printed.
You can add one or more existing reports to a dashboard page. The advantage is that you can share reports with other users and schedule the dashboard pages using agents. An agent sends the entire dashboard to the user, including all data pages that the report references.
When configuring an agent for a dashboard page that contains a BI Publisher report, ensure that the following criteria are met:
The output format of the BI Publisher report must be PDF.
The agent must be set to deliver PDF.
You can add reports to a dashboard page as embedded content and as a link. Embedded means that the report is displayed directly on the dashboard page. The link opens the report in BI Publisher within Oracle BI EE.
If you modify the report in BI Publisher and save your changes, then refresh the dashboard page to see the modifications.
To add a report to a dashboard page:
Edit the dashboard. For information, see "Editing Dashboards".
Navigate to the page to which you want to add a report.
Select a report in one of the following ways:
Select the report from the Catalog pane and drag and drop it into a section on the dashboard page.
To add a report from a dashboard page, select the report from the folder that contains its dashboard in the Catalog pane.
Set the properties of the object. To do so, hover the mouse pointer over the object in the Page Layout area to display the object's toolbar, and click the Properties button.
The "BI Publisher Report Properties dialog" is displayed.
Complete the fields in the properties dialog as appropriate.
Click OK.
Click Save.
If required, add a prompt to the dashboard page to filter the results of an embedded parameterized report, as described in "Using Prompts with Parameterized Reports".
Optionally, schedule the dashboard with an agent, as described in Chapter 8, "Delivering Content."
You can use prompts to filter the results of embedded parameterized BI Publisher reports to show only results that match the prompt criteria.
A BI Publisher report that receives its data from an analysis must have the report columns that you want to filter on set to "Is Prompted" in the analysis. This type of report supports the full range of prompt expressions, but the analysis cannot contain parameters.
To use prompts with parameterized reports:
In BI Publisher, open the report and locate the parameters that it uses. Set a default value for each required parameter so that the report displays correctly without user interaction.
Create a new column prompt for each parameter by following these steps:
In the global header, click New, then Dashboard Prompt.
Select either the subject area that includes the columns from the report or a subject area whose columns closely match those in the report.
In the "Definition pane", click the New button, select Column Prompt, then select a column to use for the prompt.
For more information on creating prompts, see Chapter 6, "Prompting in Dashboards and Analyses."
Complete the "New Prompt: Column dialog" and click OK. Verify the following settings:
Set the Operator field to is equal to/is in.
Define a presentation variable with the exact same name as the parameter from the report. When using variable names in prompts, ensure that you spell them correctly and adhere to case-sensitivity. Make the data type of the parameter match the data type of the column, if they are not based on the same database column.
Click the Save Prompt toolbar button to save the prompt to the catalog in a shared folder.
Navigate to the dashboard that contains the parameterized report and click the Edit Dashboard toolbar button.
The Dashboard builder is displayed.
In the Catalog pane, navigate to the folder that contains the prompt that you want to add.
Drag and drop the prompt into the section on the dashboard page that contains the report.
Click the Save toolbar button.
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.
To change the properties of a dashboard and its pages:
Edit the dashboard. For information, see "Editing Dashboards".
Click the Tools toolbar button and select Dashboard Properties.
The "Dashboard Properties dialog" is displayed.
Make the property changes that you want and click OK.
Click the Save toolbar button.
You can change the properties of objects that have been added to a dashboard page from the "Dashboard Objects pane" and from the "Catalog pane".
To change the properties of an object on a dashboard page:
Edit the dashboard. For information, see "Editing Dashboards".
Navigate to the page that contains the object.
Hover the mouse pointer over the object in the Page Layout area to display the object's toolbar and click the Properties button.
What is displayed depends on the type of object. For some objects, a properties dialog is displayed. For other objects, a menu of options is displayed. For more information on the properties that you can change, see "Properties Buttons for Objects".
Make the property changes that you want.
Click the Save toolbar button.
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.")
To delete an object on a dashboard page:
Edit the dashboard. For information, see "Editing Dashboards".
Navigate to the page that contains the object that you want 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.
You can delete:
The current dashboard page
One or more dashboard pages from the "Dashboard Properties dialog"
To delete the current dashboard page:
Edit the dashboard. For information, see "Editing Dashboards".
Navigate to the page that you want to delete.
Click the Delete Current Page toolbar button.
Confirm the deletion.
To delete one or more dashboard pages:
Edit the dashboard. For information, see "Editing Dashboards".
Click the Tools toolbar button and select Dashboard Properties.
The "Dashboard Properties dialog" is displayed.
For each page that you want to delete:
In the Dashboard Pages area, select the page.
Click Delete in the Dashboard Pages toolbar.
Confirm the deletion.
Click OK.
You can save a dashboard:
By another name
The new name for the dashboard must not already exist in the destination folder, otherwise, the save operation will fail.
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 will be 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 will not be listed.
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.)
To save a dashboard by another name or in another location:
Edit the dashboard. For information, see "Editing Dashboards".
Click the Save Dashboard As toolbar button to display a dialog, where you specify the save criteria.
To open and use a dashboard:
In the global header, click Catalog to display the "Catalog page".
Navigate to the dashboard that you want to open and click the Open link.
The dashboard is opened to the first "Dashboard page". If no content has been added, then an empty dashboard page notification message is displayed.
(optional) Perform any of the following tasks:
Display the dashboard in the "Dashboard builder" for editing.
Navigate among dashboard pages by clicking the page tabs.
Print a page.
For information, see "About Briefing Books and Printing BI Publisher Reports".
Refresh a page.
Perform this task to ensure that the refresh operation bypasses saved information in the Oracle BI Presentation Services cache and is issued to the Oracle BI Server for processing.
When you select a specific dashboard or analysis, Oracle BI Presentation Services checks its cache to determine if the identical results have recently been requested. If so, Oracle BI Presentation Services returns the most recent results, thereby avoiding unnecessary processing by the Oracle BI Server and the back-end database. If not, the analysis is issued to the Oracle BI Server for processing. You cannot force the analysis past the Oracle BI Server's cache.
Administrators can configure cache settings for Oracle BI Presentation Services that control what is cached and for how long. For information about the Oracle BI Server cache, see Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
Add a page to a briefing book.
For information, see "Adding Content to New or Existing Briefing Books".
Create a bookmark link or a prompted link to the page.
For information, see "About Creating Links to Dashboard Pages" and "Creating Links to Dashboard Pages".
Apply saved customizations.
For information, see "What Are Saved Customizations for Dashboard Pages?" and "Applying Saved Customizations".
Edit saved customizations.
For information, see "What Are Saved Customizations for Dashboard Pages?" and "Editing Saved Customizations".
Save the current customizations.
For information, see "What Are Saved Customizations for Dashboard Pages?" and "Saving Customizations".
Clear the current customizations.
For information, see "What Are Saved Customizations for Dashboard Pages?" and "Clearing Your Current Customization".
For information on keyboard shortcuts that you can use in a dashboard, see "Keyboard Shortcuts for Oracle BI EE and Oracle BI Publisher".
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 or use by others.
Specify a saved customization as the default customization for a dashboard page, for their personal use or use by others.
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 Saved Customizations"
This section describes two example scenarios that describe the creation and use of saved customizations.
An IT group in a consumer goods company builds a master dashboard that contains the content that various product groups need to view. The dashboard contains filters and prompts from which members of the product groups would ordinarily make customizations to view relevant results.
The master dashboard contains two analyses, one that shows sales for the east, west, north, and south regions, and another that shows all products shipped in those regions. The analysis for sales by region contains a prompt that allows users to select their particular region. The analysis for all products shipped contains a filter that allows users to select their products.
An IT consultant customizes the view for the Fizzy Brands product group for each region. The consultant first selects the east region and the Fizzy Brand products from the filters and prompts on the dashboard, and then saves these choices as a customization that can be shared by other users. The consultant then assigns this customization as the default view customization to members of the east region group that sells Fizzy Brand products. The consultant repeats this process for the west, north, and south regions.
When a Fizzy Brands sales representative for the western region signs in to Oracle Business Intelligence and views the dashboard, the representative initially views sales and shipment information based on the region and product choices assigned as the default view customization for that group. All sales representatives in that group who would typically make identical choices for region and product no longer have to do so.
A business user's dashboard contains two reports, one that shows sales for all regions, and another that shows all products shipped. Each report contains a prompt, allowing the user to select a particular region and product. The user selects the eastern region and the Fizzy Brands product. The dashboard refreshes to show the user this view of the data. The user saves this view as a customization, indicates that the customization is for personal use, and that it is the default customization the user wants to see when viewing the dashboard. Then, this user creates additional combinations of the product and region sets in which the user is most interested, and saves them for later retrieval. The user can also access customizations that were saved by the IT group as shared customizations. To view sales in the western region for Fizzy Brands, the user clicks the Page Options button, selects Apply Saved Customizations, and selects the view named Dollar Sales, Western Region, Fizzy Brands. The dashboard refreshes with the new view of the data.
You can save customization for use by you or by others. You can also specify whether the customization is to be the default customization for a dashboard page, for you or for others. For more information on customizations, see "What Are Saved Customizations for Dashboard Pages?"
To save a customization:
Open the dashboard in which you want to save a customization. For information, see "Opening and Using Dashboards".
Navigate to the page on which you want to save a customization.
Make your customizations.
Click the Page Options toolbar button on the dashboard page and select Save Current Customization.
The "Save Current Customization dialog" is displayed.
Enter a descriptive name for the customization.
Specify for whom the customization is to be saved:
To save the customization for your personal use, select Me.
To save the customization for use by others, select Others and then click Set Permissions to display the "Saved Customization Permissions and Defaults dialog", where you specify the accounts that have permission to use the customization and whether the customization is to be the default customization for the accounts.
Optionally, to assign this customization as your default customization, select Make this my default for this page.
Click OK.
You can apply customizations that you have saved for your own personal use or that have been saved by someone else for your use. For more information on customizations, see "What Are Saved Customizations for Dashboard Pages?"
To apply a saved customization:
Open the dashboard in which you want to apply a saved customization. For information, see "Opening and Using Dashboards".
Navigate to the page that contains the customization that you want to apply.
Click the Page Options toolbar button and select Apply Saved Customization.
Your personal saved customizations, if any, are shown at the beginning of the list. Shared saved customizations are listed next. Your current default customization is shown in bold type.
Click a saved customization in the list to apply it to the dashboard page.
You can rename customizations, change which customization to use as your default, change permissions for those customizations that have been shared with others, and delete customizations. For more information on customizations, see "What Are Saved Customizations for Dashboard Pages?"
To edit saved customizations:
Open the dashboard in which you want to edit a customization. For information, see "Opening and Using Dashboards".
Navigate to the page that contains the customization that you want to edit.
Click the Page Options toolbar button on the dashboard page and select Edit Saved Customizations.
The "Edit Saved Customizations dialog" is displayed.
Rename customizations, change which customization to use as your default, change permissions for those customizations that have been shared with others, and delete customizations, as appropriate.
Click OK.
You can clear your current customization if you decide the choices for items such as filters, prompts, column sorts, drills in analyses, and section expansion and collapse are not what you want. For more information on customizations, see "What Are Saved Customizations for Dashboard Pages?"
To clear your current customization:
Click the Page Options toolbar button on the dashboard page and select Clear My Customization.
The current customization is cleared.
Dashboard template pages are dashboard pages that are used to populate the personal dashboards (My Dashboard) of new users on their initial login. This allows users to see one or more dashboard pages with content rather than an empty dashboard when they first log in. It also gives users a starting point to build their own dashboard pages.
You create dashboard template pages for your users in dashboards that have a designated name (by default the designated name is "default") and that you save in subfolders of /Shared Folders. When a new user logs in for the first time, Oracle BI EE searches for dashboard template pages in all dashboards that have the designated name, copies all dashboard template pages to which the user has permission to the user's My Dashboard folder, and displays them in the user's My Dashboard.
If a user has permissions to dashboard template pages in more than one dashboard, then Oracle BI EE copies all template pages from those dashboards to the user's My Dashboard folder and displays them alphabetically by name in the user's My Dashboard. If two pages have the same name, then the name of one of the pages will be prefixed with the name of the folder in which the dashboard was saved.
By default, Oracle BI EE searches for dashboard template pages in all dashboards that are named "default" and that have been saved in subfolders of /Shared Folders. (It searches only subfolders under /Shared Folders (for example, /Shared Folders/Finance) and not the entire hierarchy (for example, not /Shared Folders/Finance/Div1.)
If your organization has designated a name other than "default" for the name of dashboards that contain dashboard template pages, then Oracle BI EE searches for dashboard template pages in dashboards with that name (for example, "Templates") rather than "default" in subfolders of /Shared Folders.
To designate a name other than "default" for the name of dashboards that contain dashboard template pages, your administrator must set the DefaultName element in the instanceconfig.xml file. For information, see Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
Users can use dashboard template pages:
As a starting point to build their own dashboard pages.
Users can change any of the content on these dashboard template pages. Any changes that they make to the content are made to their local copies of the dashboard template pages in their My Dashboard folders, and not to the original dashboard template pages.
As examples of additional pages that they might want to build.
If users delete a dashboard template page from their My Dashboard, then they cannot repopulate My Dashboard with the page. However, if users delete their entire My Dashboard, when they log in again or navigate to My Dashboard again, their My Dashboard is recreated with all the latest dashboard template pages.
You can create dashboard template pages for users so that they see one or more dashboard pages with content rather than an empty dashboard when they first log in. For more information on dashboard template pages, see "About Dashboard Template Pages for New Users".
To create dashboard template pages:
Create one or more dashboards to contain the dashboard template pages. For each dashboard, specify the following:
In the Name field, enter "default" unless your organization has designated another name for the name of dashboards that contain dashboard template pages, in which case, enter the name your organization has designated.
In the Location box, select a Dashboard folder in a subfolder of /Shared Folders, for example /Shared Folders/Finance/Dashboards.
For information, see "Creating Dashboards".
Create one or more dashboard pages and add content to the pages. See "Adding New Pages to Dashboards" and "Adding Content to Dashboards".
Note:
Users will have access only to content to which they have appropriate permissions.Assign permissions on the dashboard to allow read access for all users whose My Dashboard you want to populate with the dashboard pages. For information, see "Assigning Permissions".
Note:
If you later change the dashboard content or the permissions to the dashboard, then the changes take effect only for new users on first login, not for users whose My Dashboard has already been populated with the dashboard template 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 will 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.
To publish a dashboard page:
Edit the dashboard that contains the page that you want to publish. For information, see "Editing Dashboards".
Navigate to the page that you want to publish.
Click Tools and then select Publish Page to Dashboard.
The "Publish Page to Dashboard dialog" is displayed.
In the Dashboard field, specify the name of the destination dashboard.
If the Publish Dashboard Page warning is displayed to indicate that content (such as the page, analyses, prompts, and so on) already exists in the destination location, then click:
OK to continue with the publishing operation and replace the existing content.
Cancel to discontinue the publishing operation and not replace the existing content.
Click OK.
The dashboard page is copied to the destination location.
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 e-mail.
There are two types of links that you can create — bookmark links and prompted links. The following sections describes these 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=r78an1mbj0fj4lmqhdjfndvvai
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 a period of time specified by your organization. The default is 30 days. See the administrator for the period of time that is specified for your organization. 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.
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)…
When manipulating this syntax:
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.
To create a link to a dashboard page:
Open the dashboard in which you want to create a link to a dashboard page. For information, see "Opening and Using Dashboards".
Navigate to the page for which you want to create a link.
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.
Note:
The administrator can control the display of the Create Bookmark Link and Create Prompted Link options. For information about controlling the display of these settings, see Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.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".
The link is displayed in the Address Bar of the browser. If the link is a:
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.
If your organization licensed Oracle BI Briefing Books, then you can work with briefing books.
The following topics explain what briefing books are and how you work with them:
A briefing book is a collection of static or updatable snapshots of dashboard pages, individual analyses, and BI Publisher reports.
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 New or Existing Briefing Books".
Edit briefing books to reorder content, delete content, and change the content type, navigation link properties, and content description. See "Editing Briefing Books".
Download briefing books in PDF or MHTML format for printing and viewing. See "Downloading Briefing Books".
The PDF version of a briefing book contains an automatically generated table of contents. For information about the table of contents, see "About the Table of Contents in a PDF Version of a Briefing Book".
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 "Using Agents to Deliver Briefing Books".
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 ContentsMy Dashboard Page 7/11/2008 9:15:20 AM . . . . . .1 Years to Dollars Dashboard . . . . . . . . . .2The 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.
Note:
The table of contents is always generated in English. Other languages are not supported. Therefore, you might want to translate the tables of contents that are generated in briefing books.For more information about including BI Publisher reports with briefing books, see "About Briefing Books and Printing BI Publisher Reports".
You can add the content of dashboard pages (including pages that contain BI Publisher reports) or individual analyses to briefing books. You can add the content to existing briefing books or to new briefing books that you create.
To add content to a new or existing briefing book:
Open the dashboard that contains the content that you want to add to a briefing book. For information, see "Opening and Using Dashboards".
Navigate to the page that you want to add or that contains the analysis that you want to add.
Perform one of the following actions:
To add the contents of the dashboard page to a briefing book, click the Page Options toolbar button on the dashboard page and select Add To Briefing Book.
Note:
The Add to Briefing Book option is not available on an empty dashboard page or if the Show Add to Briefing Book box in the "Dashboard Properties dialog" has not been selected for the page.To add the results of an individual analysis to a briefing book, locate the analysis on the dashboard and click the Add to Briefing Book link.
Note:
This link is displayed only if the Add to Briefing Book option was selected in the Report Links dialog when the analysis was added to the dashboard. For information about setting the Add to Briefing Book option, see "Report Links dialog".The "Save Briefing Book Content dialog" is displayed.
Click Browse to display the "Save As dialog".
In the Save As dialog, to save the contents to:
A new briefing book, specify the location in which to save the briefing book in the Save In field, enter a name for the briefing book in the Name field, optionally enter a description in the Description field, and click OK.
An existing briefing book, select the briefing book and click OK.
In the Save Briefing Book Content dialog, complete the remaining fields as appropriate.
Click OK.
The content is added to the briefing book.
You can edit briefing books to reorder content, delete content, and change the content type, navigation link properties, and content description.
To edit a briefing book:
To edit a briefing book:
In the catalog, in the global header, click Catalog to display the "Catalog page".
On a dashboard page, open the dashboard page that contains the briefing book.
Navigate to the briefing book that you want to edit and click Edit.
The "Edit Briefing Book dialog" is displayed.
To change content:
Select the content.
Click Edit to display the "Page Properties dialog".
Change the content type, the number of navigation links to follow for updatable content, or the content description as needed.
Click OK.
To reorder content, select the content and then drag and drop it to the desired location.
To delete content, select the content and click Delete.
Click OK.
You can:
Download briefing books to your computer in MHTML format and then share them for offline viewing.
Download briefing books in PDF format and print them.
The PDF version of a briefing book contains an automatically generated table of contents. For information about the table of contents, see "About the Table of Contents in a PDF Version of a Briefing Book".
To download a briefing book:
In the global header, click Catalog to display the "Catalog page".
Navigate to the briefing book that you want 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.Note:
BI Publisher reports that are contained in the briefing book are only included in the PDF file if the reports themselves are enabled for PDF output.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 e-mail or share the briefing book.
You can add a list of briefing books to a dashboard page.
To add a list of briefing books to a dashboard page:
Edit the dashboard. For information, see "Editing Dashboards".
Navigate to the page to which you want to add a list of briefing books.
From the "Dashboard Objects pane", drag and drop a folder object into a section.
Hover the mouse pointer over the folder object in the Page Layout area to display the object's toolbar and click the Properties button.
The "Folder Properties dialog" is displayed.
In the Folder field, enter the folder that contains the briefing books that you want to list.
In the Expand box, specify whether to show an expanded view of the folder.
In the Show RSS Link box, specify whether to add an RSS feed option to the folder.
Click OK and then click Save to save the dashboard.
The folder is added to the dashboard. On the Dashboard page, to:
See a list of the briefing books if the folder is not expanded, click the folder.
Edit a briefing book, click its Edit link. See "Editing Briefing Books".
Download a briefing book in PDF format, click its PDF link. See "Downloading Briefing Books".
Download a briefing book in MHTML format, click its Web Archive (.mht) link. See "Downloading Briefing Books".
To use an agent to deliver a briefing book:
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.