Pass Presentation Variable To the Title View Using Dashboard Prompt?

When you select a value from the dashboard prompt , the title is reflected correctly with the selected value in dashboard prompt.

Create the report:

• Create an analysis using SampleAppLite repository with following criteria:
• Add a Filter ->Product: Brand and make it 'Is prompted' (we will be making Brand as the presentation variable)

• Click on Result and Edit the Title.
  
• In the 'subtitle' field , Enter the name of presentation variable, say @{Brand}
  
• Save the report as 'Presentation var'

Create the Dashboard prompt

• Create a New Dashboard Prompt (New->Dashboard Prompt)
• Add a Column Prompt: Product ->Brand
• Expand the Options and Set a variable to 'Presentation variable' and Enter 'Brand' in the field below.
  
• Save the dashboard prompt as 'PVprompt'

Create the Dashboard Page

• Create a new board and name it as :PVDashboard
• Drag and drop the Dashboard Prompt created from Section 2 into the dashboard page
• Drag and drop the report created from Section 1 to the dashboard page
• Save the Dashboard page and run it.
• When there is no value selected in the dashboard prompt, the subtitle is displayed as '@{Brand}' 
  
• When you select a value for Dashboard prompt : say 'BizTech', it is displayed correctly as BizTech as shown below:
  
• To fix this issue, Do the following:
• Edit the Title view from Results tab and add a default value for All selection for eg, 'All Brand' in this case: @{Brand}{All Brand} and Save the title.
  
• Save the Dashboard PVDashboard,and Run it .Now the Presentation Variable is displayed correctly when you don't select any value for the Dashboard prompt.
  

  

Reference: https://blogs.oracle.com

Happy Stay. :-)

Adding Logo's to the Title of the OBIEE reports.

What if you would like to set some standard logo for that report?

Yes, there is an option in OBIEE where we can set the logo for an individual report. It is possible to add images into title of the view. This can make title views look more graphically appealing and can also help the user to understand what the title view is conveying.

You can find all the images that comes with the OBIEE installation at the following path,

C:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\images

• Create any sample report.

• Go to the results tab & edit the Title view of the report..

• Set the title for the report. (By default, this title is same as report name). 
• Set other fields in you are interested in further formatting.
• In the logo, you give the path for that logo/image. It can be,
• Relative path - The logo will accessible only on the localhost.
• URL - A complete URL to that image.

• Relative path - 

Note: When running in a secured environment, only resources that are located on the Oracle BI Presentation Server may be used. These resources are referenced using a relative path prefixed with "fmap:".

• URL - 
  

• For further exploration, lets fill the Subtitle & Help URL fields. 
• Set Started Time to "Display Date and Time". This will print the latest date and time when this report is executed against the database.

You can see the question mark (?) button in the title of the report, where you can give a link to any other BI content, website, etc.

Happy blogging.

Oracle BI Mobile App Designer is now Available. (Trial Edition)

You can try out the new era in BI Development from the below link.

http://www.oracle.com/technetwork/middleware/bi-foundation/bi-mobile-ad-trial-download-2020939.html?ssSourceSiteId=ocomen

Is this is what you were looking for..!! Then try it out. ;-)

Source: https://blogs.oracle.com

Thanks,
Sagar Tippe.