Rename Apply / Reset button in OBIEE prompts

If you ever wondered to change or rename Apply / Reset buttons on OBIEE dasboard prompts, here's the way.

Go to the following path on your box,

C:\Oracle\Middleware\Oracle_BI1\bifoundation\web\msgdb\l_en\messages

At this location, you will get all XML files that OBIEE uses to throw messages/errors that in human readable format. For instnace, pick the file viewmessages.xml

Here you wil get all the messages or defauls strings that we see in day-to-day things (like Apply, Reset, Reset, ViewDisplayError, NoRows, etc) in OBIEE.

Change the below tag for renaming Apply button,

Default one:
<WebMessage name="kmsgEVCPromptApply"><HTML>Apply</HTML></WebMessage>

Change it to,
<WebMessage name="kmsgEVCPromptApply"><HTML>Go</HTML></WebMessage>

That's it. Just bounce your services to load all the modified configuration files. You in with Go..!!


Happy stay.!! :-)

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. :-)

OBIEE 11g - Double Column support for dashboard level prompt.

Now it is possible to filter on the IDs when an end user chooses its description.

This is one feature that I am pretty sure everyone expects by default in a reporting tool i.e. the ability to pass IDs when a description is chosen in a prompt. But the way it has been implemented in BI EE actually makes it useful for a lot of applications than just description/id switch. This can be put to use for multi-language applications where the descriptions can be any language but the id remains the same.

This feature has 2 fold advantages,

1. In OBIEE 10g, there was no automated way of filtering on ID’s when end users chose the description values in the prompts. The Double column feature provides this ability in 11g.
2. In many implementations where data is captured in multiple languages, the descriptions might be stored in different languages. But the filtering of data will be on ID’s (which will be the same across languages). Double column feature provides that ability now.

Let's try this feature by taking one example,

• The following is the screenshot for the table on which we will be applying this double column support.

• To achieve this double column support, in BMM layer of repository, we need to assign the descriptor ID column for the column on which we are going to apply this feature. Here, Country_Name.

• Save the repository and upload it on server.
• Now go to BI Analysis page and create one dashboard level prompt. When we include this Country_Name column in the prompt, you will notice that the prompt will automatically show the Included ID column as well.

• Notice that, we now have the ability to display the Descriptor ID as well.
  Lets enable that option as well so that users who are more familiar with the ID’s will have the ability to toggle between the Country_Name and the Country ISO Code.

• Now create a sample report and apply a filter on the column having description. Here, Country Name.

• Take that report and the prompt you have just created on a dashboard, end users will now have the ability to filter on the description as well as the ID.

• If you enable the Select by ID check box, you will notice that the drop down will now have the ID and the description concatenated for easy selection.

Reference: http://www.rittmanmead.com/

Happy blogging. :-)