Skip Headers
Oracle® Business Intelligence Enterprise Edition Help
11g Release 1 (11.1.1)
  Go To Table Of Contents

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


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.


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 Presentation Services Privileges" in Security Guide for Oracle Business Intelligence Enterprise Edition for information on privileges.


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:


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:


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.


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.


The toolbar contains the following buttons:


Use this button to save your edits and return to the compound layout view.


Use this button to restore the settings in effect prior to your edits.