OBIEE 11.1.1.7 is available

OBIEE 11.1.1.7.0 is finally available for download at Oracle site.

It is available for all regular platforms.

Remember to download the new RCU as well.

Please note there is a new System Requirement excel (for BI 11.1.1.7) at this page.

There are many new features described HERE.

It seems that the documentation of OBIEE 11.1.1.7 is not available in the regular place (http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/documentation/index.html), but you can get it from the Middleware  documentation
Or directly here: http://docs.oracle.com/cd/E28280_01/bi.htm


The latest patch bundle for 11.1.1.7 is available in the link  OBIEE Bundle Patch 11.1.1.7.150120 is available. You should consider it. 

OBIEE - Top 2 of top 10 with Selection Steps

In the past I talked about Hierarchical Columns and selection steps. 

(here: OBIEE 11g - Hierarchical Columns Introduction

 and here:OBIEE 11g Hierarchical Columns and Selection Steps).

Lets talk about additional sample of using Selection Steps. This time I don't use Hierarchical Column, just to show, we don't need to.

What I want is a report of Top 2 Offices with top 10 Products.

Lets start with a simple report of Department, Product and Revenue.

The result isn't exactly what I wanted, since the same products are sold by different  Departments.  

I want top 10 unique Products.

So lets create a column that gives a unique sum for each product ( SUM(Revenue by Product) ) and run the in Top 10 on it.

Now we have a list of 92 row, since they are 10 Departments.

Now I want the top 2 departments by its revenue from the 10 top products.

I could create another column and filter on it, but it's easier to use Selection Steps:

Lets concentrate on Offices - Department, and create a new condition.

 

Select the Top.. based on... condition

And select the "Keep Only", "is top", 2.

We can select the Measure (Revenue for our needs)

And run it for all members of the Products.

As a result we have the top 2 Departments that sell the top 10 Products:

You don't believe me?

Lets remove the Selection Step, and summarize by Department:

The result proves to be correct. Q.E.D.

Endeca Information Discovery 3.0 is available

The new version of Endeca Information Discovery 3.0 is available at edelivery .

As usual it's available for Linux and Windows 64bit systems.

You can see the documents of the product in the top of the documents link: http://www.oracle.com/technetwork/middleware/endeca/documentation/index.html.

Next stop OBIEE 11.1.1.7 ?

OBIEE 11g Hierarchical Columns and Selection Steps

So we know what are Hierarchical Columns. What are Selection Steps?

Many people don't notice they exist is OBIEE 11g:

So what can we do with Selection Steps?
First of all they are not specific for Hierarchical Column.  Selection steps just like filter are intended to allow you to limit the data to fit your specific needs.
In the Users Guide, Chapter 5  there is a discussion about the difference between filters and Selection Steps.

• Filters are applied before Selection Steps
• Selection Steps are applied in the order you defined them
• Selection Steps are applied after the query was aggregated and affects only the members displayed and not the resulting aggregates.
• You can save Selection Steps for reuse.
• Unlike filters, if you exclude or delete a dimension from you analysis, the Selection Steps are excluded/deleted as well (despite all my efforts).

In Selection Steps you can:

 Select Members, Add Group of Calculated Items, Apply a Condition and Select Members based on Hierarchy.

There are 3 types of action you usually do with them:

• Keep - keep only the selected members
• Add  - add the selected members to the result
• Remove - remove the members from a result

We can have a long discussion about each option. We might do it one day, but lets have an example.

I want to create a set of previous 35 days based on time hierarchy. (I can do it with filters as well... The actual case was a bit more complicated).

So I can select"Apply a Condition in Time Hierarchy.

Now Select Condition type of "Last 3 Month":

In my case I want to keep only 

the last 35 values of day level 

in the Time Hierarchy.

I also want to override the value of 35 with a Presentation Variable, whenever I want. 

As a result the Time hierarchy values are now in Day level.


This is very "OLAP like" behavior. Selected Month level, would cause the report to show values of month and not dates.

I can now remove some of the days from the list as well, for example the last 32 days. So I'm left with only 3 days (it also fits very nicely with the not perfect data of the Sample).

Next I can save the Selection Steps for future use.
You can only save steps for a specific dimension.







So I'll save the steps in a selected folder.
In the screen:
The Name is the name of the members file.
Display Label is what you see in the Analysis (if I leave it empty, the name will be used).

The important question is what to Save: general steps, so it will give dynamic results, or just the members of the Results.

In our case the difference is between selecting each time the 3 days, or using the specific 3 days of this result, each time.

Now each time I create a new analysis, I can use saved Selection Steps:

I can even Edit the Start with all members

Then select a group of Calculated Item. That would be our Steps.

The result is:

(Please notice the little menu option near the Move arrow. You can select there "add" or "add members". The later will show you the days and not the "35 days" group you see in the result).

Another option is to add our Steps to existing "start with all" (or any other start with...)

This is what you get: