11.1.1.6.0 fe

OBIEE 11g (11.1.1.6) New Features

Posted on 2012/04/19 by Guident

OBIEE 11 g provides more enhanced interface for Dashboards and Analyses.
Below are the new features in OBIEE 11.1.1.6.
When working with the tables and pivot tables it displays a menu when you right click on it. It all depends on the on the view what we have selected. If you right click on column heading .The interactions are related to column. Ex: Below screenshot.

This change though with 11.1.1.6 and now either the analysis developer, or the end-user, can add create customized report by right-clicking on the view. Let’s work through an example.
Here is an example of a Simple dashboard. The user wants to see which department has Top 3 target revenue in the year 2010 Q3.

So now the user wants 2010 Q1 details. To achieve this scroll down and find 2010 Q3 data. After finding 2010 Q3 details right click and select keep only option.

Now you will have only 2010 Q3 data displayed.
If you wants to see the subtotal of target revenue and fixed cost right click on column heading Product p1 and select show subtotal option. It will display all the totals by product.

Now you can also find the row level grand total.

If you want to display Top 3 Products based on the target revenue. Right click on the column
Select Keep only->Top x-> Based on Revenue.

Below you can see Top 3 products in the Q3 quarter.

If the user wants to save this customization report. He can save it in his own account. To do that, you can save this particular dashboard customization, by selecting Save Current Customization from the Edit Page menu in the top right-hand corner of the page, like this:

and then choose whether this customization is available as an option for other users, and whether it gets applied automatically whenever this particular user accesses this dashboard page again.

You can also exclude, move, hide and sort the column by right clicking on the column heading.

Selection steps:
Before 11.1.1.6, selection steps could only be added within the analysis editor , and there was no way to display to the end-user what selection steps had been applied, or any way for them to add their own steps. These changes though with 11.1.1.6, and now either the analysis developer, or the end-user, can add selection steps to the analysis by right-clicking on the view. Below is the example.

These are the selection steps what we did changes to the dashboard.

Sorting:
If you want to sort the data, right click on the column and you will find the sort option.

Moving columns:
You move the columns to back to the current column, sections, prompts, to the rows.
Moving to the prompts: Right click on the column heading, and select move column,

Data looks like this after moving to prompts .

Moving data to sections:

Calculated item and Groups:
You can continue to create calculated items to perform mathematical operations on members. In previous releases, you could create a calculated item for an attribute column. In this release, you can create a calculated item for the members of an attribute column or of a hierarchical column.
In this release, you can create a “group” of members to display in a view. The group inherits the aggregation function of the measure column with which it is displayed.