Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 364,321 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

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 »

%d bloggers like this: