ORACLE BUSINESS INTELLIGENCE WORLD

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

    • 358,305 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: