Thursday, 16 October 2014

Oracle BI Bundle Patch OBIEE

The new bundle patch set for Oracle Business Intelligence Enterprise Edition and Oracle Exalytics OBIEE was released recently.

Detailed patch description on Oracle Support: OBIEE 11g Bundle Patch is Available for Oracle Business Intelligence Enterprise Edition and Exalytics.

Further information on the current bundle patch respectively on OBIEE 11g patch sets:

OBIEE 11g: Bugs Fixed in
OBIEE 11g: Required and Recommended Bundle Patches and Patch Sets
Overview of Available Update Patches for Oracle BI Publisher Enterprise 11g

Friday, 10 October 2014

OBIEE Analyses Online Seminar

Do you know everything about creating analyses with OBIEE? Some participants of our Oracle University class Oracle BI Analyses Insights for End Users work with OBIEE since years. Find out their comments after attending the class:

Eric B.: “This seminar shows solutions you cannot find yourself, even if you attended all trainings.”

Sara B.: “This seminar is outstanding to get an overview on how a company can build reports efficiently. A lot of useful tips and new knowledge, a brilliant course!”

Joerg A.: “The online seminar was very helpful for us, because we are just preparing the rollout of OBIEE. The seminar gave us helpful tips and tricks we didn’t know till now!”

Johan D.: “The training is very good. The trainer gives time to ask questions.”

Reinhold S.: “Good is the practical relevance and the expert knowledge in customer contact.”

The seminar is scheduled next on the 14-Nov-2014 as online class. Take this chance to learn how to create powerful analyses with OBIEE and register today at Oracle University. Additional information:

Thursday, 2 October 2014

OBIEE Setting Data Format for Dates

For sure you know the situation having a date field like Order Date which provides date information in DateTime format. In such a case the user should be able to decide if Date or DateTime format is used, because both possibilities may apply.

Thus, your OBIEE application will provide those date fields in DateTime format. Otherwise users won't be able to access the time information. Date data format for reports not needing time information needs to be changed via Column Properties.

When implementing reports for users using Oracle BI in different languages you will lose locale settings if you select a specific date format, e.g. MM/DD/YYYY or any other from the date format list below.

OBIEE Date Data Format

To avoid lose of locale setting select Custom and insert as Custom Date Format:


OBIEE Custom Date Data Format

Tip: If you just want to see time information use [FMT:time]. Run your report, go to My Account, change the locate and reload OBIEE analysis results. Date format appears in locale selected.

OBIEE My Account Locale

Interested in some more end user topics? Check out Oracle BI useful things.