Presentation Variable, prompt values in Report Titles (OR) Using Presentation Variable in Dashboard Text object and Narrative View directly in OBIEE

Standard

Normally, to let user know that what are the selected values in dashboard prompt, we use narrative views or Filter views.

In this blog entry, you will see that how to use presentation variable in directly narrative view and in dashboard objects.

Recently, I had a requirement like prompt is populated with some values along with All Choices

When user selects a particular value from drop-down that value should be displayed on report and when select All Choices nothing to be display.

Variables in Narrative View:

For this i went with the following approach.

1. Create a prompt with presentation variable say, var_region and set Default to: All Choices. Save the prompt

prompt

2. Create a report with some measures and the dimension column i used as prompt in the step 1

criteria

3. Click on Results tab, and add the narrative view to compound layout

4. In Narrative section mention the presentation variable name directly @{var_region}, set Rows to display to 1 and click OK to add the narrative to compound layout

narrative

5. Arrange views, so that the narrative view comes under the title view

arrange-cl

6. Go to Criteria tab

7. Apply filter condition on that dimension and assign presentation variable to the filter. Save the report

filter-condition

8. Now create a dashboard page and add the prompt and report just now you created

9. Save the page and you can see that there nothing appears in narrative view as default value for prompt is All Choices.

10. Select any value from prompt and click on Go. You will see the selected item in report.

Note: If you are writing any text in narrative view like, Region is:@{var_region}, then even for all choices the text will be shown but no value shown for prompt

So, when there All choices option is selected in prompt associated with presentation variable, it holds nothing. It holds the value when there is single value selected. Of course, variables contains only single value

Variables in Dashboard Object – Text

  1. Edit the dashboard page.
  2. Add the Text dashboard object to the existing section

text-object

3. Click on Properties option for Text object and write the following code.

<center><font Size=’4′><font color=”#000000″>@{var_region}</font></font></center>

Don’t forget to click on Contains HTML Markup check box

text-properties

4. Click on Properties of Report > Show View and select Table1 to show only the table view on dashboard, so that the narrative we are not showing. This avoids the displaying prompt values twice

show-view

5. Save the page and go to dashboard. As default value is All Choices, you will not see anything on dashboard related to text object

6. Select any value from drop-down and click on Go, and watch that the selected item is appears on dashboard

dashboard-result

Normally, this post explains how to use presentation variables directly in views or text dashboard object and displaying prompt values in report.

Advertisements

About Kishore & Naresh

Hi.. This is a blog operated by Kishore and Naresh. We are colleagues and working as BI Developers. Here we want to share our ideas and researches here. We were the active members of OTN Forums and inspired with Venkat and John's blog. We may not reach to that level, but we brings up all our ideas and research work we done. All the views expressed here are our own and does not reflect the views of our employers. We need all your blessings and support to grow. Thanks

20 responses »

  1. Do u know, how to achieve this when we use ‘is between’ as operator instead of ‘is equal to / is in’ .

    I have to show the report heading as start date and end date which is specified in a prompt.

  2. Hi Mohan,

    thanks for you comment.
    And, to your question,

    If you want to show the dates which are with “is between” operator in the prompts, you can use filter view. But you can’t customize the filters view. So, possible solution is to show them in Narrative view. Before doing this, you need to assign each date with presentation variable.

    In fact, when you are using “is between” you can’t use presentation variable. But see here…
    http://obiee101.blogspot.com/2009/03/obiee-between-dates-prompt.html

    With this, you can assign each date selected in prompt with presentation variable, and can use in narrative as i suggested in this post.

    Regards
    Kishore Guggilla

    • Kishore Guggila,

      Thank you so much for Step by Step display about presentation and narrative display its very help full.

      Can you suggest me suppose in prompt shows All Choices. So in need display the All Choices in Dash board. How to achieve this.

      Thanks in Advance,
      Sathyan Malugulu

  3. HI Kishor, good to see this.. I have a question, Is there any ways to create presentation variable for Multi-select prompts?

  4. Incredible! I’m truly enjoying the design and style of your blog. Are you using a custom made template or is this readily available to all users? If you don’t want to say the name of it out in the general public, please contact me at: chloefrench@hotmail.
    de. I’d love to get my hands on this template! Kudos.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s