OBIEE 11.1.1.9 soon?


UPD. May 14, 2015 OBIEE 11.1.1.9.0 is now availbale for download on OTN. New features here. Note This post contains assumptions and rumors about upcoming OBIEE 11.1.1.9.0. Since it have been released, this post is no longer actual. You may be interested in reading about OBIEE 11.1.1.9 New features or OBIEE 11.1.1.7 to 11.1.1.9 upgrade. An interesting thing have been spotted in "Patch 20532929: PATCHSET UPDATE: HYPERION ESSBASE SERVER 11.1.2.4.001" readme. The first fixed bug is: Defect Number Defect Fixed 20573567 When upgrading EPM from 11.1.2.3 to 11.1.2.4 and BI from 11.1.…

Continue Reading

Oracle Business Intelligence and Cloudera Impala configuration


It's pretty easy to find a guide for connecting OBI EE to Cloudera's Impala when OBI EE is installed on MS Windows. But I haven't found any guides for Linux platform. So, here it is. Steps to connect OBI EE to Cloudera Impala when OBI EE is installed on Linux are the following: Download ODBC drivers Install and configure ODBC drivers on Linux (server side) Install and configure ODBC drivers on Windows (client side) Create and configure physical layer of repository Downloading ODBC drivers All the drivers you need are located on Cloudera's website and are available for download for free. Go to Download Cloudera Connectors page and select "Impala Drivers & Connectors". Click ODBC. Locate and download drivers for…

Continue Reading

Oracle Mobile App Designer installation


Oracle Mobile App Designer (BIMAD) is an OBI EE extension, based on BI Publisher (former XML Publisher) which allows developers to make highly interactive reports (so called applications) which can be viewed on almost any HTML5-compliant mobile device. Unfortunately, BIMAD is not installed during typical OBIEE installation and requires additional installation and configuration. This post covers this process. If you need information how to start using BIMAD, please read this post. Installation process involves the following steps: Download BIMAD patch Install BIMAD patch Configure OBIEE instance Configure BIMAD publishing directory BIMAD patch downloading BIMAD is distributed as a patch for existing OBIEE instance. Therefore the only place where it can be obtained is My Oracle Support. As a prerequisite your…

Continue Reading

OBI EE patching process


If you want to get working instance of OBI EE you typically need to install "basic" OBI EE version (11.1.1.7.0 currently) and then patch it to the latest version. Each patch corrects multiple errors and brings new features and browsers support. This post outlines basic patching principles and shows step by step process of applying the latest patch. There are nine patches available at the time of this post: Version Patch number 11.1.1.7.1 16556157 11.1.1.7.131017 17530796 11.1.1.7.140114 17886497 11.1.1.7.140225 18057570 11.1.1.7.140415 18283508 11.1.1.7.140527 18507268 11.1.1.7.140715 18818588 11.1.…

Continue Reading

OBI EE unix start/stop scripts


When installing OBI EE on MS Windows you get start-stop scripts out-of-box, but Oracle doesn’t provide any for Unix installations. Fortunately windows scripts could be very easily changed to work on Unix OS. I’ve tested them on various Linux ad AIX installations, and none of them gave me any troubles. These scripts use Apache ANT for starting and stopping OBI EE. ANT is packaged with all OBI EE distributives, is installed automatically and doesn’t need installation or any configuration. All you need to do is to create two files: small executable one and then configuration (build) one for ANT. Executable start_stop.sh: start_stop.sh export MW_HOME=/u01/oracle/Middleware export wls_host=bihome.bisoftdiary.…

Continue Reading

Oracle Business Intelligence 11g installation guide (Linux)


This guide shows step by step how to install OBIEE on Linux platform. But I've installed OBIEE to multiple Linux, Solaris, AIX and Windows servers, and can say that the process does not have significant differences in any other Unix or even Windows platforms. The only difference I can remember right now is a particular Java version for AIX (and it's perfectly documented). So all the steps of this guide could be used for any platform. Installation steps Prepare environment; Download proper distributives; Create database repository; Install and configure software. Preparing environment Before starting an installation, you need to prepare proper environment, which consists of proper operating system for BI server, database for storing OBI EE repository and for a…

Continue Reading