With the launch of new version of Oracle BI OBIEE 11g, some new features and enhancements got added.
I installed the new version and started looking at the new features. This is completely a new experience. The look and feel is very much improved now and is much better.
Here in this post I will discuss only about the new feature introduced in Pivot charts. Now the pivot has the ability to expand and collapse the levels using the + and - signs as shown below.
If we just compare this new feature of OBIEE11g with Qlikview from end user perspective, it stands nowhere.
Now lets discuss how we can achieve this in OBIEE11g and then we will compare it with Qlikview:
1. You first need to create a hierarchy in the presentation layer: For example, I have created a presentation hierarchy named "Products" having 3 levels "LOB" - "Type" - "Prod Name" as shown below.
Now if you run the report you will see the results like this:
On the similar lines if a user require this pivot to have a column from some other dimension say for example "Time". If we just add a column from the "Time" dimension lets say "Year", the pivot will look like this:
So we have seen the limitations and now we will see how easily an end user can create such reports without any help from developers or IT.
Simply create a Pivot table report and select the dimension columns and fact column. Here in this example I have selected the 3 columns which has been used to create the pivot in OBIEE11g. This is how the report will look like:
This is really simple and no hierarchies needs to be created anywhere. Now we will try to add some Time dimension column in the existing pivot and see how it looks. Simply add the column in the dimensions tab and arrange by promoting or demoting to see it wherever we want. I have added it to the top and this is how it will appear:
Going one step ahead lets say I want to have the subtotals of levels to be displayed in the pivot, Qlikview does it by simply selecting some of the available options. In Properties-Presentation tab there is a check box which says show Partial sum. You can also choose for the level for which you require the partials sums above or below. In OBIEE11g, I could not find anything other than the grand total sum. This is how it finally looks in Qlikview:
These small small options may not sound that important to some of us but for an end user it makes the entire experience interactive and helps him feel more independent and brings the feeling of ownership.
Till next time...