Skip Headers
Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition (Oracle Fusion Applications Edition)
11g Release 1 (11.1.1)

Part Number E20835-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

E User Interface Reference

This appendix contains comprehensive reference information for each user interface item (dialogs, panes, editors, and so on). Topics are provided in alphabetical order by user interface item.


Act As dialog

Use this dialog to select the user who you want to "act as"; that is the user whose account you want to access. You also use this dialog to return to your own user account after "acting as" another user. This dialog is available and includes a list of users only if you have been assigned the appropriate privilege and the administrator has configured this feature. For configuration information, see "Enabling Users to Act for Others" in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition.

For more information, see "Acting for Other Users".

Components

User

Use this option to select the ID of the user whose account you want to access. Based on the system settings, a text box might be displayed in this dialog. Generally, this text box is displayed if a long list of users is returned. In this text box, enter the ID of the user to act as.

Stop

Use this button to stop accessing another user's account and to return to your own account.


Action Link dialog

Use this dialog to add an action link to an initiative or objective in a Scorecard.

For more information, see:

Components

State Equals

Use this box to select the state of the initiative or objective under which the action link is to be enabled.

Action

Displays the action to be associated with the action link.

Create New Action

Use this button to select the type of action to create and display the "Add New Action dialog", where you create the action.

Select Existing Action

Use this button to display the "Select Existing Action dialog", where you select an existing action.

Link Text

Use this field to enter the text to display as the link to execute the associated action.


Action Links dialog

Use this dialog to add an action link to a KPI threshold range.

For more information, see:

Components

Action Links List

Displays the action links that have been added to the KPI, including the text of the action links and the actions associated with the links.

Add Action Link

Use this option to display the "New Action Link dialog", where you create a new action link.

Edit Action Link

Use this button to display the "Edit Action Link dialog", where you edit the selected action link.

Remove Action Link

Use this button to remove the selected action link.


Action Link Menu Properties dialog

Use this dialog to set the properties of an action links menu on a dashboard page.

For more information, see:

Components

Menu Label

Use this field to enter the text to display for the menu.

Caption

Use this field to enter a caption to be displayed above the menu text.

Action Links

Displays a list of action links associated with the action links menu.

Add

Use this button to display the "Action Link Properties dialog", where you add an action link to the action links menu.

Edit

Use this button to display the "Action Link Properties dialog", where you edit the currently selected action link.

Delete

Use this button to delete the currently selected action link.

Notes


Action Link Properties dialog

Use this dialog to set the properties of an action link on a dashboard page.

For more information, see:

Components

Link Text

Use this field to enter the text to display as the link to execute the associated action.

Caption

This field is available only for actions links that are not displayed on an action link menu.

Use this field to enter a caption to display above the link text.

Action

Displays the action to be associated with the action link.

New Action

Use this button to select the type of action to create and display the "New Action dialog", where you create an inline action. For more information on inline actions, see "What Are Inline Actions?"

Select Action

Use this button to display the "Select Existing Action dialog", where you select a named action. For more information on named actions, see "What Are Named Actions?"

Edit Parameter Mapping

This button is available only for named actions that have parameters that are not fixed or hidden.

Use this button to display the "Edit Parameter Mapping dialog", where you edit the action parameters. For more information on action parameters, see "What Are Action Parameters?"

More (>>)

Displays these options for the currently selected action:

Open Link in New Window

This box is available only for actions that navigate to related content, such as Navigate to a Web Page and Navigate to BI Content actions.

Use this box to specify, for an action link that navigates to a URL or to other BI content, whether to open the link in a new browser window or new tab (if the browser supports tabs). Select this box to open the action link in a new browser window or tab. Deselect this box to open the action link in the same browser window or tab.

Note:

If you selected a named action for this action link, the default value for this component is determined by the definition of the named action (that is, by the value specified for the Open In New Window component in the "Action Options dialog: Invoke Action tab". You can override this default value. The value you set here ultimately determines whether to open a new window or new tab.

Add to Briefing Book

This box is available only for Navigate to BI Content actions.

Use this box to specify whether the action associated with the action link can be executed in a briefing book, but only if the number of briefing book navigation links to be followed is greater than 0. (You set the number of briefing book navigation links to be followed in the "Save Briefing Book Content dialog" or in the "Page Properties dialog".)

If you select this box, then the action can be executed in a briefing book. A briefing book icon is displayed to the left of the action link on the dashboard page and in the briefing book to indicate that the action can be executed.

If you deselect this box, then the action cannot be executed in the briefing book.

See "Working with Briefing Books".

Show Link

Use this box to specify one of the following options:

Condition

(Displayed only if the Conditionally option is selected.)

Use this area to specify the condition under which the action link is to be enabled. It includes the following components:


Action Options dialog

Use this dialog to customize information to display to users when they execute an action.

For more information, see:

Components

Invoke Action

Use the "Action Options dialog: Invoke Action tab" to:

Action Results

This tab is available only for Invoke a Web Service actions.

Use the "Action Options dialog: Action Results tab" to customize a dialog to display information to users about the results of the action, if the action executed successfully.


Action Options dialog: Action Results tab

Use this tab of the "Action Options dialog" to customize a dialog to display information to users about the results of the action, if the action executed successfully.

For more information, see:

Components

Contains HTML Markup

Use this option to work with HTML codes, as described in "Working with HTML Markup".

Dialog Text

Use this field to enter the Web Service results information to display to users.

XPath Results

Use this area to specify one or more XPath expressions to be used to extract values from the XML returned from the Invoke a Web Service action.

Note:

Before specifying any XPath expressions, you must know what the Web Service returns. You can find out what a Web Service returns by reading the Web Services Definition Language (WSDL).

To add an XPath Expression to the list, click the Add XPath Expression button. A row is added to the list, where you then specify the following information:

Note:

If multiple values for an XPath expression are found in the results, then only the first value is shown.

To delete an XPath expression from the list, select the XPath expression and click the Delete XPath Expression button.

Dialog Title

Use this box to specify the title of the dialog, for example, Action Results.

Dialog Width

Use this field to specify the width for the dialog. Specifying a width causes the content to wrap and a scroll bar to be displayed, if necessary.

If you do not specify the width, then the dialog is sized based on its content.

You might want to specify a width, for example, if the dialog text contains a long sentence without any explicit line breaks, which would result in a very wide dialog.

Dialog Height

Use this field to specify the height for the dialog. Specifying a height causes the content to wrap and a scroll bar to be displayed, if necessary.

If you do not specify the height, then the dialog is sized based on its content.

You might want to specify a height, for example, if the dialog contains extensive text, which would result in a very long dialog.

Show Preview

Use this button to preview how the dialog is displayed. (Note that this does not run the action.)


Working with HTML Markup

Various dialogs and editors in which you can enter HTML codes include the Contains HTML Markup box. These dialogs and editors include the "Action Options dialog: Action Results tab", the "Edit Footer or Header dialog", the "Results tab: Narrative editor", the "Results tab: Static Text editor", the "Results tab: Ticker editor", and the "Text Properties dialog".

This option is available in the Action Options dialog: Action Results tab only if you have been granted the Save Actions containing embedded HTML privilege, and in the other dialogs and editors only if you have been granted the Save Content with HTML Markup privilege by the administrator.

Use this box to specify whether the text that you enter in the appropriate field contains HTML markup. (For example, in the Action Results tab, the field is labeled Dialog Text.) Select this box if the text contains HTML markup. Deselect this box if it contains only plain text. If the text contains HTML markup and you do not select this box, then the text is displayed as plain text.

You can add HTML that contains formatted text, and depending on the security settings of the servers, Active-X controls or Java scripts, sound bites, animation, a background image, and so on. The HTML code can contain anything that is supported by the browser.

Table E-1 contains usage notes and examples for several HTML elements. If you find an example in the table that is similar to what you want to do, then you can copy and paste the example, then tailor it to your needs.

Table E-1 Usage Notes and Examples for HTML Elements

HTML Element Usage Notes and Examples

Text

Any HTML tags can be used to control the format of the text. The following HTML tags are examples of some of the formatting you can apply.

  • To center the text in the section:

    <CENTER>Centered Text</CENTER>

  • To make the text bold:

    <B>Bold Text</B>

  • To set font size and color:

    <FONT SIZE="4" COLOR="red">Red Text</FONT>

  • You can also combine tags for additional effects:

    <CENTER><B><FONT COLOR="red">Bold Centered Red Text</FONT></B></CENTER>

Active-X object

The Active-X object must be self-contained and supported by the browser. Paste or type the object into the HTML text window, ensuring that you include the beginning and ending tags <object...> and </object>.

JavaScript and VBScript

The script must be self-contained and supported by the browser. Paste or type the script into the HTML text window, ensuring that you include the beginning and ending tags <script> and </script>.

Specify the script language in the opening <SCRIPT> tag, either <SCRIPT LANGUAGE="javascript"> or <SCRIPT LANGUAGE="vbscript">.

Audio

Ensure that you know where the audio clip is located. If the audio clip is for use in a shared environment, then it must be located on a network drive that is accessible to all users. Use the HTML tag <EMBED> to add audio in the dashboard. The following HTML code is an example:

<EMBED SRC="audio" AUTOSTART="true" LOOP="true" HIDDEN="true"></EMBED>

where "audio" is the location and name of the audio clip.

Note: You might need to adjust the HTML for the browser.

The following HTML tags are examples of the <EMBED> tag.

  • To add an audio clip located on the hard drive, specify the following HTML code:

    <EMBED SRC="c:\mycomputer\MIDIfiles\wakeup.mid" AUTOSTART="true" LOOP="true" HIDDEN="true"></EMBED>

  • To add the same audio clip from a shared location on the Web server, specify the following HTML code:

    <EMBED SRC="/DashboardFiles/wakeup.mid" AUTOSTART="true" LOOP="true" HIDDEN="true"></EMBED>



Action Options dialog: Invoke Action tab

Use this tab of the "Action Options dialog" to:

For more information, see:

Components

Run Confirmation

Use this box to specify whether to display a confirmation prompt to users when they run the action. The confirmation prompt includes the text that you enter, a Yes button to run the action, and a No button to cancel the running of the action.

Select this box to display a confirmation prompt and then enter the text of the confirmation prompt in the field to the right. Deselect this box to not display a confirmation prompt.

Dialog Title

Use this box to customize the title of the dialog that is displayed to users when they must supply action parameter values.

Select this box to customize the title and then enter the title in the field to the right. Deselect this box to use the default title Invoke Action.

Action Help Text

Use this box to specify the text of the dialog that is displayed to users when they must supply action parameter values.

Select this box to specify the text and then enter the text in the field to the right. Deselect this box to use the default text Enter the values for action parameters and execute.

To embed a URL link within the text, use the token @{URL}. The URL link is substituted for the token.

Link URL

Use this box to specify whether to display a URL link below or within the text of the dialog that is displayed to users when they must supply action parameter values. This enables you, for example, to display a link that navigates to a URL that provides more information about the action being executed.

Select this box to display a URL link below or within the text and then enter the URL in the box to the right. If the @URL token is embedded in the text, the URL (or URL label if provided) is displayed within the text. If the token is not embedded in the text, then the URL (or URL label if provided) is displayed beneath the text.

Deselect this box to not display a URL below or within the text.

Label

Use this field to enter the text to display for the URL link.

Execute Button Text

Use this box to customize the name of the button that is shown on the dialog that is displayed to users when they must supply action parameter values, and that users click to execute the action when they have supplied parameter values.

Select this box to customize the name of the button and then enter the name in the box to the right. Deselect this box to use the default value Execute.

Open In New Window

This box is available only for actions that navigate to related content, such as Navigate to a Web Page and Navigate to BI Content actions.

Use this box to specify, for an action link that navigates to related content, whether to open the link in a new browser window or new tab (if the browser supports tabs). Select this box to open the action link in a new browser window or tab. Deselect this box to open the action link in the same browser window or tab.

Note:

The setting you specify for this Open In New Window component determines the default value for the Open Link in New Window box in the "Action Link Properties dialog", but only when you select a named action for the action link that you are adding to a dashboard page.

Successful Invocation Message

This box is not available for some action types.

Note:

For an Invoke a Web Service action, you can use the "Action Options dialog: Action Results tab" to customize a dialog to display information to users about the results of the action, if the action executed successfully.

Use this box to customize the message that is displayed to users when the action is successfully executed.

Select this box to customize the message and then enter the message in the field to the right. Deselect this box to use the default message Action invocation was successful.

Invocation Failure Message

This box is not available for some action types.

Use this box to customize the message that is displayed to users when the action is not successfully executed.

Select this box to customize the message and then enter the message in the field to the right. Deselect this box to use the default message Action invocation was unsuccessful.


Add Application Roles, Catalog Groups, and Users dialog

Use this dialog to select the users, Application roles, and Catalog groups to:

For more information, see:

This dialog is also displayed as:


Add Groups dialog
Edit Groups dialog
Select User dialog

Components

Group Name

Available only when working with Catalog groups. Enter the name to use for this group.

Location

Available only when you are working with catalog object permissions. Displays the catalog location of the object with which you are working.

Available Members

Use this area to:

Click to see effective permissions

Available only when you are working with catalog object permissions. Use this button to add the Permissions column to the Available Members list. This column displays the permissions that the corresponding Application role, Catalog group, or user would have if you add them to the object for which you are assigning permissions. The effective permissions that display in the table are determined by the membership that the Application role, Catalog group, or user has in the other roles, groups, and users previously added to the Permissions dialog. For example, suppose that you have a catalog object called Report1 and you grant the BIAdministrator Application role the Full Control permission. Then you access the Add Application Roles, Catalog Groups, and User dialog to search for and add User A to the object's permission list. Since User A belongs to the BIAdministrator role, the effective permissions that displays for User A is Full Control.

Search Binoculars

Use this button to show and hide the Search area within the Available Members area.

Search area

Use this area to search for users, Application roles, and Catalog groups.

To initiate a search, enter the string for which you want to search in the Name field; select either Application Roles, Catalog Groups, Users, or All and click the Search button. The results are displayed in the Available Members list.

Shuttle

Use these buttons move accounts between the available and selected areas.

Selected Members

Use this area to view the accounts that you have selected from the Available Members area and moved to the Selected Members area.

Set Permission to

Available only when you are working with catalog object permissions. Use this box to select the permission for the accounts that are listed in the Selected Members area. For more information about the options in this list, see "Permission Definitions" and "Permissions Available by Object Type".


Add Columns dialog

Use this dialog to select the attribute or hierarchical column to use as a dimension for the KPI.

Components

List of Columns

Displays the subject area's attribute and hierarchical columns that you can use as dimensions for the KPI. Use this list to select a column.

Related Topics


"Creating or Editing KPIs"

Add Comment dialog

Use this dialog to add new comments to or reply to existing comments attached to initiatives, objectives, and KPIs. (Remember that a comment is associated with a specific point of view.)

For more information, see:

This dialog is also displayed as:


New Comment dialog
Reply dialog

Components

Subject

Use this box to enter the subject of the comment.

Comment

Use this box to enter your comment.

History

This area is not available when the New Comment dialog is displayed from the "Collaboration pane".

Displays any comments that previously have been added to the initiative, objective, or KPI for the current point of view.

To expand or collapse the History area, click the Expand All or Collapse All button.

Notes


Add Dashboard Page dialog

Use this dialog to specify the name and description of the page that you are adding to a dashboard.

For more information, see "Adding New Pages to Dashboards".

Components

Page Name

Use this field to enter a name for the page.

Page Description

Use this field to enter a description for the page.


Add KPI dialog

Use this dialog to provide a label for a KPI usage or to pin (or set) the value of one or more KPI dimensions.

Pinning is optional. Typically, it is best not to pin most of the dimensions so that the data is controlled by the point of view settings. For more information about pinning, see "What Are Dimensions and Pinned Dimension Values?"

You pin values of KPI dimensions, for example, when you add a KPI to one of the following tables:

When you view the KPI, the data displayed is determined by the dimension values that you selected.

This dialog also displays as:


Edit Watchlist Entry dialog

Components

KPI Name

Displays the name of the saved KPI that you are adding (for example, Revenue KPI).

Subject Area

Displays the name of the subject area that contains the KPI dimension or dimensions.

<Dimension>

This box is not available for a dimension whose value has been set in the KPI.

Use this box to specify a dimension value. Consider the following options:

Label

Use this field to enter a user-friendly, descriptive KPI name to display in the watchlist or the Objectives & KPIs table.

Tip:

If you select a specific value for a dimension, rather than the Use Point-of-View option, then enter a label that describes the pinning. For example, if you select Central for the Region dimension, you might enter Sales Central Region.


Add a Related Document dialog

Use this dialog to add links to business intelligence objects and documents that are stored in the Oracle BI Presentation Catalog or web pages that provide additional information about or can be used with the KPI.

Components

Name

Use this field to enter the name of the link that is displayed in the related documents table. The user clicks this link to access the corresponding Web site, document, or business intelligence object.

Type

Use this list to indicate how you want to provide the path to the related document.

Catalog

This field displays if you select Catalog in the Type field.

Displays the location of the business intelligence object that you select from the catalog. To provide a location in this field, click the Browse button to access the "Select an Object from the BI Catalog dialog" and select a catalog object.

Browse

This option is available if you select Catalog in the Type field. Use this button to access the "Select an Object from the BI Catalog dialog" to browse the Presentation Services catalog and choose an object.

Link

This field displays if you select Link in the Type field.

Use to enter or paste the URL of the related object.

Related Topics

"KPI editor: Related Documents page"

"Collaboration pane"


Add/Remove Subject Areas dialog

Use this dialog to add or remove related subject areas from which to select columns.

Note:

In BI Composer, this dialog shows all Subject Areas, not just related ones.

For more information, see:

Components

List of Subject Areas

Displays the primary subject area and any related subject areas that you have permission to access. The primary subject area (which you select when you create a new analysis, a new named filter, or a new dashboard prompt) is always listed first.

A check mark beside a subject area identifies a related subject area that has been added. A grayed-out check mark identifies the primary subject area or a related subject area whose data is currently being used in the analysis, named filter, or column prompt. You cannot remove a primary subject area. You can remove a related subject area only if its data is not currently being used.

Use this list to add or remove related subject areas. Check a related subject area to add it. Deselect a subject area to remove it.


Administration page

Use this page to administer Oracle BI Presentation Services. You perform administration tasks such as managing privileges and metadata for maps.

The functions of the Administration page are described in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition and in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition.

Components

Product Information

Use this collapsible section to see the following information about your installation of Oracle BI EE:

Manage Catalog Groups

Use this link to display the "Administration: Manage Catalog Groups page" in which you manage Catalog groups.

Manage Privileges

Use this link to display the "Administration: Manage Privileges page" in which you view and administer privileges that are associated with various components. Privileges are actions that users have the right to perform.

Manage Sessions

Use this link to display the "Administration: Manage Sessions page" in which you view information about active sessions and about the cache for each analysis.

Manage Agent Sessions

Use this link to display the "Administration: Manage Agent Sessions page" in which you view information about currently active agent sessions that are triggered by Oracle BI Scheduler.

Manage Device Types

Use this link to display the "Administration: Manage Device Types page" in which you create, edit, view or delete device types for use with agents.

Toggle Maintenance Mode

Use this link to turn maintenance mode on or off. You can see the setting of the mode in the Product Information area. When Maintenance Mode is on, users cannot write to the Oracle BI Presentation Catalog.

Reload Files and Metadata

Use this link to reload XML message files, refresh metadata from the Oracle BI Server, and clear caches.

Issue SQL

Use this link to display the "Administration: Issue SQL page" in which you enter a SQL statement to run against the Oracle BI Server.

Scan and Update Catalog Objects That Require Updates

Use this link to display the Scan and Update Catalog Objects That Require Updates page in which you can upgrade objects in the catalog that might be affecting performance. See "Updating Catalog Objects" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition for information.

Manage Map Data

Use this link to display the "Administration: Manage Map Data page" in which you manage layers, background maps, and images.

Manage Marketing Jobs

Use this link to display the Marketing Job Management page in which you manage background jobs and the database cache.

Manage Marketing Defaults

Use this link to display the Manage Marketing Defaults and Contact Planning Rules pages, in which you select the default Campaign Load File Format, the default Global Audience segment and the Profile Dashboard for each Target Level.

Manage BI Publisher

Use this link to display the Administration page for BI Publisher where you can manage BI Publisher users, permissions, jobs, and files and folders.

For information, see Oracle Fusion Middleware Administrator's Guide for Oracle Business Intelligence Publisher.


Administration: Issue SQL page

Use this page to enter a SQL statement to send directly to the Oracle BI Server. This feature is useful for testing the server only. Results are not formatted, and it is not possible to save the SQL statement that you issue here as an analysis.

For more information, see Appendix D, "Logical SQL Reference".

Components

SQL

Use this field to enter a SQL statement to send directly to the Oracle BI Server.

Issue SQL

Click this button to send the SQL statement to the Oracle BI Server.

Logging Level

Use this box to select the Oracle BI Server logging level, from 0 through 7. Each user receives a default logging level during user creation in the BI Server Administration tool. Select Default in this box to specify the use of your default level.

For information on logging levels, see "Viewing and Configuring Diagnostic Log Files" Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Use Oracle BI Presentation Services Cache

Use this box to specify whether to use the Oracle BI Presentation Services Cache. Deselect this box to specify that you do not want the query to use the Presentation Services cache. In general, you should avoid deselecting this box as disabling the cache has potential performance degradation issues.


Administration: Manage Agent Sessions page

Use this page to view information about currently active agent sessions that are triggered by Oracle BI Scheduler.

For more information, see "Monitoring Active Agent Sessions" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Components

Agent Sessions

Displays a table with information about each agent session. You can see details such as the job identifier, the instance identifier, the primary agent, and the day and time at which the agent session was last accessed.

Click the Sort button at the top of various columns to sort the sessions. Click the link in the Primary Agent column to display the agent in the "Agent editor".

Click the Expand button to see the list of agents in that session.

Agents

Displays a table with information about each agent. You can see details such as the path for the agent and its state. The state can be either Created, Populated, or Conditional Request Resolved.

Click the link in the Path column to display the agent in the "Agent editor". Click the Expand button to see the list of recipients for that agent.

Recipients

Displays a table with the name and type of each recipient of the agent.


Administration: Manage Catalog Groups page

Use this page to manage Catalog groups. These groups are for backward compatibility with previous releases (prior to 11g) only.

For more information, see "Working with Catalog Groups" in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition.

Components

Create a New Catalog Group

Use this button to display the "Add Groups dialog", in which you create a new group.

Edit Selected Group

After selecting a group in the list, use this button to display the "Edit Groups dialog", in which you edit an existing group.

Delete Selected Groups

After selecting one or more groups in the list, use this button to delete the groups.

Name

Enter the name of a group that you need and click Search to display a list of groups that match that name. You generally must use this field only when you have a very long list of groups and are having difficulty finding the one that you need.

More Groups

Click this button to display either a list of additional groups or a message box that states that no other groups are available. Groups are displayed in lists of 25.


Administration: Manage Device Types page

Use this page to create, edit, view or delete device types for use with agents. The types that are specified on this page can be selected on the "Create Device dialog" from the "My Account dialog: Delivery Options tab".

For more information, see "Managing Device Types for Agents" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Components

Device Type Name

Displays the names of device types that were previously created.

Category

Displays the category of the device type, such as mobile phone, pager, or handheld device.

Create New Device Type

Click this link to display the "Create New Device Type dialog".

Edit

Click this button to display the "Edit Device Type dialog".

Delete

Click this button to begin the process of deleting the device type. A confirmation dialog is displayed in which you verify the deletion of the device type.


Administration: Manage Map Data page

Use this page to administer maps and data, so that users can create map views. You perform administration tasks such as managing layers and background maps. Click OK when you have finished updating the page, to save your changes.

For more information, see "Administering Maps" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Components

Layers

Use this tab to work with the layers for display on a map.

Background Maps

Use this tab to work with the main maps for use with map views.

Images

Use this tab to specify the images for use with map views. You specify images only if you want content designers to include them as part of formats on the map.

Import

Use the import buttons on each tab to display a dialog in which you can import layers, background maps, or images to the tab.

If a particular tab contains no items, then you can click the text in the nearly empty row to display the appropriate Import dialog.

Edit and Delete

Use the edit or delete button on each tab, after importing a layer, background map, or image to either display a dialog in which you can edit the item or delete it from the tab.

Sort

Use the sort buttons beside Name and Location on each tab to sort the layers, maps, or images.


Administration: Manage Privileges page

Use this page to view and administer privileges that are associated with various components. Privileges control the rights that users have to access the features and functionality of Oracle BI Presentation Services.

For more information, see "Managing Catalog Privileges" in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition.

Components

Privilege Table

Use this table to:


Administration: Manage Sessions page

Use this page to view information about active sessions and about the cache for each analysis. See Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition for information on active sessions.

Components

Sessions area

Displays the total number of active sessions. Also displays a table that includes the following information about sessions that have been created for users who have logged in:

Field Description

User ID

The name that the user entered when logging in.

Host Address

The name or IP address of the computer that initiated the HTTP connection to the Web server. This could be a user's PC, a handheld device, a firewall, and so on.

Session ID

A unique identifier assigned by Presentation Services for each client session.

Browser Info

Information about the browser from which the user logged on.

Logged On

The time stamp on which the user logged on.

Last Access

The time stamp of the last activity for this user on Presentation Services. This can be any kind of activity on the system, such as switching from one dashboard page to another.


Cursor Cache area

Displays a table that includes the following information about each analysis:

Field Description

ID

The unique internal cache identifier for this entry.

User

The name of the user who ran the analysis and last placed it into the cache. If two IDs are shown, then the second ID is impersonating the first. For example, the entry lhurley/administrator means that the Administrator account logged on and impersonated lhurley. This can happen when Oracle BI Scheduler starts an agent on someone's behalf. Oracle BI Scheduler logs on and impersonates that user so security and content filters still apply.

Refs

The number of references to this entry since it was placed into the cache.

Status

The status of the analysis that is using this cache entry:

  • Starting — The analysis is starting to run.

  • Running — The analysis is currently running.

  • Finished — The analysis has finished.

  • Queued — The system is waiting for a thread to become available so the analysis can be processed.

  • Canceling — The application is in the process of canceling the analysis.

  • Error — An error was encountered during the processing or running of the analysis. Look in the Statement column for information about the error.

Time

The time taken to process and run the analysis, displayed in one-second increments. A value of 0s (zero seconds) indicates that the analysis took under 1 second to complete.

Action

The following links that you can click to affect the analysis:

  • Cancel — Terminates the analysis. Is displayed for in-progress analyses. The user running the analysis receives an informational message indicating that the analysis was canceled by an administrator.

  • Close — Clears the cache entry associated with this analysis. Is displayed for completed analyses.

  • View Log — Displays the entry in the nQQuery.log file for this analysis (if logging is turned on for this user). This file logs query activity on the system at the individual user level.

    Query logging is turned off by default. It can be enabled for individual users at different logging levels. The administrator can use the Identity Manager to enable logging for a user.

    You can also view the nQQuery.log file (located by default in the Log directory in the Oracle Business Intelligence installation directory) using a text editor such as Windows Notepad. The administrator determines the maximum size of the nQQuery.log file by setting the USER_LOG_FILE_SIZE parameter in the NQSConfig.INI file.

Last Accessed

The time stamp of the last time the cache entry for this analysis was used to satisfy an analysis.

Statement

The SQL statement that was issued for the analysis; or if the analysis resulted in an error, information about the nature of the error.

Information

Usage tracking information (for example, what analysis contained the query).

Records

The number of records in the result set that have been seen (for example, 50+ to indicate that 50 records have been seen but there are additional records to be fetched or 75 to indicate that 75 records have been seen and there are no more records to be fetched).


Cancel Running Requests

Use this button to cancel all requests that are running for analyses.

Close All Cursors

Use this button to close all cursors, which removes all information in the Cursor Cache table.

Notes

Use the arrow button beside each column heading to sort the table by that value.


Advanced SQL Filter dialog

Use this dialog to edit the SQL code that is generated for a column filter.

For more information, see "Creating and Editing the SQL Statements for a Column Filter in an Analysis".

Components

SQL

Use this field to modify the SQL WHERE clause to be used as a filter.

For descriptions of SQL clauses, see Appendix D, "Logical SQL Reference".

Related Topics


"Creating or Editing Column Filters"

Advanced Ticker Options dialog

Use this dialog to specify additional options for a scrolling ticker.

For more information, see

Components

# of Loops

Use this field to enter the number of times that the results scroll. The default is an infinite number of times.

You must specify a whole number.

Scroll Amount

Use this field to enter the number of pixels between successive redraws of the results.

Scroll Delay

Use this field to enter the number of milliseconds between successive redraws of the results.

Background Color

Use this field to enter the color to use for the background. Depending on what the browser supports, you can enter a color name, such as yellow or blue, or use the 6-digit hexadecimal format, such as #AFEEEE for pale turquoise. (You can omit the number sign character from the hexadecimal format.)

Additional Marquee Attributes

Use this field to enter other marquee options that the browser might support, such as ALIGN="top | middle | bottom" to align the ticker to the top, middle or bottom of the text around it. You can also add HTML to further customize the look of the ticker.


Agent editor

Use this editor to create or edit an agent.

For more information, see:

Components

Overview

Displays a summary of the current settings for the agent. Use the Plus and Minus buttons to expand and collapse this summary.

General

Use the "Agent editor: General tab" to specify the priority of the content that the agent is to deliver and how to send the delivery content

Schedule

Use the "Agent editor: Schedule tab" to specify whether the agent is to be run based on a schedule, how often it runs, and when its running is to start and end.

Condition

Use the "Agent editor: Condition tab" to specify whether the agent always delivers its content and executes its actions, or conditionally delivers its content and executes its actions.

For more information about conditions, see Chapter 9, "Working with Conditions."

Delivery Content

Use the "Agent editor: Delivery Content tab" to specify the content to deliver with the agent, such as a dashboard page or a saved analysis.

Recipients

Use the "Agent editor: Recipients tab" to specify who is to receive the delivery content of the agent and who is allowed to subscribe to the agent.

Destinations

Use the "Agent editor: Destinations tab" to specify where the content is to be delivered.

Actions

Use the "Agent editor: Actions tab" to specify one or more actions to execute when the agent finishes.

For more information about actions, see Chapter 10, "Working with Actions."

Toolbar

The toolbar contains the following buttons:


Agent editor: Actions tab

Use this tab of the "Agent editor" to specify one or more actions to execute when an agent finishes.

You can specify actions to execute under the following circumstances:

For more information, see:

Components

Agent Condition True or No Condition Exists

Use this area to specify one or more actions to execute only if the agent condition evaluates to true or if there is no condition associated with the agent.

Agent Condition is False

This area is enabled only when a condition has been specified for the agent. See "Agent editor: Condition tab".

Use this area to specify one or more actions to execute only if the agent condition evaluates to false.

Invoke per Row

This box is enabled only when a condition has been specified for the agent. It is not available for Invoke Server Script actions, Invoke Agent actions, or actions for which one of the parameters is a result set mapping.

Use this box to specify whether to execute the action for each row returned by the condition. Select this box to execute the action for each row. Deselect this box to execute the action only once, regardless of the number of rows returned.

Add New Action

Use this button to display the "Create New Action dialog", where you create a new action.

Add Existing Action

Use this button to display the "Select Existing Action dialog", where you select an existing action.

Edit Action

Use this button to display the "Edit Action dialog", where you edit the selected action. For inline actions, you can edit the action definition. For named actions, you can edit only parameter values.

Delete Action

Use this button to delete an action.


Agent editor: Condition tab

Use this tab of the "Agent editor" to specify whether an agent always delivers its content and executes its actions, or conditionally delivers its content and executes its actions.

To determine whether the agent delivers its content and executes its actions, you use a condition. (For more information on conditions, see Chapter 9, "Working with Conditions.")

For more information, see:

Components

Settings

Use this box to select one of the following options:

Create

Use this button to display the "Create Condition dialog", where you create an inline condition.

Browse

Use this button to display the "Select Condition dialog", where you select a named condition.

Edit Condition

This button is available only if you created an inline condition.

Use this button to display the "Edit Condition dialog", where you edit an inline condition. (You cannot edit named conditions.)

Customize

This button is available only if you selected a named condition that is based on an analysis that includes one or more prompted filters.

Use this button to display the "Customize Condition dialog", where you can customize the condition.

Test Condition

Use this button to test whether the condition evaluates to true or false.

Save To Catalog

This button is available only if you created an inline condition.

Displays the "Save As dialog", where you save the condition to the catalog as a named condition.


Agent editor: Delivery Content tab

Use this tab of the "Agent editor" to specify the content to deliver with the agent, such as a dashboard page or a saved analysis. You can also specify:

For more information, see:

Components

Subject

Use this field to enter the subject line for the agent.

Content

Use this box to select the type of content to deliver:

Browse

Use this button to display the "Choose Delivery Content dialog", where you select the content.

Customize

(This button is not available if you have specified Condition Analysis as the delivery content. Instead, the customizations specified on the Conditions tab are used.)

Use this button to display the "Customize Delivery Content dialog", where you customize the content to be delivered.

Clear

Use this button to remove content previously selected.

Format

Use this box to select the format in which to deliver the content. The format options depend upon the type of delivery content. The format options are:

Delivery

Use this area to select whether to deliver the content directly or as an attachment:

Attachment Note

Use this field to enter a text message to provide context for the agent attachment.

If Condition is False

Use this area to specify whether to deliver a text message to recipients when there is no agent content to deliver to them. To deliver a text message, select Deliver this Message and then enter the text message to be delivered.

Notes


Agent editor: Destinations tab

Use this tab of the "Agent editor" to specify where content is to be delivered.

For more information, see:

Components

Home Page and Dashboard

Use this box to specify whether content is to be delivered to the Home page and dashboard pages.

Devices

Use this option to specify whether content is to be delivered to specified devices. If you select this option, then you must select one of the following options:

Oracle BI Server Cache (For seeding cache)

This option is available only for administrators who have been granted the Manage Catalog Groups privilege.

Use this option to specify whether to seed the cache.

Administrators can create Server cache for individual users. The cache seeding operation enables administrators to run analyses on dashboard pages or analyses that are stored in the catalog, and to create a Server cache. This speeds up response time for users when they actually run the analyses on the dashboards. If data exists in the cache for a given analysis, then the data is deleted and refreshed when the agent runs.

The cache for the analysis or the dashboard page is created at the appropriate schedule for the indicated set of users.

Note:

To have the cache created for each user, select the Run As Recipient or Specified User box in the General tab.

Generally, if you are using the analysis that you have specified as the content for this agent to seed the cache, then you do not select any other user destinations (such as Email).


Agent editor: General tab

Use this tab of the "Agent editor" to specify the priority of the delivery content that an agent is to deliver and how to generate the delivery content.

For more information, see:

Components

Priority

Use this option to specify the priority of the delivery content — High, Normal, Low. The priority works with the delivery profile for a user to determine the destination for delivery content of different priorities.

For more information on delivery profiles, see "What Are Devices and Delivery Profiles?" and "Configuring Your Devices and Delivery Profiles".

Run As

Use this option to specify how to generate the delivery content (that is, what user to run the query as):

Created by

This information is displayed when the agent has been saved.

Displays the name of the person who created the agent.

Last Modified

This information is displayed when the agent has been saved.

Displays the date and time when the agent was last modified.

Description

This information is displayed when the agent has been saved.

Displays the description of the agent that was provided when the agent was saved.

You can edit the description of the agent by navigating to the agent on the "Catalog page" and using the Properties option on the More menu.


Agent editor: Recipients tab

Use this tab of the "Agent editor" to specify who is to receive the delivery content of the agent and who is allowed to subscribe to the agent.

For more information, see:

Components

Select Recipients

Use this area to view and specify who is to receive the delivery content of the agent.

To:

Note:

When a user subscribes to and customizes an agent, if you then select the same user as a recipient, then the user's customizations are lost when the agent is next run.

Get Recipients from the Request Used in the Agent Condition

This box is enabled only if you have specified a condition that is based on an analysis for the agent. In addition, you must include the recipient information in the conditional result set (that is, you must include a column that contains who the recipient should be for each row).

Use this box to specify whether recipients are to be determined dynamically from the results of a conditional analysis. Select this box to have recipients determined dynamically from the results of a conditional analysis. Deselect this box to have the recipients determined from the Select Recipients area.

Note:

If you select the option to allow the recipients to be determined from the results of a conditional analysis and choose to show only relevant rows to each user, then it is assumed that you want the results of the conditional analysis set as the delivery content in the "Agent editor: Delivery Content tab". If the content has been set to something else (through clicking Clear or Browse), then a message is displayed asking if you want to update the delivery content to be the results of the conditional analysis. Click Yes to proceed and update the delivery content, or No to retain the current delivery content. If you click No, then the recipients will still be determined from the conditional analysis, but users will receive all content, and not only the content that pertains to them.

Column Containing Recipients

This box is available only if the Get Recipients from the Request Used in the Agent Condition box is selected.

Use this box to select the column in the conditional analysis that contains the desired recipients.

2nd Column Containing Recipients (optional)

This box is available only if the Get Recipients from the Request Used in the Agent Condition box is selected.

Use this box to optionally select an additional column in the conditional analysis that contains desired recipients.

Only Return Rows Relevant to the User Running the Agent

This box is available only if the Get Recipients from the Request Used in the Agent Condition box is selected.

Use this box to specify whether only rows in the results that are relevant to the user running the agent are sent in the delivery content. Select this box to send only rows that are relevant to the user running the agent. Deselect this box to send all rows.

Publish for subscription

Use this box to specify whether the agent is to be published so that users can subscribe. Note the following:

For more information on how to subscribe to agents, see "Subscribing to Agents".

Allow Subscribers to Customize Agent

This box is available only when the Recipient box is selected on the "Agent editor: General tab".

Use this box to specify whether subscribers can customize their subscription of the agent, for example, by providing values for a prompted filter associated with an analysis.

For more information on how to customize an agent subscription, see "Customizing Your Agent Subscriptions".

Agent Subscribers

Use this area to view and specify who is allowed to subscribe to this agent. In the list of agent subscribers, the Name column identifies the users, Application roles, and Catalog groups that are allowed to subscribe to the agent and the Currently Subscribed column identifies (with a check mark) those users, Application roles, and Catalog groups that are currently subscribed.

To:


Agent editor: Schedule tab

Use this tab of the "Agent editor" to specify whether the agent is to be run based on a schedule, how often it runs, and when its running is to start and end.

Agents can execute based on a specified schedule. You can define a starting date and time for the agent, a recurrence schedule, and an ending date.

You can also create a nonscheduled agent. This is useful when you want to create an agent that runs only as part of an agent chain, or an agent that is initiated by an external process.

For more information, see:

Components

Enabled

This box is disabled when the Frequency box is set to Never.

Use this box to specify whether to enable the agent to run as scheduled. This is useful if you have defined a schedule for an agent but find you want to stop it for a certain period of time.

You also can enable and disable an agent's schedule from the "Catalog page". See "Disabling and Enabling Agents' Schedules".

Frequency

Use this box to select one of the following options to specify how often the agent runs:

Start

Use this box to specify the date and time to start the agent and the time zone. Click the Select Date and Time button to display the Select Date and Time dialog, where you select the date, time, and time zone.

Re-run Agent Every

Use this box to specify whether to run the agent multiple times within a day. Select this box to run it multiple times within a day. Then enter the interval between executions (in minutes) and specify the time to stop the repetition by clicking the Select Time button to display a dialog in which to select the time.

Deselect this box to run it one time within the day.

End

Use this area to specify when to end the running of the agent:

Notes

When you select the date and time, for time zones where daylight savings applies, the time zone reflects the daylight savings time. For example, if, during the summer months, you select (GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London, this means BST (British Summer Time).


Alert dialog

Use this dialog to:

For more information, see:

Components

Alert Information

Displays the following information:

Alert Content

Displays the content of the alert.

Clear Alert

Use this button to delete the alert.


Alerts dialog

Use this dialog to:

For more information, see:

Components

Alerts

Displays a list of your alerts, including the name, priority (High, Normal, or Low), last delivery date and time, and number of occurrences for each alert.

To view the latest occurrence of an alert, click its name. The "Alert dialog" is displayed, where you can view information about the alert and the content of the alert. You can also edit and run the agent that generated the alert.

Each alert contains a toolbar that displays when you hover over the alert name. The toolbar contains the following buttons:

Subscribe to RSS feed

Displays the browser's page that lets you subscribe to an RSS feed. Using this page, you can subscribe to an Oracle BI Alerts feed (that is, the channel that contains the delivered agents).

Clear All

Use this button to delete all alerts. When you clear all alerts, the Alerts! button in the global header and the Alerts area on the "Home page" are no longer displayed.

Refresh

Use this button to refresh the list of alerts.


Analysis editor

Use this editor to create or edit an analysis. Analyses let you explore and interact with information by visually presenting data in tables, graphs, pivot tables, and so on. You can include the views that you create in an analysis for display in dashboards.

For more information, see:

Components

Criteria

Use the "Analysis editor: Criteria tab" to specify the criteria for an analysis, including columns and filters. You can work with selection steps after displaying the "Selection Steps pane".

Results

Use the "Analysis editor: Results tab" to create different views of the analysis results such as graphs, tickers, and pivot tables. You can also work with selection steps.

Prompts

Use the Analysis editor: Prompts tab to access the "Prompt editor" to create prompts that allow users to select values that dynamically filter all views within the analysis or all analyses on a dashboard.

Advanced

Use the "Analysis editor: Advanced tab" to examine or edit the XML code and logical SQL statement that is generated for an analysis.

Toolbar

The toolbar includes the following buttons:

Related Topics

"What Is the Analysis Editor?"


Analysis editor: Advanced tab

Use this tab of the "Analysis editor" to examine or edit the XML code and logical SQL statement that is generated for an analysis. This tab is for use only by advanced users and developers who have the appropriate privileges. See "Examining the Logical SQL Statements for Analyses" for additional important information on working with this tab.

For more information, see:

Components

Referencing the Results

Use this area at the top of the tab to access links that are identified with the name of the analysis and offer the following functions:

These links execute for the analysis as it is currently saved. If you update the analysis later, then the links are also changed for those updates. The links are not visible if you have not yet saved an analysis.

Analysis XML

Use this area to view and modify the XML code for an analysis.

Caution:

Analyses are stored in the Oracle BI Presentation Catalog in XML format. If you change the XML code, then you change the analysis in the catalog.

Use the following components in this area:

SQL Issued

Use this read-only box to view the SQL statement that is sent to the Oracle BI Server when the analysis is executed.

New Analysis

Click this button to display the "Analysis Simple SQL Statement dialog", in which you create a new analysis using the SQL statement from the current analysis as the starting point. Any hierarchical columns, selection steps, groups, or formatting that are specified in the current analysis are removed before the dialog is displayed. You can edit the SQL statement in this dialog.

Advanced SQL Clauses

Use this area to modify the SQL statement for an analysis. You can include additional SQL clauses and change the subject area or the FROM clause for certain analyses. All but one of these features are disabled for analyses that contain hierarchical columns, member selections, or groups. Only the ability to specify a prefix is enabled.

Use the following components in this area:

Apply SQL

Click this button to apply the:

Note:

Use care when clicking this button. When you do, Oracle BI EE essentially creates a new analysis based on the SQL statement that you have added or modified. Therefore, you lose all views, formatting, and so on that you had previously created for the analysis. The XML code is also modified for the new analysis.

Query Performance

Use this area to set the following components:

Apply

Use this button to apply the settings for the options in the Query Performance area.

Notes


Analysis editor: Criteria tab

Use this tab of the "Analysis editor" for:

Common Components

Subject Areas

Use the "Subject Areas pane" to select the columns and hierarchy levels for an analysis and to work with subject areas.

Catalog

Use the "Catalog pane" to drag and drop objects from the catalog to add to the analysis.

General Components

Use the following components when you are not creating a direct database request.

Selected Columns

Use the "Selected Columns pane" to modify the columns and hierarchy levels that have been selected for an analysis.

Filters

Use the "Filters pane" to create new filters for an analysis.

Selection Steps

Use the "Selection Steps pane" to create and modify steps for data selections. This pane is not visible until you click the button on the toolbar to display it.

Toolbar

The toolbar contains the following buttons:

Direct Database Request Components

Use the following components when you create a direct database request.

For more information, see "Working with Direct Database Requests".

Connection Pool

Enter the name of the connection pool for the database that is defined in the physical layer of the Oracle BI Administration Tool. A sample name is sql_samples.

For information about connection pools, see Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

SQL Statement

Enter the SQL statement to send directly to the database. Oracle BI Server security rules for data are bypassed and cannot be applied when you send a direct database request.

The statement that you execute is affected by the user name that is specified for this connection pool in the Oracle BI Administration Tool. You might find that not all columns from the database are returned to you, if the specified user name is not permitted to see them.

Validate SQL and Retrieve Columns

Click this button to validate the SQL statement and retrieve any columns that you have specified in the request. The columns are displayed in the Result Columns area.

If any errors are returned from the database, then you see them in the area below this button. See Oracle Database SQL Language Reference for information on resolving any errors.

Bypass Oracle BI Presentation Services Cache

Use this box to specify whether to use the Oracle BI Presentation Services Cache. Select this box to specify that you do want the request to use the Presentation Services cache. In general, you should avoid selecting this box as enabling the cache has potential performance degradation issues.

Result Columns

Use this area to work with the columns that are returned, if any, from the valid SQL statement. This area includes each column name and data type with the following options:

To change which columns that are returned, modify and validate the SQL statement.


Analysis editor: Results tab

Use this tab of the "Analysis editor" to create different views of the analysis results such as graphs, tickers, and pivot tables. For more information, see "Displaying the Results of Analyses".

Components

Subject Areas

Use the "Subject Areas pane" to select the columns and hierarchy levels for an analysis and to work with subject areas.

Catalog

Use the "Catalog pane" to display objects from the catalog to use with views.

Views

Use the "Views pane" to create and modify views to work with analyses.

Compound Layout

Use the "Compound Layout" to assemble different views for display on a dashboard and to create additional layouts.

Selection Steps

Use the "Selection Steps pane" to create and modify steps for data selections.

Toolbar

This toolbar contains the following buttons:


Analysis Properties dialog

Use this dialog to specify properties for an analysis.

For more information, see "Specifying the Criteria for Analyses".

Components

Results Display

Use the "Analysis Properties dialog: Results Display tab" to specify how results that are returned from an analysis are to be handled.

Interactions

Use the "Analysis Properties dialog: Interactions tab" to specify which interactions (for example, Drill) are available for an analysis when you right-click in a table view or pivot table view at run time.

Data

Use the "Analysis Properties dialog: Data tab" to specify how data is to be handled in an analysis.


Analysis Properties dialog: Data tab

Use this tab of the "Analysis Properties dialog" to specify how data is to be handled in an analysis.

Components

Display of Columns Added in Criteria Tab

Displays options to specify how columns that are added to an analysis from the "Analysis editor: Criteria tab" after displaying the analysis results are handled:

Placement of Added Members

Use the buttons within this area as follows, to control how members are added to hierarchical columns in this analysis using selection steps:

For more information on selection steps, see "Creating Selection Steps".


Analysis Properties dialog: Interactions tab

Use this tab of the "Analysis Properties dialog" to specify which interactions (for example, Drill) are available for an analysis when you right-click in a table view or pivot table view at run time.

Note that the administrator can specify defaults for these right-click interactions. For more information, see "Manually Configuring for Interactions in Views" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Components

Views Run-time Options

Use this area to select whether, when you right-click in a table or pivot table at run time, all interactions or only one or more of the following interactions are available:


Analysis Properties dialog: Results Display tab

Use this tab of the "Analysis Properties dialog" to specify how results that are returned from an analysis are to be handled.

Components

No Results Settings

Use this box to select the type of message (default or custom) that is displayed if no results are returned from an analysis. You might see the message, for example, if you have a very restrictive filter placed on the columns in the analysis. You do not see the custom message if you simply create the analysis and include no columns.

Header

Edit the header to use for the custom message. Available only when you specify a custom message for No Results Settings.

Message

Edit the message to use for the custom message. Available only when you specify a custom message for No Results Settings.

View for Text Delivery

Use this box to manually control which compound layout, including its associated views, is sent to a particular destination. For more information, see "Customizing Views for Delivery to Agent Users".


Analysis Simple SQL Statement dialog

Use this dialog to enter simple SQL statements that you can use to easily create an analysis. This dialog is displayed from the following places:

For information, see "Creating New Analyses" and "Examining the Logical SQL Statements for Analyses".


Analytics pane

Use this pane as follows:

For more information, see:

This pane is part of the "Scorecard editor: KPI Details tab", the "Scorecard editor: Initiative Details tab" and the "Scorecard editor: Objective Details tab".

Components for KPI Details

History

Displays a graph that presents actual values and target values that enable you to view KPI performance over time or using dimensions selected from the following:

The graph shows multiple time periods only if trending was enabled in the KPI's definition.

Parent Initiative or Parent Objective

Displays the name of the parent initiative or the parent objective whose progress is measured by the KPI.

Actions

Displays the action links associated with each KPI performance level or range. Use to perform actions in response to the KPIs current performance state. (You add or edit the action links in the KPI definition. See "Adding Actions to KPIs" and "Editing Actions and Action Links Added to KPIs".)

Performance

Displays the following KPI values and data:

Indicator Type

Displays the following options to indicate whether the performance of the KPI drives other KPIs, or is affected by the performance of other KPIs, or other data or processes:

Perspective

Displays the perspectives available for the scorecard. Select the perspective with which to align the initiative or objective. For example, you might align an objective for Increased Product Sales with the Financial perspective.

For more information on perspectives, see "What Are Perspectives?"

Dimensionality

Displays the dimensions associated with the KPI. Use this area to pin the dimensions.

Pinning is optional. Typically, it is best not to pin most of the dimensions so that the data is controlled by the point of view settings. For more information about pinning, see "What Are Dimensions and Pinned Dimension Values?"

To pin a dimension, click the down-arrow button to the right of the dimension and select one of the following options:

Components for Initiatives and Objectives

Score

Displays the score for the initiative or objective in a gauge and numerically.

For more information on scores, see "Understanding Initiative or Objective Performance Assessment".

Parent Initiative or Parent Objective

Displays the name of the parent initiative (for an initiative) or the parent objective (for an objective).

Start Date

This box is available only for initiatives.

Use this box to specify the date on which the initiative is to begin and the time zone. To select a date, click the Select Date button to display the Select Date dialog.

Due Date

This box is available only for initiatives.

Use this box to specify the date on which the initiative is due and the time zone. To select a date, click the Select Date button to display the Select Date dialog.

Completion Date

This box is available only for initiatives.

Use this box to specify the date on which the initiative was actually completed and the time zone. To select a date, click the Select Date button to display the Select Date dialog.

Children

Displays for the initiative or objective:

If there is at least one child objective, initiative, or KPI for a particular status, the status name is a hyperlink that displays the "Scorecard editor: Breakdown tab", showing the child object or objects.

Descendants

Displays for the initiative or objective:

If there is at least one descendant objective, initiative, or KPI for a particular status, the status name is a hyperlink that displays the "Scorecard editor: Breakdown tab", showing the descendant object or objects.

Perspective

Displays the perspectives available for the scorecard. Select the perspective with which to align the initiative or objective. For example, you might align an objective for Increased Product Sales with the Financial perspective.

For more information on perspectives, see "What Are Perspectives?"

Assessment Formula

Displays the following options to specify the rule to be used to assess the overall performance of the initiative or objective:

Indicator Type

Displays the following options to indicate whether the performance of the objective drives other objectives, or is affected by the performance of other objectives or other data or processes:

Priority

This box is available only for initiatives.

Displays the options High, Medium, and Low to identify the importance and urgency of an initiative.

Actions

Displays the action links that have been added to an initiative or objective, including the text of the action links, the actions associated with the links, and under which states of the objectives or initiatives the action links are enabled.

Use this area to view and manage action links:

Initiatives & KPIs or Objectives & KPIs

Use this table to view and manage:

See "Initiatives & KPIs table; Objectives & KPIs table; Objectives, Initiatives & KPIs table; New KPI Watchlist table; and Breakdown table".


Initiatives & KPIs table; Objectives & KPIs table; Objectives, Initiatives & KPIs table; New KPI Watchlist table; and Breakdown table

The Initiative and KPIs table "Analytics pane" of the "Scorecard editor: Initiative Details tab" and the "Scorecard editor: Objective Details tab", the Objectives & KPIs table, the Objectives, Initiatives & KPIs table, the New KPI Watchlist table, and the Breakdown table display initiatives, objectives, and KPIs as follows:

These tables contain the following components:


Status window

The Status window shows the following information:

Use this window to view and manage this information as follows:


Apply Saved Filter dialog

Use this dialog to specify how to add a named filter to the analysis with which you are working.

For more information, see:

This dialog is also displayed with the following name, with fewer options that are read-only:


View Saved Filter dialog

Components

Clear all existing filters before applying

Use this option to remove all existing filters from the analysis before adding the named filter.

Apply contents of filter instead of a reference to the filter

Select this option to add the filter as an inline filter. The filter is added to the "Filters pane", where you can edit it. Any changes that you make to the filter are saved with the analysis, but not to the catalog.

Deselect this option to add the filter as a named filter. Deselecting this option adds a reference to the filter (that is, add the filter as a named filter). The filter is added to the Filters pane, where you can view it but not edit it.


Archive dialog

Use this dialog to specify if and how you want to apply the existing folder or object permissions and if you want to include timestamps when preparing the archive file. See "What is Archiving?"

Components

Keep Permissions

Use this option to maintain the object or folder's existing permissions. If you do not select this option, then the archiving process does not include any permissions. Upon unarchiving, the system assigns the parent folder's permissions to all of the objects and folders.

Keep Timestamps

Use this option to maintain the CreationTime, LastModified, and LastAccessed timestamps assigned to the object or folder. Upon unarchiving, the LastModified timestamp is updated to indicate the time at which the object or folder is unarchived. If you select this option, the Old option in the Paste Overview area of the Preferences dialog is available when unarchiving. You use the Old option to overwrite existing catalog items that are older than the catalog items in the archive.

If you do not select this option, then the archiving process does not include timestamp information and the Old option in the Paste Overview area of the Preferences dialog is not available.

Notes

Before you archive, ensure that the Archive\Unarchive privilege is assigned to your account.


Bar Graph (Layer) dialog

Use this dialog to specify the formatting of bar graphs on a map view. The bar height varies with metric values. For pie graphs, the slice size varies as a percentage of the whole.

For more information, see "Editing Map Views".

This dialog is also displayed as:


Pie Graph (Layer) dialog

Components

Name

Displays the name of the data column whose values are displayed in graphs on the map and used as their labels.

Name Automatically

Deselect this box to specify that you want to enter the label for the graphs, rather than having the label specified automatically as the column name.

ToolTips

Use this list to select the column whose name is used as the tooltip when you hover over a value of the data column on the map.

Bar Size or Slice Size

Use this list to specify the measure column whose values control the size of the bars or slices, such as Dollars or Units.

Graph Size

Use this box to specify the size in pixels of each graph that is displayed on the map.

Bars or Slices

Use this list to select the attribute column whose values show as bars or slices in the graphs, such as Product or Channel.

For example, you can create pie graphs that have a slice for each Product. The size of the slice depends on the Dollars sold for that Product.


BI Composer wizard

Use this wizard to quickly and easily create, edit, or view an analysis, without the complexities of the "Analysis editor".

The steps of this wizard display the following panels:

For more information, see:

Components

BI Composer train

This train is available only after you select a subject area in the Subject Areas tab and click Create, or select an existing analysis in the Catalog tab and click Edit.

Use the buttons in this train to navigate the steps of the BI Composer wizard. The availability of some buttons depend on your actions. For example:

You can navigate among the enabled steps in any order. For example, from the Highlight step, you can click the Select Views button to navigate back to the Select Views step. You do not have to navigate these steps in order.

Catalog tab

This tab is not available in Oracle BI EE.

Displays the following folders from the Oracle BI Presentation Catalog:

You use this tab to select an existing analysis to edit or view.

For more information on the Oracle BI Presentation catalog, see "What is the Oracle BI Presentation Catalog?"

Reload

Use this button to refresh the objects that are displayed in the Catalog tab.

Subject Areas tab

This tab is not available in Oracle BI EE.

Displays the list of available subject areas. You use this tab to select a subject area from which you want to select columns to create an analysis.

For more information on subject areas, see "What Are Subject Areas and Columns?"

Edit

Use this button to display the "Edit Analysis Analysis_Name: Select Columns panel", where the analysis that is selected in the Catalog tab is available for you to edit.

View

Use this button to display the analysis that is selected in the Catalog tab for viewing.

Create

Use this button to display the "BI Composer wizard -- Create Analysis: Select Columns panel", where you create an analysis using columns from the subject area selected in the Subject Areas tab.

View Area

Displays the analysis that is selected in the Catalog tab for viewing.

Collapse (Restore) Pane

Use this toggle button to collapse and restore a pane. For example, you might want to collapse the Catalog and Subject Areas pane to provide more room for the display of one of the panels, such as the Select Views panel.


BI Composer wizard -- Create Analysis: Select Columns panel

Use this panel of the "BI Composer wizard" to select the columns that are to be included in the analysis. You can also:

For more information, see:

This panel is also displayed as:


Edit Analysis Analysis_Name: Select Columns panel

Components

Subject Area: Subject_Area_Name

Displays the subject area from which to select columns to be included in the analysis.

Use this area to select a column to add to the analysis. To do so, expand the subject area folder that contains the column that you want, select the column, and then click Add.

To manage a subject area folder, right-click the folder to display the following options:

For more information on subject areas and columns, see "What Are Subject Areas and Columns?"

Add

This button is available only if one or more subject areas are available and you have permission to access them.

Use this button to display the "Add/Remove Subject Areas dialog", from which you can add or remove subject areas.

Selected Columns

Displays the columns that have been added to the analysis.

To:

Add

Use this button to add the column selected in the Subject Area: Subject_Area_Name list to the Selected Columns list.

Remove

Use this button to remove the selected column from the Selected Columns list.

Remove All

Use this button to remove all columns from the Selected Columns list.

Up and Down Arrows

Use these buttons to reorder the columns in the list and, thus, change the order of the columns in the analysis.


BI Composer wizard -- Create Analysis: Select Views panel

Use this panel of the "BI Composer wizard" to:

For more information, see:

This panel is also displayed as:


Edit Analysis Analysis_Name: Select Views panel

Components

Title

Use this field to enter the title for the analysis.

Table

Use this box to select the type of tabular view to include in the analysis:

Graph

Use this box to select the type of graph view to include in the analysis:

Layout

Use this box to select the placement of the tabular and graph views in the analysis. The options are:

Preview

Use this box to specify whether to display a preview of the results:

Show how results will look on a dashboard

Use this button to show a fully interactive view where you can page through large result sets, drill, and so on.

Report XML

Use this button to show the XML code for the analysis. This information is helpful for debugging purposes.


BI Composer wizard -- Create Analysis: Edit Table panel

This panel is available only if you have added a tabular view to the analysis using the "BI Composer wizard -- Create Analysis: Select Views panel".

Use this panel of the "BI Composer wizard" to:

For more information, see:

This panel is also displayed as:


Edit Analysis Analysis_Name: Edit Table panel

Components

Rows

This target area is available only for a pivot table.

Displays the columns that are to be shown as rows in a pivot table.

Use this target area to modify the way that data is arranged in the pivot table by moving rows to different target areas.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Columns

Displays the columns that are to be shown as columns in a table or pivot table.

Use this target area to modify the way that data is arranged in the table or pivot table by moving columns to different target areas.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Move To

Displays the following options to move a column to a different target area:

Additional Layout Options

Use this option to display the following target areas Prompt For, Section By, and Excluded.

Prompt For

Displays the columns that are to be displayed as prompts.

Use this target area to move a column to another other target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Section By

Displays the columns that are to be to used to divide the table or pivot table into sections.

Use this target area to move a column to another target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Excluded

Displays the columns that are to be excluded from the view.

Use this target area to move a column to another target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Up and Down Arrows

Use these buttons to reorder the columns in the target areas.

Preview

Use this box to specify whether to display a preview of the results:

Show how results will look on a dashboard

Use this button to show a fully interactive view where you can page through large result sets, drill, and so on.

Report XML

Use this button to show the XML code for the analysis. This information is helpful for debugging purposes.


BI Composer wizard -- Create Analysis: Edit Graph panel

This panel is available only if you have added a graph view to the analysis using the "BI Composer wizard -- Create Analysis: Select Views panel".

Use this panel of the "BI Composer wizard" to:

For more information, see:

This panel is also displayed as:


Edit Analysis Analysis_Name: Edit Graph panel

Components

Subtype

Use this box to select the graph subtype.

Vary Color By

This target area is not available for pie graphs.

Displays the columns for which each column value or column value combination is to be shown in a different color.

Use this target area to modify the way that data is arranged in the graph by moving columns to different target areas (or positions).

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Group By or Points

This target area is named Group By for bar, area, and line-bar graphs, and Points for scatter graphs.

This target area not available for pie graphs.

Displays the columns for which the axis labels are to be clustered into groups. For example in a vertical bar graph whose criteria includes the Region, District, and Dollars column, if this target area contains the Regions column, then the data is grouped by region on the horizontal axis.

Use this target area to modify the way that data is arranged in the graph by moving columns to different target areas (or positions).

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Slices

This target area is available only for pie graphs.

Displays the columns for which each column value or column value combination is to be shown as a separate slice of the pie.

Use this target area to modify the way that data is arranged in the graph by moving columns to different target areas (or positions).

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Pies

This target area is available only for pie graphs.

Displays the columns for which each column value or column value combination is to be shown as a separate pie.

Use this target area to modify the way that data is arranged in the graph by moving columns to different target areas (or positions).

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Move To

Displays the following options to move a column to a different target area:

Additional Layout Options

Use this option to display the following target areas Prompt For, Section By, and Excluded.

Prompt For

Displays the columns that are to be displayed as prompts. Use this target area to move a column to another other target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Section By

Displays the columns that are to be to used to divide the graph into sections. Use this target area to move a column to another target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Excluded

Displays the columns that are to be excluded from the view. Use this target area to move a column to another target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Up and Down Arrows

Use these buttons to reorder the columns in the target areas.

Preview

Use this box to specify whether to display a preview of the results:

Show how results will look on a dashboard

Use this button to show a fully interactive view where you can page through large result sets, drill, and so on.

Report XML

Use this button to show the XML code for the analysis. This information is helpful for debugging purposes.


BI Composer wizard -- Create Analysis: Sort and Filter panel

Use this panel of the "BI Composer wizard" to:

For more information, see:

This panel is also displayed as:


Edit Analysis Analysis_Name: Sort and Filter panel

Components

Expand Sort or Collapse Sort

Use this button to expand or collapse the Sort area.

Sort

Use this area to specify and manage sorting. This area contains the follow components:

Expand Filter or Collapse Filter

Use this button to expand or collapse the Filter area.

Filter

Use this area to specify and manage filters. This area contains the follow components:

Preview

Use this box to specify whether to display a preview of the results:

Show how results will look on a dashboard

Use this button to show a fully interactive view where you can page through large result sets, drill, and so on.

Report XML

Use this button to show the XML code for the analysis. This information is helpful for debugging purposes.


BI Composer wizard -- Create Analysis: Highlight panel

This panel is available only if you have added a tabular view to the analysis using the "BI Composer wizard -- Create Analysis: Select Views panel".

Use this panel of the "BI Composer wizard" to:

For more information, see:

This panel is also displayed as:


Edit Analysis Analysis_Name: Highlight panel

Components

Expand Formatting or Collapse Formatting

Use this button to expand or collapse the Formatting area.

Formatting

Use this area to specify and manage conditional formatting on columns. It contains the follow components:

Preview

Use this box to specify whether to display a preview of the results:

Show how results will look on a dashboard

Use this button to show a fully interactive view where you can page through large result sets, drill, and so on.

Report XML

Use this button to show the XML code for the analysis. This information is helpful for debugging purposes.


BI Composer wizard -- Create Analysis: Save panel

Use this panel of the "BI Composer wizard" to save the analysis with the same name or with a different name. You can also:

For more information, see:

This panel is also displayed as:


Edit Analysis Analysis_Name: Save panel

Components

Analysis Name

Use this field to enter a name for the analysis.

Description

Use this field to enter a description of the analysis.

Save In

Use this area to select the location in which to save the analysis.

To:


BI Publisher Report Properties dialog

Use this dialog to specify the information for adding an Oracle BI Publisher report to a dashboard page.

For more information, see "Adding Oracle BI Publisher Reports to Dashboard Pages".

Components

Embedded Content

Use this button to specify that the report is to be embedded in the dashboard, rather than displaying as simply a link to BI Publisher. This option is selected by default for reports.

For more information about embedded content, see "Adding Content to Dashboards".

Width and Height

Use these fields to specify the width and height of the report on the dashboard, if the report is embedded.

Link

Use this box to specify that a link is to be displayed on the dashboard (rather than embedding the report in the dashboard). The text of the link is the name of the report. By clicking the link, you open the report in BI Publisher.

View Latest Version

Use this box to indicate, for a report that is scheduled, that you want the most recently generated version of the report to be displayed on the dashboard page.


Break dialog

Use this dialog to add page and column breaks to the layout of a dashboard page.

For more information, see "Properties Buttons for Objects".

Components

No Break

Use this option to place the column next to the column that is above it.

Column Break

Use this option to place the column beneath the column that is currently to the left of it (or next to it).

Page Break with Column Break

Use this option to place the column on another page in printed and PDF versions. This option also places the column below the column that it is next to, if you have not selected the Column Break option.


Bubble (Layer) dialog

Use this dialog to specify the formatting of bubbles on a map. Bubble size represents the value of a metric. Bubble location indicates the geographic region. Bubbles, images, and shapes can apply to both polygon layers and point layers. Point layers cannot use a color fill format.

For more information, see "Editing Map Views".

This dialog is also displayed as:


Bubble (Custom Point Layer) dialog
Color Fill (Layer) dialog
Image (Custom Point Layer) dialog
Image (Layer) dialog
Variable Shape (Custom Point Layer) dialog
Variable Shape (Layer) dialog

Components

Name

Displays the name of the data column whose values are displayed as bubbles, color fills, images, or shapes on the map and used as their label.

Name Automatically

Deselect this box to specify that you want to enter the label for the bubbles, color fills, images, or shapes, rather than having the label specified automatically as the column name.

X (longitude) and Y (latitude)

Available only for the custom point layer and only if the Single Column box is not selected. Use this list to select the columns whose values specify the longitude and latitude of the point to represent on the map as a bubble, image, or shape.

You must specify different columns for longitude and latitude. These columns must store longitude and latitude values, values from a coordinate system that can identify a point, or address values that can be converted to longitude and latitude using the ETL system. The column values must adhere to the WGS84 coordinate system.

Single Column

Use this box to indicate that the values from one column specify the coordinates of the points to represent on the map. The column is specified in the Location box.

Location

Available only for the custom point layer and only if the Single Column box is selected. Use this list to select the column whose values specify the longitude and latitude of the point to represent on the map as a bubble, image, or shape. Ensure that the column contains both longitude and latitude values.

Delimiter

Available only for the custom point layer and only if the Single Column box is selected. Use this box to enter the delimiter that is used in the single column that you specified in the Location box that holds the longitude and latitude values, such as a comma. This box has no default values. If you do not specify the proper delimiter, then the format cannot be displayed appropriately on the map.

ToolTips

Use this list to select the column whose name is used as the tooltip when you hover over a value of the data column on the map.

Shape

Available only for shapes. Use this list to select the shape to include on the map. You can select Circle, Triangle, or Diamond.

Vary Size By or Vary Color By or Vary Image By

Use this list to specify the measure column whose values control the images, the color fills, or the size of the bubbles or shapes, such as Dollars or Units. For example, you can vary the color of the shapes by one measure column and the size of the shape by another measure column.

Minimum Size

Available only for bubbles and shapes. Enter the minimum size of the bubbles or shapes.

Maximum Size

Available only for bubbles and shapes. Enter the maximum size of the bubbles or shapes.

Color

Available only for bubbles and shapes. Use this list to select the color for the bubbles or shapes on the map. For bubbles, this box is disabled when you click Vary By Measure. When varying color by measure, you specify a palette of colors that corresponds to the binned values of the measure.

Bin Type

Use this list to select the type of grouping for the values to indicate using images or shapes. You can select one of the following types:

Bins

Use this list to select the number of bins for grouping the values to indicate using color fills, images or shapes. You can select various integers, Quartile (4), or Decile (10). The number of bins that you select corresponds to the number of colors that the map format shows.

Style

Available only for shapes and color fills. Use this list to select the shape or gradient to display. The number of colors in the style depends on the number that is specified for Bins.

Minimum and Maximum

Use these boxes to enter the minimum, maximum, and other values for the bins. You can enter the values only if you select Value Binning for Bin Type. If you select Percentile Binning, then the values are specified automatically.

Label

Enter the labels for the bins. Labeling a bin helps users understand what a particular bin, or bucket, means. A label for the top quartile might say "Top Selling Products" instead of "Top 25%". You can customize these labels, and the map provides automatic bin labels for particular types of data sets (percentage bins).

Image

Available only for images. Use this list to select the images for the bins. Click an image to display the "Select Image dialog" where you select the image for the bin. Images are shown at a latitude and longitude coordinate.

Color

Available only for color fill. Use this list to select the colors for the bins. Click a color to display a dialog where you select the color for the bin.

Allow Dashboard Users to Edit Thresholds

Available only for color fill when Bin Type is set to Percentile Binning or Value Binning. Select this box to display a slider component that enables end users to dynamically adjust threshold values. These adjustments allow users to perform visual analysis on their map data, which is sometimes referred to as "what-if analysis."

If you allow users to edit thresholds and they modify them, then the setting for Bin Type is automatically changed to Value Binning from any other settings.

For information, see "Modifying Thresholds for Formats on a Map View".


Catalog page

Use the Catalog page to locate objects in the catalog and perform tasks specific to those objects. The objects and options that are available to you are determined by your system privileges and the permissions assigned to individual folders and objects.

Use the Catalog page to:

For more information, see:

Components

Folders pane

Use the "Folders pane" to display the catalog as a directory hierarchy or to display only those folders and objects that you created or that you marked as your favorites.

Search pane

Use the "Search pane" to provide search criteria and initiate a catalog search.

Catalog area

Use the "Catalog area" to view the results of your search, open folders to browse content, and initiate tasks specific to an object.

Tasks pane

Use the "Tasks pane" to initiate tasks specific to an object.

Preview pane

Use the "Preview pane" to preview the object that you selected in the Catalog area. This pane is not visible until you click the button to display it.

Toolbar

The buttons that are enabled for the toolbar vary between object types. The toolbar contains the following buttons:

Location

Displays the directory path of a selected object. Use as a way to determine where you are within the directory structure.

Show Hidden Items

Select to display all object-related settings and data such as system privileges, metadata, and cached data. When you select this option, hidden folders, including the following folders, are displayed: _Portal, _Filters, _Prefs, _Alerts, _Agents, and _Delivers.


Catalog area

Use this area to view your search results and browse business intelligence objects and folders. If you use the fully-integrated full-text search, messages will display at the top of the Catalog area indicating the indexing status (indexing makes the objects available to the search) or if you need to refine your search.

You can also use this pane to perform object-specific tasks and to move objects by dragging and dropping them to different areas within the Catalog. You can drag and drop objects within the Catalog area or from the Catalog area to the "Folders pane".

This area is part of the "Catalog page".

For more information, see:

Components

Type

Use this list to specify which object type to display in the catalog area. Selecting an object type applies only to the folder that you are viewing and not to the whole catalog. For example, if you are viewing content in the /My Folders location and select the Dashboard object type, only the dashboards within the /My Folders location display in the Catalog area.

Sort

This field displays if you selected either the List or Descriptive view type in the Change list view type list located in the "Catalog Page" toolbar.

Use this list to specify how you want to sort the objects in the Catalog area. By default, objects display in alphabetical order (A-Z). For example, you can select the Last Modified Ascending option to view the object chronologically.

Show More Details

This field displays if you selected the Descriptive view type in the Change list view type list located in the "Catalog Page" toolbar.

Use to display more information about specific object types. For example, if the Catalog pane listing contains agents and you select the Show More Details option, the information listed with the agent includes last run, next run, recipient, and priority information.

Object/Folder Links

Use to view a list of catalog objects and to initiate a specific task from an object. The way in which the objects display in this area (for example, list or details) is determined by the view type selection that you made in the Change list view type list located in the "Catalog Page" toolbar.

The tasks available for each object depend upon the object's type, the object's permissions, and your privileges. The tasks that display in the Catalog area also display in the "Tasks pane". For descriptions of these tasks, see "Tasks Options".

If the Catalog area displays results from a fully-integrated full-text search and those results contain dashboards, the Catalog area provides the Open with Search Filter option which, when clicked opens and applies the search criteria to the dashboard.


Catalog pane

Use this pane to add objects from the Oracle BI Presentation Catalog to analyses, dashboards, and so on. The objects available for you to add depend on the task that you are performing. For example, if you are creating:

This pane is displayed in numerous places, including the tabs of the "Analysis editor", the "Dashboard builder", and the "New Calculated Item dialog".

For more information, see:

Components

List

This box is not available in the Dashboard builder or the New Calculated Item dialog.

Use this box to select which objects to display in the Catalog Tree. The options can vary depending on whether the Catalog pane is displayed but can include the following:

Catalog Tree

Displays catalog objects that are appropriate for the task that you are currently performing and for which you have appropriate permissions.

Use this tree to:

Toolbar

This toolbar is available only in the Catalog pane displayed in the tabs of the Analysis editor.

The toolbar contains the following buttons:


Catalog pane for Scorecard

Use this pane to work with objects in the Oracle BI Presentation Catalog. For example, if you are creating an objective, you can add predefined KPIs to evaluate the objective's performance and progress by dragging and dropping KPIs from this pane to the objective.

For more information, see:

This pane is part of the "Scorecard editor" and the "KPI Watchlist editor".

Components

Catalog Tree

Displays catalog objects for which you have appropriate permissions.

Use this tree to work with the catalog objects. For example, you can add a KPI to an objective or initiative by dragging and dropping it, you can open a KPI, and so on.

Toolbar

The toolbar contains the following buttons:


Causal Linkage dialog

Use this dialog to specify the strength of a cause and effect relationship, and how the values of one impact the values of the other.

For more information, see:

Components

Strength

Use this box to specify whether the strength of the cause and effect relationship is Strong, Moderate, or Weak.

Proportionality

Use this box to specify whether changes in performance or value in the cause and effect relationship are directly proportional (Direct) or inversely proportional (Inverse).


Cause & Effect Map Preferences dialog

Use this dialog to specify how cause and effect relationships are to be displayed on a cause & effect map.

For more information, see:

Components

General

Use the "Cause & Effect Map Preferences dialog: General tab" to specify which types of cause and effect relationships are to be displayed on a cause & effect map. You can also specify the slant of the lines that link objects and how many levels of the strategy hierarchy are to be displayed.

Hidden Nodes

Use the "Cause & Effect Map Preferences dialog: Hidden Nodes tab" to specify which objectives and KPIs on a cause & effect map are to be hidden.


Cause & Effect Map Preferences dialog: General tab

Use this tab of the "Cause & Effect Map Preferences dialog" to specify which types of cause and effect relationships are to be displayed on a cause & effect map. You can also specify the slant of the lines that link objects and how many levels of the strategy hierarchy are to be displayed.

For more information, see:

Components

Show Link Strengths

Displays the following boxes to specify which types of cause and effect relationships are to be displayed on the map:

Show Link Interactions

Displays the following boxes to specify whether only associated objectives and KPIs whose changes in performance or value are directly proportional to the objective are to be displayed on the map, or only associated objectives and KPIs whose changes in performance or value are inversely proportional to the objective are to be displayed on the map, or both:

Link Angle

Use this box to specify the degree to which the lines that link objects on the map are to slant. To use straight lines, specify 0.

Number of Levels

Use this box to specify how many influencing, child objectives, to display on the map. This is helpful to reduce the visual complexity of the map.

Related Topics

"Cause & Effect Map Preferences dialog: Hidden Nodes tab"


Cause & Effect Map Preferences dialog: Hidden Nodes tab

Use this tab of the "Cause & Effect Map Preferences dialog" to specify which objectives and KPIs on a cause & effect map are to be hidden.

You might, for example, want to hide some nodes so that you can view only the nodes for which you are the business owner.

For more information, see:

Components

Associated Objectives and KPIs (left pane)

Displays all objectives and KPIs that are associated with the objective or KPI that is the root of the map.

Hidden Objectives and KPIs (right pane)

Displays all objectives and KPIs that are to be hidden on the map.

Shuttle

Use these buttons move objectives and KPIs between the two panes.


Cause & Effect Map tab: Details tab

Use this tab of the "Scorecard editor: Cause & Effect Map tab" to specify supporting information for a cause & effect map.

For more information, see:

Components

Name

Displays the name of the cause & effect map.

Description

Use this field to enter a description of the cause & effect map.

Business Owner

Displays the userID of the person responsible for managing the cause & effect map. To specify the business owner, click the Set User button to display the "Business Owner dialog", where you can search for and select the business owner.

Objectives and KPIs

Use this table to view and manage the objectives and KPIs that are displayed in the cause & effect map.

See "Initiatives & KPIs table; Objectives & KPIs table; Objectives, Initiatives & KPIs table; New KPI Watchlist table; and Breakdown table".

Related Documents

Use the "Related Documents area" to view and manage documents that provide supporting information to the cause & effect map.


Related Documents area

Displays the documents that provide supporting information to a scorecard object, such as an objective.

Use this area to view and manage the documents:


Cause & Effect Map tab: Diagram tab

Use this tab of the "Scorecard editor: Cause & Effect Map tab" to create a diagram that illustrates the cause and effect relationships of an objective or KPI.

For more information, see:

Components

Diagram

Use this area to drag and drop the objective or KPI whose cause and effect relationships you want to diagram.

Each node (that is, the representation of an objective or KPI) on the diagram shows the status of the objective or KPI by displaying the icon and color that represents the assessment range. A KPI node also displays the actual value of the KPI and the percent variance from the target.

To:

Legend

Use the "Legend pane" to view the legend for the cause & effect map.


Change Aggregation Rule dialog

Use this dialog to select the aggregation rule for a column when performing a direct database request. For more information, see "Working with Direct Database Requests".

Components

Column

Displays the name of the column for which you are changing the aggregation rule.

Aggregation Rule

Use to select the aggregation rule for this column. In this dialog, Default indicates the default aggregation rule; that is, the rule that is determined by the Oracle BI Server (such as the rule that is defined in the Oracle BI repository).

For a list of the valid values, see "Aggregation Rules and Functions".


Change Column Labels

Use this dialog to change the labels of the columns (such as % Change) that are displayed in a KPI watchlist

Table E-7, "Commonly Used KPI Data Columns" describes some of the commonly used columns.

You can change the column labels in a stand-alone KPI watchlist or in a KPI watchlist that has been added to a scorecard. You cannot change the labels in a KPI watchlist that has been added to a dashboard.

For more information, see:

Components

Column

Use this box to enter a new label for the column. For example, you might want to change the % Change column label to Percent Change.


Choose Request Column dialog

Use this dialog, when adding an inline action to an agent that is conditionally executed based on an analysis, to select a column in the analysis whose value is to be used as the value of an action parameter.

For more information, see:

Components

Columns

Use this list to select the request column whose value is to be used as the value of an action parameter.

Name

Displays the name of the selected column.

Note

Related Topics


Chapter 9, "Working with Conditions"
"Agent editor: Condition tab"

Collaboration pane

Use this pane to identify information that is helpful for collaborating on KPI details, an initiative, or an objective, including the business owner, key resources, and related documents.

For more information, see:

This pane is part of the "Scorecard editor: KPI Details tab", "Scorecard editor: Initiative Details tab", and "Scorecard editor: Objective Details tab".

Components

Comments

Displays the comments that have been added to the KPI, initiative, or objective. For more about comments, see "About Comments".

Use this area to view and manage the comments. Before you begin to work with comments, ensure that the point of view controls reflect the values for which you want to add or view comments.

To:

Business Owner

Displays the userID of the person responsible for managing the initiative, objective, or KPI. To specify the business owner, click the Set User button to display the "Select Business Owner dialog", where you can search for and select the business owner.

Related Documents

(for KPI details) Displays links to documents that provide supporting information to the KPI. You added these links when you created or edited the KPI. For more information, see "Creating or Editing KPIs".

(for initiatives and objectives) Use the "Related Documents area" to view and manage documents that provide supporting information to the initiative or objective.

Key Resources

This area is available only for initiatives.

Displays the key resources for an initiative, that is the users who are working on an initiative.

Use this area to view and manage the key resources:


Color Selector dialog

Use this dialog to specify the color in which the cells that contain the KPI's actual values are displayed. The color that you choose reflects the value's performance levels.

Components

Color Samples

Use these samples to select a color. When you select a color, a sample of the color and its hexadecimal value displays in the Customizations field.

Customizations

Use this box to modify the selected color's hexadecimal value or enter the hexadecimal value corresponding to the desired color (for example, #FF0000 or #996600).

Related Topics


"Creating or Editing KPIs"

Column Properties dialog

Use this dialog to:

This dialog is also displayed as:


Hierarchical Level Properties dialog

For more information, see:

Components

Style

Use the "Column Properties dialog: Style tab" to format the content of columns and hierarchy levels.

Column Format

Use the "Column Properties dialog: Column Format tab" to modify how folder and column headings are displayed in the analysis and to specify how repeated values display in the column.

Data Format

Use the "Column Properties dialog: Data Format tab" to override the data's default display characteristics.

Conditional Format

Use the "Column Properties dialog: Conditional Format tab" to add a condition, or filter, to the column or hierarchy level.

Interaction

Use the "Column Properties dialog: Interaction tab" to specify what you want to happen when the user clicks a value for a column or hierarchy level.

Write Back

Use the "Column Properties dialog: Write Back tab" to set the properties of a column that enables it for writing back values from a table.

Save As Default

Use this button to affect the default property settings for columns and hierarchy levels, based on the specifications in this dialog. You need the appropriate privileges to save the properties as a systemwide default.

Click OK to save these properties for this column or hierarchy level in this analysis only.

The Save as Default button applies slightly differently to the various tabs of this dialog:


Column Properties dialog: Column Format tab

Use this tab of the "Column Properties dialog" to modify how folder and column headings are displayed in the analysis and to specify how repeated values display in the column or hierarchy level.

This dialog is also displayed as:


Hierarchical Level Properties dialog: Level Format tab

For more information, see Chapter 7, "Formatting Analyses, Views, and Dashboard Pages".

Components

Hide

Not available for hierarchy levels. Use this box to hide the column in the analysis. You can hide columns whose appearance adds no value to the analysis. Hidden columns do not affect the aggregation of the values. For example, you want to build an analysis that includes only customers located in Illinois. To build the proper filter, you must include the column called Customers.State. Because this column was added for filtering purposes, only, and its appearance adds no value to the analysis, then you can hide this column.

Folder Heading and Column Heading

Not available for hierarchy levels. Use these fields to view or modify the name of the folder or column that is provided by the repository in which the column resides. To modify this field, you must first select the Custom Headings box, then you can specify a different heading to use. To modify the heading's appearance, click the Edit Format button.

You can reference variables in the Folder Heading and Column Heading fields. For the syntax to use, see "What Is the Syntax for Referencing Variables?" For more information on variables, see "Using Variables".

Edit Format

Use this button to modify the corresponding heading's format. For example, you can modify the heading to be displayed in 14-point bold Helvetica font. Any formatting changes that you specify override the Oracle BI EE style sheet and any formatting preferences that you specified on the "Column Properties dialog: Style tab" for this column.

Custom Headings

Use this box to enable the Folder Heading and Column Heading fields for editing. The fields are read-only until you select this box.

Show TimeZone

This box displays only for the columns and hierarchy levels that have the date/time data type. Use this box to include the Time Zone button with the column or hierarchy level. Click the box multiple times to move through the three different states. When the box is selected, the button is displayed. When the box is not selected, the button is not displayed. When the box appears to be not available, then the default system behavior is used.

The Time Zone button displays with the data column or hierarchy level in a view, and you can click the button to view the name of the display time zone. For more information about modifying the time zone, see "Display Time Zone" in "Column Properties dialog: Data Format tab".

Value Suppression

Use the buttons in this area to affect the display of repeating data values for the column or hierarchy level.

The data in one column or hierarchy level of a folder might be repeated in relation to rows of data in other columns or hierarchy levels in the folder. For example, if one column lists customer names and another column lists the regions that those customers are in, then the region data could be repeated for each customer row. You can choose to display duplicate data only once, or display it for every row. Displaying repeating or duplicated data only once can make a table somewhat easier to read, and can make distinctions in that data more apparent.

You can select one of the following buttons:


Column Properties dialog: Conditional Format tab

Use this tab of the "Column Properties dialog" to add a condition to a column or hierarchy level. You specify a condition to affect the formatting of values based on certain criteria. The formatting that you specify for a column or hierarchy level on this tab is visible in any view that can display data and its formatting, except for graphs, funnel graphs, and gauges. For information on conditional formatting in graphs, see "Graph Formatting Based on Columns".

This dialog is also displayed as:


Hierarchical Level Properties dialog: Conditional Format tab

For more information, see "Applying Conditional Formatting to Tables and Pivot Tables".

Components

Add Condition

Use this button to begin the process of creating a conditional format by adding a condition to any type of column or to a hierarchy level.

When you access the "New Condition dialog" from the Conditional Format tab, the dialog shows the options that apply to conditional formats. For example, the Operator list contains the operators that are used in conditional formats, and you can apply presentation variables. For information on presentation variables, see "Using Variables".

When you have created a conditional format, you see it listed at the top of this tab. Use the buttons that are displayed with the conditional format to edit the condition, format the values, or delete the format.

Clear All

Use this button to delete from the tab any conditional formats that you have created. This button is available only when at least one format exists.


Column Properties dialog: Data Format tab

Use this tab of the "Column Properties dialog" to override the data's default display characteristics by specifying custom formats. The options that display on this tab depend upon the data type (text, numeric, or date) of the column or hierarchy level. For example, if the data type is numeric, then you can add the thousands separator to the values.

This dialog is also displayed as:


Data Format dialog
Hierarchical Level Properties dialog: Data Format tab

For more information, see "Custom Format Strings"

Components

Override Default Data Format

This box is displayed for all data types.

Use this box to specify to enter an override format for the column or hierarchy level. Selecting this box enables the remainder of the settings on the tab.

Treat Text As

This list is displayed for the text data type.

Use this list to specify how you want to display the text for the values. You can select from options such as plain text, HTML, or a link. Based on your choice, the Custom Text Format field displays the applicable HTML string used to display the data.

If you select the Custom Text Format option, then you can type the custom format into the Custom Text Format field.

Custom Text Format

This field is displayed for the text data type.

Use this field to view the HTML string that corresponds to the option that you selected in the Treat Text As list. This field is read-only for all options except the Custom Text Format option.

When you specify the Custom Text Format option, you use this field to write HTML calls that provide formatting. You can also type any valid HTML string, including JavaScript, VBScript, and so on.

The first character must be an at sign character (@). This enables devices that are incapable of displaying the custom format to display the data in the appropriate default format.

For example, the following example HTML code sets the width and height of a column or hierarchy level in tables and pivot tables. In the example, the text html enclosed in brackets ([html]) means to use HTML, and the at sign (@) character represents the dynamic contents of the column or hierarchy level.

@[html]<span style="width:200px; height:50px">@</span>

If you are unfamiliar with HTML, JavaScript, VBScript, and so on, then consult a third-party reference.

Treat Number As

This list is displayed for the numeric data type.

Use this list to specify how you want to display the number values. You can select from options such as Currency, Percentage, and Month Name. The option that you select determines the fields that display in the Data Format tab.

Currency Symbol

This list is displayed if you selected the Currency option in the Treat Number As list.

Use this list to select the currency symbol to be displayed in the column or hierarchy level. For example, you can select the British Pound or the Polish Zloty.

To use the symbol of a user's preferred currency, select the User's Preferred Currency option. (Users specify their preferred currencies in the "My Account dialog".)

Negative Format

This list is displayed if you selected the Number, Currency, or Percentage option in the Treat Number As list.

Use this field to specify how you want negative numbers to be displayed in the column or hierarchy level. For example, you can select negative numbers to be displayed as -123 or (123).

Decimal Places

This list is displayed if you selected the Number, Currency, or Percentage option in the Treat Number As list.

Use this list to specify how many numbers you want to include after the decimal point when displaying the value in a view. For example, you can specify two decimal places. Decimal values are always rounded rather than truncated.

In this list, you can use the up to options to indicate the maximum number of decimal places to include. In the database, values for a single column or hierarchy level can be stored with various numbers of decimal places. Some might have 2, 4, or 6 for example. If you specify up to 4 in this list, then values are displayed with no more than 4 decimal places, but potentially with less if the value has less than 4 decimal places.

Use 1000's Separator

This box is displayed if you selected the Number, Currency, or Percentage option in the Treat Number As list.

Select this box to include a separator, such as a comma, in numbers that are 1000 or greater.

Custom Numeric Format

This field is displayed if you selected the Custom option in the Treat Number As list.

Use this field to enter a custom number format. For custom format strings that you can enter, see "Custom Format Strings".

You can use the number sign (#) to include significant digits, and the number zero (0) to include as many digits as specified, even if the number does not contain that detail.

For example, specifying ##.# shows 12.34 as 12.3, and specifying ##.000 shows 12.34 as 12.340.

Date Format

This list is displayed for the date and time zone data type.

Use this list to specify how you want the date to display in the column or hierarchy level. For example, 5/8/2003 07:34:57 AM or 05/08/2003 7:34:57. If you select the Custom option, then you can create a date format in the Custom Date Format field.

Custom Date Format

This field is displayed for the date and time zone data type and only if you selected the Custom option from the Date Format list.

Use this field to enter a date format. For custom format strings that you can enter, see "Custom Format Strings".

Display Time Zone

This list is displayed for the date and time zone data type.

Use this list to select and apply a specific time zone to the column or hierarchy level. Note the following default conditions:

Data Time Zone Offset

This field is displayed for the date and time zone data type.

Use this field to specify an offset for the time zone that you selected. For example, suppose you selected GMT +05:45 Kathmandu. You can specify an offset of 15 minutes to use when displaying time values for columns or hierarchy levels.


Column Properties dialog: Interaction tab

Use this tab of the "Column Properties dialog" to specify what you want to happen when the user clicks a column heading or value (for example, the user can click a column value to drill down into the data that was summed to create the column value).

This dialog is also displayed as:


Hierarchical Level Properties dialog: Interaction tab

For more information, see:

Components

Column Heading: Primary Interaction and Value: Primary Interaction

Use this box to specify what happens when you click either the column heading or a value in the column or hierarchy level. The values that are available depend on the type of column and on column heading versus value.

Specify channel

This field is displayed only if you select Send Master-Detail Events in the Primary Interaction field for a value.

Use this field to enter one or more channels on which data views are to send master-detail events. Note that the name of the channel is case sensitive.

Action Links

The Action Links area is displayed if you select Action Link from the Column Heading: Primary Interaction box or Value: Primary Interaction box.

Displays the action links that have been added to a column heading or value, including the text of the action links, the actions associated with the links, and whether the action links are always enabled or enabled conditionally.

Use this area to view and manage action links:


Column Properties dialog: Style tab

Use this dialog to specify properties for displaying values in various locations such as in a column or hierarchy level of data, in a view such as a table, and in a column or section that you are adding to a dashboard page.

In this dialog, a setting of Default (System) indicates that a user has not yet overridden the default values that were provided during installation. Each property has only one default setting at a time.

For table and pivot table views, the formatting that you specify in this dialog applies to the look of a table. The formatting is displayed slightly differently in a pivot table. For example, the default colors differ for tables and pivot tables.

For more information, see:

This dialog is also displayed as:


Column Properties dialog
Edit Column Format dialog
Edit Font Format dialog
Edit Format dialog
Format Caption dialog
Format Container dialog
Format Legend View dialog
Format Logo dialog
Format Narrative View dialog
Format Static Text View dialog
Format Subtitle dialog
Format Text dialog
Format Time dialog
Format Title dialog
Format Title View dialog
Grid Formatting dialog: Grid Format tab
Hierarchy Level Properties dialog: Style tab
Section Heading Properties dialog
Section Properties dialog
Sections Formatting dialog: Sections Format tab

Components

Note:

Not all components are available in each version of this dialog.

Toolbar

The toolbar displays only in those instances in which you can copy and paste cell formatting properties from one location to another. The toolbar contains the following buttons:

Caption

This box applies to totals that you include with tables and pivot tables. Use this box to specify custom text to insert into a total heading. Enter the text as follows

For more information, see "Adding Totals to Tables and Pivot Tables".

Family

Use this box to select the font family.

Size

Use this field to enter the font size.

Color

Use this box to select the font color.

Style

Use this box to select the font style, such as bold or italic.

Effects

Use this box to select the font effects, such as underline or strike through.

Horizontal Alignment

Use this box to select the type of horizontal alignment, such as left, right, or center.

Background Color

Use this box to select the color of the background.

Vertical Alignment

Use this box to select the type of vertical alignment, such as top, bottom, or center. Vertical alignment does not have any impact unless the column spans multiple rows of other columns.

Image

Use this field to specify the image to display inside of the cell. When you click the field, the Graphics dialog is displayed. For more information, see "Graphics dialog".

Wrap Text

Use this box to wrap the text within the column.

Note that if the width of a word extends beyond the width of the column, then the column is extended so as not to divide the word.

Border Position

Use this box to select the position of the border of the cell, column, or section, such as none or all. You can select or deselect custom borders by clicking the top, bottom, left, and right borders near the Position list.

Border Style

Use this box to select the style of the border, such as single, double, or thick.

Border Color

Use this box to select the color of the border.

Width

Use this field to specify the width of the cell, column, or section on the page.

Height

Use this field to specify the height.

Indent (Left Padding)

Use this field to specify the indent (that is, the left padding).

Right Padding

Use this field to specify the indent (that is, the right padding).

Top Padding

Use this field to specify the indent (that is, the top padding).

Bottom Padding

Use this field to specify the indent (that is, the bottom padding).

Use Custom CSS Style

Use this box to specify a custom cascading style sheet style to use for formatting, for example, background-color: #ff0000; font-size:28pt.

Use Custom CSS Class

Use this box to specify a custom cascading style sheet class to use for formatting.


Column Properties dialog: Write Back tab

Use this tab of the "Column Properties dialog" to set the properties of a column that affect writing back values to the data source to expose the write-back capability in tables. To use write back, you must also use the Table Properties dialog: Write Back tab. Write back is not available for hierarchical columns.

For more information, see "Modifying Values and Performing Write Back".

This dialog is also displayed as:


Write Back Settings dialog

Components

Enable Write Back

Use this box to allow users to modify values in the column, if the following are true:

If the column has not been enabled for write back in the repository, then the Enable Write Back box is disabled.

When you select this box, additional options for write-back are displayed.

Text Field Width

Use this box to select the width for the text field where users enter values, for text columns. Use the box to scroll among the values.

This box is not available on the Write Back Settings dialog.


Column Properties dialog for BI Composer

Use this dialog to perform the following tasks in the "BI Composer wizard -- Create Analysis: Select Columns panel":

For more information, see:

Components

Column Name

Use this field to enter a new name for the column.

Column Formula

Use this field to enter a formula for the column.

You can edit the formula for an attribute column or a measure column. This editing affects the column only in the context of the analysis and does not modify the formula of the original column in the subject area. (This functionality is not available for hierarchical columns.)

A column formula specifies what the column values represent. In its most basic form, such as "Base Facts"."1-Revenue", a column takes the data from the data source as is. You can edit the formula to add functions, conditional expressions, and so on. This editing enables you to present analysis results in a variety of ways. For example, suppose that you want to perform what-if analysis and show what the revenue might be by product if you increased revenue by 10%. You can see this increase by changing the formula for the Revenue column to show the revenue increased by 10%.


Compound Layout

Use this area to assemble different views for display on a dashboard. The views are displayed in separate containers within a compound layout. Each container has a toolbar.

Use this area also to view multiple compound layouts, each on its own tab. For more information, see "Creating Additional Compound Layouts".

Components

Views

Displays the views assembled for display on a dashboard, according the selected compound layout.

When you run a new analysis, the default assemblage of views can include a title view and either a table or pivot table view. The administrator might have configured a different default assemblage for your company.

Toolbar

The toolbar for each view contains the following buttons:


Contact Owner dialog

Use this dialog to send a message to the business owner of a Scorecard object, such as an initiative or objective.

For more information, see:

Components

Owner

Displays the name of the person who is responsible for managing and improving the business value and performance of the scorecard object.

Subject

Use this box to enter the subject of your message.

Priority

Displays the options High, Normal, and Low to identify the importance and urgency of your message.

Message

Use this box to enter the text of your message.


Content pane

This pane to the right of the "Catalog page" displays the contents of folders and objects that you select in the "Folders pane" or the results of a search. Use this pane to perform tasks such as:

For information, see "Managing Objects in the Oracle BI Presentation Catalog".


Create Delivery Profile dialog

Use this dialog to create a delivery profile.

You can create any number of delivery profiles. However, only one profile can be active at any given time.

For more information, see:

This dialog is also displayed as:


Edit Delivery Profile dialog

Components

Name

Use this field to enter the name of the delivery profile. For example, for your office phone, you might use Phone - Office.

Device Priorities

Use this area to indicate, for each of your delivery devices, what priority content is to be delivered to the device. To do so, next to each delivery device to use when this profile is the active profile, select one or more of the priority content options — High, Normal, or Low.

For example, if you have a pager as one of your delivery devices, you might associate it with high priority content only. When you know that you must be away from your office frequently, and out of e-mail range, you might associate your e-mail device with low priority content.

Note:

Do not set the priority for devices that you do not want to use. Devices that do not have a priority selected are not used by the profile.


Create Device dialog

Use this dialog to create a delivery device.

For more information, see:

This dialog is also displayed as:


Edit Device dialog

Components

Name

Use this field to enter the name of the device.

Category

Use this box to select the device category. For example, if you are adding an e-mail device, select Email. The value in this box affects the values that are available in the Device Type box.

Device Type

Use this box to select the type of device. For example, if you are adding an e-mail device, select either HTML Email for Plaintext Email.

The list of device types is specified on the "Administration: Manage Device Types page".

Address/Number

Use this field to enter the address for the device. For example, for an e-mail device, enter the e-mail address or for a phone, enter the phone number.

Note:

When typing a phone number for a device, do not use punctuation such as spaces, dashes, or parentheses.


Create New Action dialog

Use this dialog to create an action.

For more information, see Chapter 10, "Working with Actions."

This dialog is also displayed as:


Add New Action dialog
New Action dialog
Edit Action dialog

Components

Browse

This button is not available for all action types.

Displays one of the following dialogs:

Note:

In order for Hyperion resources, Web Service operations, EJBs, and functions to be exposed in their respective dialogs, some setup is required beforehand. For how to expose Hyperion resources, Web Service operations, EJBs, and functions in their respective dialogs, see Oracle Fusion Middleware Integrator's Guide for Oracle Business Intelligence Enterprise Edition.

URL

This field is available only for Navigate to a Web Page and Invoke an HTTP Request actions and only if URL aliases have been defined for these actions.

Use this field to enter the URL of the Web page.

Be sure to encode the URL, if required. See "About Encoding the URL for a Navigate to a Web Page or Invoke an HTTP Request Action".

Tip:

Copy the URL from the browser and paste it in this field.

If URL aliases have been defined for Navigate to a Web Page and Invoke an HTTP Request, and you want to specify an alias for the URL, click the Show URL location aliases button (that is, the down arrow) and select the alias.

For more information on defining URL aliases, see Oracle Fusion Middleware Integrator's Guide for Oracle Business Intelligence Enterprise Edition.

Request

Use this box to select one of the following options:

This field is available only for Invoke an HTTP Request actions.

Define Parameters

This button is available only for Navigate to a Web Page and Invoke an HTTP Request actions

Use this button to display the Define Parameters area. It also automatically parses the specified URL for parameters and lists them in the Define Parameters area.

For example, this URL:

http://finance.google.com/finance?q=ORCL

Becomes this:

http://finance.google.com/finance?q=@{1}

And an action parameter with the name 1 and a default value of ORCL is displayed in the Define Parameters area.

Any part of a URL can be converted into a token if the token name matches the parameter name. When an action is executed, the value of the parameter is used in the final URL.

Language

This box is available only for Invoke Server Script actions.

Use this box to select the script type — either JavaScript or VB Script.

Script Path

This field is available only for Invoke Server Script actions.

Use this field to enter the path of the script to be executed. Use a path name relative to the value of the DefaultScriptPath element in the instanceconfig.xml file for Scheduler. (For more information on the DefaultScriptPath element, see "General Scheduler Configuration Settings That Affect Agents" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.)

Function Name

This field is available only for Invoke a Browser Script actions.

Use this field to enter the name of the JavaScript function to be executed. Click Browse to display the "Select Script Function dialog", where you can select a script.

Path

This field is available only for Invoke Agent actions.

Displays the path to the agent that is to be invoked.

Execute for Recipients

This box is available only for Invoke Agent actions.

Use this box to select one of the following options to specify the scope of the recipients:

Define Parameters

Use this area to define the action parameters.

Depending on the action type, some action parameters might be displayed automatically in this area. For example:

This area includes, depending on the type of action, some of the following buttons and columns:

Filters

This area is available only for an action that invokes an agent that is conditional based on an analysis that filters its data by a column prompt.

Use this area to map any column of the specified agent (that is, the agent to be invoked) that contains a column prompt to any to column of the current agent (that is, the agent to which the action is being added). At run time, the system generates a filter based on the data returned by the execution of the conditional analysis of the current agent.

For more on how filters work in an Invoke Agent action, see Oracle Fusion Middleware Integrator's Guide for Oracle Business Intelligence Enterprise Edition.

Options

This button is available only for actions where it is appropriate to display information to users. For example, this option is not available for actions added to agents.

Use this button to display the "Action Options dialog", where you specify information to display to users when they run an action.

Save As

This button is available only on the Edit Action dialog for named actions.

Use this button to display the dialog, where you save the action to the catalog as a new action with another name.

Notes


About Encoding the URL for a Navigate to a Web Page or Invoke an HTTP Request Action

If the URL that you specify for a Navigate to a Web Page or Invoke an HTTP Request action contains characters outside the ASCII character set or contains characters in an international language, you must encode it. Encoding involves replacing the characters that are outside the ASCII character set or the characters in an international language with "%" and the two hexadecimal digits that correspond to the character values in the ISO-8859-1 character set. Note the following about encoding the various parts of a URL:

The following example shows an encoded URL:

http://myservice.example.com:4579/path/to/my%20service/endpoint/@{bivariable1}?parameter1=fixed&parameter2=@{bivariable2}

Note that in the example URL:


Create New Agent dialog

Use this dialog to create an agent from a KPI.

For more information, see:

Components

Name

Use this field to enter a name for the agent.

Description

Use this field to enter a description of the agent.

Location

Use this field to select a folder or create a new folder in which to save the agent. To create a folder, click the New Folder option in the list to display the "Create New Folder dialog". To select a folder that is not listed, click the Folder button to display the "Select Agent Location dialog".

Trigger Agent if KPI Status is

Use this box to select the KPI status that is to initiate the agent to deliver its content and execute its actions.

Qualify

Displays the dimensions that must be pinned. Select a value for each dimension.


Create New Device Type dialog

Use this dialog to create a delivery device type. This dialog is displayed from the "Administration: Manage Device Types page".

For more information, see "Managing Device Types for Agents" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

This dialog is also displayed as:


Edit Device Type dialog

Components

Name

Enter the name of the device type.

Category

Use this box to select the category of the device type. Select from Mobile Phone, Pager, or Handheld Device.

Domain

Enter the domain or e-mail extension of the service provider, such as pagenet.net.


Custom Permissions dialog

Use this dialog to assign a specific permission or build a specific set of permissions for a catalog object. For information about assigning detailed privileges that further refine the tasks users can perform, see "Managing Catalog Privileges" in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition.

For more information, see:

Components

Read

Use this option to enable users to view, but not modify, the object.

Execute

Use this option to enable users to run or launch the programs or applications associated with the object, such as an agent or the actions for an action link.

Traverse

Use this option to give the user authority to bypass any permissions set on the folder that would prevent the user from accessing the object from the Catalog, a dashboard, or WebCenter Portal application page. Note that this option does not change the folder's permissions.

For example, if you grant users the Traverse permission to the /Shared Folders/Test folder, then they can access objects, through the Catalog or embedded in dashboards or WebCenter Portal application pages, stored in the/Shared Folders/Test folder and stored in sub-folders, such as the /Shared Folders/Test/Guest folder. However, users cannot access (meaning view, expand, or browse) the folder and sub-folders from the Catalog.

Write

Use this option to enable users to modify the object.

Delete

Use this option to enable users to delete the object.

Change Permissions

Use this option to enable users to modify or assign other permissions to the object.

Set Ownership

Use this option to enable users to specify the owner of the object.

Run Publisher Report

This option displays for all object types; however, you can only apply it to Oracle BI Publisher objects. Use this option to allow the user to run the report. When the user runs the report, the report is compiled using the most current data.

Schedule Publisher Report

This option displays for all object types; however, you can only apply it to Oracle BI Publisher objects. Use this option to allow the user to schedule the report.

View Publisher Output

This option displays for all object types; however, you can only apply it to Oracle BI Publisher objects. Use this option to allow the user to view, but not run or modify, the report.


Custom View Properties dialog

Use this dialog to specify a background image, a background color, or both for the diagram in a custom view.

For more information, see:

Components

Background Image

Use this field to enter the URL to the background image.

Note that when you enter a URL in the Background Image field, the Width and Height fields are automatically populated with the actual image size (if possible).

Note:

A custom view uses the Adobe Flash component to render its content. The background image is fetched by the Adobe Flash component and rendered. Flash components have security restrictions on the content to which they have access. Generally, Flash components can load or render the content from the same domain from which the original Flash movie was downloaded (that is, the Oracle BI Server). If you want a background image from any other server or domain, then the remote server must allow access to the BI Server's domain to retrieve the image. This is done by configuring the crossdomain.xml on the remote server. For how to configure the crossdomain.xml on the remote server, see the following knowledge base article:

http://kb2.adobe.com/cps/142/tn_14213.html#main_Cross_domain_policy_files

Position

Use this area to specify the position of the background image in the diagram. To do so, specify the following:

Size

Use this area to specify whether to maintain the aspect ratio or to size the image to fit the diagram. To do so, select one of the following options:

Background Color

Use this box to display the Color dialog, where you select the color to use for the background of the diagram.


Custom View tab: Details tab

Use this tab of the "Scorecard editor: Custom View tab" to specify supporting information for a custom view.

For more information, see:

Components

Name

Displays the name of the custom view.

Description

Use this field to enter a description of the custom view.

Business Owner

Displays the userID of the person responsible for managing the custom view. To specify the business owner, click the Set User button to display the "Business Owner dialog", where you can search for and select the business owner.

Objectives and KPIs

Use this table to view and manage the objectives and KPIs that are displayed in the custom view.

See "Initiatives & KPIs table; Objectives & KPIs table; Objectives, Initiatives & KPIs table; New KPI Watchlist table; and Breakdown table".

Related Documents

Use the "Related Documents area" to view and manage documents that provide supporting information to the custom view.


Custom View tab: Diagram tab

Use this tab of the "Scorecard editor: Custom View tab" to create a diagram that shows a customized view of your business and strategy data.

For more information, see:

Components

Diagram area

Use this area to drag and drop objectives and KPIs to show in your customized view.

Each node (that is, the representation of an objective or KPI) on the diagram shows the status of the objective or KPI by displaying the icon and color that represents the assessment range. A KPI node also displays the actual value of the KPI and the percent variance from the target.

To:


Customize Condition dialog

Use this dialog to customize a condition that is based on an analysis that includes one or more prompted filters. (A prompted filter is a filter whose operator is set to Is Prompted.)

For more information, see "Agent editor: Condition tab".

This dialog is also displayed as:


Customize Delivery Content dialog

Components

Edit the Prompted Filters

Displays the prompted filters associated with the analysis.

Click the Edit button adjacent to a prompted filter to display the "Edit Parameter Filter dialog", where you edit the filter.


Customize Gauge Limit dialog

Use this box to customize the minimum or maximum gauge limit.

For more information, see "Gauge Properties dialog: Scale tab".

Components

Gauge Limit

Use this box to specify the custom gauge limit by selecting one of the following options:


Customize Scale Marker dialog

Use this dialog to set the value for one of the following items for a graph:

To set the value, you can use a static value, a presentation variable, a measure column, or a SQL query. If a value is not valid, then the scale marker is ignored.

For more information, see "Scale Markers dialog".

Components

Static Value

Use this option to set the value to a hard-coded value that you specify. If you select this option, then enter the hard-coded value in the field to the right of the option.

Variable Expr

Use this option to set the value to the value of a presentation variable. If you select this option, then enter the presentation variable in the field to the right of the option and a default value in the (default) field.

Column Name

Use this option to set the value based on a measure column. If you select this option, then select the measure column in the box to the right of the option.

Note that using a measure column could yield numerous values. Only the first value is applied.

SQL Query

Use this option set the value based on the results of a SQL query. If you select this option, then enter the SQL query in the box beneath the option.

Note that the results could be a table but only the first row and first column cell value is applied.


Customize Subscription to Agent dialog

Use this dialog to customize an agent subscription.

For more information, see "Customizing Your Agent Subscriptions".

Components

Condition

Use "Customize Subscription to Agent dialog: Condition Parameters tab" to customize prompted filters for an analysis that is used in an agent condition.

Content

Use "Customize Subscription to Agent dialog: Content Parameters tab" to customize prompted filters for an analysis that is the delivery content for an agent.


Customize Subscription to Agent dialog: Condition Parameters tab

Use this tab of the "Customize Subscription to Agent dialog" to customize prompted filters for an analysis that is used in an agent condition.

For more information, see "Customizing Your Agent Subscriptions".

Components

Edit the prompted filters

Displays the prompted filters that you can customize.

Modify operator/value for this parameter

Use this button to display the "Edit Parameter Filter dialog", where you can customize the prompted filters.


Customize Subscription to Agent dialog: Content Parameters tab

Use this tab of the "Customize Subscription to Agent dialog" to customize prompted filters for an analysis that is the delivery content for an agent.

For more information, see "Customizing Your Agent Subscriptions".

Components

Edit the prompted filters

Displays the prompted filters that you can customize.

Modify operator/value for this parameter

Use this button to display the "Edit Parameter Filter dialog", where you can customize the prompted filters.


Dashboard builder

Use this Dashboard builder to build or edit dashboards. The process of building or editing a dashboard includes:

For more information, see:

Components

Page Tabs

Use the tabs across the top of the editor to select the dashboard page to edit.

Dashboard Objects

Use the "Dashboard Objects pane" to select the objects to include on a dashboard page and drag and drop them to the Page Layout area.

Catalog

Use the "Catalog pane" to select objects from the Oracle BI Presentation Catalog to include on a dashboard page and drag and drop them to the Page Layout area. This adds a shortcut to the content as saved in the catalog. If the content changes, then the change is reflected on the dashboard page.

To locate the content, you can browse by either the catalog folder it is stored in, or by the dashboard on which it is located.

Page Layout

Use "Page Layout area" to layout and place the content (that is, objects from the Dashboard Objects pane and the Catalog pane) to include on a dashboard.

Toolbar

The toolbar contains the following buttons:


Page Layout area

Use this area to layout and add the content that you want on a dashboard by dragging and dropping objects from the "Dashboard Objects pane" and "Catalog pane". After you drop an object to this area, you can modify the object using the buttons on its Toolbar.

This area is part of the "Dashboard builder".

Components

Object Representations

Each object that you drag and drop to the Page Layout area is represented by a rectangle.

Object Toolbars

Each object dropped to the Page Layout area contains a toolbar that displays when you hover over the object. The Object Toolbar contains the following buttons:


Properties Buttons for Objects

Each object that is represented on the "Page Layout area" has a toolbar that contains a Properties button. What the button displays depends on the type of object. The following sections describe, for each type of object, what the Properties button displays.

Column Properties

This button displays the following options:

Section Properties

This button displays the following options:

Alert Section Properties

This button displays the following option:

Action Link Properties

Use this button to display the "Action Link Properties dialog", where you set the properties of an action link.

Action Link Menu Properties

Use this button to display the "Action Link Menu Properties dialog", where you set the properties of an action links menu.

Link or Image Properties

Use this button to display the "Link or Image Properties dialog", where you specify properties for a text link or image link that you are adding to a dashboard page.

Embedded Content Properties

Use this button to display the "Embedded Content Properties dialog", where you specify the URL and other information about content to embed on a dashboard page.

Text Properties

Use this button to display the "Text Properties dialog", where you specify properties for a text object, including the text and formatting tags.

Folder Properties

Use this button to display the "Folder Properties dialog", where you add a view of a Catalog folder and its contents.

BI Publisher Report Properties

Use this button to display the "BI Publisher Report Properties dialog", where you specify the information for adding an Oracle BI Publisher report.

Analysis Properties

This button displays the following options:

Prompt Properties

This button displays the following options:

Scorecard Object Properties

This button displays the following options:


Dashboard Filters and Variables dialog

Use this dialog to add hidden named prompts to a dashboard or a dashboard page.

For more information, see:

This dialog is also displayed as:


Filters and Variables - page dialog

Components

Embed New Hidden Dashboard Prompt

Use this button to access the "Open dialog", which enables you to browse and select the named prompt to add to the dashboard. After you select a prompt, its path displays in the Prompts Path table.

Edit

Use this button to access the "Open dialog", which enables you to browse and replace the currently selected prompt with another prompt. After you select another prompt, its path is displayed in the Prompts Path table.

Remove

Use this button to delete the selected prompt.

Prompt Path

Displays the paths of the hidden prompts that you added to the dashboard. You can select a prompt and then click the Edit or Remove button to replace or delete the prompt.


Dashboard Objects pane

Use this pane to select the dashboard objects to include on a dashboard page and drag and drop them to the "Page Layout area".

For more information, see "Adding Content to Dashboards".

This pane is part of the "Dashboard builder".

Components

List of Objects

Use the list of dashboard objects to decide what to include on a dashboard page. Drag and drop an object from the list to an appropriate location in the page layout area on the right side of the Dashboard builder.

For more information on dragging and dropping, see "Dragging and Dropping Objects to the Page Layout Area in the Dashboard Builder".

Table E-2 lists and describes the dashboard objects that you can include on a dashboard page.

Table E-2 List of Dashboard Objects

Dashboard Object Description

Column

Used to align content on a dashboard. (Sections within columns hold the actual content.) You can create as many columns on a dashboard page as you need, and you can place columns on a dashboard horizontally or vertically. Note that the columns used in the Dashboard builder are not related to the columns used in the Analysis editor.

Section

Used within columns to hold the content, such as action links, analyses, and so on. You can drag and drop as many sections as you require for a column.

Alert Section

Used to add a section in which to display Alerts from agents, if any.

On users' My Dashboard, an Alert section is added automatically to the first page, if you do not manually place one there. You cannot disable the appearance of an Alert section on the first page of users' My Dashboard. You can add an Alert section to an additional dashboard page so that section is then displayed on both dashboard pages.

Action Link

Used to add an action link. An action link is a link that you embed in an analysis, dashboard page, or KPI that, when clicked, runs an associated action.

For more information, see Chapter 10, "Working with Actions."

Action Link Menu

Used to add an action link menu. An action link menu let users choose, from a list of action links, the right action to be executed.

For more information, see Chapter 10, "Working with Actions."

Tip: If you add an action link to an action link menu and later decide that you do not want the link to be displayed in the menu, you can simply drag and drop it elsewhere on the page.

Link or Image

Used to add text links and image links and specify what should happen when a user clicks them. For example, you can direct users to another Web site or dashboard, open documents, launch applications, or perform any other action that the browser supports. You can also add an image or text only, without any links.

Embedded Content

Used to add embedded content. Embedded content is any content that is displayed within a window (called a frame) inside the dashboard, as opposed to content that is accessed by clicking a link. Content that you might want to embed includes analyses, Excel charts, documents, Web sites, tickers from Web sites, and so on. When you embed content into a dashboard, the required HTML is automatically added to the target content.

Analyses are embedded by default. Embedding an analysis in a dashboard causes it to execute automatically and to display the results within the dashboard. This provides access to current results.

Note: Some third-party Web sites, because of the way they have been created, cannot be embedded within another Web page. If you see unexpected results when viewing an embedded Web site, then you might need to click the browser's Back button until an Oracle Business Intelligence screen reappears, or close and then reopen the browser. Then, remove the embedded Web site from the dashboard.

Text

Used to add plain text or, if allowed at your organization, HTML.

See the administrator to find out if adding HTML is allowed at your organization.

To add embedded content, which is content that is displayed in a window within the browser, then use the Embedded Content object instead. Then, using the Embedded Content feature, specify the name and location of the target, and the required HTML is wrapped around the target for you.

Folder

Used to add a view of a Catalog folder and its contents. For example, you might add a folder that contains a collection of saved analyses that you run frequently. Then from the dashboard, you can open the folder, navigate to a saved request, and click it to run it.



Dashboard page

Use a dashboard page to view and navigate a dashboard.

For more information, see:

Components

Page Tabs

Use the tabs across the top of the viewer to select the dashboard page to view and navigate.

Toolbar

The toolbar contains the Page Options button, which displays the following options:


Dashboard Properties dialog

Use this dialog to change the properties of a dashboard and its pages.

For more information, see "Changing the Properties of a Dashboard and its Pages".

Components

Style

Use this option to select a style for the dashboard. Styles control how dashboards and results are formatted for display. The administrator might have created styles that you can choose from. If not, analyses are formatted using a default style.

Description

Use this field to enter a description for the dashboard. Descriptions are displayed when administrators use the Catalog Manager. The description is not displayed on the dashboard.

Filters and Variables: Edit

Click this button adjacent to the Filters and Variables heading to display the "Dashboard Filters and Variables dialog", where you add hidden named prompts to the whole dashboard. See "Adding a Hidden Dashboard Prompt to a Dashboard or Dashboard Page".

Dashboard Report Links: Edit

Use this button to display the "Report Links dialog", where you select which links are to be displayed with all analyses on the dashboard, unless customized settings have been specified for an individual dashboard page or analysis.

Prompts Apply Buttons

Use this list to specify if you want to include or exclude the prompt's Apply buttons on the dashboard at run time. This setting applies to the entire dashboard, but you can use the "Dashboard builder" to override this setting on individual dashboard pages. Note the following options:

Prompts Reset Buttons

Use this list to specify whether you want to include or exclude the prompt's Reset buttons on the dashboard at run time. The Reset button provides the user with three reset options: Reset to last applied values, Reset to default values, and Clear All. The Prompts Reset Buttons setting applies to the entire dashboard, but you can override this setting on individual dashboard pages.

Note the following options:

Prompts Auto-Complete

Use this option to enable or disable the auto-complete functionality for the dashboard. When enabled, Oracle BI EE suggests and highlights matching prompt values as the user types in the dashboard's prompt selection field, and highlights matching prompt values in the "Select Values dialog". See "What Is Auto-Complete?"

Dashboard Pages

Displays the pages in the dashboard. Use this area to perform operations (such as hide or rename) on dashboard pages using the dashboard pages toolbar buttons.

Dashboard Pages Toolbar

This toolbar contains the following buttons:

Note:

These operations are not reversed when you click Cancel in this dialog.

Hide Page

Use this box to specify whether the page is to be displayed when the dashboard is shown. This option is helpful when you are working with a dashboard page and want to hide it from users until your changes are complete. When you select this option, the page remains visible to any users who are currently viewing it.

Show Add to Briefing Book

Use this box to specify whether the Page Options menu for the page contains the Add to Briefing Book option. For more information on the Add to Briefing Book option, see "Dashboard page".

Reorder

Use these buttons to specify the order of the pages on the dashboard.


Definition pane

Use this pane to add, organize, and manage the prompt's columns. You can use column prompts, image maps, currency prompts, and variable prompts.

For more information, see:

This pane is part of the "Prompt editor".

Components

Definition Table

Use this table to view high-level information about the prompt's columns. You can also use this table to select columns for editing or deleting, arrange the order in which the prompts are displayed to the user, or insert row or column breaks between prompt items.

Note the following Definition Table components.

Toolbar

The toolbar contains the following buttons:


Dimension Pinnings dialog

Use this dialog to pin (or set) the value of one or more KPI dimensions. You set values of KPI dimensions, for example, when you add a strategy map that contains one or more KPIs that are dimensioned to a dashboard.

Pinning is optional. Typically, it is best not to pin most of the dimensions so that the data is controlled by the point of view settings.

For more information, see:

Components

List of Dimensions

Displays a list of the dimensions to be pinned.

To pin a dimension, click the down arrow to the right of the dimension and select one of the following options:


Display pane

Use this pane to view the prompt's layout and design. The Display pane is updated as you use the "Definition pane" to arrange the prompt items and the "Prompt editor" to add and modify prompt items. The items displayed in the Display pane do not access the prompt's data source and, therefore, do not include the columns' data selection options. To test the prompt with data selection options and view the resulting dashboard or analysis, click Preview.

For more information about creating and adding prompts, see:

This pane is part of the "Prompt editor".

Components

Edit

Use this button to access the"Edit Page Settings dialog" to specify the prompt page's title and instructional text, and the text and tables formats (for example, font size, cell color, and border width).


Edit dialog

Use this dialog to work with values as part of the "Select Values dialog".

Components

Edit

Use this area to work with values in the following ways:

Separate values that you enter with carriage returns (Enter key) or pipe (|) characters. Values that you copy in can be separated by carriage returns (the Enter key), | (pipe) characters, or tabs.

Press the Tab key to move the focus to the OK button.


Edit Background Map dialog

Use this dialog to edit a map from the Background Maps tab of the "Administration: Manage Map Data page". Before editing a background map, add layers using the Layers tab. A background map is a non-interactive map that serves as a base for the map view. It might display a satellite image or a map with roads. (A background map is referred to as a "tile" in MapViewer.)

For more information, see "Administering Maps" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Components

Name

Use this field to enter the name of the map.

Location

Displays the location of the background map in the data source from MapViewer. Click the Location button to display the "Import Background Maps dialog" for importing a different map. If you select a background map that includes a different number of zoom levels, then the zoom levels are automatically adjusted for the layers that are associated with the map by scaling their ranges.

Description

Use this field to enter a description of the map, which is displayed in the following locations:

Interactive BI Layers area

Use this area to specify the layers from the Oracle Database that are available on the map and their zoom level. The first time that you display this dialog after adding a map, this area lists any appropriate layers that are specified on the Layers tab, with their default zoom level settings.

The layers are listed from bottom to top, in terms of how they are applied to the map. A sample order is Countries, States, Cities. The lower level layers generally have the lower zoom levels. For example, if you have a States layer and a Cities layer, then include lower zoom levels for State than City.

This area contains the following components:

Map area

Use this area to specify how the map is displayed to users. Use the panning and zooming controls to affect the display of the map. If you hover over the zoom slider, then you see tooltips that specify the names of the layers that are currently associated with that zoom level.


Edit Briefing Book dialog

Use this dialog to edit a briefing book. You can reorder content, delete content, and change the content type, the number of navigation links to follow, and the content description.

For more information, see:

Components

Content

Displays the contents of the briefing book. To edit or delete content, select the content and then use the toolbar buttons. To reorder content, select the content and drag and drop it to the desired location.

Toolbar

This toolbar contains the following buttons:

Related Topics


"Adding Content to New or Existing Briefing Books"
"Downloading Briefing Books"
"Adding a List of Briefing Books to a Dashboard Page"
"Using Agents to Deliver Briefing Books"

Edit Column Formula dialog

Use this dialog to:

You cannot customize headings, specify the aggregation rule, or edit the formula for a hierarchical column or for a hierarchy level; however, you can specify a hierarchical column within a formula for an attribute or measure column.

For more information, see:

Components

Formula

Use the "Edit Column Formula dialog: Column Formula tab" to customize headings, specify the aggregation rule, and edit the formula for a column.

Bins

Use the "Edit Column Formula dialog: Bins tab" to combine values for the column into sets.


Edit Column Formula dialog: Bins tab

Use this tab of the "Edit Column Formula dialog" to perform "binning," which enables you to combine values for the column into sets. For example, suppose that the Region column has a value EASTERN. You can specify "My Home Region" instead as the text that displays for that value in the view that displays that column's data.

Binning differs from groups in that groups allow the view to display each member that is part of the group. For information, see "What are Groups?"

For more information, see "Editing the Formula for a Column".

Components

Add Bin

Use this button to display the "New Filter dialog", where you can create a filter expression to display as a CASE statement in the Formula area of the "Edit Column Formula dialog: Column Formula tab".

You can combine multiple values or ranges of values from a given column into bins. When you add and name the bins, all instances of the various values that comprise the bin in the result set are replaced by the bin name. Aggregations are performed accordingly as well. For example, you can specify that all values over $10M are displayed as "My10M."

Bins List

Displays the list of bins that you have created for this column using the Add Bin button. Use the following buttons within this list:

Create a bin for all other values

Use this box to create an entry in the Bins list called "All other values" and to display the dialog in which you can enter a name for this bin. This bin includes all values that have not yet been included in another bin in the list. You cannot edit the filter for this bin nor can you reorder it. It must be the last bin in the list.

Treat result as a numeric value or expression

Use this box to indicate that binned numeric values that you specify are treated as numbers, rather than as the default of text. For example, suppose that you specify 35 as the bin name. If you do not select this box, then the name is treated as text, rather than as the number 35 when it is displayed in views. If you select this box, then the value 35 is treated as a number, which affects operations that are specific to data types such as sorting.

Clear All

Use this button to remove the bins that you have created. When you click this button, a message prompts you to decide whether to keep the CASE statement in the formula on the Formula tab:

Notes


Edit Column Formula dialog: Column Formula tab

Use this tab of the "Edit Column Formula dialog" to:

For more information, see:

This dialog is also displayed as:


Edit Formula dialog

Components

Folder Heading

Not available for KPIs.

Use this field to enter the text for the heading for the column's folder. To enable this field, select the Custom Headings box.

Column Heading

Not available for KPIs.

Use this field to customize the heading to reflect the data in the column. To enable this field, select the Custom Headings box. For example, to change the column heading to "Dollars Increased by 10%", select the Custom Headings box and then, in the Column Heading field enter Dollars Increased by 10%.

Custom Headings

Not available for KPIs.

Use this box to enable the Folder Heading and Column Heading fields so that you can customize the headings to suit your needs. For example, if you change the formula of a column, you might want to change the column heading to something that is more representative of the column.

Aggregation Rule (Totals Row)

Use this box to select the aggregation rule for the:

For a list of the valid values, see "Aggregation Rules and Functions".

Available

Displays the primary subject area and any related subject areas that have been added to the "Subject Areas pane". Use this area to select columns to use in formulas. To insert a column in a formula, select the column and click the Add Column button (the arrow button between the Available and Column Formula areas). Note that when you insert a column, if you have something highlighted in the Column Formula area, it is replaced.

Column Formula

Use this area to perform these tasks:

When you have text selected in the Column Formula box, it is replaced by values that you select elsewhere, such as in the Available list or by inserting functions or filters. The selected text is also displayed in the Insert Function and Insert Filter dialogs when you invoke them.

You can enter the formula manually or use these components:

Treat as an Attribute Column

Available only for measure columns and only when the dialog is invoked from the Criteria tab. The default is that the box is not selected. Use this box to specify that a measure column be treated as an attribute column. This setting forces a Group By of the column values when the measure column is positioned outside the Measures area to an edge of the view This setting is not applied to a measure column in the Columns and Measures area of a table or the Measures area for a pivot table or graph.

This box is required to facilitate functionality in this release that specifies to not show all the detail when a measure column is moved to an edge but rather to aggregate the measure column to the grain of the edge. For example, aggregating dollar values to the Region grain.

Suppose that you have an analysis that contains the Region, Units, and Dollars columns. Using the Bins tab of the Edit Column Formula dialog for Units, you create one bin for values greater than or equal to 10 million and you specify that bin name as X. All other values use the bin name of Y. These bins create a CASE statement in the formula for this column.

When you display that analysis in a table on the Results tab, you see values for X and Y in the Units column. If you display that analysis in a pivot table with the Units column on the Measures edge, you also see values for X and Y. If you move the Units column to another edge, such as the row edge of a pivot table, then you see only values for X. This is because the values of the column were aggregated for each region and none are now less than 10 million.

To resolve this problem and have views display data as in previous releases (prior to 11g), you select the Treat as an Attribute Column box to specify that the measure column be handled as an attribute column, which prevents the aggregation of the values.

All analyses are upgraded from Release 10g with all measure columns having the Treat as an Attribute Column box selected, to ensure that the measure columns are treated as attribute columns, as they were in Release 10g.

Notes

To manually enter a variable in an expression in the Formula area, follow the guidelines for referencing variables in expressions that are described in Table 2-2.

Related Topics


"Edit Column Formula dialog: Bins tab"

Edit Dimension Settings dialog

Use this dialog to set up the control for a dimension in the point of view area of a scorecard. Specifically, you can specify:

For more information, see:

Components

Dimension

Displays the name of the dimension in the database, for example, "A - Sample Sales"."Products"."P1 Products".

Label

Use this field to enter a user-friendly label for the dimension's point of view control when no specific value has been set for the dimension. For example, you might enter Products for the dimension "A - Sample Sales"."Products"."P1 Products". Note that you do not need to specify a label for:

Default Value

Use this box to select one of the following options:

If you select a specific value and:

Prompted

Use this box to specify whether a control for this dimension is to be displayed in the point of view area of the scorecard:

Prompted By

This box is available only if you have deselected the Prompted box. Use this box to select the dimension whose control in the point of view area this dimension is to share.


Edit Footer or Header dialog

Use this dialog to specify the information for adding a footer or header to PDF and HTML output, when printing a dashboard page. Each header and footer can contain as many as three lines.

For more information, see:


"Print Options dialog"
"Changing the Properties of a Dashboard and its Pages"

Components

Bold, Italic, Underline

Use these buttons to apply Bold, Italic, or Underline to characters in the footer or header.

Line Break

Use this button to insert a line break between characters in the footer or header.

Contains HTML Markup

Use this option to work with HTML codes, as described in "Working with HTML Markup".

Insert Field

Use this menu to select a field to include in the header or footer, such as the author name, date, or page number.

Text

Use these fields to enter the text for the header or footer.

You can reference variables in these fields. For the syntax to use, see "What Is the Syntax for Referencing Variables?" For more information on variables, see "Using Variables".

Edit Format

Click this button to display the "Edit Format dialog", in which you specify formatting for the text in the footer or header.

Display in browser when applicable

Use this option to specify whether to display the header or footer in the HTML output. If you deselect this box, then the header or footer is displayed in the PDF output only.


Edit Layer dialog

Use this dialog to edit a layer from the Layers tab of the "Administration: Manage Map Data page". One important task is to associate the layer of spatial data with data for Oracle BI EE.

Spatial data is managed in MapViewer and stored in an Oracle Database. To display data for Oracle BI EE on a map, you must associate a spatial layer with the appropriate columns of data from the Oracle BI Server. The combinations of BI data columns are referred to as "BI Keys". When you associate the layer of spatial data with data for Oracle BI EE, that layer becomes available for use with the specified columns in the specified subject areas.

For more information, see "Administering Maps" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Components

Name

Use this field to enter the name of the layer.

Location

Displays the location of the layer in the data source from MapViewer. Click the Location button to display the "Import Layers dialog" for importing a different layer.

Browse

Use this button to display the "Import Layers dialog", in which you select a source location to associate with the layer. Your selection is reflected in the Location box.

Description

Use this field to enter the description of the layer, which is displayed in the following locations:

Layer Key

Use this box to select the column of spatial data from MapViewer to associate with data for Oracle BI EE. Each column value corresponds to a shape that is stored in the Oracle database. For example, a MY_CITIES layer might have a layer key called CITY. By default, the selected value is a "best guess" at the appropriate column. Use the list to select the appropriate column.

Click the Sample Data link to display an actual value for that column that you can use as an example.

If the box is empty, then the administrator must define the key column for the shapes in the spatial table for that layer in MapViewer. The map is drawn only where common values exist between the spatial data column and the associated column of Oracle BI EE data. Otherwise, the map might show a white area to indicate a missing value. To verify that common values exist for the two columns, display the column of Oracle BI EE data in the Oracle BI Administration Tool and review its values. In MapViewer, verify that the associated layer contains all the appropriate geometry definitions for the values in the corresponding column of Oracle BI EE data.

The following list provides the reasons why a white area might be drawn, using the country of Mexico as an example:

BI Key Delimiter

Available only when multiple columns are specified for one key. Use this field to enter a single ASCII character (such as a comma or underscore) to function as a delimiter for combining the BI data columns that form a key.

Geometry Type

Use this box to specify whether the layer is a point geometry layer or a polygon layer. The specification for a point or polygon layer affects the formatting that can be applied to that layer.

BI Key Columns Area

Use this area to select the columns of data from the Oracle BI Server to associate with the layer. You can have multiple columns associated with a single layer. You can select multiple columns from one subject area or from multiple subject areas. The columns and delimiter that you select must exactly match the name of the Layer Key value. Suppose the Layer Key value is STATE_CITY. You must select the STATE and CITY BI data columns and specify the underscore character as the delimiter for use in creating the BI Key to associate with the layer.

Click the following options:

When a content designer creates a map view, a default main map is selected as the basis for that map view. If at least one data column from the analysis is associated with a layer that is associated with a main map, then that main map is selected by default.

Show Qualified Names

Use this box to specify whether to display the fully qualified name of the column in the BI Key Columns Area or simply the column name.


Edit Page Settings dialog

Use this dialog to modify the prompt page's title, instructions, and page formatting. For more information, see "Definition pane".

Components

Title

Use this field to enter the title to display on the prompt page. You can format this title by clicking the Format button.

Instruction

Use this field to enter instructions for the prompt page. For example, "Use this page to specify sales measure prompt values."

Format

Click this button to display the "Edit Format dialog", in which you specify the formatting options that you can apply to the prompt page. For example, you can specify a font size and style for the title and a background color for the cell.

Prompt Display

Use this field to specify if you want the prompt label to display beside the prompt field or above the prompt field.

Wrap label to fit

Use this field to specify if you want to wrap the prompt labels. Selecting this option moves long prompt labels to multiple rows, if necessary. Note that if the total row length is longer than the user interface, Oracle BI EE adds a horizontal scroll bar to the prompts page.

The default maximum label size is 250 pixels. Note that this value differs if the Administrator modified the default pixel value in the Oracle BI EE configuration file.

Set width of all prompts to

Use this field to specify if and how you want Oracle BI EE to adjust the field width for all prompts on the prompts page. When selected, this field overrides any prompt width settings that you added to individual prompts. The field width is where the prompt values display, and does not include the field's label. If you selected the is between operator, each field ("from" and "to") is sized to the pixel size that you specify.

Select this field to apply the specified width to all prompts on the prompts page. Deselect this field to set each prompt width individually in the "New Prompt dialog".

After you select this field, you can specify the one of the following options:

Show Apply Button

Use this box to include or exclude the Apply button at run time. If you deselect this box, the Apply button will be excluded and Oracle BI EE immediately applies the specified prompt value to the dashboard or analysis. If you select this box, the Apply button is included, which the user must click to apply the specified prompt value to the dashboard or analysis. Note that this setting can be overridden in the "Dashboard builder".

Show Reset Button

Use this field to include or exclude the Reset button at run time. If you deselect this box, the Reset button is excluded from the prompt. If you select this box, the Reset button is included and the user can click it to reset or clear the specified prompt values from the analysis or dashboard. The Reset button provides the user with three reset options: Reset to last applied values, Reset to default values, and Clear All. Note that this setting can be overridden in the "Dashboard builder".

Place buttons on side of prompts

If you select to include either the Apply or Reset button or both the Apply and Reset buttons, use this list to specify where you want the buttons to display in relation to the prompt fields. You can place the buttons to the side of or below the prompt fields.

Apply display properties to all prompt pages

Use this field to apply the page display properties that you specified to all of the prompts pages. Deselect this field to apply the properties to the prompts page upon which you are working, only.


Edit Parameter Filter dialog

Use this dialog to edit a prompted filter that is associated with an analysis on which a condition is based.

For more information, see:


"Customize Condition dialog"
"New Condition dialog"

Components

Filter

Displays the name of the column on which the filter is built.

Operator

Use this box to select the operator to apply to the value specified in the Value field. For guidelines on operators, see "Operators".

Value

Use this field to specify the value to use when applying the filter. You can type a value or click the Show list of values button to search for one or more specific values.

To specify a session or repository variable as the value, click the Value label and select Session Variable or Repository Variable. The Value field label changes to either Session Variable or Repository Variable. Then, enter the name of the session or repository variable.

For more information on session and repository variables, see "Using Variables".

Show list of values

Use this button to display the "Select Values dialog", where you can select one or more values from a list of available values.

Add another filter value

Use this button to add another Value field.

Delete Filter Value

Use this button to delete the corresponding value and field.


Edit Parameter Mapping dialog

Use this dialog to edit the action parameters associated with an action.

For more information, see:

This dialog is also displayed as:


Add Existing Action dialog

Components

Define Parameters

Use this area to define the action parameters. It includes the following components:


Edit Saved Customizations dialog

Use this page to edit the customizations saved for a dashboard page. You can:

For more information, see:

Components

Saved Customizations

This area displays the customizations, both personal and shared, that have been saved for the dashboard page.

To rename a customization, overwrite the old name with the new name.

To set a customization as your default, select the button in the My Default column for the customization. To have no personal customizations as your default, select the button in the My Default column for the No Personal Customizations entry.

Permissions

Use this button 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.

Delete

Use this button to delete the selected customization.


Embedded Content Properties dialog

Use this dialog to specify the URL and other information about content to embed on a dashboard page.

For more information, see "Adding Content to Dashboards".

Components

URL

Use this field to enter the location and name of the content to embed.

These are examples:

http://www.oracle.com
/dashboardfiles/piegraph.xls

The URL that you specify should begin with http:// unless you plan to use an item that is saved on the Web server. If you use a network path to indicate the location of the item, then ensure that you use the exact path. Items that are embedded on a shared dashboard must be located on a network drive that is accessible to all users.

Width

Use this field to specify the width of the embedded content in the dashboard. Note the following about width and height specifications:

Height

Use this field to specify the height of the embedded content in the dashboard. Adjust the height setting for the best display results.

Hide Scroll Bars

Select this box to indicate that the scroll bars for the embedded content are not displayed. If you do not select this box, then scroll bars are automatically added to the window if they are needed.


Enter Email Address dialog

Use this dialog to add e-mail recipients who are to receive the delivery content of an agent.

For more information, see:

Components

Email address for content delivery (separate multiple addresses with commas)

Use this field to enter the e-mail address of each e-mail recipient who is to receive the delivery content of the agent. Use commas to separate multiple addresses.


Enter Expression dialog

Use this dialog to enter a variable expression or SQL query to use to set a gauge threshold.

For more information, see:

This dialog is also displayed as:


Enter SQL Query dialog

Components

Expression

Use this box to enter the expression or SQL query.

You can reference one or more presentation variables in the expression. For guidelines on referencing a variable in an expression, see Table 2-2. For more information on variables, see "Using Variables".


Filter editor

Use this editor to create or edit a named filter.

For more information, see:

Components

Subject Areas

Use the "Subject Areas pane" to select the attribute column or measure column to be included in the filter. If your repository is configured for double columns, typically, you choose a display column on which to filter. However, you can choose a code column on which to filter but only if the code column is exposed in the Presentation layer in the Oracle BI EE repository. For more information on the Presentation layer, see Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.

After you select a column, the "New Filter dialog" displays where you specify the new filter's criteria.

Catalog

Use the "Catalog pane" to search for and drag and drop named filters from the catalog to the Filter editor. When you add a named filter to the Filter Editor, you are given the choice of either copying a catalog reference to the named filter or copying the named filter's contents to the analysis. When you include a reference to the named filter, you cannot modify the filter. When you include a copy of the named filter, you can modify the filter's contents and either save the filter as an inline or named filter.

Saved Filter

Use this area to work with a filter just as you would in the "Filters pane".


Filters pane

Use this dialog to create or edit a named filter or inline filter.

For more information, see:

This pane is part of the "Analysis editor: Criteria tab".

This pane also displays as the Saved Filter pane on the "Filter editor".

Components

Filters Pane Toolbar

The toolbar contains the following buttons.

Filter Item Toolbar

The filter item toolbar is the collection of buttons that displays when you hover over a filter item within the list of filter items. It includes the following buttons:

Operator

Click the operator to toggle between AND and OR. When you add a filter item, the default operator is AND. The AND operator means that the criteria specified in each filter must be met. This is the default method for combining column filters. The OR operator means that the criteria that is specified in at least one of the column filters must be met.

If you have specified three or more filters and click AND, then Oracle BI EE automatically groups the filter item with the filter item above it. Grouped filters are indented in the filters list. You can click the operator to group the filters in several layers. Grouped filters are always processed before ungrouped filters.

Edit Filter Group

This button displays when you hover over a collection of grouped filters. Use this button to specify what you want to do with the corresponding group. If you are working with a multi-level group, then ensure that you are clicking on the correct Edit Filter Group button. Note the following options:


Folder Properties dialog

Use this dialog to add a view of a catalog folder and its contents, such as saved analyses, or a list of briefing books to a dashboard page. For example, if you have a collection of saved analyses that you run frequently, you can open the folder in the dashboard, navigate to a saved analysis, and click it to run it.

For more information, see:

Components

Folder

Displays the path to the folder whose view you want to add to the dashboard page, for example, /Shared Folders/Briefing Books. Click the Browse button to display the "Open dialog", where you select the folder.

Expand

Use this option to specify whether to show an expanded view of the folder.

Show RSS Link

Use this option to specify whether to add an RSS feed option to the folder.

The RSS feed option enables a user to access the dashboard's catalog folder from an RSS 2.0 compatible reader that supports HTTP basic authentication. If Oracle BI Presentation Services uses HTTPS protocol, then the RSS Reader that you use must also support the HTTPS protocol. An RSS reader is a third-party program that enables the user to aggregate information from different web-based locations into one browser window (for example, news feeds or events listing).

When the RSS link is added to the dashboard's catalog folder, an XML button that provides the catalog's URL is displayed for that folder. When a user accesses a catalog folder from an RSS reader, the reader prompts the user to log in to the Oracle BI Server.

You can include an RSS feed option to a catalog folder that is displayed on a dashboard page. Users must have the proper privilege to add the RSS feed option to a dashboard page's catalog. The RSS Feeds privilege is granted by the administrator.


Folders pane

Use this pane to display and navigate the content of personal (My Folders) and shared folders that all users can access. Administrators can display the catalog root folder that contains all system, object, and user data and settings. You can also use this pane to move objects by dragging and dropping them to different areas within the Catalog. You can drag and drop objects within the Folders pane or from the Folders pane to the "Catalog area".

For more information, see:

This pane is part of the "Catalog page".

Components

Show Folder Tree

Use this button to display all folders in hierarchical directories.

Show Quick Access Folders

Use this button to list, excluding their hierarchy, these folders:

My Folders

Contains all of your personal folders.

Shared Folders

Contains folders to which you have the permissions to access.


Font Format: Item dialog

Use this dialog to set formatting properties for a graph, such as the font family for text.

For more information, see "Graph Properties dialog: Titles and Labels tab".

Note:

Depending on what you are formatting, this dialog might be displayed without tabs. If so, then it contains only the components in the "Font Format: Item dialog: Font Format tab".

Components

Display Options

Use "Font Format: Item dialog: Display Options tab" to set properties for the display of titles, scale labels, and data labels.

Font Format

Use the "Font Format: Item dialog: Font Format tab" to set properties for displaying text.

Number Format

This tab is not available for the vertical axis 2 of a pareto graph.

Use the "Font Format dialog: Number Format tab" to override the default numeric format in which data labels are currently displayed.


Font Format: Item dialog: Display Options tab

Use this tab of the "Font Format: Item dialog" to set properties for the display of titles, scale labels, and data labels in a graph.

For more information, see:

This dialog is also displayed as:


Format: Item dialog: Display Options tab

Components

Truncate

This box is available only for titles.

Use this box to specify whether items are to be automatically truncated or truncated by a specified number of characters. If you select Specify, then enter the number of characters in the characters field.

Label Orientation

This box is available only for scale labels.

Use this box to select the number of degrees scale labels are to be rotated.

Abbreviate

This box is available only for scale and data labels. It is not available for the vertical axis 2 of a pareto graph.

Use this box to select the abbreviation to use for scale and data labels. For example, if you select Million(m) for a scale label of 120,000,000, then the label is abbreviated to 120M.

Show Data Labels

This box is available only for data labels.

Use this box to specify whether to hide or show data labels. Data labels are displayed when you hover the mouse over elements in a graph or gauge.

Data labels are enabled by default for selected 2D graph types. Data labels have no effect on graphs such as 3D bar and column.


Font Format: Item dialog: Font Format tab

Use this tab of the "Font Format: Item dialog" to set properties for displaying text.

For more information, see:

This dialog is also displayed as:


Font Format: Item dialog

Components

Toolbar

The toolbar contains the following buttons:

Family

Use this box to select the font family.

Size

Use this field to enter the font size.

Color

Use this box to select the font color.

Style

Use this box to select the font style, such as bold or italic.

Effects

Use this box to select the font effects, such as underline or strike through.


Font Format dialog: Number Format tab

Use this tab of the "Font Format: Item dialog" to override the default numeric format in which data labels are currently displayed.

Note:

The numeric format is inherited from the representative column in the Criteria tab. If two or more columns are selected for the same axis, then numeric formatting is not inherited.

For more information, see:


"Graph Properties dialog: Titles and Labels tab"
"Gauge Properties dialog: Titles and Labels tab"

Components

Override Default Data Format

Use this box to specify that you want override the default numeric format in which data labels are currently displayed.

Treat Numbers As

Use this box to specify whether data labels are numbers, percentages, or currency.

Currency Symbol

This box is available only if you select Currency in the Treat Numbers As box.

Use this box to select the currency symbol to show in data labels.

Negative Format

Use this option to specify whether to display negative data labels using a minus sign (for example, -123) or parentheses (for example, (123).

Decimal Places

Use this box to select the number of decimal places (to a maximum of 6) in which to display numbers (for example, 120,000,000.000).

Use 1000's Separator

Use this box to specify whether to separate each magnitude of a thousand by a comma. (for example, 1,000,000,000.00


Gauge Properties dialog

Use this dialog to edit the properties of gauge.

For more information, see:

Components

Canvas

Use the "Gauge Properties dialog: General tab" to set properties related to the gauge canvas, such as, legend location.

Style

Use the "Gauge Properties dialog: Style tab" to set properties that control the appearance of the gauge, such as width and height of the gauge.

Scale

Use the "Gauge Properties dialog: Scale tab" to set properties for gauge limits and tick marks.

Titles and Labels

Use the "Gauge Properties dialog: Titles and Labels tab" to set properties that control the display of titles, footers, and labels for the gauge or gauges in a gauge set.


Gauge Properties dialog: General tab

Use this tab of the "Gauge Properties dialog" to set properties related to the gauge canvas, such as legend location.

For more information, see:

Components

Gauges Per Row

Use this field to enter the number of gauges display per row in a gauge set.

Legend Location

Use this box to specify whether a legend is to be displayed and its location. Select one of the following options:

Listen to Master-Detail Events

Use this box to specify whether the gauge is to act as a detail view in a master-detail relationship and listen for master-detail events. This box also displays the Event Channels field.

To specify that a gauge is to act as a detail view in a master-detail relationship and listen for master-detail events, select this box and then specify the channel or channels in the Event Channels field.

For more information on master-detail relationships, see "What is Master-Detail Linking of Views?"

Event Channels

This field is displayed only if you select the Listen to Master-Detail Events box.

Use this field to enter the name of one or more channels on which the gauge is to listen for master-detail events raised by one or more master views. The channel name is case sensitive and must match exactly the channel name specified in the master view. Separate channels with commas, for example, channel a, channel b.


Gauge Properties dialog: Scale tab

Use this tab of the "Gauge Properties dialog" to set properties for the following parts of a gauge:

For more information, see:

Components

Gauge Limits

Use this area to specify the gauge limits as follows:

Tick Type

Displays the following options to specify the number of tick marks to display:

Show Major Ticks

This box is not available for bulb gauges.

Use this box to specify whether major tick marks are to be shown.

To show major ticks, select this box and then specify the number of major tick marks to show.

Show Minor Ticks

This box is not available for bulb gauges.

Use this box to specify whether to show minor tick marks.

Minor tick marks show only in dial gauges that show one measure.

To show minor ticks, select this box and then specify the number of minor tick marks to show.


Gauge Properties dialog: Style tab

Use this tab of the "Gauge Properties dialog" to set properties that control the appearance of the gauge, such as width and height of the gauge.

For more information, see:

Components

Dial Arch Length

This box is available only for dial gauges.

Use this field to enter length of the dial arc in degrees. The maximum value is 360 degrees.

Gauge Size

Use this box to specify the size of the gauge — Fit to Canvas, Small, Medium, Large or Custom.

If you select Custom, then you must complete the Width and Height fields, where you specify the width and height in pixels.

Width

This field is enabled only when you select Custom in the Gauge Size box.

Use this field to enter the width of the gauge in pixels.

Height

This field is enabled only when you select Custom in the Gauge Size box.

Use this field to enter the height of the gauge in pixels.

Marker Type

This area is available only for dial gauges.

Use this area to specify, for each measure in the gauge, the type and color of the indicator. The indicator is the part of the gauge that points to the value that is plotted.

In the first box, select the type of indicator and then, in the second box, select the color. The types of indicators are:

Gauge Colors and Border: Background

This box is available only for dial gauges.

Displays the Color Selector dialog, where you select the color for the gauge background.

Gauge Colors and Border: Border

This box is available only for dial gauges.

Displays the Color Selector dialog, where you select the color for the border around the gauge.

Canvas Colors and Border: Background

Displays the Color Selector dialog, where you select the color for the canvas background.

Canvas Colors and Border: Border

Displays the Color Selector dialog, where you select the color for the border around the canvas.


Gauge Properties dialog: Titles and Labels tab

Use this tab of the "Gauge Properties dialog" to set properties that control the display of titles, footers, and labels for a gauge or gauges in a gauge set.

If the canvas consists of a gauge set, then titles and footers are displayed for each gauge. Titles and footers are optional.

For more information, see:

Components

Gauge Set Title: Title

Use this field to enter the title for the gauge or gauge set. The title is displayed at the top of the canvas.

Use measure name as graph title

Use this box to use the name of the measure column or columns (for example, Dollars) for the title of the gauge or gauge set.

Gauge Titles: Title

Use this field to enter a title to be displayed above each gauge.

You can use a token (@n) to include the results from the designated column in the gauge title. For example, @1 inserts the results from the first column, and @3 inserts the results from the third column.

Gauge Titles: Footer

Use this field to enter a footer to be displayed beneath each gauge.

You can use a token (@n) to include the results from the designated column in the gauge footer. For example, @1 inserts the results from the first column, and @3 inserts the results from the third column.

Format Title

Use this button (which is displayed next to each Title field and the Footer field) to display the "Font Format: Item dialog", where you can format the title or footer.

Format Label

Use this button (which is displayed next to the Legend, Scale Labels and Data Labels labels) to display the "Font Format: Item dialog", where you can format the legend, scale labels, or data labels.

The Format Label button for scale labels is not available for bulb gauges.


Getting Started pane

Use this pane to learn how to use Oracle Scorecard and Strategy Management to drive and assess corporate performance, to link to the Oracle Business Intelligence glossary, and to link to information about how to create scorecards.

For more information, see "Viewing Overview Information".

This pane is part of the "Scorecard editor: Overview tab".

Components

Overview

Use this link display overview information about scorecarding.

Glossary of Terms

Use this link to display a glossary of Oracle Business Intelligence terms.

How do I?

Use link to display information on how to create scorecard components, such as objectives, initiatives, perspectives, and views.


Graph Properties dialog

Use this dialog to edit the properties of a graph.

For more information, see:

Components

General

Use the "Graph Properties dialog: General tab" to set properties related to the graph canvas, such as legend location.

Style

Use the "Graph Properties dialog: Style tab" to set properties that control the appearance of the graph, such as the style.

Scale

Use the "Graph Properties dialog: Scale tab" to set properties for axis limits and tick marks.

Titles and Labels

Use the "Graph Properties dialog: Titles and Labels tab" to set properties that control the display of titles and labels for the graph.


Graph Properties dialog: General tab

Use this tab of the "Graph Properties dialog" to set properties related to the graph canvas, such as legend location.

For more information, see:

Components

Canvas Width

Use this field to enter the width of the graph canvas in pixels.

Canvas Height

Use this field to enter the height of the graph canvas in pixels.

Legend Location

Use this box to specify whether a legend is to be displayed and its location. Select one of the following options:

Zoom and Scroll

This component is not supported for radar, funnel, and pie graphs.

Use this area to specify whether to enable zooming and scrolling on the horizontal and vertical axes:

When you enable zooming and scrolling for an axis, the Zoom button (from which you can zoom and scroll) is displayed in the graph area when you hover the mouse over the graph.

For more information on how to zoom and scroll, see "Zooming and Scrolling in Graphs".

Listen to Master-Detail Events

Use this box to specify whether the graph is to act as a detail view in a master-detail relationship and listen for master-detail events. This box also displays the Event Channels field.

To specify that a graph is to act as a detail view in a master-detail relationship and listen for master-detail events, select this box and then specify the channel or channels in the Event Channels field.

For more information on master-detail relationships, see "What is Master-Detail Linking of Views?"

Event Channels

This field is displayed only if you select the Listen to Master-Detail Events box.

Use this field to enter one or more channels on which the graph is to listen for master-detail events raised by one or more master views. The channel name is case sensitive and must match exactly the channel name specified in the master view. Separate channels with commas, for example, channel a, channel b.

Animate graph on Display

This box is not supported for funnel graphs.

Use this box to specify whether to show an initial rendering effect. The rendering effect varies from graph to graph. In a horizontal graph, for example, the bars start at the horizontal axis and move up to the current measurement level.


Graph Properties dialog: Scale tab

Use this tab of the "Graph Properties dialog" to set properties for the following parts of a graph:

This tab is not available for pie graphs or funnel graphs.

For more information, see:

Components

Note:

If a graph has both vertical and horizontal axes (for example in a scatter graph) or two vertical axes (for example in a line-bar graph), this tab contains sub-tabs so that you can set the scale properties for both axes.

Axis Limits or Scale and Limits

This area is disabled for a pareto graph.

Use this box to specify the limits of the vertical or horizontal axis. Select one of the following options:

Axis Scale or Scale Type and Tick Marks

Displays the following options to specify the number of tick marks to display:

Note that the color you select color for the horizontal and vertical gridlines on the "Graph Properties dialog: Style tab"also is applied to the major and minor tick marks.

Show Major Ticks

Use this box to specify whether to show major tick marks. If you select this box, then specify the number of major tick marks to show.

Show Minor Ticks

This box is disabled for vertical axis 2 of a pareto graph.

Use this box to specify whether to show minor tick marks. If you select this box, then specify the number of minor tick marks to show.

Use logarithmic scale

This box is disabled for a pareto graph.

Use this box to specify whether to use a logarithmic scale.

Click to edit Scale Markers

Displays the "Scale Markers dialog", where you define the scale markers for the graph.

Notes


Graph Properties dialog: Style tab

Use this tab of the "Graph Properties dialog" to set properties that control the appearance of the graph, such as the style.

For more information, see:

Components

Style

This box is not enabled for bubble and radar graphs.

Use this box to select the graph style. The options are:

Style and Conditional Formatting

Displays the "Style and Conditional Formatting dialog", where you specify formatting.

3D

Use this box to specify whether the graph is to be three-dimensional.

Plot Area: Background

Displays the Color Selector dialog, where you select the color for the plot area background.

Gridlines

Use these boxes to specify whether to display the default gridlines or gridlines that you specify.

If you select the Specify option, then, for the major grid and for the minor grid, specify the gridlines that you want and their color using the following boxes:

If you select the Specify option only and do not select any checkboxes for the major and minor grid, no gridlines (not even the ones shown by default) are displayed.

Note that, for a pareto graph, enabling the horizontal major or minor gridlines shows only the gridlines corresponding to vertical axis 1.

Legend: Background

Displays the Color Selector dialog, where you select the color for the legend background.

Legend: Transparent

Use this box to specify whether the legend is transparent (that is, has no background color).

Legend: Border

Displays the Color Selector dialog, where you select the color for the border around the legend.

Canvas Colors and Borders: Background

Displays the Color Selector dialog, where you select the color for the canvas background.

Canvas Colors and Borders: Gradient

Use this box to specify whether the canvas background color is to gradually fade from the specified color at the top to white at the bottom.

Canvas Colors and Borders: Border

Displays the Color Selector dialog, where you select the color for the border around the canvas.


Graph Properties dialog: Titles and Labels tab

Use this tab of the "Graph Properties dialog" to set properties that control the display of titles and labels for the graph.

For more information, see:

Components

Title

Use this field to enter a title for the graph.

Use measure name as graph title

Use this button to specify whether to use the measure name or names as the graph title.

Vertical Axis 1 Title

Use this field to enter a title for the vertical axis 1.

Use measure name as axis title

Use this button to specify whether to use the measure name or names as the vertical axis 1 title.

Vertical Axis 2 Title

Use this field to enter a title for the vertical axis 2.

Use measure name as axis title

Use this button to specify whether to use the measure name or names as the vertical axis 2 title.

Horizontal Axis Title

Use this field to enter a title for the horizontal axis.

Use column name as axis title

Use this button to specify whether to use the column name or names as the horizontal axis title.

Format Title

Use this button (which is displayed next to each Title field) to display the "Font Format: Item dialog", where you can format the title.

Format Label

Use this button (which is displayed next to the Legend, Vertical Axis 1 Scale Labels, Vertical Axis 2 Scale Labels, Horizontal Axis Labels and Data Labels labels) to display the "Font Format: Item dialog", where you can format the legend, scale labels, or data labels.

Notes

For time series line graphs, no data formatting options are available for the time axis labels or data labels. You can modify font characteristics, but any other formatting selections are ignored.

For a time series line graph, labels that display on the time axis are locale-sensitive. For example, month and day names use the appropriate locale-sensitive short names.


Graphics dialog

Use this dialog to select images to display for the following:

You can select a standard image or manually enter a path to a custom image.

Components

No Image

Use this box to indicate that no image is included in the column's layout. If you are creating a KPI threshold, select this option to display only KPI values and omit symbols that reflect performance levels or states.

Custom Image

Use this field to specify a custom image to include in the column's layout or with the KPI threshold. To do so, enter one of the following:

Note:

If you are trying to save an object that uses the fmap syntax, then you must have the Save Content with HTML Markup privilege. See "Managing Catalog Privileges" in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition for information on privileges.

The custom image should be one that is accessible to all users who view or edit the scorecard.

Custom images can be used for both conditional and unconditional column results.

Select Standard Image

Use this pane to select an image distributed with Oracle Business Intelligence. To select an image, click the option next to the image to include in the column. These images are useful in conditional formatting, such as meters and trend arrows. The left pane shows the categories of images. When you click an image category, the right pane shows the images in that category.

Image Placement

Use this field to specify where you want the image to be displayed relative to the column's data or heading.

Select Choose Image Only if you want the column to contain the image without the text. Choose Default to use the image's default position, which is usually to the left of the column's data or heading.


Home page

Use this page to:

For more information, see:

Components

Create...

Provides links to initiate the most popular creation tasks by category (for example, Published Reports or Actionable Intelligence). Click the More link to access a list of the category's other creation tasks. Oracle BI EE populates this list of categories based on what is installed on your company's system and the pieces to which you have been given the rights to access.

Browse /Manage...

Provides the ability to search the folders and objects to which you have permission to access. You can click the Catalog Folders [Search] link to access the catalog search interface where you can search for an object by name, location, and type. For more information about the catalog and how to search it, see "Managing Objects in the Oracle BI Presentation Catalog".

This section also gives you the ability to quickly perform pre-defined searches of the catalog by clicking any folder/binocular button. For example, click My Scorecards folder/binocular button to access a list of all of the Scorecard objects located in your My Folders location. After you click a folder/binocular button, the Catalog page displays and contains the results of your search, as well as the pre-defined search's criteria defaulted into the Search fields.

Get Started...

Provides links to information and tools that will acquaint and help you with Oracle BI EE and other related Oracle technologies. Note that your administrator can customize this section to meet the informational needs of the users.

This section contains the following links:

Alerts

(This section is available only when one or more alerts are delivered to the Oracle BI EE Home page.)

Displays your alerts (up to a maximum of five), including the priority (High, Normal, or Low) and last delivery date and time for each alert.

To view the latest occurrence of an alert, click its name. The "Alert dialog" is displayed, where you can view information about the alert and the content of the alert. You can also edit and run the agent that generated the alert, if you have the appropriate permissions.

Each alert has the following links:

If more than five alerts have been delivered, the View All Alerts link is displayed. Click this link to display the "Alerts dialog", where you can view and manage all your alerts.

To configure an agent to deliver an alert to the Home page, you must select the Home Page and Dashboard option on the "Agent editor: Destinations tab". For more information about creating agents, see "Creating Agents".

Recent

Contains a list of the dashboards that you have recently viewed, created, or updated. Note that these dashboards display in the first row of this section. Click the More Dashboards link to access additional dashboards that you recently created and updated. All other recently created or updated objects display below the dashboard row.

The links that are included with an individual object (for example, Edit and Properties) are displayed based on the object's type and your permissions for that object. For example, if you can view but not edit a dashboard, only the Open link is displayed with the dashboard. If a dashboard that you created displays in this section, then the Open and Edit links display with the dashboard. Click the More link to access a list of more dashboard options, such as Properties.

Most Popular

Contains a list of recommended objects that other users with your same role viewed. You have not accessed these objects yet but may find them useful. Oracle BI EE compiles this list of recommendations by determining which objects similar users have accessed and compares those objects to your list of recently accessed object. Oracle BI EE includes only items to which you have the view permission. Only items saved to the Shared Folder display in this list.

The links that are included with an individual object are displayed based on the object type and your permissions for that object. For more information about how Oracle BI EE determines the object's links, see the Recent component in this topic.


Image Map Prompt Properties dialog

Use this dialog to specify information for the map column. For more information, see "Creating or Editing an Image Prompt" and "Other Prompt Types".

Components

Caption

Use this field to enter a caption for the image map prompt. The caption is displayed as the prompt's field label. For example, "Click a region to see sales data." You can include HTML markup tags in the caption, such as <b>, <font>, and <table>.

Description

Use this field to enter a description that is saved with the prompt. Descriptions are displayed when an administrator uses the Catalog Manager.

Image URL

Use this field to specify the location of the image file.

The image file must reside on a Web server. Oracle recommends that you put the image files in the directory that contains all Web resource files (for example, app\res\region3.jpg). Placing the image files with the Web resource files prevents a security warning message from displaying when the user accesses the image from the dashboard or analysis.

However, if you are using a Web server, such as WebServices, where the resource files are located in the deploy directory, then you must put the image file in the deploy directory and the directory that contains all Web resource files.

You can reference variables in this field. For the syntax to use, see "What Is the Syntax for Referencing Variables?" For more information on variables, see "Using Variables".

HTML

Use this field to specify the HTML <map> tags. In the map tags, you indicate the map region's shape, X and Y coordinates, and region name.

Extract Image Map from HTML

Use this link to extract the values that you specified in the HTML <map> tags and put them in a table where you can link the regions to data columns and values.


Import Background Maps dialog

Use this dialog to import maps to the Background Maps tab of the "Administration: Manage Map Data page". For information, see "Administering Maps" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

This dialog is also displayed as:


Add Layers dialog
Import Images dialog
Import Layers dialog

Components

Look in

Not available for the Add Layers dialog. Use this box to select the connection to a data source in MapViewer that contains the predefined background maps, layers, or images from which you want to select. Each data source can contain a set of background maps, layers, and images. The sets are not related to each other. (In MapViewer, background maps are referred to as "tiles.")

The list of connections includes all those that have been defined during the configuration of MapViewer.

Available Items

Use this list to select one or more background maps, layers, or images, depending on which dialog is displayed.

Previewing Area

Displays a preview of the selected background map, layer, or image. If multiple items are selected, then the last selected item is displayed. The name of the item is displayed at the top of the Previewing Area.

Preview Map

Available only in the Import Layers dialog. Use this list to select the background map to display for previewing the layer. If no background map is available, then a static image of the layer is shown in the Previewing Area. The default background map displayed is the map that covers the largest spatial area, because that map has the highest probability of displaying the points that comprise the layer.


Initiative Linkage dialog

Use this dialog to specify how strongly an initiative drives an objective or how strongly an objective is driven by an initiative.

For more information, see:

This dialog also displays as:


Objective Linkage dialog

Components

Initiative

Displays the name of the initiative that drives the objective.

Objective

Displays the name of the objective that is driven by the initiative.

Strength

Use this box to specify whether the strength of the relationship between the objective and initiative is Strong, Moderate, or Weak.

For example, an initiative called "Upgrade Out Of Date Software" might moderately drive an objective called "Improved Employee Productivity".

Proportionality

Use this box to specify whether changes in performance or value in one object are directly proportional (Direct) or inversely proportional (Inverse) to changes in performance or value in the other object.

For example, in a relationship between an objective named Reduce Customer Complaints to 4% and an initiative named Improve Quality Control, the proportionality would be inverse because improvements in quality control should result in lower numbers of customer complaints.


Initiatives pane

Use this pane to create, modify, and delete initiatives.

For more information, see:

This pane is part of the "Scorecard editor".

Components

Initiative Tree

Displays the initiatives that have been defined for the scorecard and the KPIs that measure their progress hierarchically. It also shows the statuses of initiatives and KPIs using the appropriate colors and symbols that you specified for assessment mappings. For more information on assessment mappings, see "Defining Assessment Mappings for Scorecards".

Toolbar

This toolbar contains the following buttons:

Right-Click Menu for an Object

Displays options for working with an object. See "Right-Click Menu for Objects in the Initiatives Pane and Strategy Pane".


Right-Click Menu for Objects in the Initiatives Pane and Strategy Pane

The right-click menu for objects in the "Initiatives pane" or the "Strategy pane" provides a number of options that allow you to work with the objects in the pane. For example, you can open objects or delete objects.

The options vary depending on the type of object, whether the object is in the Initiatives pane or Strategy pane, and whether the Scorecard editor is in edit or read-only mode:


Insert Filter dialog

Use this dialog to add a SQL FILTER function to a column formula in the "Edit Column Formula dialog: Column Formula tab".

For more information, see:

Components

Filter Function Area

Displays the SQL function in the form:

FILTER(expr USING filter_expressions)

Where:

Use this area to define filter_expressions by adding a single filter expression or building a complex filter statement using multiple filter expressions.

For each filter expression to add, select a column from the Subject Areas pane. The "New Filter dialog" is displayed where you create the filter to add to the filter expression.

As you define the filter_expressions, you can use the following:

Subject Areas

Use the "Subject Areas pane" to select columns to add to the filter expression.

Catalog

Use the "Catalog pane" to select filters from the catalog to add to the filter expression.


Insert Function dialog

Use this dialog to select a function to add to a formula in the "Edit Column Formula dialog: Column Formula tab".

For more information, see:

Components

Functions

Use this tree to select a function to add to a formula. Expand a function group to show a list of functions within that group.

Selected

Displays the name of the function that is currently selected in the Functions tree.

Syntax

Displays the syntax of the function that is currently selected in the Functions tree.

Where

Displays descriptions of the arguments for the syntax.

Example

Displays an example of the function.

Description

Displays a description of the function that is currently selected in the Functions tree.

Notes


Insert Variable dialog

Use this dialog to add a variable (either session, repository, or presentation) to a formula in the "Edit Column Formula dialog: Column Formula tab" or in the "New EVALUATE_PREDICATE Function dialog".

For more information, see:

Components

Variable Name

This field is available only if you have selected Session and Repository as the variable type to add.

Use this field to enter the name of the session or repository variable, for example USER.

Variable Expression

This field is available only if you have selected Presentation as the variable type to add.

Use this field to enter the name of the presentation variable, for example MyFavoriteRegion.

To type-cast (that is, convert) the variable to a string, enclose the name in single quotes, for example:

'user.displayName'

Default Value (Optional)

This field is available only if you have selected Presentation as the variable type to add.

Use this field to enter a default value for the presentation variable, for example EASTERN REGION.

Notes

Related Topics


"Using Variables"

Invoke Action dialog

Use this dialog to provide values for action parameters and to run an action.

For more information, see:


Key Resource dialog

Use this dialog to identify a user who is a key resource on an initiative.

For more information, see:

Components

User

Displays the name of a user who is a key resource on the initiative. Click the Set User button to display the "Select Key Resource User dialog", where you search for and select the user.

Capacity

Use this field to enter the percentage of full time hours the user devotes to this initiative, for example, 80%.


KPI editor

Use this editor to create and modify KPIs that monitor your company's performance and goals. The KPIs that you create define performance targets and evaluate the performance of objectives and initiatives.

For more information, see:

This editor is also displayed as:


Scorecard editor: KPI tab

Components

General Properties

Use the "KPI editor: General Properties page" to enter the business owner, the actual value, the target value, and to turn on trending to compare KPI values with those from a previous period.

Dimensionality

Use the "KPI editor: Dimensionality page" to specify dimensions that determine how Oracle BI EE aggregates data in the KPI.

States

Use the "KPI editor: States page" to specify the performance thresholds and range of values that determine how KPI performance is evaluated and represented. Also use this page to create action links for the KPI.

Related documents

Use the "KPI editor: Related Documents page" to attach any relevant document or business intelligence object stored in the Oracle BI Presentation Catalog.

Custom Attributes

Use the "KPI editor: Custom Attributes page" to create custom columns for the KPI.

Related Topics


"Scorecard editor"

KPI editor: Custom Attributes page

Use this page of the "KPI editor" to create custom columns for the KPI. You can add a maximum of five custom columns.

For more information, see:

This page is also displayed as:


Scorecard editor: KPI tab

Components

Custom Columns

Displays the custom columns for the KPI.

Use this table to create custom columns. To add a custom column row to the table, click the Add button. Consider the following options:

Add

Use this button to add a custom column row to the Custom Columns table.

Remove

Use this button to remove the row that is currently highlighted in the Custom Columns table.

Related Topics


"KPI editor: General Properties page"
"KPI editor: Dimensionality page"
"KPI editor: States page"
"KPI editor: Related Documents page"
"Scorecard editor"

KPI editor: Dimensionality page

Use this page of the "KPI editor" to add or remove KPI dimensions. This page also enables you to pin a value to a dimension.

Dimensions are based on attribute columns and hierarchical columns and determine how Oracle BI EE aggregates data in the KPI. For example, if you are creating a KPI for product sales, you could add dimensions that allow the user to view sales by both a specific region and a specific year.

Note that almost all KPIs should include a Time dimension, except constants or metrics defined only to be current snapshots like "Inventory On Hand" or "Current Phone Support Wait Time." It is not necessary to pin the time dimension to a specific value. It is a best practice to leave Time unpinned within the KPI definition. For more information, see the below description for the Value field. An unpinned Time dimension enables a dashboard or scorecard user to select the time period to display and enables the creation of trend and historical charts or tables.

For more information, see:

This page is also displayed as:


Scorecard editor: KPI tab

Components

Name

Displays the column name that you chose for the dimension. To add a dimension to the KPI, click the Add button.

Value

Use the down arrow to browse or search for and choose a value to pin to the dimension. When a user views the KPI, the pinned value aggregates the KPI. Select Not Pinned to do one of the following:

Note that when the designer pins a dimension value, that value cannot be changed when a user adds the KPI to a watchlist or scorecard. Only the designer or user with the appropriate permissions can access the KPI editor to modify a dimension's pinned value.

Oracle suggests that you create KPIs that are not pinned in their initial definition. Such KPIs are more flexible, reusable, and prevent you from creating and managing many over-specific KPIs. Suppose that you create a Sales KPI without pinned region or time dimension values. You can then specify usages of the same KPI definition by pinning different region and time dimension values within scorecards, scorecard views, KPI watchlist rows, or dashboards.

Add

Use to access the KPI's subject area where you can select another attribute or hierarchical column as a dimension.

Remove

Use to delete the highlighted dimension from the KPI.

Related Topics


"KPI editor: General Properties page"
"KPI editor: States page"
"KPI editor: Related Documents page"
"KPI editor: Custom Attributes page"
"Select Values dialog"
"Scorecard editor"

KPI editor: General Properties page

Use this page of the "KPI editor" to specify the actual value (collected or calculated value) and the target value (desired value) of the KPI. You can enter, insert, or calculate these values.

Also use this tab to assign the business owner responsible for the KPI and specify if the KPI should support trending. Trending enables you to compare previous values to current values. For example, you can compare your December 2009 sales to the current year's sales.

To analyze KPIs by multiple dimensions (for example, Product, Geography, and Time), ensure that the data you use to calculate actual and target values is also dimensioned by Product, Geography, and Time.

For more information, see:

This page is also displayed as:


Scorecard editor: KPI tab

Components

Description

Use this field to enter a description of the KPI.

Business Owner

Use this field to view and select the userID of the person responsible for the business performance of the KPI. Business owners have the ability to override the KPI's statuses.

Click the Set User button to search for and select a business owner.

Set User

Use this button to open the "Select Business Owner dialog", where you can search for the person whom you want to assign as the KPI's business owner.

Actual Value

Use this field to specify a value to compare to the target value. Consider the following options:

Target Value

Use this field to specify the value that you want the KPI to achieve. The target value is a quantifiable goal for each measure. Consider the following options:

Down Arrow

Use this button to access the subject area list. From this list you can browse for and select a column for the value.

Edit Value Formula

Use this button to access the "Edit Column Formula dialog: Column Formula tab" to create a formula that calculates the value.

Enable Trending

Use this option to indicate the direction in which change occurs (up or down), the extent of the change (as a value and percentage), and if the change indicates an increase or decrease in performance. If trending is enabled, then users see a trend icon on nodes in Scorecard diagrams, in KPI watchlists, and in other tables within Scorecard that reference this KPI. Users also see a history chart on the KPI Details and KPI Overview tabs in Scorecard.

To use trending, ensure that a time dimension is defined in the subject area.

Data Format

Displays an example of how the numeric data displays in the KPI. Click Edit to access the dialog where you specify the data format settings for the KPI.

Compare to Prior

Use this option to select the period of time to use for trend analysis. The period that you select determines the time periods displayed in history charts on the KPI Details tab and KPI Overview tab in Scorecard.

For example, to compare Units Shipped quarterly, select "Fiscal Time"."Quarterly". In this example, the KPI trends upward, downward, or unchanged based on the KPI values from one quarter to the next. Any KPI change values are computed using "Quarterly" as the period of analysis.

Tolerance

Use this field to enter the tolerance value for the trend. This field enables you to prevent reporting non-significant trends, such as expenses being over-budget by $100.

The tolerance value that you enter must be a literal and can be expressed either as a percentage or absolute value (for example, 5,000 or 5%). The tolerance level must be met before the KPI displays the performance as improving or worsening.

Tolerance Down Arrow

Use this field to specify how to measure tolerance value that you entered in the Tolerance field. Choose % Change to measure it by percent or Change to measure tolerance by the actual value.

Related Topics


"KPI editor: Dimensionality page"
"KPI editor: States page"
"KPI editor: Related Documents page"
"KPI editor: Custom Attributes page"
"Scorecard editor"

KPI editor: Related Documents page

Use this page of the "KPI editor" to view and add links to business intelligence objects or web pages that provide additional information about or can be used with the KPI. After you add related documents to a KPI, the related documents display in the "KPI editor: Related Documents page" and on the "Scorecard editor: KPI Details tab".

For more information, see:

This page is also displayed as:


Scorecard editor: KPI tab

Components

Name

Displays the link to the related item. Click this link to access the related document, or click Edit to modify the link.

Location

Displays the location of the related item. The location is either a location within the catalog or a URL to a location outside of the catalog.

Type

Displays the type of item. "Catalog" displays if the item is located in the catalog, or "Web" displays if the item is located outside of the catalog.

Add

Use to access the "Add a Related Document dialog" to add an item to the Related Documents table.

Remove

Use to remove the highlighted row from the Related Documents table.

Related Topics


"KPI editor: General Properties page"
"KPI editor: Dimensionality page"
"KPI editor: States page"
"KPI editor: Custom Attributes page"
"Scorecard editor"

KPI editor: States page

Use this page of the "KPI editor" to:

For more information, see:

This page is also displayed as:


Scorecard editor: KPI tab

Components

Goal

Use this list to specify if high, low, or closer to target values indicate the KPI's performance goal.

For example, select High values are desirable for a Customer References KPI or Low values are desirable for an Unresolved Support Calls KPI.

Status label

Use this field to enter the label for the status, for example, Critical.

Color

Use this button to access the "Color Selector dialog" where you can select a text color to represent the corresponding status, for example, red for Critical.

Icon

Use this button to access the "Graphics dialog" where you can select an icon to represent the corresponding status, for example, a red X for Critical.

Actions

Use this button to display the "Action Links dialog" wherever the KPI displays, such as on objectives, initiatives, KPI Watchlist, or on the scorecard views on dashboards. This dialog specifies the processes or operations to be performed or invoked if the status of a KPI corresponds to a specific performance state. Action links display from the right-mouse click wherever the KPI displays, such as on an initiative or a KPI Watchlist.

For example, if a KPI for quarterly revenue is less than a particular amount, then an action is triggered that automatically schedules a mandatory meeting of sales directors and managers.

define as % of target value

Use this box to specify whether you want to define thresholds as discrete values or as percentages of the target value. Select this box to define thresholds as percentages of the target value. Deselect this box to define discrete values for thresholds.

Thresholds

Use these fields to enter the numeric values that set the boundaries for the status ranges.

Depending on whether you selected the define as % of target value box, you can specify either of the following:

Remove

This button is displayed only if the Show Advanced Properties options is selected.

Use this button to remove the threshold.

Add

This area is displayed only if the Show Advanced Properties options is selected.

Use this button to add another threshold above or below the threshold.

Show Advanced Properties

Use this option to specify whether to display the scores to which KPI statuses are mapped.

Score

This area is displayed only if the Show Advanced Properties options is selected.

Uses this area to specify the scores to which KPI statuses are mapped. Use the Score button to display these options:

If KPI returns no data

Use this box to specify the status to assign to a KPI that returns no data. The options are No status or one of the defined statuses, for example, Critical.

Related Topics


"KPI editor: General Properties page"
"KPI editor: Dimensionality page"
"KPI editor: Related Documents page"
"KPI editor: Custom Attributes page"
"Scorecard editor"

KPI Watchlist editor

Use this editor to create a KPI watchlist.

This editor is also displayed as:


Scorecard editor: KPI Watchlist tab

For more information, see:

Components

Catalog

Use the "Catalog pane for Scorecard" to locate and drag and drop KPIs from the catalog to build a KPI watchlist.

Performance

Use the "KPI Watchlist editor: Performance tab" to build the watchlist by dragging and dropping KPIs from the catalog pane to the KPI Watchlist. The KPI watchlist displays the KPIs' performance levels and other KPI data.

Details

Use the "KPI Watchlist editor: Details tab" tab to supply a description of the KPI watchlist, specify a business owner, and attach any necessary related documents.

Toolbar

This toolbar contains the following buttons:


KPI Watchlist editor: Details tab

Use this tab of the "KPI Watchlist editor" to specify supporting information for the KPI watchlist.

For more information, see:

Components

KPI Watchlist Name

Displays the name of the KPI watchlist.

Description

Use this field to enter a description of the KPI watchlist.

Business Owner

Displays the userID of the person responsible for managing the KPI watchlist. To specify the business owner, click the Set User button to display the "Business Owner dialog", where you can search for and select the business owner.

Related Documents

Use the "Related Documents area" to view and manage documents that provide supporting information to the KPI watchlist.


KPI Watchlist editor: Performance tab

Use this tab of the "KPI Watchlist editor" to add KPI instances to the watchlist. When you add a KPI to the watchlist, you add an instance of the KPI. You can then assign default dimension values to the KPI's instance. From this tab you can also modify the KPI stored in the catalog, or view the KPI instance as an analysis.

Components

KPI Watchlist

Use this table to add KPIs to and manage KPIs in the watchlist.

See "Initiatives & KPIs table; Objectives & KPIs table; Objectives, Initiatives & KPIs table; New KPI Watchlist table; and Breakdown table".

Related Topics

"KPI Watchlist editor: Details tab"


Layout pane

Use this pane to specify the layout of data in data views (graphs, gauges, funnel graphs, pivot tables, and tables).

For more information, see:

This pane is part of the following editors:

Components Common to All Data Views

Note:

This section describes the components that are common to all data views. Additional components are available in the Table and Pivot Table editors (see "Additional Components Common to the Table and Pivot Table Editors") and in the Graph, Funnel, and Gauges editors (see "Additional Components Common to the Graph, Funnel, and Gauge Editors").

Drop Targets

Use drop targets to modify the way that data is arranged in a view. By dragging columns from one drop target and dropping them in another, you can rearrange the data to suit your needs.

The drop targets that are displayed in this pane depend on the type of view. For more information, see "Understanding Drop Targets".

Properties

Use this button to display the Properties dialog for a drop target. For example, if you click the button beside the Sections drop target, then the "Section Properties dialog" is displayed. If you click the button beside the view type name for tables and pivot tables, then the Properties dialog for that type of view is displayed.

Additional Components Common to the Graph, Funnel, and Gauge Editors

Display as Slider

Use this box to specify whether the members of the columns dropped in the Sections drop target are to be displayed as a section slider rather than as unique views. Select this box to display the members as a section slider. Deselect this box to display the each member as a unique view. For more information on section sliders, see "Defining Section Sliders in Graphs and Gauges".

Use unified scale

This box is available only for line bar graphs.

Use this box to specify whether to display the lines and bars using the same scale or two separate scales, one for the lines and one for the bars.

Select this box to use one scale for both the lines and bars. The measure column that has the higher values is used for the scale.

Deselect this box to use two scales.

Show In Legend

Use this box to specify whether a legend is to be displayed to show the color variation of the columns dropped in the Vary Color By (Horizontal Axis) drop target.

Additional Components Common to the Table and Pivot Table Editors

Totals

Use this button to add a grand total for that drop target for the entire view for attribute columns and hierarchical columns and to display the following options:

More Options

Use this button to display the following options:


Aggregation Rules and Functions

The following list describes the aggregation rules that are available for measure columns in the "Layout pane" and for columns in the "Edit Column Formula dialog: Column Formula tab". The list also includes functions that you can use when creating a calculated item.


Legend pane

Use this pane to view the legend for a cause & effect map or strategy map.

For more information, see:

This pane is part of the "Cause & Effect Map tab: Diagram tab" or the "Strategy Map tab: Diagram tab".

Components

Legend

Displays and explains the symbols used on the cause and effect map or strategy map to indicate the proportionality. That is, whether changes in performance or value in the cause and effect relationship are directly proportional (direct) or inversely proportional (inverse) and strength (strong, moderate, or weak) of cause & effect relationships.


Link or Image Properties dialog

Use this dialog to specify properties for a text link or image link that you are adding to a dashboard page.

For more information, see "Adding Content to Dashboards".

Components

Caption

Use this field to enter the text to display for the text link or image link.

Entering a caption for an image link is optional. If you do enter one, then you must also specify, in the Image Layout box, where the caption is to be displayed relative to the image.

Destination

Use this field to specify what is to happen when the user clicks the text or image:

Target

Use this box to specify whether the information is to be displayed in the Current Window or in a New Window for the browser.

For every action except sending mail and executing a program, you can control how the link should be displayed. Select the current window when you want the action to occur in the display pane of the dashboard. This leaves the dashboard active but in the background. Choose a new window when you want the action to take place in a new browser window. This opens another instance of the browser.

Image

Use this field to enter the location and name of the image to be displayed. Specify the location as a URL. These are examples:

http://imageserver/MyImage.gif
/DashboardFiles/image.gif

If the image is not on the local server, then the URL must include http://. If the image is for use in a shared environment, then ensure that the image is located on a network drive that is accessible to all users.

Image Layout

Use this box to select where to display the image, such as to the right or left of the caption or above or below the caption, if you entered a caption.

Notes


Manage Favorites dialog

Use this dialog to organize and manage your favorite objects. Favorite objects are those catalog objects that you view regularly or want to view again at another time.

For more information, see:

Components

Category Tree

Use this area to browse for and select a favorites category. After you select a category, any favorite objects or subcategories included in the selected category display in the Selected Category area.

Selected Category

Use this area to view the favorites objects and subcategories included in the category that you selected in the Category Tree area.

You can use this area to organize your favorites by dragging and dropping them into categories or subcategories. You can use this area to create new subcategories, rename a category, rearrange the order of the objects in the category, and copy, paste, and remove objects from your favorites list.

Toolbar

The toolbar contains the following buttons:


Map Properties dialog

Use this dialog to edit the properties of a map view, such as its size and the options that are available on the toolbar.

For more information, see "Editing Map Views".

Components

Canvas

Use the "Map Properties dialog: Canvas tab" to specify the size of the map.

Tools

Use the "Map Properties dialog: Tools tab" to specify which tools are available for display with the map.

Interaction

Use the "Map Properties dialog: Interaction tab" to specify whether to automatically create formats when drilling in a map.

Labels

Use the "Map Properties dialog: Labels tab" to specify whether to show the labels for certain layers on the map view.


Map Properties dialog: Canvas tab

Use this tab of the "Map Properties dialog" to specify the size of the map.

For more information, see "Editing Map Views".

Components

Canvas Size

Use this box to specify the size of the map within its container. You can select either Default, Custom, or a predefined size. If you select Default or a predefined size, then no other options are available and the map is sized to fit its container. The container is whatever area is holding the map, such as the area in the Map editor or the section of a dashboard page.

Width

Use this field to specify the width of the map in pixels.

Height

Use this field to specify the height of the map in pixels.


Map Properties dialog: Interaction tab

Use the Interaction tab and the Labels tab of the "Map Properties dialog" to do the following:

The tab is also displayed as:


Map Properties dialog: Labels tab

For more information, see "Editing Map Views".

Components

Automatically create formats when drilling

Available on the Interaction tab. Use this box to specify whether to automatically create formats each time that you drill in a map. The formats that you create are listed in the Map Formats pane and are based on the formats that exist on the base drill layer. For example, if you have a Region color fill format and a Region pie graph format and you drill on that layer, then you automatically create a new color fill format and a new pie format with the drill action.

You can also specify this option in the Map Formats area of the Map View editor. The option is updated in both places when you make a change in either place.

Show Labels for Spatial Layers

Available on the Labels tab. Use this box to specify whether to show labels for all layers or specific layers on the map view. The tab includes a box for each layer on the map view. The labels are displayed in the same order as that of the layers listed in the Map Formats area of the Map View editor. Custom point layers have labels hidden by default.


Map Properties dialog: Tools tab

Use this tab of the "Map Properties dialog" to specify which tools are available for display with the map.

For more information, see "Editing Map Views".

Components

Toolbar

Use this box to specify the display of the following buttons on the toolbar:

Overlay

Use this box to specify the display of the following options on top of the map:

Information

Use this box to specify the display of the following options in the Information panel of the map:


Mission tab: Details tab

Use this tab of the "Scorecard editor: Mission tab" and the "Scorecard editor: Vision tab" to specify supporting information for the mission or vision statement.

For more information, see:

The tab is also displayed as:


Vision tab: Details tab

Components

Name

Displays the name of the mission or vision statement.

Description

Use this field to enter a description of the mission or vision statement.

Business Owner

Displays the userID of the person responsible for managing the mission or vision statement. To specify the business owner, click the Set User button to display the "Business Owner dialog", where you can search for and select the business owner.

Related Documents

Use the "Related Documents area" to view and manage documents that provide supporting information to the mission or vision statement.


Mission tab: Document tab

Use this tab of the "Scorecard editor: Mission tab" and the "Scorecard editor: Vision tab" to enter and format your mission statement or vision statement.

For more information, see:

The tab is also displayed as:


Vision tab: Document tab

Components

Toolbar

This toolbar contains buttons (such as Bold, Increase Font Size) for formatting your mission or vision statement.


My Account dialog

Use this dialog to specify your personal preferences, such as your locale, time zone, preferred currency, and delivery options for the delivery of alerts by agents. The options that display on this dialog depend upon your privileges.

Note:

If the Delivery Devices and Deliver Profiles tabs contains devices and profiles, then do not make any changes to these tabs without first consulting the administrator, as any changes you make override the delivery device and profile information that was configured for you.

For more information, see:

Components

User ID

Displays the user ID that is shown in the user interface.

Display Name

Displays the name that is shown in the user interface.

Preferences

Use the "My Account dialog: Preferences tab" to specify your account's display preferences.

BI Publisher Preferences

Use the "My Account dialog: BI Publisher Preferences tab" to specify your Oracle BI Publisher preferences.

Delivery Options

Use the "My Account dialog: Delivery Options tab" to configure your devices and profiles for the delivery of alerts.

Roles and Catalog Groups

Use the "My Account dialog: Roles and Catalog Groups tab" to view a list of the Application roles and Catalog groups to which you have been assigned by the administrator.

Delegated Users

Use the "My Account Dialog: Delegated Users tab" to view a list of users who have been given the privileges to access your analyses and dashboards, if the administrator has configured this functionality.


My Account dialog: BI Publisher Preferences tab

Use this tab of the "My Account dialog" to modify the Oracle Business Intelligence Publisher preferences.

For more information, see:

Components

Report Locale

Use this box to select a locale for reports. This locale can be different than the locale that you specified in the "My Account dialog: Preferences tab".

The reports that you view and create use the locale that you specify here. The locale usually corresponds to the language that you specify in the User Interface Language field that you selected in the "My Account: Preferences tab" or the country from where you are working. For example, your specified language is English and your locale can be English - United States or English - Canada. The locale that you select determines the date and time formats, daylight saving time settings, and currency formats settings.

Report Time Zone

Use this box to select the time zone to apply when viewing or creating reports. This time zone can be different than the time zone that you specified in the "My Account: Preferences tab."

This option is useful if you do not reside in the same physical location as the default time zone that was set by the administrator, and you want to select another time zone.


My Account Dialog: Delegated Users tab

Use this tab of the "My Account dialog" to view a list of users who can use the "Act As" functionality to access your analyses and dashboards. You cannot modify this list. This tab is available only if the administrator has configured this functionality.

Depending upon the privileges, users can inherit your user privileges, which enables them to change your default dashboard and modify your content and preferences, or they are granted restricted access to only view your analyses and dashboards. When users are granted restricted access, they maintain their own user privileges when accessing your business intelligence content.

For more information, see:


My Account dialog: Delivery Options tab

Use this tab of the "My Account dialog" to configure your delivery devices and delivery profiles. Your delivery devices, along with your delivery profiles, control how you are reached when an alert is generated by an agent.

For more information, see:

Components

Devices

Use this area to configure your delivery devices. To do so, in the first box, select the category of the device, either Email, Phone, Pager, Handheld, or Other), and then to:

Delivery Profiles

Use this area to configure your delivery profiles. Click the Create Delivery Profile button to display the "Create Delivery Profile dialog", where you create a delivery profile.

If you want a delivery profile to be your active profile, click the Active option in the Active column to the right of the profile name.

To delete a delivery profile, select the profile name and then click the Delete Profile button.

To edit a delivery profile, select the profile name and then click the Edit Profile button. The "Edit Delivery Profile dialog" is displayed.


My Account dialog: Preferences tab

Use this tab of the "My Account dialog" to specify your account's display preferences.

For more information, see:

Components

Starting Page

Use this box to select the dashboard to display when you sign in to Oracle BI Enterprise Edition. Note the following options:

Locale (location)

Use this box to select a locale. The locale usually corresponds to the language that you specify in the User Interface Language field or the country from where you are working. For example, your specified language is English and your locale can be English - United States or English - Canada.

The locale that you select determines the date and time formats, daylight saving time settings, and currency formats settings.

User Interface Language

Use this box to select the language in which you want the Oracle BI EE interface to display. The language that you specify here persists, unless, for example, it is overridden for the session by the language that you specify in the "Sign In page". If your language is overridden, then the cause of the override displays in a second box within this field.

Time Zone

Use this box to select the time zone to apply when viewing content. This option is useful if you do not reside in the same physical location as the default time zone that was set by the administrator, and you want to select another time zone. For example, suppose that the Oracle BI Server that sends you alerts resides in the US Pacific time zone, but your work location is in the US Central time zone. After you set the Central time zone as your preferred time zone setting, the delivered time on your alerts is displayed in Central time.

Your account's time zone automatically applies to any items that you create, modify, run, receive, and print. The date and time columns included in analyses are displayed according to the content designer. The content designer can force a specific time zone to be displayed in the column or can allow your default time zone to be displayed in the column. A clock button is displayed in the column heading, and when you hover over this button, the name of the time zone used in the column is displayed.

For more information on how the administrator sets the Oracle BI Server time zone, see Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.

Currency

This box is available only if the administrator has configured the userpref_currencies.xml file. For information, see "Configuring Currency Options" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Use this box to select the currency in which to view currency columns in dashboards and analyses.

This selection:

The administrator defines the currency options that are available in this box.

Prompts Auto-Complete

Use this field to enable or disable the auto-complete functionality for your account. Choosing Off disables auto-complete for all dashboards that you access, and disables the auto-complete functionality when you search for prompt values in the "Select Values dialog".

When enabled, Oracle BI EE suggests and highlights matching prompt values as you type in the dashboard's prompt selection field and highlights matching prompts values in the search dialog. See "What Is Auto-Complete?"

Analysis Editor

Use this option to specify which editor you want to use when you work with analyses:

Accessibility Mode

Use this option to select whether content for Oracle BI EE is rendered in a browser in a way that facilitates the use of a screen reader.

If you select On, then the BI Composer wizard in accessibility mode will be used as the analysis editor, regardless of the setting of the Analysis Editor component.

If you select Off, and the setting of the Analysis Editor component is Wizard (limited functionality), then the BI Composer wizard in regular mode will be used as the analysis editor.

This setting persists unless it is overridden for the session by the accessibility mode setting in the "Sign In page".

If you had selected accessibility mode on sign in and you turn off accessibility mode here, it will override the accessibility mode setting in the Sign In page.

For information, see Appendix C, "Accessibility Features."


My Account dialog: Roles and Catalog Groups tab

Use this tab of the "My Account dialog" to view a list of the Application roles and Catalog groups to which you are assigned. You cannot modify this list. See the administrator to be added to or removed from Application roles.

An Application role defines a set of permissions. Any user or group assigned to an Application role is granted the permissions associated with that role. For example, you might belong to a role that enables you to view and not create business intelligence content.

A Catalog group is defined locally in Oracle BI Presentation Services and is used to grant privileges in the Oracle Business Intelligence user interface in addition to granting Oracle BI Presentation Catalog permissions.

For more information on Application roles and Catalog groups, see Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition.


New Action Link dialog

Use this dialog to create an action link to add to an analysis.

For more information, see:

This dialog is also displayed as:


Edit Action Link dialog

Components

Link Text

Use this field to enter the text to display as the link to execute the associated action.

Action

Displays the action to be associated with the action link.

Create New Action

Use this button to select the type of action to create. If you selected:

Select existing action

Use this button to display the "Open dialog", where you select an existing action to add to the analysis.

Edit Parameter Mapping

This button is available only for named actions that have parameters that are not fixed or hidden.

Use this button to display the "Edit Parameter Mapping dialog", where you edit the action parameters.

More (>>)

Displays these options:

Enable

Use this box to specify one of the following options:

Conditions

(Displayed only if the Conditionally option is selected.)

Use this area to create one or more conditions to be used to conditionally enable the action link.

To create a condition, you select either an attribute column or a hierarchical column on which to base it but with these restrictions:

If you add multiple conditions, then each additional condition you add is combined with the previous condition using the AND operator. The AND operator means that the criteria specified in each condition must be met. This is the default method for combining conditions. You can change the AND operator to OR by clicking AND. The OR operator means that the criteria specified in at least one condition must be met.

Depending on how you construct the condition combinations with the AND and OR operators, some conditions might be grouped. Grouped conditions are bounded by boxes.

This area includes the following components:


New Calculated Item dialog

Use this dialog to create or edit a calculated item or a group.

For more information, see "Working with Groups and Calculated Items".

This dialog is also displayed as:


Edit Calculated Item dialog
Edit Group dialog
New Group dialog

Components

Note:

Not all components are available in each version of the dialog.

Display Label

Use this field to specify the label for the calculated item or group when it is displayed in a view. This label can differ from the name under which the object is stored in the Oracle BI Presentation Catalog.

Values From

Use this box to select an attribute column or hierarchical column, which is included in the analysis, whose values you want to use for the calculated item or group. This field is read-only if you displayed the dialog from the Layout pane or from a location in which a column was previously selected.

Function

Use this box to select the function for the calculated item. Many of the functions are those described in "Aggregation Rules and Functions".

In addition, you can select Custom Formula, which provides a toolbar with which you select mathematical operators to include in the function for the calculated item. You can also enter the following functions: Absolute, Ceiling, Floor, Round, Sqrt.

A formula creates a dynamic custom grouping within the view. All measures referenced in a formula must be from the same column and must be present in the results. Formulas can be inserted into, or combined with, other calculated items.

Instead of specifying a named item for attribute columns, you can specify $n or $-n, where n is an integer that indicates the item's row position. If you specify $n, then the measure is taken from the nth row. If you specify $-n, then the measure is taken from the nth to the last row.

Available

Use this area to select members to move to the Selected List area. The "Catalog pane" is displayed so you can select members or groups from there. When you move a member to the Selected List area, it is displayed with a green check mark beside it in the Available List area.

Search

Use this button to display the Search area of the "Select Values dialog", where you can locate members.

Selected

Use this area to view the values that you have selected from the Available area and moved to the Selected area. If you selected Custom Formula, then use the toolbar of mathematical operators at the bottom to create the formula for this calculated item. Use the following operators:

Format

Use this button to display the "Edit Format dialog" where you format the calculated item or group. If you apply formatting in this dialog, this formatting is applied first, then conditional formatting is applied.

Remove calculated item members from view

Use this box to suppress the display of the members that you have included in the calculated item in the view. For example, suppose that you have a pivot table that is displaying Region on the row edge, and it is currently showing the values Eastern, Western, and Central. Suppose that you create a new calculated item called "Other Regions" that is the sum of Western + Central. If you select Remove calculated item members from view, then only two members are shown in the pivot table: Eastern and Other Regions.

If you select this box for a custom formula, then an implicit remove selection step is created using the items from either the custom formula or from the Selected list.

Selection Steps

Use this tab to see the steps that are saved as a group, if you select the Steps button. This tab is available only if you are editing a group that you have previously saved as a list of selection steps.

Results

Use this tab to see the members that have been specified by the selection steps.

Steps (generate results dynamically at run time)

Click this button to save the selection steps for a group. The results of the selection are refreshed at run time.

Results (generate results now and display every time)

Click this button to save a group as a list of members, rather than as a list of steps.

Notes


New Category dialog

Use this dialog to specify the favorites category to create. For more information, see "Organizing Favorites" and "Manage Favorites dialog".

Component

Name

Use this field to enter the name of the favorites category. The category name that you enter will display when you click the Favorites list, located on the global header.


New Condition dialog

Use this dialog to create or edit a condition.

For more information, see Chapter 9, "Working with Conditions."

This dialog is also displayed as:


Create Condition dialog
Edit Condition dialog

Components

Create condition based on

Use this list to select whether the condition is to be based on an Analysis or KPI.

Browse

Use this button to display one of the following dialogs, where you select the analysis or KPI on which to base the condition:

Condition Data

Displays the following:

Parameters

Displays the prompted filters associated with the analysis. (A prompted filter is a filter whose operator is set to Is Prompted.)

Click the Edit button adjacent to a prompted filter to display the "Edit Parameter Filter dialog", where you edit the filter.

Dimension Value area

Displays the KPI dimensions whose values were set to Not Pinned in the KPI. Use the Value fields to specify values for these dimensions.

True If Row Count

This area is available only if the condition is based on an analysis.

Use this area to specify the evaluation criteria as follows:

Condition true if KPI

This area is available only if the condition is based on a KPI.

Use this box to specify the KPI status on which the condition is to be evaluated.

Test

Use this button to test whether the condition evaluates to true or false. Displays the Test Condition dialog, which provides the results of the condition evaluation.


New Condition Step dialog

Use this dialog to create a condition step as part of working with selection steps.

For more information, see "Working with Selections of Data".

This dialog is also displayed as:


Edit Condition Step dialog

Components

Condition Type

Use to select from a list of condition types for the specified dimension column. The following list describes the categories of condition steps that you can create. The components in this dialog differ slightly, depending on which type you select.

Action

Use this box to select the type of action to create for the members that the condition step specifies. You can select to add the selected members to the selection, keep only the selected members and remove all others, or remove the selected members from the selection.

Use the box beside the action type to select the column for whose members you are creating the condition step.

Column

Use this box to select the attribute column on which to base the condition, when created condition steps of the type Match, All X Values where Y = values.

Operator

Use this area to select the operator, based on the type:

Number

Enter the number of time periods, such as 3, when creating condition steps of type Time/Ordinal.

Time Period

Select the column value on which to base the condition, when creating condition steps of type Time/Ordinal.

Rank or Range

Enter the percentage to use for the rank or range, such as 5, when creating condition steps of type Exception or Top/Bottom.

Value

Enter the value to use for the comparison, when creating condition steps of type Exception.

Text

Enter the string to use for matching with the members, when creating condition steps of type Match. Select Match Case to provide case-sensitivity for the matching.

Override with

Use this box to specify that an analysis prompt, a dashboard prompt, or a variable can override the values that you specify in this condition step. Depending on what you are overriding, you can override certain values with a prompt, a presentation variable, a session variable, or a repository variable.

If you select a variable type, then enter the name of the variable in the field. For example, suppose that you have a column called EMPLOYEE_ID. You can specify USER as the session variable with which to override the value of that column. When a user logs in, the column value is set to his login name. For more information on variables, see "Using Variables".

In a list of steps for a column, specify that only one step in the list be able to be overridden by a prompt or presentation variable.

For information, see Chapter 6, "Prompting in Dashboards and Analyses."

Measure

Use this list to select the name of the measure column whose data values you want to compare, when creating condition steps of type Exception or Top/Bottom.

For

Use this area to qualify all of the dimensions of the analysis other than the dimension whose members you want to select, when creating condition steps of type Exception or Top/Bottom. For each dimension, you select which of its members to include. You can select specific members, or All, which specifies to aggregate the members when creating the condition. For example, suppose that you are qualifying the Region dimension. You can select a specific region, such as East, whose value is used in the condition. If you select All, then the values of all regions are aggregated and used in the condition.

You can use the For area to create a qualified data reference (QDR). A QDR is a qualifier that limits one or more of the dimensions to retrieve a single value for a measure column. A QDR is useful when you want to temporarily reference a measure column value without affecting the current status of the dimensions. The following is an example of a QDR:

Add members of Total Products (Rgd Sk Lvl) where "A - Sample Sales"."Base Facts"."1- Revenue", For: Cust Segments Hier: 'Active Singles', 'Baby Boomers' is greater than "A - Sample Sales"."Base Facts"."1- Revenue", For: Cust Segments"

When you specify a QDR, you can specify multiple members for limiting the dimensions. When you specify multiple members, the measure column value is aggregated using the default aggregation from the Oracle BI Server. For example, suppose that you want to create a condition for displaying those Regions in which Units is greater than 100. Suppose that you create a QDR for the Year dimension that specifies 2000 and 2001 and that the default aggregation is Sum. If the values for 2000 and 2001 for the Central region are 50 and 60 respectively, then both those years are displayed, because their sum exceeds the 100 units that was indicated.

Offset

Use this list to select either addition or subtraction, to enter the number and to specify whether the number is a percent, when creating certain condition steps of type Exception.

Match in

Use this box to select the part of the member to match when creating condition steps of type Match. Options include any label, member ID, long label, medium label, and short label.

Note

To create a step that is based on a hierarchy, use the "New Hierarchy Selection Step dialog".


New Dashboard dialog

Use this dialog to specify the name, description, and location of the dashboard that you are creating.

For more information, see "Creating Dashboards".

Components

Name

Use this field to enter a name for the dashboard.

Description

Use this field to enter a description for the dashboard.

Location

Use this list to select a folder for the dashboard in the Oracle BI Presentation Catalog. If the folder you want is not in the list, click the Browse Catalog link (at the bottom of the list) to display the "Select Location dialog", where you can browse for the folder that you want.

If you choose a folder 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 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 as /Shared Folders/Sales/Dashboards.

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.

Content

Displays the following options:

See "Editing Dashboards".


New EVALUATE_PREDICATE Function dialog

Use this dialog to create or edit the EVALUATE_PREDICATE function's formula.

For more information, see:

This dialog is also displayed as:


Edit EVALUATE_PREDICATE Function dialog

Components

Available

Displays the primary subject area and any related subject areas that have been added to the "Subject Areas pane". Use this area to select columns to use in the formula. To insert a column in a formula, select the column and click the Add Column button.

Formula

Use this area to create the EVALUATE_PREDICATE function's formula.

You can enter the formula manually or use these components:

Notes

To manually enter a variable in an expression in the Formula area, follow the guidelines for referencing variables in expressions described in Table 2-2.


New Filter dialog

Use this dialog to create or edit a column filter, to specify a condition under which an action link is to be enabled, or to specify a condition for applying graph formatting.

For more information, see:

This dialog is also displayed as:


Edit Condition dialog
Edit Filter dialog
New Condition dialog

Components

Note:

When this dialog is displayed as the New Condition dialog or the Edit Condition dialog, not all components are available.

Column

Displays the name of the column for the filter.

Edit Formula

Use this button to display the "Edit Column Formula dialog" where you can modify the column's formula for use with the filter that you are creating.

Data Time Zone

Use this button to select the time zone.

Operator

Use this list to select the operator to apply to the value specified in the Value. For guidelines, see "Operators".

Note that, if your repository is configured for double columns, and you are creating the filter on a display column and select the contains all, contains any, does not contain, begins with, ends with, is LIKE (pattern match), or is not LIKE (pattern match) operator, then filtering is always done by display values, not code values. For more information on double columns, see "Understanding the Double Column Feature".

Value

Use this field to specify one or more values to use when applying the filter or condition. You can:

If your repository is configured for double columns, and you are creating the filter on a display column, then by default you specify display values. However, if your organization allows the display of code values, then you can specify code values rather than display values, but only if you use one of the following operators:

To specify code values, select the Select by Code Column box.

Note:

If you create or modify a filter or condition using code values and, subsequently, the code column for that value is removed from the Presentation layer using the Administration Tool, then filtering by code values remains in effect (although the code values are not visible). When you edit the filter or condition, the code value (for example, 1) is converted to the equivalent display value (for example, Excellent).

For more information on double columns, see "Understanding the Double Column Feature".

Select by Code Column

Available only if your repository is configured for double columns, you are creating the filter on a display column whose code column is exposed in the repository Presentation layer, and you selected either the is equal to / is in, is not equal to / is not in, or is between operator.

Use this box to allow code values to be specified in the Value field. When this box is selected, the list box displays both the code values and the display values (for example, 1 - Beverages) for selection and the Filter by box is selected but disabled. When this box is deselected, the list box displays only the display values (for example, Beverages).

Filter by Code Column

Available only if your repository is configured for double columns and you selected either the is equal to / is in, is not equal to / is not in, or is between operator.

Use this box to specify whether the column is to be filtered by code values or display values. Select this box to filter by code values. Deselect this box to filter by display values.

Saved Analysis

Available if you selected the is based on the results of another analysis operator.

Use this field to specify the saved analysis whose results are to be the basis for the filter.

Relationship

Available if you selected is based on the results of another analysis in the Operator field.

Use this list to select the appropriate operator to determine the analysis' column results that set the filter.

Use values in column

This field displays if you selected the is based on the results of another analysis operator.

Use this list to view a matching column name in the analysis, if there is one. To use another column, then select it instead. The values in this column set the filter.

Add More Options

Available for all operators except is prompted or the is based on the results of another analysis.

Click this button to add a SQL expression or a session, repository, or presentation variable to the filter. You can add one or more of these options. When you select an option, a corresponding field is displayed where you specify either a SQL expression or the name of the variable.

When this dialog is displayed as the New Conditions dialog from the "Column Properties dialog: Conditional Format tab" or as the Edit Condition dialog from the "Edit Action Link dialog", you can add only a presentation variable.

For more information on variables, see "Using Variables".

SQL Expression

Available if you selected SQL Expression from the Add More Options list.

Enter or paste a SQL expression.

Session Variable

Available if you selected Session Variable from the Add More Options list.

Enter the name of the session variable to use, for example USER.

Repository Variable

Available if you selected Repository Variable from the Add More Options list.

Enter the name of the repository variable to use, for example prime_begin.

Variable Expr.

Available if you selected Presentation Variable from the Add More Options list.

Enter the name of the presentation variable to use, for example MyFavoriteRegion.

(default)

Available if you selected Presentation Variable from the Add More Options list.

(Optional) Specify a default value to be used if no value is returned by the presentation variable.

Delete

Click this button to delete the corresponding value and field.

Clear All

Click this button to remove all values and codes. If you added a SQL expression or variable to the filter, then clicking the Clear Values button deletes all related values and fields.

Protect Filter

Select this option to protect the filter's value from being overridden by either a prompt value or when the user navigates to another analysis. When the user navigates from one analysis to another analysis, any prompt values that were specified in the first analysis transfer to the second analysis.

Convert this filter to SQL

Select this option to convert the filter that you have built to a SQL WHERE clause that you can edit manually. Note that after you convert a filter to SQL code, you can view and edit the filter item as SQL code in the "Advanced SQL Filter dialog", only. You can no longer view and edit the filter in the Edit Filter dialog.

Related Topics


"Applying a Named Filter to an Analysis"
"Combining and Grouping Column Filters"
"Using a Saved Analysis as a Filter"
"Creating and Editing the SQL Statements for a Column Filter in an Analysis"

Operators

Use the guidelines shown in Table E-4 when choosing an operator and specifying the required values. The operator list from which you can choose is populated based on the function you are performing (for example, creating a filter or creating a dashboard prompt) and the type of column that you selected.

Table E-4 Guidelines for Choosing an Operator When Creating a Column Filter

Operator Usage Guidelines

is equal to / is in

Valid for a column that contains text, numbers, or dates. Specify a single value or multiple values. Results include only records where the data in the column matches the value in the filter.

is not equal to / is not in

Valid for a column that contains text, numbers, or dates. Specify a single value or multiple values. Results include only records where the data in the column does not match the value in the filter.

is less than

Valid for a column that contains numbers or dates. Specify a single value. Results include only records where the data in the column is less than the value in the filter.

is greater than

Valid for a column that contains numbers or dates. Specify a single value. Results include only records where the data in the column is greater than the value in the filter.

is less than or equal to

Valid for a column that contains numbers or dates. Specify a single value or multiple values. Results include only records where the data in the column is less than or the same as the value in the filter.

is greater than or equal to

Valid for a column that contains numbers or dates. Specify a single value or multiple values. Results include only records where the data in the column is greater than or the same as the value in the filter.

is between

Valid for a column that contains numbers or dates. Specify two values. Result include only records where the data in the column is between the two values in the filter.

is null

Valid for a column that contains text, numbers, or dates. Do not specify a value. The operator tests only for the absence of data in the column. Results include only records where there is no data in the column.

Sometimes it might be useful to know whether any data is present, and using the is null operator is a way to test for that condition. For example, suppose your business has a worldwide address book and you want to extract the United States addresses only. You could do this by checking for the presence or absence of data in the "State" field. This field should be unpopulated (null) for non-United States addresses and populated (not null) for United States addresses. You can obtain a list of United States addresses without the need to check the column for a specific value.

is not null

Valid for a column that contains text, numbers, or dates. Do not specify a value. The operator tests only for the presence of data in the column. Results include only records where there is data in the column.

is ranked first

Valid for a column that contains text or dates. Specify a single value. Results include only the first n records, where n is a whole number specified as the value in the filter.

This operator is for ranked results. For example, you could use this operator to obtain a list that contains the first ten brand names in alphabetical order.

is ranked last

Valid for a column that contains text or dates. Specify a single value. Results include only the last n records, where n is a whole number specified as the value in the filter.

This operator is for ranked results. For example, you could use this operator to obtain a list of the dates of the last ten sales transactions.

is in top

Valid for a column that contains numbers. Specify a single value. Results include only the first n records, where n is a whole number specified as the value in the filter.

This operator is for ranked results. For example, you could use this operator to obtain a list of the top ten sales in dollars.

is in bottom

Valid for a column that contains numbers. Specify a single value. Results include only the last n records, where n is a whole number specified as the value in the filter.

This operator is for ranked results. For example, you could use this operator to obtain a list of the customers reporting the fewest numbers of problems.

contains all

Valid for a column that contains text, numbers, or dates. Specify a single value or multiple values. Results include only records where the data in the column contains all of the values in the filter.

does not contain

Valid for a column that contains text, numbers, or dates. Specify a single value or multiple values. Results include only records where the data in the column does not contain any of the values in the filter.

contains any

Valid for a column that contains text, numbers, or dates. Specify a single value or multiple values. Results include only records where the data in the column contains at least one of the values in the filter.

begins with

Valid for a column that contains text, numbers, or dates. Specify a single value. Results include only records where the data in the column begins with the value in the filter.

ends with

Valid for a column that contains text, numbers, or dates. Specify a single value. Results include only records where the data in the column ends with the value in the filter.

is LIKE (pattern match)

Valid for a column that contains text. Specify a single value or multiple values. Requires the use of a percent sign character (%) as a wildcard character. You might specify up to two percent sign characters in the value. Results include only records where the data in the column matches the pattern value in the filter.

is not LIKE (pattern match)

Valid for a column that contains text. Specify a single value or multiple values. Requires the use of a percent sign character (%) as a wildcard character. You might specify up to two percent sign characters in the value. Results include only records where the data in the column does not match the pattern value in the filter.

is prompted

Valid for a column that contains text, numbers, or dates. Choosing this operator for a filter's column flags it as ready to be filtered by a prompt. This means when a prompt is used, results include only records where the data in the column that is prompted matches the user's choices.

Note: This operator is required for columns included in prompts where no prefiltered values are desired.

is based on the results of another analysis

Valid for a column that contains text, numbers, or dates. This operator constrains the filter by using the value of a column from the same subject area in another saved request.

prompt user

Valid for a column that contains text, numbers, or dates. Choosing this operator enables the user to select the dashboard or analysis' prompt operator at run time.



New Folder dialog

Use this dialog box to specify the folder to create in the Oracle BI Presentation Catalog. For more information, see the "Catalog page".

Component

Name

Use this field to enter the name of the folder.


New Prompt dialog

Use this dialog to define the column, variable, or currency prompt.

For more information, see "Creating or Editing a Column Prompt".

This dialog is also displayed as:


Edit Prompt
Edit Prompt: Column dialog
New Prompt: Column dialog

Components Common to Column, Currency, and Variables Prompts

Note:

This section describes the components that are common to column, currency, and variable prompts. Additional components are available for the column and variable prompts. See "Additional Components for Column and Variable Prompts".

Label

Use this field to enter an appropriate label for the prompt. For example, "Select a date range," "Select a currency," or "Select a percentage by which to calculate the region's dollars." You can include HTML markup tags in the caption, such as <b>, <font>, and <table>.

Description

Use this field to enter a short description of the prompt. This description is displayed as tool tip text, which is displayed when the user mouses over the prompt's label in the dashboard or analysis.

Additional Components for Column and Variable Prompts

Prompt for Column

This field displays for column prompts, only.

Use this field to view information about the column that you selected. You can edit the formula that displays in this field by clicking the Edit Formula button. For more information, see "Edit Column Formula dialog".

Edit Formula

This field displays for column prompts, only.

This button displays for attribute and measure column types, but not for hierarchical columns; however, if you are creating a column or variable prompt and choose to modify the column's formula, you can specify a hierarchical column in the column's formula.

Use this button to display the "Edit Column Formula dialog" where you can modify the column's formula for use with the prompt.

If you added a SQL case statement to the analysis' column instance and you want to use that case statement within the prompt, then you must specify the same SQL case statement in the prompt's column formula.

For example, on the analysis' column, you can use the Edit Formula functionality to create a "Beverage Type" bin to group a long list of beverages into two categories called "Carbonated Beverages" and "Fruit Juices and Non-Carbonated Beverages." When building the prompt, you then add the same bin or SQL case statement to the prompt's column formula. When the prompt is completed and previewed, the "Carbonated Beverages" and "Fruit Juices and Non-Carbonated Beverages" items are displayed in the prompt's value list.

Data Time Zone

Use this field to set the time zone.

Prompt for

This field displays for variable prompts, only.

Use this field to select the type of variable to create and to type a name for the variable. This variable name is the name that you add to the analysis or dashboard where you want the variable prompt's value specified by the user to display. Currently, you can create only presentation variables.

Included Code Column

This field displays for display columns, only.

Displays the name of code column that is mapped to the display column.

For more information on display and code columns, see "Understanding the Double Column Feature".

Operator

This field displays for column prompts, only.

Use this list to select the prompt's operator. For more information about each operator, see "Operators".

Note the following items:

User Input

This field displays for column and variable prompts.

Use this list to specify the user interface component where the user selects the prompt values (for example, prompt the user with radio buttons to select only one prompt value or prompt the user with a text box that requires the user to enter one or more specific prompt values). The input option that you select determines the fields that are displayed in the dialog. For a description and example of each user input option type, see "What Types of User Input Options Can I Use With a Column or Variable Prompt?"

User Input Values

This field displays for column and variable prompts.

Use this field to specify which data values you want to display in the user input method that you selected. For example, if you selected the Choice List user input method and the All Column Values option, then the user selects the prompt's data value from a list that contains all of the data values contained in the data source.

Note that for attribute columns and measures column, all choice list values type are available.

The User Input Values options are:

Select Values or Remove selected value buttons

These buttons display for column and variable prompts. These buttons display if you selected Custom Values, Specific Column Values, Members of Groups, or All Column Values and Specific Groups in the User Input Values field.

Use the Select Values button to open the "Select Values dialog" to search for and add values or groups to the Select List. The prompt presents this values list to the user. This functionality is useful when you want to limit the number of user choices to a small, intuitive list. For example, if you chose Radio Buttons as the user input method and created a specific values list of five dates, the prompt presents the user with five radio buttons, one for each date. If you selected Custom Values in the User Input Values field, the Enter Value dialog displays rather than the Select Values dialog, where you enter a custom value.

Use the Remove selected value button to remove the selected value.

SQL Statement

This field displays if you selected SQL Results in the User Input Values field.

Use this field to create or edit a SQL statement. When run, the SQL statement produces a group of values that is displayed in the Select List.

Include "All Choices" choice in the list

This box displays if you selected either the Choice List, List Box, or Radio Buttons user input type.

Use this box to display the "All Choices" option in the value list. Users can select the "All Choices" option to select all of the values in the list.

Limit values by

This box displays if you selected either the Check Box, Choice List, List Box, or Radio Buttons user input type.

Use this box to select an existing prompt column to limit the values that display in the select list for the prompt column that you are creating. This type of limitation is also known as a cascading prompt. For example, if a prompt contained a column prompt called Region and you create another column prompt called District and specify to limit it by the Region column prompt, the users is allowed to select regions that are located only within the district that they selected. If the users select the Central District, then they are allowed to select only a Region of Chicago, Minneapolis, or Milwaukee.

Enable user to select multiple values

This box displays if you selected either the Choice List or List Box user input type.

Use this box to allow the user to select multiple prompt values from the list of values. If you selected the Choice List user input option, then the prompt value selection list displays a check box before each prompt value.

If you selected the List Box option, then to select:

If you are creating the prompt on a hierarchical column, then this option is selected and you cannot deselect it. If you are creating a prompt with only one value, then use the "Select Values dialog" to select one value.

Enable user to type values

This box displays if you selected the Choice List user input type.

Use this box to allow the user to choose values from the choice list or place the cursor and type a value into the selection field. For example, select this box when the prompt's value list is lengthy and the user does not want to scroll through or search the list, or the user knows the specific prompt value. This option is useful when the prompt contains non-measure numeric values (for example, a product ID or employee ID) that cannot be easily or quickly located in a list of values.

If this option and the Enable user to select multiple values option are selected, users can enter multiple values (using the semicolon delimiter) into the prompt's selection field.

Require user input

This box displays for all user input types.

Use this box to make the prompt required. When the prompt is required, users cannot click the Go button to execute the prompt query until they have selected a prompt value. When you select this option, an asterisk displays to the left of the prompt label to indicate to the user that the prompt is required.

Slider Values

This field displays for the Slider user input type, only.

Use this field to specify the prompt values and value range to display in the slider. Currently, Within Specific Limits is the only available Slider Values option.

Lower limit

This field displays for the Slider user input type, only.

Use this field to specify the beginning prompt value that is displayed on the left-end of the slider. This prompt value is the lowest value that the user can select.

Upper limit

This field displays for the Slider user input type, only.

Use this field to specify the ending prompt value that is displayed on the right-end of the slider. This prompt value is the highest value that the user can select.

Show Spinbox

This box displays for the Slider user input type, only.

Use this box to display a spinbox where the user can click arrows to select a value. When the user clicks the spinbox's arrows, the slider resets to the same value. Deselect this box to remove the spinbox from the prompt.

Compress Values

This box displays for the Slider user input type, only.

Use this box to remove the zeros from values of 1,000 and over. For example, 1,000 displays as 1K and 1,000,000 displays as 1M. If you select this option and are using a non-English environment, the compressed value label is not translated. The value label is displayed in English (for example, 1K or 1M).

Slider Orientation

This field displays for the Slider user input type, only.

Use this field to specify whether you want the slider to be displayed horizontally or vertically on the prompts page.

Label location

This field displays for the Slider user input type, only.

Use this field to specify where you want the prompt's label to display in relation to the slider. Currently, Left of Slider is the only available Label location option.

Slider size

This field displays for the Slider user input type, only.

Use this field to choose the size of the slider. You can select Small, Medium, or Large.

Default selection

Use this field to specify the prompt value that you want users to see initially. First select one of the following options, then (except for the None option) specify the value in the box that is displayed:

Enable user to select by Code Column

This option displays for display columns, only.

Select this option to add a check box to the prompt that enables the user to specify whether to select prompt values by display values (for example, "Beverages") or by code-display values (for example, "1-Beverages"). This box is automatically labeled with the partial caption of "Select by." If you select this option, then add a label in the Label field that identifies what the user is selecting by.

Label

This field displays for display columns, only.

Use this field to complete the "Select by" label for the check box that enables the user to specify whether to select prompt values by display values (for example, "Beverages") or by code-display values (for example, "1-Beverages"). For example, you might enter "product codes" so that the check box label is "Select by product codes."

Choice List Width

Use this field to specify the width of the prompt's field that displays on the prompts page. This field determines the width of the area where the prompt's member values display and does not include the field's label. Note the following options:

Note that setting the Set width of all prompts to field on the "Edit Page Settings dialog" overwrites what you specify in the Choice List Width field. Likewise, specifying preferences for the individual prompt in the Choice List Width field deselects the Set width of all prompts to checkbox in the "Edit Page Settings dialog". For more information, see the help for the "Edit Page Settings dialog."

Set a variable

Use this field to create a variable that this column prompt is to populate.

Select the type of variable, either Presentation Variable or Request Variable, then, enter a name for the variable. Note if you selected Request Variable, you must use the name of the session variable that you want this request variable to override.

Note:

If you are creating a dashboard prompt for an Oracle BI Publisher report that receives its data from an Oracle BI Server or SQL Server, then you must type "Presentation" in the Variable Name field.

For more information about using variables, see "Using Variables".

Column

This field displays if you selected either All Column Values, Specific Column Values, or Members of Groups from the User Input Values field.

This field displays the name of the column upon which you selected to populate the variable prompt's list of values. This field is read-only. To specify a different column name to display in this field, you must click the Select Column button and browse for and select another column.

Select Column

Use this button to display the "Select Column dialog" where you can browse for and select the column to use to generate the prompt's list of values.


New Related Document dialog

Use this dialog to add a document that provides supporting information to a scorecard object, such as an objective. A related document that you add is displayed as a link in the Related Documents table and can link to a dashboard page or analysis that is stored in the Oracle BI Presentation Catalog or to a Web address. For example, you might want to add analysis as a related document for an objective.

For more information, see:

This dialog is also displayed as:


Edit Related Document dialog

Components

Name

Use this field to enter the text to be displayed as the link to the related document.

If you did not specify a name, then Oracle BI EE defaults to the name of the dashboard or analysis, or a shortened form of the URL.

Type

Displays the following options to specify the type of related document:

Location

If you selected as the type:

Browse

This option is available only if you selected the BI Content type. Displays the "Select an Object from the BI Catalog dialog", where you select the dashboard page or analysis from the catalog.


New Scorecard dialog

Use this dialog to create a scorecard.

For more information, see:

Components

Name

Use this field to enter the name of the scorecard, for example, Marketing.

Location

Use this list to select a folder or create a new folder in which to create the scorecard. To create a folder, click the New Folder option in the list to display the "Create New Folder dialog". To select a folder that is not listed, click the Folder button to display the "Select Scorecard Location dialog".

Description

Use this field to enter a description of the scorecard.

Use Default Perspectives?

Use this box to specify whether you want to use the default perspectives defined by the Balanced Scorecard Methodology. You can associate initiatives and objectives with these perspectives or to other custom perspectives that you create. For more information on perspectives, see "What Are Perspectives?"


Open dialog

Use this dialog to open objects, select objects, or save objects.

This dialog is also displayed as:


Choose Delivery Content dialog
Create New Folder dialog
Save dialog
Save Action dialog
Save Action As dialog
Save Agent dialog
Save As dialog
Save Selection Steps dialog
Select dialog
Select Action dialog
Select Agent Location dialog
Select Analysis dialog
Select an Object from the BI Catalog dialog
Select BI Content For Action dialog
Select Condition dialog
Select Dashboard dialog
Select Existing Action dialog
Select Existing Agent dialog
Select KPI dialog
Select a KPI dialog
Select Location dialog
Select Request dialog
Select Scorecard Location dialog

Components

Folders

Use this pane to select a folder in the Oracle BI Presentation Catalog to display in the Open In or Save In area.

Show Folder Tree

Displays the catalog folders in a tree structure.

Show Favorites

Displays your favorite folders in the Folder pane.

Open In or Save In

Displays the folder that is selected in the Folders pane and its contents.

You can save any object in any location. However, the "Save In" field sometimes recommends the best location based on the object type that you are saving. For example, you should save filters, groups, and calculated items within a subject area folder so that these items are available when you build an analysis for the same subject area. If a subject area folder does not exist in your /My Folders or within /Shared Folders, then a subject area folder is created automatically. The "Save In" field defaults a save path to /My Folders/Subject Area Contents/<subject area>, however, the dialog's Folders area displays all instances of the subject area folder in the catalog.

You can save other objects such as analyses, prompts, and conditions in any folder. Bear in mind the distinctions between shared and personal folders, when deciding whether to share the object that you are saving with other users.

Up

Selects the folder that is one level higher in the folder structure.

New Folder

Adds a new empty folder under the folder that is specified in the Open In or Save In field.

Change list view type

Displays the following options to change the view of the list:

Name

Use this box to specify the name of the object to open, select, or save.

To specify the name of the object, do one of the following:

The name is displayed in the tree structure when a user moves the mouse over the object.

Description

Use this field to enter a description of the object.

Descriptions are displayed when administrators use the Oracle Business Intelligence Catalog Manager. Descriptions for analyses are helpful when including them on dashboard pages.

Display Label

Available only for selection steps.

Use this field to enter the label for the group when it is displayed in a view. The display label can differ from the name of the group as it is saved in the catalog.

Steps

Available only for selection steps.

Click this button to save the selection steps for a group. The results of the selection are refreshed at run time.

Results

Available only for groups.

Click this button to save a group as a list of members, rather than as a list of steps.

Replace current action (or steps, or condition) with a reference to the saved action (or group, or condition)

Use this box in the following situations:

Select this box to replace the reference with the saved action, group, or condition. Deselect this box to maintain the reference to the action, group, or condition.

Open As

Available only for objects from Oracle Hyperion Financial Reporting.

Use this box to select how to open an object from Financial Reporting in Workspace. You can select HTML or PDF.

Select Mime Type

Available only for objects from Oracle Hyperion Financial Reporting.

Use this box to select how to save an object from Financial Reporting in Workspace. You can select the following options:

Notes

This dialog is displayed slightly different when you use it to work with objects from Oracle Hyperion Financial Reporting in Workspace. The dialog title is Select.


Overview pane

Use this pane to view summary information about the selected initiative, objective, or KPI.

For more information, see "Viewing Overview Information".

This pane is part of the "Scorecard editor: Overview tab".

Summary Information

This area displays summary information about the selected objective, initiative, or KPI. For more information on the specific information that is displayed, see:


Initiative or Objective Overview

This view is displayed in the "Overview pane" when you select an initiative in the "Initiatives pane" or an objective in the "Strategy pane". Use this view to view basic settings for the selected initiative or objective (for example, status, business owner, and so on) and a status summary showing the number of KPIs and initiatives, or KPIs and objectives, that evaluate progress in each performance state.

Components

Score

Displays the score for the selected initiative or objective in a gauge.

For more information on scores, see "Understanding Initiative or Objective Performance Assessment".

Children

Displays for the selected initiative or objective:

If there is at least one child objective, initiative, or KPI for a particular status, the status name is a hyperlink that displays the "Scorecard editor: Breakdown tab", showing the child object or objects.

Descendants

Displays for the selected initiative or objective:

If there is at least one descendant objective, initiative, or KPI for a particular status, the status name is a hyperlink that displays the "Scorecard editor: Breakdown tab", showing the descendant object or objects.

Perspective

Displays the perspective with which the selected objective or initiative is associated. For example, an Improved Client Response Time objective might be associated with the Customer perspective.

For more information on perspectives, see "What Are Perspectives?"

Business Owner

Displays the userID of the person responsible for managing the selected initiative or objective.

Assessment Formula

Displays the rule that is used to assess the overall performance of the selected initiative or objective, for example, Worst Case or Weighted.

Go to this initiative or Go to this objective

Displays the "Scorecard editor: Initiative Details tab" or the "Scorecard editor: Objective Details tab") for the selected initiative or objective in the current mode (edit or view).


KPI Overview

This view is displayed in the "Overview pane" when you select a KPI in the "Initiatives pane" or "Strategy pane". Use this view to view basic KPI settings for the selected KPI and performance data.

Components

Score

Displays the score for the selected KPI in a gauge.

For more information on scores, see "Understanding Initiative or Objective Performance Assessment".

Perspective

Displays the perspective with which the selected KPI is associated. For example, a Net Profit KPI might be associated with the Financial perspective.

For more information on perspectives, see "What Are Perspectives?"

Trend

Displays information that indicates how the performance of the selected KPI has changed since the last reporting period or a date that you specify.

Business Owner

Displays the userID of the person responsible for managing the selected KPI.

Performance

Displays the following performance data for the selected KPI:

History

Displays a graph showing, for the selected KPI, the actual values over time, such as for financial quarter, according to their assessed performance. For example, if four performance states (critical, warning, good, and excellent) were defined, KPI values are displayed according to these mappings.

The graph shows multiple time periods only if trending was enabled in the KPI's definition.

Go to this KPI

Displays the "Scorecard editor: KPI Details tab" for the selected KPI in the current mode (edit or view).


Page Properties dialog

Use this dialog to edit the content in a briefing book. You can change the content type, the number of navigation links to follow, and the content description.

For more information, see:

Components

Content Type

Use this area to select one of the following options:

Follow Briefing Book Navigation Links

This option applies only to updatable content, not to snapshot content.

Use this area to select one of the following options:

Description

Use this field to enter a description of the content being saved to the briefing book.

Related Topics


"Adding Content to New or Existing Briefing Books"
"Downloading Briefing Books"
"Adding a List of Briefing Books to a Dashboard Page"
"Using Agents to Deliver Briefing Books"

Permission dialog

Use this dialog to set permissions for a catalog object. Permissions determine which user, group, or role can view, open, or modify the object. If you are using this dialog to assign permissions to a catalog object and need more information about the privileges that further refine the tasks users can perform, see "Managing Catalog Privileges" in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition.

For more information, see:

This dialog is also displayed as the:


Section Permissions dialog

Components

Note:

Not all components are available in each version of the dialog.

Location

Displays the folder in which the object resides.

Owner

Displays the account name of the object owner. To change the name that displays in this field, go to the Owner column in the Permission area and select the button corresponding to the account you want to assign as the owner. Note that this field sets the catalog owner of the object, which is differs from setting the business owner for a KPI or scorecard object. For more information about the business owner, see "KPI editor: General Properties page".

Permissions

Use this area to add accounts and assign permissions. Note the following options:

Permissions Toolbar

This toolbar contains the following buttons:

Apply permissions to sub-folders

Use this option to assign permissions to the folder's subfolders, but not to the individual objects within the folder.

Apply permissions to items within a folder

Use this option to assign permissions to the folder's individual objects, but not to the subfolders within the folder.

Apply permissions to all descendants

This option is available only in the "Scorecard editor" when you apply permissions to an object in the Initiatives pane tree or the Strategy pane tree.

Use this option to assign permissions to all descendants of an object in the "Initiatives pane" or the "Strategy pane".

Notes

You can use this dialog when working with objects from Oracle Hyperion Financial Reporting in Workspace. If you display this dialog while working in the catalog in Workspace, any permission changes that you specify are applied immediately. If you display this dialog as part of the Batch Scheduler wizard, then the permission changes are not applied until you run the batch.


Perspectives pane

Use this pane to:

For more information, see:

This pane is part of the "Scorecard editor".

Components

Perspectives List

Displays a list of the perspectives for the scorecard.

Toolbar

This toolbar contains the following buttons:


Preview pane

Use this pane to preview the object that you selected in the Catalog page. Not all object types have previews available. For example, if you select an analysis or dashboard, those objects display in the Preview pane, but none of the interactive features such as drilling, pivoting, and sorting are available. However, if you select an action, the "View not available" message is displayed in Preview pane.

Working with the Preview pane expanded can consume considerable system resources, so Oracle recommends that you only open the Preview pane when needed.

This pane is part of the "Catalog page".


Print Options dialog

Use this dialog to specify page settings and header and footer content for the PDF output, when printing a dashboard or views.

Dashboards are printed in Adobe Acrobat PDF format. Adobe Reader 6.0 or greater is required to print using Adobe PDF.

Notes:

The print selections that you specify apply to PDF output only. If you then print the PDF on a local or network printer, then the print selections that are specified in the browser are in effect, such as the selection for paper size.

This dialog is displayed from the PDF and Print Properties option in the Tools menu on the "Dashboard builder" toolbar and Print Options button on the "Analysis editor: Results tab" toolbar.

For more information, see:

Components

Paper Size

Use this list to select the size of the paper to use for the PDF output.

Orientation

Use this list to select the orientation of the PDF output, either Portrait or Landscape.

Print Rows

Use this list to specify which rows are displayed in the PDF output, either all rows or only the visible rows.

Hide Margins

Use this box to show or hide margins.

Include Header and Include Footer

Use these boxes to include a header, a footer, or both in the PDF output. Click Edit to display the "Edit Footer or Header dialog", where you can specify the layout and formatting of the contents of the header or footer. You can also specify whether to display the header or footer in the HTML output.


Privilege dialog

Use this dialog to control the privileges that users are granted. Privileges control the rights that users have to access the features and functionality of Oracle BI Presentation Services. This dialog is displayed from the "Administration: Manage Privileges page".

For more information, see "Managing Catalog Privileges" in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition.

Components

Permissions

Use this area to add accounts and grant or deny privileges.

To add accounts and grant or deny privileges, use the Permissions toolbar buttons.

To grant or deny a privilege to an account, in the Permission column, select either Granted or Denied.

Permissions Toolbar

This toolbar contains the following buttons:


Prompt editor

Use this editor to create prompts.

For more information, see:

This dialog is also displayed as:


Analysis editor: Prompts tab

Components

Definition

Use the "Definition pane" to create prompts that allow users to select values that dynamically filter all views within the analysis.

Display

Use the "Display pane" to view the prompt's layout and design.

Toolbar

The toolbar contains the following buttons:


Prompt Links dialog

Use this dialog to specify whether to display the Edit and Copy links with a prompt. These links, which display at run time, allow users (with the proper privileges) to edit the prompt or copy the prompt's link.

For more information, see:

Components

Edit

Use this option to specify whether the Edit link is displayed with the prompt at run time. When users with the proper privileges click the Edit link, the prompt is displayed in the "Prompt editor" where users can edit the prompt definition.

Copy

Use this option to specify whether the Copy link is displayed with the prompt at run time. This link enables users to copy the prompt in its current state (that is, the prompt definition with the default or selected prompt values) to Microsoft Excel or Word, in which Oracle Business Intelligence Add-in for Microsoft Office has been installed and configured.


Properties dialog

This dialog box is displayed when you select an object in the "Catalog page" and click Properties in the Tasks pane or click More, then Properties below the object.

For more information, see:

Components

General

Use this area to view and modify general information about the object. You can view the object's name, type (such as action or analysis), and location in the catalog. You can also enter a description for the object.

Access

Use this area to learn the following information about an object:

Attributes

Use the options in this area to set the following attributes of the object:

Custom Properties

This area is read-only and contains system-generated information for troubleshooting object and catalog problems.

Ownership

Use this area to take ownership of the object. This area displays only if the proper privileges were assigned to the user, group, or role. Note that the owner of an object or folder cannot automatically access the object or folder. To access an object or folder, the user must have the proper permissions assigned in the object or folder's "Permission dialog".


Publish Page to Dashboard dialog

Use this dialog to specify the shared dashboard to which you want to publish the current dashboard page so that you can share the page with others.

This dialog is displayed from the "Dashboard builder".

For more information, see "Publishing Dashboard Pages".

Components

Dashboard

Use this field to specify the dashboard to which to publish the current dashboard page. Click Browse to display the "Select Dashboard dialog", where you select the dashboard.


Related Items pane

Use this pane to identify the following:

For more information, see:

This pane is part of the "Scorecard editor: KPI Details tab", the "Scorecard editor: Initiative Details tab" and the "Scorecard editor: Objective Details tab".

Components

Causes

This table is available only in the Scorecard editor: KPI Details tab and the Scorecard editor: Objective Details tab.

Displays the following:

Use this table to view and manage the causes:

Effects

This table is available only in the Scorecard editor: KPI Details tab and the Scorecard editor: Objective Details tab.

Displays the following:

Use this table to view and manage the effects:

Initiatives driving this Objective

This table is available only in the Scorecard editor: Objective Details tab.

Displays the initiatives that drive the objective.

Use this table to view and manage the initiatives:

Objectives Driven by this Initiative

This table is available only in the Scorecard editor: Initiative Details tab.

Displays the objectives that are driven by the initiative.

Use this table to view and manage the objectives or KPIs:


Rename dialog

Use this dialog to enter a different name for:

For more information about the catalog, see:

For more information about favorites, see:

This dialog is also displayed as:


Rename View dialog

Components

Name (or View Name)

Use this field to enter a new name for the object, favorites category, view, or compound layout.

Format

This button is available when you rename a section in the "Dashboard builder".

Use this button to display the "Section Heading Properties dialog", where you can format the name of a section.

Use Dashboard Object name as link text

This option is available when you rename an analysis in the Dashboard builder.

Use this option to specify whether to use the new name of the analysis as the link text when you display analysis results as a link on a dashboard.

Select this box to use the new name you specify. Deselect this box to use the name with which the analysis is stored in the catalog.

For more information on displaying the analysis results as a link, see the Display Results option on the Analysis Properties button described in "Properties Buttons for Objects".

Preserve references to old name of this item

This option is not available for all objects.

Use this option to specify to maintain any existing references to the previous name of the object. This creates a shortcut with the old name that points to the renamed object in the Oracle BI Presentation Catalog. If you do not select this option, then existing references break.


Replace Icon dialog

Use this dialog to select an icon to represent an assessment range.

For more information, see:

Components

Standard Images

Use the "Replace Icon dialog: Standard Images tab" to select a standard image to use as the icon.

Custom Images

Use the "Replace Icon dialog: Custom Image tab" to specify a custom image to use as the icon.


Replace Icon dialog: Custom Image tab

Use this tab of the "Replace Icon dialog" to specify a custom image to use as the icon to represent an assessment range.

For more information, see:

Components

Web Address

Use this field to specify a custom image. To do so, enter one of the following:

Note:

If you are trying to save an object that uses the fmap syntax, then you must have the Save Content with HTML Markup privilege. See "Managing Catalog Privileges" in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition for information on privileges.

The custom image should be one that is accessible to all users who view or edit the scorecard.

Update Preview

Use this button to display the image in the Preview area.

Preview

Displays the custom image.


Replace Icon dialog: Standard Images tab

Use this tab of the "Replace Icon dialog" to select a standard image to use as the icon to represent an assessment range. Also use this dialog to select an image to display for a range of data on a map. You display this dialog from the "Image (Layer) dialog".

This tab is also displayed as:


Select Image dialog

For more information, see:

Components

Image Categories (left pane)

Displays the categories of images. Click a category to display the available images in the right pane. The bottom-most category, which is marked by a globe icon, indicates the list of images that you imported on the Image Library tab of the "Administration: Manage Map Data page".

Standard Images (right pane)

Displays the standard images that are available for the category that you selected in the left pane. Click the image that you want.

If you must add an image, then see the administrator.


Report Links dialog

Use this dialog to specify the links that are to be displayed with analyses on a dashboard page. You can specify these link setting at the following levels:

For more information, see:

Components

Inherit Dashboard Settings

Select this option to specify that the link settings for the dashboard are to be used.

This option is available only when you are specifying the link settings at the dashboard page level.

For more information, see "Changing the Properties of a Dashboard and its Pages".

Inherit Page Settings

Select this option to specify that the link settings for the dashboard page are to be used.

This option is available only when you are specifying the link settings at the analysis level.

Customize

Select this option to customize the link settings for a particular dashboard page or analysis.

This option is available only when you are specifying the link settings for a dashboard page or an analysis.

Analyze

Select this option to specify that the Analyze link is to be displayed. This link displays the analysis in its current state (that is, with the current context, for example, with applied filters, prompts, and so on) in the "Analysis editor", where users can edit it.

For more information on editing an analysis, see "Editing Analyses".

Edit

Select this option to specify that the Edit link is to be displayed. This link displays the analysis in its original state (that is, without the current context) in the "Analysis editor", where users can edit it.

For more information on editing an analysis, see "Editing Analyses".

Export

Select this option to specify that the Export link is to be displayed. This link provides users with various options to export the results of the analysis, for example, Export 2003+. For more information on the available export options, see "Export Menu Options for Views and Results".

For more information on exporting an analysis, see "Exporting Results".

Refresh

Select this option to specify that the Refresh link is to be displayed. This link enables users to refresh the analysis.

Add to Briefing Book

Select this option to specify that the Add to Briefing Book link is to be displayed. This link displays the "Save Briefing Book Content dialog", where users can add the analysis to a briefing book.

For more information about adding an analysis to a briefing book, see "Adding Content to New or Existing Briefing Books".

Print

Select this option to specify that the Print link is to be displayed. This link provides users with the following print options:

Copy

Select this option to specify that the Copy link is to be displayed. This link enables users to copy the analysis in its current state (that is, with the current context, for example, with applied filters, prompts, and so on) to Microsoft Office applications.

For more information about copying analyses to Microsoft Office applications, see "Copying Results to Microsoft Applications".

Related Topics


"Dashboard Properties dialog"

Results tab: Column Selector editor

Use this editor of the "Analysis editor: Results tab" to edit a column selector view. A column selector is a set of drop-down lists that contain pre-selected columns. Users can dynamically select columns and change the data that is displayed in the views of the analysis.

For more information, see "Editing Column Selector Views".

Components

Include Selector

Use this box to specify whether a drop-down list is to be displayed for the column that contains this box.

Label

Use this field to enter a label for this column in the selector.

Choices

Displays the columns that are to be displayed as the choices in the drop-down list for the column. To add a new column to a drop-down list, ensure that the column to which you want to add a new column is active by clicking it to highlight it. Then double-click the new column to add in the "Subject Areas pane".

Column Properties

Use this button to display the "Column Properties dialog" for the column.

Edit Formula

Use this button to display the "Edit Column Formula dialog" for the column.

Delete

Use this button to delete the column from the drop-down list.

Clear Choices

Use this link to clear all the columns that are selected to be displayed in the drop-down list, except for the first column that was selected for the analysis.

Toolbar

The toolbar contains the following buttons and boxes:

Done

Use this button to save your edits and return to the compound layout view.

Revert

Use this button to restore the settings in effect prior to your edits.


Results tab: Create Segment editor

The editor is for users of the Oracle Siebel Marketing operational application, Version 7.7 (or higher), integrated with Oracle Business Intelligence.

Use this editor of the "Analysis editor: Results tab" to edit a create segment view, which displays a Create Segment link in the results. Users can click this link to create a segment in their Oracle Siebel Marketing operational application, based on the results data.

For more information, see:

Components

Display Results

Use this box to specify whether to show the view results in the editor.

Toolbar

The toolbar contains the buttons that are common to all views. For more information, see "Toolbar Buttons Common to All Views".

Done

Use this button to save your edits and return to the compound layout view.

Revert

Use this button to restore the settings in effect prior to your edits.


Results tab: Create Target List editor

This editor is for users of Oracle's Siebel Life Sciences application integrated with Oracle's Siebel Life Sciences Analytics applications.

Use this editor of the "Analysis editor: Results tab" to edit a create target list view, which enables automatic integration of lists of contacts and accounts based on the results of an analysis. For example, you can create a target list in Oracle's Siebel Pharma Sales application and use it in Oracle's Siebel Pharma Mobile Analytics application.

When you add a create target list view, a link named Create Target List is displayed in an analysis on a user's interactive dashboard. The user can click this link to populate or refresh a list of contacts or accounts in the Life Sciences application.

For more information, see:

Components

Create Target List

Use this link to create a target list.

Toolbar

The toolbar contains the following buttons and box:

Done

Use this button to save your edits and return to the compound layout view.

Revert

Use this button to restore the settings in effect prior to your edits.


Results tab: Data View editor

Use this editor of the "Analysis editor: Results tab" to edit one of the following data views:

For more information, see:

This editor is displayed as:


Results tab: Funnel editor
Results tab: Gauge editor
Results tab: Graph editor
Results tab: Map editor
Results tab: Pivot Table editor
Results tab: Table editor

Components

Subject Areas

Use the "Subject Areas pane" to select the columns for an analysis and to work with subject areas.

Analysis Results

Displays the analysis results in a graph, funnel graph, gauge, map, pivot table, or table, depending on the type of view.

Layout

This pane is not available for maps.

Use the "Layout pane" to specify the layout of the data for the view.

Catalog

Use the "Catalog pane" to drag and drop named groups and named calculated items from the Oracle BI Presentation Catalog to the view. For more information on named groups and named calculated items, see "What are Inline or Named Objects?"

Selection Steps

This pane is available only in the Graph, Map, Pivot Table, and Table editors.

Use the "Selection Steps pane" to create and modify steps for data selections. Selection steps are not visible until you click the plus button (+) to expand the Selection Steps pane.

Settings

This pane is available only in the Funnel and Gauge editors.

Use the "Settings pane" to set the thresholds for a funnel graph or gauge.

Toolbar

The toolbar contains buttons that are common to all view and buttons that depend on the type of data view. For more information on the buttons common to all views, see "Toolbar Buttons Common to All Views". For more information on specific data view buttons, see "Data View Editor Toolbar".

Done

Use this button to save your edits and return to the compound layout view.

Revert

Use this button to restore the settings in effect prior to your edits.

Right-Click Menu

Displays, when you right-click a column heading or member in a table or pivot table, interactions that allow you to work with the view. For information, see "Right-Click Menu for Tables and Pivot Tables".

Paging Buttons

These buttons are available only when editing or working with tables and pivot tables.

When a table or pivot table includes a large number of rows, a set of buttons can be displayed under the view. You can use the following buttons to page through the rows in the view:

Components Specific to Map

Map View Area

Use this area to interact with the components of the map such as the zoom controls, legend, and overview map.

BI Data Layers

Use this area to work with the applicable formats for the BI layers of the map. Not all formats are available for all layer types. For example, point layers cannot have Color Fill formats. The map cannot display multiple non-point formats at a time (at a single zoom level) but can display multiple point formats simultaneously, if they do not share the same latitude and longitude location. If multiple graph formats are specified at the same geographic layer, then they render on top of each other.

You can do the following:

If no layers are specified in the map formats area, then click New Map Format. The map prompts you to import the geo-encoded columns for displaying a format for a particular geo-layer, if the columns are not part of the analysis.

When you specify to create a map view, you likely see at least one layer available in the Map Formats area. If no layer is available, then the New Map Format link is displayed.

Limits exist for how much data can be displayed for formats on a map view. As you work with formats, you might exceed the data limit. If you do so, then you see a message that alerts you to the data limit and the fact that not all formatting can be displayed, so you can contact the administrator. The administrator controls the limit with the MaxRecords configuration element. For information on setting this element, see "Manually Configuring for Map Views" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Map Features

Use this area to add non-BI layers to the map. These layers have not been associated with BI data so are not interactive. Click New, then select the layer that you want to add to the map.


Right-Click Menu for Tables and Pivot Tables

When editing or working with tables and pivot tables, you can right-click to display a menu of interactions that are applicable to the view.

The interactions that are available when you right-click in a table or pivot table depend on:

The right-click menu can include the following interactions (listed in alphabetic order):

For more information on selections steps, see "Working with Selections of Data". For more information on groups and calculated items, see "Working with Groups and Calculated Items".

Notes

For the Add Related, Keep Only Related, and Remove Related interactions, you can select one of the following family relationship options:


Toolbar Buttons Common to All Views

The following toolbar buttons are common to all views:


Data View Editor Toolbar

The toolbar on a data view editor contains some buttons that are common to all data views and other buttons and boxes that are particular to specific views. See the following sections:

Toolbar Buttons Common to All Data Views

The following toolbar buttons are common to all data views:

Toolbar Buttons Specific to Graph and Funnel Graph Views

The toolbar contains the following buttons and boxes that are specific to a graph view:

Toolbar Buttons and Boxes Specific to Gauge Views

The toolbar contains the following buttons and boxes that are specific to a gauge view:

Toolbar Buttons and Box Specific to Map Views

The toolbar contains the following buttons and box that are specific to a map view:

See "Working with Map Views on Dashboard Pages" for more information.

Toolbar Buttons and Box Specific to Pivot Table or Table Views

The toolbar contains the following buttons and box that are specific to a pivot table or table view:


Export Menu Options for Views and Results

You can use the following options to export the results of an analysis or a view. When you export the results of an analysis, any tables, pivot tables, or graphs that are displayed with the analysis are included.

For more information, see "Exporting Results".


Sorting Options Menu

The options that are available on the Sorting Options menu depend on the type of data view and the location in which you right-clicked and can include the following options:

In a pivot table that has more than one measure in a column (or a row), when you right-click and select one of the sorting options (such as Sort Ascending) to sort a row (or a column), options that allow you to select which measure to use in the sort are displayed.

For more information on sorting, see "Sorting Data in Views".


Results tab: Filters editor

Use this editor of the "Analysis editor: Results tab" to view the filters in effect for an analysis.

For more information, see "Editing Views".

Components

Toolbar

The toolbar contains the buttons that are common to all views. For more information, see "Toolbar Buttons Common to All Views".

Done

Use this button to save your edits and return to the compound layout view.

Revert

Use this button to restore the settings in effect prior to your edits.

Notes


Results tab: Legend editor

Use this editor of the "Analysis editor: Results tab" to edit a legend view, which documents the meaning of special formatting used in an analysis, such as the meaning of custom colors applied to gauges. Legends are displayed in HTML and PDF output, and can be localized.

For example, suppose you use conditional formatting in an analysis to show critical items in the color red and items that need attention in the color yellow. You can add a legend with text that documents the meaning of the colors and captions that summarize the appropriate action. You can use cosmetic formatting to make the background colors of the text match the colors in the conditional analysis.

Each legend item consists of a legend symbol with sample text (for example, a red box that displays Critical) and a caption that documents the meaning of the legend symbol (for example, Requires Immediate Attention.

For more information, see "Editing Legend Views".

Components

Title

Use this field to enter a title for the legend.

Format Title

Use this button to display the "Format Title dialog", where you format the title.

Caption

Use this field to enter, for each legend item, the meaning of the legend symbol, such as Requires Immediate Attention.

Format Caption

Use this button to display the "Format Caption dialog", where you format the caption.

Sample Text

Use this field to enter, for each legend item, the text that is to be displayed within the legend symbol, for example, Critical.

Format Text

Use this button to display the "Format Text dialog", where you format the caption text.

Move Down and Move Up

Use these buttons to reorder captions by moving them up or down one row in the list. Available only when you have multiple captions.

Delete

Use this button to delete a caption.

Add Caption

Use this button to add another caption.

Toolbar

The toolbar contains the following buttons and boxes:

Done

Use this button to save your edits and return to the compound layout view.

Revert

Use this button to restore the settings in effect prior to your edits.


Results tab: Narrative editor

Use this editor of the "Analysis editor: Results tab" to add one or more paragraphs of text to be displayed with the results. Narrative text is useful for providing information such as context, explanatory text, or extended descriptions along with column values. You can perform the following actions in the narrative view:

For example, suppose that you have created an analysis that shows a user's sales by region and want to provide explanatory text with the analysis. Using a narrative view, you can create the following explanatory text:

This report shows your sales by region. The regions are:
East Region
West Region

For more information, see "Editing Narrative Views".

Components

Bold, Italic, Underline

Use these buttons to insert the HTML tags to begin and end bold, italic, or underlined text in the Prefix, Narrative, or Postfix fields.

Line Break

Use this button to insert a line break in the Prefix, Narrative, or Postfix fields.

Note:

Pressing Enter does not result in multiple lines of text in the Prefix, Narrative, or Postfix fields.

Contains HTML Markup

Use this option to work with HTML codes, as described in "Working with HTML Markup". If you are trying to save a narrative object that contains HTML code, then you must have the Save Content with HTML Markup privilege. See "Managing Catalog Privileges" in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition for information on privileges.

Prefix

Use this field to enter the header for the narrative. This text is displayed at the beginning of the narrative.

For example, the following prefix entry:

[b]This analysis shows your sales by region. The regions are:[/b][br/][br/]

Displays this text:

This analysis shows your sales by region. The regions are:

Narrative

Use this field to enter the narrative text that is displayed for each row in the results. You can include both text and column values. Include a line break code at the end of this field to force each line of text and values onto its own line.

To include values, use the at sign (@), as described in the following list:

For example, for an analysis that returns the region name in the second column, the following narrative entry:

@2

Displays this text:


East Region
West Region

Row separator

Use this field to enter a row separator for each line from the Narrative field that contains values. For example you might enter a string of plus signs (+) between each line.

Rows to display

Use this field to enter the number of rows from the column to return. For example, enter 5 to display values from the first 5 rows of the column. For a hierarchical column, you can use selection steps to display hierarchy levels with the hierarchical column. For example, create a step to select members based on hierarchy and add members of the specified level. A hierarchy level is considered a row.

Postfix

Use this field to enter the footer text to be displayed at the bottom of the narrative. To display the footer information on a separate line from the actual narrative text, include markup tags in the Postfix field. Ensure that the narrative ends in a line break, or that the footer begins with a line break.

Display Results

Use this box to specify whether to show the view results in the editor.

Toolbar

The toolbar contains the following buttons:

Done

Use this button to save your edits and return to the compound layout view.

Revert

Use this button to restore the settings in effect prior to your edits.

Notes


Results tab: Selection Steps editor

Use this editor of the "Analysis editor: Results tab" to view the selection steps in effect for the analysis.

For more information, see "Editing Views".

Components

Selection Steps Area

Displays the selection steps. Use the List box to specify which column to view in the area. If the selection steps contain a calculated item or group member link, the area will display a link that you can click to view more details. For example, if the selection steps contain a group, you can click the group link and the "View Group: Group dialog" displays and shows the members of the group.

Note that you cannot modify the selection steps from this area. To modify the selection steps, you must exit the Selection Steps editor and in the Analysis editor: Results tab, go to the "Selection Steps pane".

Toolbar

The toolbar contains the buttons that are common to all views. For more information, see "Toolbar Buttons Common to All Views".

Done

Use this button to save your edits and return to the compound layout view.

Revert

Use this button to restore the settings in effect prior to your edits.


Results tab: Static Text editor

Use this editor of the "Analysis editor: Results tab" to edit a static text view, which enables you to add or edit text to be displayed with the analysis results.

The markup can contain anything that is supported by the browser, but only formatting defined using the buttons at the top of the workspace is displayed in PDF output.

For more information, see "Editing Views".

Components

Bold, Italic, Underline

Use these buttons to insert the HTML tags to begin and end bold, italic, or underlined text in the Static Text field.

Line Break

Use this button to insert a line break in the Static Text field.

Note:

Pressing Enter does not result in multiple lines of text in the Static Text field.

Contains HTML Markup

Use this option to work with HTML codes, as described in "Working with HTML Markup".

Static Text

Use this field to enter the text to be displayed with the analysis results.

For the syntax to use for variables, see "What Is the Syntax for Referencing Variables?" For more information on variables, see "Using Variables".

See the Notes section for some examples of static text.

Display Results

Use this box to specify whether to show the view results in the editor.

Toolbar

The toolbar contains the following buttons:

Done

Use this button to save your edits and return to the compound layout view.

Revert

Use this button to restore the settings in effect prior to your edits.

Notes

Table E-5 lists and describes several static text view examples.

Table E-5 Static Text View Examples

Static Text View Example Description and Usage Notes

HTML text

Paste or type the HTML (or appropriate formatted text) into the text box. You can also click the HTML tag buttons. Based on the format of the text that you are entering, you can use markup tags to control the format of the text. The following are some examples of what you can do:

  • To set font size and color:

    <FONT SIZE="4" COLOR="red">Red Text</FONT>
    
  • To combine tags for additional effects:

    <B><FONT COLOR="red">Bold Red Text</FONT></B>
    

ActiveX object

The Active-X object must be self-contained and supported by the browser. Paste or type the object into the HTML Text window, making sure to include the beginning and ending tags <object...> and </object>.

JavaScript or VBScript

The script must be self-contained and supported by the browser. Paste or type the script into the text box, making sure to include the beginning and ending tags <script> and </script>.

Audio

Ensure that you know where the audio clip is located. If the audio clip is for use in a shared environment, then it must be located on a network drive that accessible to all users.

Use the HTML tag <EMBED> to add audio. The following format is an example format. Your browser might require a different format.

<EMBED SRC="audio" AUTOSTART="true" LOOP="true" HIDDEN="true"></EMBED>

where "audio" is the location and name of the audio clip.

To add an audio clip located on the hard drive, the following HTML is an example:

<EMBED SRC="c:\mycomputer\MIDIfiles\wakeup.mid" AUTOSTART="true" LOOP="true" HIDDEN="true"></EMBED>

To add the same audio clip from a shared location on the Web server, the following HTML is an example:

<EMBED SRC="\DashboardFiles\wakeup.mid" AUTOSTART="true" LOOP="true" HIDDEN="true"></EMBED>

Background image

The following example uses JavaScript.

Ensure that you know where the image to use as the background is located. If the image is for use in a shared environment, then it must be located on a network drive that is accessible to all users.

If the image is located in a shared dashboard files folder, then the following is example HTML:

<script language="javascript"> document.body.background = "/dashboardfiles/"NameOfGraphic";</script>

where NameOfGraphic is the name of the file to use, such as bricks.gif or sand.jpg.

Variables

The following example includes variables:

[u] Static Text View [/u][br/]
Region: @{variables.myFavoriteRegion} - Year: @{variables.myFavoriteYear}[br/]
System Time: @{system.currentTime}[dddd,MMMM dd,yyyy][br/]
Product Version: @{system.productVersion}[br/]
[br/]


Results tab: Ticker editor

Use this editor of the "Analysis editor: Results tab" to edit a ticker view, which displays the results of an analysis as a marquee (moving results that scroll across the page). You can customize the size of the scroll area, the speed and direction in which the results scroll, and other display settings.

Note:

If the Web browser does not support moving text, then the results are displayed, but they do not scroll across the page.

For more information, see "Editing Views".

Components

Behavior

Use this box to select how the results move in the ticker:

Direction

Use this box to select the direction the results move in the ticker — Left, Right, Down, or Up.

Width

Use this field to enter the width of the ticker, either in pixels or as a percentage of the page width. For example, a value of 200 indicates a width of 200 pixels, and a value of 25% indicates a width of one-quarter of the page.

Height

Use this field to enter the height of the ticker, either in pixels or as a percentage of the page height.

Contains HTML Markup

Use this option to work with HTML codes, as described in "Working with HTML Markup". If you are trying to save a ticker object that contains HTML code, then you must have the Save Content with HTML Markup privilege. See "Managing Catalog Privileges" in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition for information on privileges.

Beginning Text

Use this field to enter any optional text or graphics to display at the beginning of each redraw of the analysis results. You can use HTML to format the text.

If you include an image, then ensure you know where the image is located. If the image is for your use only, then the following is a sample location:

c:\mycomputer\temp\report.gif

If the image is for use in a shared environment, then it must be located on a network drive accessible to all users. For a shared image, specify the UNC name, for example:

\\ALLUSERS\graphics\report.gif

Row Format

Use this field to enter the HTML to use in formatting the rows in the results.

To include the results from a designated column, use @n. For example, @1 inserts the results from the first column, and @3 inserts the results of the third column.

Row Separator

Use the field to enter the character that separates one row from another. The default character is a vertical bar ( | ).

Column Separator

Use this field to enter the character that separates one column from another. The default character is a vertical bar ( | ).

Ending Text

Use this field to enter any optional text or graphics to display at the end of each redraw of the analysis results. You can use HTML to format the text.

If you include an image, then ensure that you know where the image is located. If the image is for your use only, then the following is a sample location:

c:\mycomputer\temp\report.gif

If the image is for use in a shared environment, then it must be located on a network drive accessible to all users. For a shared image, specify the UNC name, for example:

\\ALLUSERS\graphics\report.gif

Set Defaults

Use this button to generate default settings for the most commonly used field.

Note:

If you click Set Defaults after entering values in other fields, your entered values are cleared.

Clear Fields

Use this button to clear all fields.

Note:

After you clear all fields, you can click Set Defaults to restore default settings for the most commonly used fields.

Advanced

Use this button to display the "Advanced Ticker Options dialog", where you specify additional options for the ticker, such as number of loops and background color.

Display Results

Use this box to specify whether to show the view results in the editor.

Toolbar

The toolbar contains the buttons that are common to all views. For more information, see "Toolbar Buttons Common to All Views".

Done

Use this button to save your edits and return to the compound layout view.

Revert

Use this button to restore the settings in effect prior to your edits.


Results tab: Title editor

Use this editor of the "Analysis editor: Results tab" to edit a title view. You can add a title, a subtitle, a logo, a link to a custom help or other related information, and timestamps to the analysis.

For more information, see "Editing Views".

Components

Title

Use this field to enter the text to display as the title. Do not include HTML markup.

If you do not specify a title, then the name of the saved analysis is used as the title. For unsaved analyses, the Title text box is blank.

Format Title

Use this button to display the "Format Title dialog", where you format the title.

Display Saved Name

Use this box to specify whether to show the saved name of the analysis. Select the box to show the saved name. Deselect the box to hide it.

Logo

Use this field to specify a logo image or other graphic to display in the title. To do so, enter one of the following:

Note:

If you are trying to save an object that uses the fmap syntax, then you must have the Save Content with HTML Markup privilege. See "Managing Catalog Privileges" in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition for information on privileges.

The image or graphic file should be one that is accessible to all users who view the analysis.

Format Logo

Use this button to display the "Format Logo dialog", where you format the logo.

Subtitle

Use this field to enter the text to display as a subtitle. The subtitle follows the title on a new line.

Format Subtitle

Use this button to display the "Format Subtitle dialog", where you format the subtitle.

Started Time

Use the box to specify whether to display a timestamp indicating when an analysis started to execute. You can specify the date, the time, the date and time, or no display.

Format Time

Use this button to display the "Format Time dialog", where you format the time for the analysis.

Help URL

Use this field to display a Help icon (that is, a question mark) that links to a custom help file or other related information in the title. To do so, enter one of the following:

Note:

If you are trying to save an object that uses the fmap syntax, then you must have the Save Content with HTML Markup privilege. See "Managing Catalog Privileges" in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition for information on privileges.

The custom help file or other related information should be one that is accessible to all users who view the analysis.

Format Value

Use this button to display the "Format Title dialog", where you specify formatting for a view component.

Display Results

Use this box to specify whether to show the view results in the editor.

Toolbar

The toolbar contains the following buttons:

Done

Use this button to save your edits and return to the compound layout view.

Revert

Use this button to restore the settings in effect prior to your edits.

Notes


Storing Custom Files Locally and Using the fmap Function to Reference Them

You can store custom files, such as images and help files, locally in your Oracle Business Intelligence environment and then easily reference them using the fmap function. For example, you can store an image locally to display in a title view. Then, when you specify the image for the title view in the "Results tab: Title editor", you can use the fmap function to reference it.

To store custom files locally, you must use the following directory and expose it according to the instructions for the HTTP Server that your organization uses:

ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obipsn/analyticsRes

Note:

Because the analyticsRes directory gets replicated for every instance that is populated, the custom files must be replicated in each instance.

You can store files directly in this directory or in subdirectories in this directory. It is strongly recommended that you use ASCII characters for names of custom files that you reference using the fmap syntax.

Note:

Custom files that were stored locally in previous releases (prior to 11g) of Oracle Business Intelligence must be manually migrated in Release 11g.

To easily reference custom files that are stored in the analyticsRes directory, use the following fmap syntax:

fmap:location/file_name

where:

The following are examples of fmap commands:

fmap:mylogo.gif
fmap:Images/newlogo.gif

If you are trying to save an object that uses the fmap syntax, then you must have the Save Content with HTML Markup privilege. See "Managing Catalog Privileges" in Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition for information on privileges.


Results tab: View Selector editor

Use this editor of the "Analysis editor: Results tab" to edit a view selector view, which enables users to select a specific view of an analysis from among the saved views. For example, users can select to display a graph view for the analysis.

For more information, see "Editing View Selector Views".

Components

Caption

Use this field to enter a caption for the view selector.

Format Caption

Use this button to display the "Format Caption dialog", where you format the caption.

Caption Position

Use this box to select a position for the caption — Left, Above, or Right.

Available Views

Displays the views that are available to be included as choices in the view selector. Select a view and click the right arrow to move it into the Views Included area.

Note:

The None view shows the view selector only.

Views Included

Displays the views to be included as choices in the view selector. To change the order of the view in the list, select a view and use the up and down arrows. To remove a view from this area, select a view and click the left arrow.

Toolbar

The toolbar contains the following buttons:

Done

Use this button to save your edits and return to the compound layout view.

Revert

Use this button to restore the settings in effect prior to your edits.


Save Briefing Book Content dialog

Use this dialog to add content to a briefing book.

For more information, see:

Components

Content Type

Use this area to select one of the following options:

Follow Briefing Book Navigation Links

This option applies only to updatable content, not to snapshot content.

Use this area to select one of the following options:

Description

Use this field to enter a description of the content being saved to the briefing book.

Location

Use this field to enter the briefing book in which to save the content. Click Browse to display the "Save As dialog", where you can select an existing briefing book or create a new briefing book by entering the new briefing book name in the Name field.

Related Topics


"Editing Briefing Books"
"Downloading Briefing Books"
"Adding a List of Briefing Books to a Dashboard Page"
"Using Agents to Deliver Briefing Books"

Save Current Customization dialog

Use this dialog to save a customization for a dashboard page.

For more information, see:

Components

Name

Use this field to enter a name for the saved customization.

Save For

Use this area to specify for whom the customization is to be saved. It contains the following components:

Make this my default for this page

Use this option to specify whether to use this saved customization as your default customization when you display this page in a dashboard.


Saved Customization Permissions and Defaults dialog

Use this dialog to specify the accounts that have permission to use the customization and whether the customization is to be the default customization for the accounts.

For more information, see:

Components

Permissions

Displays the accounts that have permission to use the customization and indicates whether the customization is to be the default customization for the accounts.

To indicate that the customization is to be the default customization for an account, click the Group Default box for the account.

Add Users/Roles

Use this button to display the "Add Groups dialog", where you select the users, Application roles, and Catalog groups to have permission to use a saved customization.

Delete Selected Users/Roles

Use this button to delete the selected account.


Scale Markers dialog

Use this dialog to define scale markers for a graph.

Scale markers are accenting lines or shaded background ranges that mark key point, thresholds, ranges, and so on in a graph. There are two types of scale markers:

Line or range scale markers can be applied on one or more axes depending on the type of graph.

Note:

Some graph types do not use scale markers, such as pie graphs.

For more information, see "Graph Properties dialog: Scale tab".

Components

Click to add a new scale marker

Use this button to add a new scale marker row to the Scale Markers area.

Click to remove selected scale markers

Use this button to remove selected scale markers. To select a scale marker for removal, select the first box in the scale marker row.

Scale Markers

Use this table to define scale markers using the following components:


Scorecard Breadth pane

Use this pane to view pie graphs that show how evenly the objectives (and the KPIs that support them) that compose your scorecard are distributed among the following categories:

These pie graphs are helpful to determine how balanced your scorecard is.

For more information, see:

This pane is part of the "Scorecard editor: Overview tab".

Components

Financial versus Non-Financial Pie Graph

Displays how many objectives are finance-specific and how many are not finance-specific. To maintain a balanced scorecard, financial and non-financial perspectives should be equally implemented.

Internal versus External Pie Graph

Displays how many objectives are specific to your internal corporate processes, and how many are related to external, customer-related objectives.

Leading versus Lagging Pie Graph

Displays how many objectives drive the performance of other objectives (that is, how many are leading) and how many are affected by the performance of other objectives or by other data or processes (that is, how many are lagging).


Scorecard Content Properties dialog

Use this dialog to specify how a scorecard object that you have added to a dashboard page is to be formatted.

For more information, see:

Components

Width

Use this field to enter the width of the object as a percentage of its original size.

Height

Use this field to enter the height of the object in pixels.

Hide Scroll Bars

Use this option to specify whether scroll bars are to be hidden.

Render as Watchlist

Use this option to specify whether the object is to be displayed a watchlist (that is, as table that lists the details) rather than as a diagram.


Scorecard Documents pane

Use this pane to create scorecard objects that present and analyze corporate strategy, such as vision and mission statements, strategy maps, cause & effect maps, and so on.

For more information, see

This pane is part of the "Scorecard editor".

Components

Object List

Displays a list of objects that present and analyze corporate strategy.

Toolbar

The toolbar contains the following buttons:


Scorecard editor

Use this editor to create a scorecard of your entire organization or of individual departments.

For more information, see:

Components

Point of View

Displays dimensions of KPIs that are used in the Scorecard to measure the progress and performance of initiatives and objectives. Use this area to pin values for the dimensions. For more information, see "About the Point of View Area".

Strategy

Use the "Strategy pane" to create, organize, and leverage the objectives that form the strategic structure, also called a strategy tree, of the corporate entity (department, for example) to evaluate using KPIs or to drive by initiatives.

Initiatives

Use the "Initiatives pane" to create, organize, and leverage the initiatives that are the tasks required to achieve objectives. You can monitor the progress of initiatives by assigning KPIs.

Scorecard Documents

Use the "Scorecard Documents pane" to create diagrams and views that provide different depictions of strategy dynamics and structures (for example, cause & effect maps and strategy maps).

You can also use this pane to build custom maps to present scorecard data and define mission and vision statements that articulate the overarching goal of the entity that you are scorecarding such as your organization or department.

Catalog

Use the "Catalog pane for Scorecard" to locate and drag and drop objects from the catalog to build a scorecard. For example, you might select a predefined KPI and drag it to the objective or initiative whose progress it measures.

Perspectives

Use the "Perspectives pane" to modify the default perspectives defined by the Balanced Scorecard Methodology, create custom perspectives, and delete perspectives.

Tab area

Displays tabs for the objects that you choose to view, create, or modify (for example, initiatives, strategy objectives, and strategy maps), including:

Toolbar

The toolbar contains the following buttons:


Scorecard editor: Breakdown tab

Use this tab to view and manage the objects that are used to evaluate the performance of an initiative or an objective.

You generate this tab dynamically from the:

You cannot save this tab.

Using this tab, you can filter the objects by descendants or children, by object type, and by status. For example, for an objective, you might want to show only the child KPIs that have a status of OK.

For more information, see:

Components

Show

Use this component to specify whether to display either the descendants or the children of the objective or initiative in the Breakdown table.

Type

Use this component to filter the objects displayed in the Breakdown table by type as follows:

Status

Use this component to filter the objects displayed in the Breakdown table by the statuses that have been defined for the scorecard. For example if the defined statuses are OK, Warning, and Critical, you could select to display only objects with the OK status, only objects with the Warning status, only objects with the Critical status, or any combination of these statuses.

Breakdown

Use this table to view and manage:

See "Initiatives & KPIs table; Objectives & KPIs table; Objectives, Initiatives & KPIs table; New KPI Watchlist table; and Breakdown table".


Scorecard editor: Cause & Effect Map tab

Use this tab of the "Scorecard editor" to create, view, and edit a cause & effect map.

For more information, see:

Components

Diagram

Use the "Cause & Effect Map tab: Diagram tab" to create a diagram that illustrates the cause and effect relationships among objectives and KPIs.

Details

Use the "Cause & Effect Map tab: Details tab" to specify supporting information for a cause & effect map.

Toolbar

This toolbar contains the following buttons:


Scorecard editor: Custom View tab

Use this tab of the "Scorecard editor" to create, view, and edit a custom view.

For more information, see:

Components

Diagram

Use the "Custom View tab: Diagram tab" to create a diagram that shows a personalized view of your business data.

Details

Use the "Custom View tab: Details tab" to specify supporting information for a custom view.

Toolbar

This toolbar contains the following buttons:


Scorecard editor: Initiative Details tab

Use this tab to create, view, and edit an initiative.

For more information, see:

Components

Name

Use this box to enter a new name for the initiative.

Description

Use this box to enter a description of the initiative.

Status

Displays the current performance status of the initiative, for example, Warning.

Type

Displays the type of object, that is, Initiative.

Analytics

Use this "Analytics pane" to specify basic information about the initiative, to identify the KPIs and other objectives that support and measure the performance of the initiative, and to add action links.

Collaboration

Use the "Collaboration pane" to identify information helpful for collaborating on the initiative, including the business owner, key resources, and related documents.

Related Items

Use the "Related Items pane" to identify the objectives that drive the initiative.

Toolbar

This toolbar contains the following buttons:


Scorecard editor: KPI Details tab

Use this tab to work with KPI details, such as viewing basic KPI settings, pinning dimensions, specifying information helpful for collaborating on the KPI, and identifying related items.

For more information, see:

Components

Name

Use this box to enter a new name for this use of the KPI.

Description

Use this box to enter a description of this KPI usage.

Status

Displays the current performance status of this KPI, for example, Warning.

Trend

Displays information that indicates how the performance of the selected KPI has changed since the last reporting period or a date that you specify.

Type

Displays the type of object, that is, KPI.

Analytics

Use the "Analytics pane" to view basic KPI settings and a graph that presents actual values and target values, pin dimensions, and run actions.

Collaboration

Use the "Collaboration pane" to identify information helpful for collaborating on the KPI, including the business owner, key resources, and related documents.

Related Items

Use the "Related Items pane" to identify the objectives that drive the KPI or are driven by the KPI.

Toolbar

This toolbar contains the following buttons:


Scorecard editor: Mission tab

Use this tab of the "Scorecard editor" to define, view, and edit a mission or vision statement for your organization.

For more information, see:

The tab is also displayed as:


Scorecard editor: Vision tab

Components

Document

Use the "Mission tab: Document tab" or "Vision tab: Document tab" to enter and format your mission statement or vision statement.

Details

Use the "Mission tab: Details tab" or "Vision tab: Details tab" to specify supporting information for the mission or vision statement.

Toolbar

This toolbar contains the following buttons:


Scorecard editor: Objective Details tab

Use this tab to create, view, and edit an objective.

For more information, see:

Components

Name

Use this box enter a new name for the objective.

Description

Use this box to enter a description of the objective.

Status

Displays the current performance status of the objective, for example, Warning.

Type

Displays the type of object, that is, Objective.

Analytics

Use this "Analytics pane" to specify basic information about the objective, to identify the KPIs and other objectives that support and measure the performance of the objective, and to add action links.

Collaboration

Use the "Collaboration pane" to identify information helpful for collaborating on the objective, including the business owner and related documents.

Related Items

Use the "Related Items pane" to identify other objectives that cause or effect the objective and initiatives that drive the objective.

Toolbar

This toolbar contains the following buttons:


Scorecard editor: Overview tab

Use this tab of the "Scorecard editor" to:

For more information, see "Viewing Overview Information".

Components

Overview

Use the "Overview pane" to view summary information about the selected initiative, objective, or KPI.

Getting Started

Use the "Getting Started pane" to learn how to use scorecard to drive and assess corporate performance, to link to the Oracle Business Intelligence glossary, and to link to information about how to create scorecards.

Scorecard Breadth

Use the "Scorecard Breadth pane" to view pie graphs that show how evenly the objectives (and the KPIs that support them) that compose your scorecard are distributed among the following categories:


Scorecard editor: Perspective tab

Use this tab to create, view and edit perspectives.

For more information, see:

Components

Perspective Name

Use this field to enter the name of the perspective.

Description

Use this field to enter a description of the perspective.

Business Owner

Displays the userID of the person responsible for managing the perspective. To specify the business owner, click the Set User button to display the "Business Owner dialog", where you can search for and select the business owner.

Focus

Displays the following options to indicate the focus of the perspective:

Objectives, Initiatives & KPIs

Use this table to view and manage the initiatives, objectives, and KPIs that are associated with this perspective.

See "Initiatives & KPIs table; Objectives & KPIs table; Objectives, Initiatives & KPIs table; New KPI Watchlist table; and Breakdown table".

Related Documents

Use the "Related Documents area" to view and manage documents that provide supporting information to the perspective.

Toolbar

This toolbar contains the following buttons:


Scorecard editor: Strategy Map tab

Use this tab of the "Scorecard editor" to create, view, and edit a strategy map.

For more information, see:

Components

Diagram

Use the "Strategy Map tab: Diagram tab" to create a diagram that shows how the objectives that have been defined for a scorecard and the KPIs that measure their progress are aligned by perspectives.

Details

Use the "Strategy Map tab: Details tab" to specify supporting information for the strategy map.

Toolbar

This toolbar contains the following buttons:


Scorecard editor: Strategy Tree tab

Use this tab of the "Scorecard editor" to create, view, and edit a strategy tree.

For more information, see:

Components

Diagram

Use the "Strategy Tree tab: Diagram tab" to view an objective and its supporting child objectives and KPIs hierarchically in a tree diagram or wheel diagram.

Details

Use the "Strategy Tree tab: Details tab" to specify supporting information for the strategy tree.

Toolbar

This toolbar contains the following buttons:


Search pane

Use this pane to find objects by name, directory location, and type (agents and scorecards, for example). This pane enables you to quickly locate the objects that you need.

For more information, see:

This pane is part of the "Catalog page".

Components

Name

Use this field to enter the full or partial name of the object or folder to find. In the Search pane and in the Search field in the global header of Oracle BI EE, you can enter text and you can use "glob matching". "Glob matching" refers to the syntax for searching in an MS-DOS command window. Table E-6 describes strings that you can use with the "glob syntax."

Table E-6 Using glob Syntax in Search Criteria

Search String Entered Result

a

Adds wildcards before and after your search string (for example, *a*), enabling the search to return results that contain the letter "a".

^a

Adds a wildcard after your search string (for example, a*), enabling the search to return results that begin with the letter "a".

a$

Adds a wildcard before your search string (for example, *a), enabling the search to return results that end with the character "a".

a\*

Searches explicitly for strings containing a character followed by an asterisk (*) for example, "a*".

?

Use a question mark (?) with a character and an asterisk (*) to return zero (0) or more occurrences of a character. For example, ?a* returns zero or more occurrences of the character "a".

[] or {}

Not recognized by search.


To match any of the glob special characters themselves ('^$*?'), you must precede the character with a backslash. For example, to match the string "cost*units", enter a search string of "cost\*units".

To find an exact match of characters, include the appropriate characters at both ends of the search string. If you want to find the file called "a", then enter a search string of "^a$". Otherwise, you obtain a list of every file that includes the letter "a" anywhere in its name or description.

Location

Use this list to select a folder in which to search for objects:

Administrators can search for all user and object folders in the catalog root directory.

Type

Use this list to find only certain kinds of objects. For example, reports, dashboards, or KPIs.


Section Condition dialog

Use this dialog to specify the condition to be used to determine whether a section in a dashboard is to be displayed.

You might want to display a section conditionally, for example, when the results of an analysis show that sales are down by 15 percent or greater in the past week and you want to display a section that contains links to related reports.

This dialog is displayed from the "Page Layout area" in the "Dashboard builder".

For more information, see "Changing the Properties of Objects Added to Dashboard Pages".

Components

Condition

Displays the condition under which the section is to be displayed.

New Condition

Use this button to display the "New Condition dialog", where you create a new condition.

Select Condition

Use this button to display the "Select Condition dialog", where you select an existing condition.

More (>>)

Display these options:


Section Properties dialog

Use this dialog to specify the properties for a section of data in a view using the Layout pane.

For more information, see "Setting Properties for View Bodies and Drop Targets".

Components for Pivot Tables and Tables

Insert Page Break

Use this area to indicate whether to create a page break before the section, so that every time a value changes in the section drop target, the new section for that column is displayed on a new page. Page breaks are visible when you export an analysis to PDF. This is useful for data-driven detail analyses.

You can select from the following:

Show Blank Rows

Use this box to indicate whether to display rows that have no data in the section. Select the box to display all rows, even if a row is an empty text string and contains no value. Deselect the box to hide rows when there are no results to display. This option might be useful for example, to hide empty address lines.

Display Heading

Use this box to indicate whether to display the heading for the section.

The remaining components of this dialog are described in "Column Properties dialog: Style tab".

Components for Graphs

Maximum number of section slider values

Use this box to enter the maximum number of values to display on a section slider bar, but not to exceed the system maximum. The administrator configures the system maximum. If you enter a number that exceeds the system maximum, then it is ignored.

For more information about section sliders, see "Defining Section Sliders in Graphs and Gauges".


Select Column dialog

Use this dialog to navigate to and select the columns or members to include in an analysis, prompt, filter, KPI, or when associating columns with layers for maps. In some cases, you can also use this dialog to add additional subject areas to the dialog.

For more information, see:

This dialog is also displayed as:


Add Columns dialog
Select BI Key Columns dialog
Select Columns dialog
Select member in Dimension Hierarchy dialog

Components

Add Related Subject Area

This button is available only if one or more related subject areas are available and you have permission to access them.

Use this button to display the "Add/Remove Subject Areas dialog", from which you can add or remove related subject areas.

Search

Not available for maps. Click this button to search.

Subject Area

Use this tree to browse for and select the column for which you want to build the prompt, the column to add to the filter, the dimension to add to the KPI, or the column to associate with a layer for a map. For a map, you can select a single column, multiple columns from multiple subject areas, or multiple columns from a single subject area.

Selected Columns

This area is available only for columns to associate with a layer for a map. You can view and modify the columns that you have selected.

Shuttle

These buttons are available only for columns to associate with a layer for a map. You can select columns in one or more subject areas and move them between the two lists in the dialog.

Reorder

These buttons are available only for columns to associate with a layer for a map. You can select columns then click the buttons to modify the order or the columns in the list. If you are trying to duplicate the name of a geographic layer that has multiple parts, then ensure that the columns are in order from top to bottom to match that layer name. For example, if the layer name is Country_State, then ensure that you include the Country column above the State column in the list.

Related Topics


"Definition pane"
"Edit Layer dialog"

Select Java Method dialog

Use this dialog to select one of the following items:

For more information, see:

This dialog is also displayed as:


Select the Hyperion resource you want this action to invoke dialog

Components

EJB or Hyperion Resources

Displays the following:

Use this list to select a Java method or a Hyperion resource.

Selected

Displays the Java method or the Hyperion resource that you have selected in the list.


Select Script Function dialog

Use this dialog to select the function to be executed by an Invoke a Browser Script action.

For more information, see:

Components

Function

Use this list to select the function to be executed.

Name

Displays the name of the function selected in the list.


Select Values dialog

Use this dialog to search for and select one or more values from a list of available values, for example:

Using this search function, you can limit the list of available values (for example, find all those values that start with the letter D) so that you can more easily find the value or values that you want.

This dialog is also displayed as:


Choose Members dialog
Edit Hierarchy Selection Step dialog
Edit Member Step dialog
Edit Select Existing Groups and Calculated Items
Member Selection Dialog
New Hierarchy Selection Step dialog
New Member Step dialog
New Select Members dialog
New Select Existing Groups and Calculated Items
Search Members dialog

Components

Note:

Not all components are available in each version of this dialog.

Relationship

Available only when working with a member step that is based on a hierarchy.

Use this box to select the type of relationship with which to create the member step for the hierarchical column. You can select a family relationship, a specific hierarchy level (for level-based hierarchies only), or a level relationship (for level-based hierarchies only). For parent-child hierarchies, the only option available is family relationship.

Action

Use this box to select the type of action to create. You can select to add the selected members to the selection, keep only the selected members and remove all others, or remove the selected members from the selection. For groups and calculated items, the only action available is Add.

When working with a member step that is based on a hierarchy, use the box beside the Action box to specify a hierarchy level (for level-based hierarchies only) or a family relationship.

For a family relationship, you can select one of the following options:

When you edit the first step in a list, the choices for actions are Start with All Members, Start with Selected Members, and Start with Groups or Calculated Items.

Search

Use this button to show or hide the Search area that is displayed within the Available List area. See "Components of Search Area".

Available List

Use this area to:

Items that you have selected are displayed with a green check mark beside them.

Selected List

Use this area to view the values that you have selected from the Available List area and moved to the Selected List area.

Include selected members

Use this box to specify whether to include the selected member in addition to all the members of the family relationship (such as Children of) that you specify.

For example, specifying Keep Only and Children of 2011 and also selecting this box, returns: 2011, 2011 Q1, 2011 Q2, 2011 Q3, and 2011 Q4.

Edit

Use this button to display the "Edit dialog", where you can refine the values with which you are working.

This button is not available when you select members for selection steps.

Override with Prompt

Use this box to specify that an analysis prompt or a dashboard prompt can override the member step. In a list of steps for a column, specify that only one step in the list be able to be overridden by a prompt. For information, see Chapter 6, "Prompting in Dashboards and Analyses."

Notes

Components of Search Area

Use this area to initiate a search for values or members and view the results of the search.

Name

Use these fields to specify text data on which to search. In the Name box, select the appropriate option such as Starts, Contains, Ends, or Is Like (pattern match). Enter the string for which you must search.

Between and

Not available for member search. Use this field to specify a range of numeric or date and time data for which to search.

Children of

Available only when searching for hierarchical members. Use this field to specify the node in whose sub-tree you want to start searching for members. For example, suppose that you have a geography hierarchy with All Countries as the root node and 50 countries below that. You want to search for all cities that start with the letter "A" in the country called USA. Use the Children of field to specify USA.

Select Member to display the Select Member dialog.

Select a Specific Member to Search Within

Available only when searching for hierarchical members. Click this button to display the Select Member dialog in which you specify the member whose children you want to search.

At Level

Available only when searching for members of level-based hierarchies. Use this field to select the level below which you want to search for members. The default of <Any> specifies to search for members below any level. For parent-child hierarchies, no levels exist, so this setting is always <Any>. Certain levels are disabled because they are at or above the level you selected, which does not constitute a valid search.

Limited Values or Constrained

Use this button to limit the values by any other filters that are associated with the analysis.

All Values or Unconstrained

Use this button to list all values, without limiting the values by any other filters that that are associated with the analysis.

Search

Use this button to initiate the search and display the search results. When you search for members, the columns of the subject area are searched.

Notes

If the available list of values for a prompt or write back column is based on a SQL statement, then you cannot search for values.

Related Topics


"New Prompt dialog"

Select Variable dialog

Use this dialog to specify a variable to use to set a value of a KPI dimension. You set values of KPI dimensions, for example, when you add a KPI that is dimensioned to a KPI Watchlist or when you add a strategy map that contains one or more KPIs that are dimensioned to a dashboard.

For more information about variables, see "Using Variables".

Components

Variable Type

Use this box to select the type of variable to use to set the value. Depending on the task you are performing, you can select one of these types: Session, Repository, or Presentation.

Variable Name

Use this field to enter the name of the variable to use to set the value, for example USER.


Select Web Service Operation dialog

Use this dialog to select the Web Service operation to be invoked by an Invoke a Web Service action.

For more information, see:

Components

Web Services

Use this list to select the Web Service operation to invoke.

Initially, this list displays the Web Services preconfigured by the administrator. You can display other Web Services by using the WSDL URL component.

WSDL URL

Displays the Web Services Description Language (WSDL) of the Web Service operation selected in the Web Services list.

To list Web Service operations available from a WSDL URL that was not preconfigured, use this field to enter the WSDL URL (for example, http://<server>:8888/default/10?WSDL) and then click Open.

Web Service

Displays the Web Service of the selected operation.

Operation

Displays the selected operation.

Restore the list of Web Services pre-configured by your Oracle BI Administrator

Use this button to display the list of Web Services that were initially displayed in the Web Services list, that is, the Web Services preconfigured by the administrator.

Refresh the selected folder

This button is available only when you have a folder selected. Use this button to refresh the selected folder.


Selected Columns pane

Use this pane to view, add, and modify the criteria that are selected for an analysis.

Selected columns are displayed in boxes in this pane. Each box has two sections. The upper section shows the name of the column's folder, for example, Customers. The lower section shows the name of the column, for example, Customer Name. If columns from the same folder are placed next to each other, then they are grouped in one folder section.

If a column selector view is in use, then you see the phrase "Column Group" instead of the column name. You also cannot edit the properties for the columns. See "Editing Column Selector Views" for information.

You can:

Other modifications that you can make to columns depend on the type of column:

For more information, see "Specifying the Criteria for Analyses".

This pane is part of the "Analysis editor: Criteria tab".

Components

Drag Column

Use this button to reorder a single column or multiple columns that are grouped in a folder section. This button is located to the left of the column name or folder name. The following list describes how to use the Drag Column button, but you can reorder by clicking anywhere in the column or folder area and dragging and dropping to the new location. Valid drop locations are indicated by a thick solid line.

To reorder:

Plus or Minus

This button is available only for hierarchical columns.

Use this button to expand or collapse the display of hierarchy levels in column.

Options

Use this button to select one of the following options:

Toolbar

The toolbar contains the following buttons:


Selection Steps pane

Use this pane to create and modify steps for selecting data. The steps in this pane apply to all views for the analysis. You do not have to display the editor for a particular view to edit its selection steps.

For more information, see "Working with Selections of Data".

This pane is part of the "Analysis editor: Criteria tab", the "Analysis editor: Results tab", and certain view editors. This pane is not visible on the Criteria tab until you click the toolbar button to display it. The contents of this pane are displayed slightly differently on the Criteria tab if a column selector view is in use. See "Editing Column Selector Views" for information.

Components

List

Use to select the columns or measures to view in the pane. You can view all columns and measures, just measures, or specific columns.

Column Area

Use to indicate the start of the list of steps for each column. For hierarchical columns, the name of the hierarchy is included with the column name. This area includes the following types of steps:

Save Selection Steps

Click this button to display the "Save Selection Steps dialog" where you save the steps for the column or hierarchy level as a group. This button is available only when you have more than a single Start With step in the list for a column. This button is not available if you try to save a set of steps as a group and one of the steps includes a calculated item.

Then, New Step

Click this link to display the following options:

Name of Group or Calculated Item

Click the link for a group or calculated item to display one of the following dialogs: "Edit Group dialog" or "Edit Calculated Item dialog".

Selection Step Toolbar

The selection step toolbar is the collection of buttons that displays when you hover over a selection step within the list of steps. It can include the following buttons:


Set User dialog

Use this dialog to search for and select a user. For example, in a Scorecard, you use this dialog to select the user to assign as a business owner to Scorecard objects such as KPIs, initiatives, and strategy objectives. In an agent, you use this dialog to select the user whose credentials you want to use to send the delivery content.

For more information, see:

This dialog is also displayed as:


Business Owner dialog
Select Business Owner dialog
Select User dialog
Select Key Resource User dialog

Components

Name

Use this field to enter your search criteria. For example, enter the user's first name to display a list of users with that first name.

Search

Use this button to display the accounts that satisfy the name search criteria that you entered.

Accounts

Displays the list of accounts that satisfy the name search criteria that you entered. You can then select the name that you want.


Settings dialog

Use this dialog to:

For more information, see:

Components

Assessment Mappings

Use the "Settings dialog: Assessment Mappings tab" to define the score thresholds and assessment ranges to be used for scoring scorecard objects.

Dimension Settings

Use the "Settings dialog: Dimension Settings tab" to set up the controls for dimensions in the point of view area of a scorecard.


Settings dialog: Assessment Mappings tab

Use this tab of the "Settings dialog" to define the score thresholds and assessment ranges to be used for scoring scorecard objects.

For more information, see:

Components

Score Threshold

Use this field to enter the numeric values that set the boundaries for the assessment ranges.

For example, you might enter 33 and 66 to set the boundaries for three assessment ranges — Critical, Warning, and OK. Any KPI score from 0 to 33 would fall in the Critical assessment range, any KPI score from 34 to 66 would fall in the Warning assessment range, and any KPI score from 66 to 100 would fall in the OK assessment range.

Assessment Range

Use this field to enter the name of each assessment range (for example, Acceptable).

Icon

Use this button to display the "Replace Icon dialog", where you select the icon to represent each assessment range.

Color

Use this button to display the color dialog, where you select the color to represent each assessment range.

Threshold Menu

Displays the following options:

Add Threshold

Use this button to add a score threshold and assessment range below the last score threshold.


Settings dialog: Dimension Settings tab

Use this tab of the "Settings dialog" to set up the controls for dimensions in the point of view area of a scorecard.

For more information, see:

Components

Dimensions Settings

Displays all the dimensions that are referenced by KPIs in a scorecard and shows their current settings. Use this area to set up the controls for the dimensions.

To set up the control for a dimension, select the dimension and then click the Edit Row button to display the "Edit Dimension Settings dialog".


Settings pane

Use this pane to set the thresholds that are to be displayed in a funnel graph or gauge.

Each threshold has a high and a low and is associated with a color in which the range identified by the threshold is displayed in the gauge, such as green for acceptable, yellow for warning, and red for critical.

For more information, see:

This pane is part of the "Results tab: Funnel editor" and the "Results tab: Gauge editor".

Components

High values are desirable

Use this box to specify whether the high values are the desirable goal. Selecting this box lists the statuses in order from the most desirable indicator (for example, Excellent) at the top to the least desirable indicator (for example, Warning) at the bottom.

Low values are desirable

Use this box to specify whether the low values are the desirable goal. Selecting this box lists the statuses in order from the least desirable indicator (for example, Warning) at the top to the most desirable indicator (for example, Excellent) at the bottom.

Threshold

Use this list to specify the data values in a gauge that highlight a particular range of values. The values must be between the minimum and the maximum values set for the gauge limits. The range identified by a threshold is filled with a color that is different from the color of other ranges.

To specify a data value, you can either:

Threshold Options

Displays these options to set a threshold:

Status

Use this list to specify the label for each range identified by a threshold and the color in which the range is to be displayed in the gauge. Use the Status Options button to specify a label and the Color button to specify a color for each range.

Status Options

Displays the following options:

Color

Displays the Color Selector dialog, where you select the color for the range that is identified by the threshold.

First Stage x final stage target value

This field is available only for last-stage only funnel graphs.

Use this box to enter the factor required to meet the target. In a last-stage only funnel graph, the target value of all the stages before the last are calculated based on the last stage target value and this target factor.

Add Threshold

Use this button to add a new threshold row.

Delete Threshold

Use this button to delete a threshold row.


Show More Columns dialog

Use this dialog to add or remove columns that display data such as the status, trend, target, and variance of KPIs on a KPI Watchlist, perspective, initiative, or objective. This enables you to customize the KPI data displayed by specifying visible columns.

For information about KPIs, see:

Components

Available Columns

Displays all of the columns that you can select to present a wide variety of data for the KPIs that evaluate the initiative. Table E-7 describes some of the commonly used columns.

To display additional