ORACLE BUSINESS INTELLIGENCE WORLD

Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

Archive for the ‘Narrative View’ Category

Narrative View

Posted by Santosh Kumar Gidadmani on June 18, 2011

Use the Narrative view to add one or more paragraphs of text to appear with the results. Narrative text is useful for providing information such as context, explanatory text, or extended descriptions.
Let us take an example to create a narrative view to display top 10 sales by country.
Create a report with two columns country_name and sales_revenue. Sum the sales revenue to get the summarized view of sales by country.
In the compound layout, click on add view and select Narrative as shown below.

Provide the below information in the narrative view

Prefix: specify the header note for the view.
Narrative: Use the format @n to reference a column, where n represents its position of the column in the query criteria. @1 is country name and @2 is the sales revenue.
Prefix: specify footer note for the view.
Rows to display: specify the number of rows to display. Here I have taken 10 to display top 10 sales.
You can use html code for color and to break the row line.
Save the report and place the report in the dashboard where required

You can create any number of narrative views to provide the summary views on top of the dashboard.
– Santosh

Posted in Narrative View, OBIEE 10g, OBIEE 10g Answers | Leave a Comment »

 
Follow

Get every new post delivered to your Inbox.

Join 57 other followers

%d bloggers like this: