OBIEE BUNDLE PATCH 11.1.1.7.150714 AKA 11.1.1.7.11 (?) is available

Please note OBIEE Bundle Patch 11.1.1.7.151020 is available. You might prefer it.

OBIEE 11.1.1.7 new general bundle patch (number 11?), 11.1.1.7.150714 is available in Patch 21103263, it can be installed on any previous 11.1.1.7 release.

Thanks to Oracle Business Analytics - Proactive Support for the tip. 

The Patch is platform specific and is available for:

• HP-UX Itanium
• IBM AIX on POWER Systems (64-bit)
• Linux x86
• Linux x86-64
• MS Windows (32-bit)
• MS Windows (64-bit)
• Oracle Solaris on SPARC (64-bit)
• Oracle Solaris on x86-64 (64-bit)

You can read the readme file here.

If you check carefully, the only new component when comparing to 11.1.1.7.150120 is patch
21235729.

Patch	Abstract
16913445	Oracle Business Intelligence Installer (BIINST) -same as previous patchset
19822893	Oracle Business Intelligence Publisher (BIP) -same as previous patchset
19825503	Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM) -same as previous patchset
19822857	Oracle Business Intelligence Server (BISERVER) -same as previous patchset
19822826	Oracle Business Intelligence Presentation Services (BIPS) -same as previous patchset
19823874	Oracle Real-Time Decisions (RTD) -same as previous patchset
16997936	Oracle Business Intelligence ADF Components (BIADFCOMPS) -same as previous patchset
20022695	Oracle Business Intelligence Platform Client Installers and MapViewer -same as previous patchset
21235729	Oracle Business Intelligence Third Party

As usual there is a bonus patch: Patch 16569379  (1111770)- Dynamic Monitoring Service patch. It is platform dependent. If you installed it with 11.1.1.7.1 or later, that's enough. It's the same.

According to "Oracle EPM BI proactive support" here additional patch Patch 18277370 (MERGE REQUEST ON TOP OF 11.1.1.7.0 FOR BUGS 18071063 18176711) is required for IE11 console users.

Bugs fixes 

Oracle Business Intelligence Third Party

 Fix For Bug  20247002

OBIEE - Controlling the Date format

Different countries use different date formats. Most of them are logical. The Default in OBIEE is the American way. Lets see how can we change it.

My customer wanted the the date in European format and stay with English interface.

 

Option 1:

 The default option is to change the settings for each user in My Account:

And set the locale to a proper one. 

For example this is English United States:

This is English UK:

This is Russian dates:

When you change to non English locale, and want the user Interface in English, remember to change that back, since it changes automatically (in this example to Russian).

 

Option 2:

When I don't want to bother with My Account, I can try brute force by changing localedefinitions.xml (located at MWHOME/Oracle_BI1/bifoundation/web/display).

Find there:

 <localeDefinition name="en">              <!-- english base -->

and there change:

<property name="dateShortFormat">M/d/yyyy</property>
 <property name="dateLongFormat">dddd, MMMM dd, yyyy</property>

to

<property name="dateShortFormat">dd/MM/yyyy</property>
 <property name="dateLongFormat">dddd, dd MMMM, yyyy</property>

Just remember it might be restored to default after patches.

OBIEE 11.1.1.9 New features - Interface, part 2

I covered some new features in part 1. Here I will cover few more. Some of the features covered here are available since 11.1.1.7.10 and 11.1.1.7.16 but are new for many OBIEE users.

There is a new feature in Prompts: Ability to arrange check boxes and radio buttons layout Horizontally as well.

The most interesting Prompt feature is not defined in Prompts but rather at the Dashboard definition page level. It's the ability not to run the dashboard, before prompt is applied.

The definition is hidden under Edit Dashboard / Dashboard Properties:

When such page is marked, the first time you open it, you will see:

The normal behavior will resume after selecting prompt values and pressing the Continue. this happens only the first time. For additional details see the Users Guide.

To remove this option from OBIEE see the Admin Guide 

Once you are in editing dashboard, you might see the Advanced Page properties option that set the scope of parameters in cases of Go URL, Prompted URL and Navigate to BI content:

In Graphs, when selecting Stacked Vertical Bar or Stacked Horizontal Bar, and setting the data labels to "always", we have centralized aligned data labels.

In Tables, Pivot and similar you can see Column properties from the edit window as well.

in the same place we can also create New calculated Measure.

Analysis Advanced Tab, there is a new options here:DIMENSIONALITY:

Dimensionality: (from the Users Guide) Show Total value for all measures on unrelated dimensions.  Select this check box to include the ENABLE_DIMENSIONALITY variable at the beginning of the
SQL statement: SET VARIABLE ENABLE_DIMENSIONALITY = 1;
Setting ENABLE_DIMENSIONALITY may allow cross subject area queries to
return non-null results for certain measure columns that would otherwise return
null values when ENABLE_DIMENSIONALITY is not set. The measure columns
may also contain duplicated values when ENABLE_DIMENISONALITY is set.

Personal note: Shiran, it was made for you.

ilOUG tech Days 9/6 -10/6

Next week ilOUG is running 2 days of lectures in Haifa Dan Carmel hotel. Seems like very interesting agenda.

A little update, I will replace Tovit in the Big Data Discovery lecture.

 

The direct link is: https://iloug-tech-days-2015.events.co.il/home