Monday, January 28, 2013

OBIEE 11.1.1.6.7 Patch Set available

The Business Intelligence Enterprise Edition 11.1.1.6.7 patch set has been released and is available to download from My Oracle Support.

Per the patch readme:
The Oracle Business Intelligence 11.1.1.6.7 patch set is comprised of the following patches:
  • Patch 15959887 (1 of 7) Oracle Business Intelligence Installer.
  • Patch 15959877 (2 of 7) Oracle Real Time Decisions.
  • Patch 15929063 (3 of 7) Oracle Business Intelligence Publisher.
  • Patch 15959899 (4 of 7) Oracle Business Intelligence ADF Components.
  • Patch 15959861 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x.
  • Patch 15894670 (6 of 7) Oracle Business Intelligence.
  • Patch 15959917 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer.

11.1.1.6.7 patch set is available for the supported platforms:
  • Microsoft Windows (32-bit)
  • Linux x86 (32-bit)
  • Microsoft Windows x64 (64-bit)
  • Linux x86-64 (64-bit)
  • Oracle Solaris on SPARC (64-bit)
  • Oracle Solaris on x86-64 (64-bit)
  • IBM AIX PPC (64-bit)
  • HPUX- IA (64-bit)

Note:
  • The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch.
  • This patch is cumulative, and therefore, contains all of the fixes included in the earlier 11.1.1.6.2, 11.1.1.6.4, 11.1.1.6.5 and 11.1.1.6.6 patch sets.
  • However, lists of fixes from included patch sets need to be looked up in the respective patches' readme files, and are not included in the above patches' readme files.
  • The instructions to apply the above patches are identical, and are contained in the readme file for patch 15959887.
  • Please bear in mind, that the readme states to apply patch 13952743 for JDeveloper, too.

 

OBIEE 11g Patch Set 11.1.1.6.4 (seven total patches)

The most recent patch available for OBIEE 11g so far is 11.1.1.6.4 that was released on 19th September 2012. Patchset comprises of seven patches as below:

The Oracle Business Intelligence 11.1.1.6.4 patchset comprises a number of patches:
PatchAbstract
14538078Patch 11.1.1.6.4 (1 of 7) Oracle Business Intelligence Installer
14538128Patch 11.1.1.6.4 (2 of 7) Oracle Real Time Decisions
14285344Patch 11.1.1.6.4 (3 of 7) Oracle Business Intelligence Publisher
14538164Patch 11.1.1.6.4 (4 of 7) Oracle Business Intelligence ADF Components
14415773Patch 11.1.1.6.4 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
14405222Patch 11.1.1.6.4 (6 of 7) Oracle Business Intelligence
14409674Patch 11.1.1.6.4 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer


This patchset is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.6.0, 11.1.1.6.1, 11.1.1.6.2, and 11.1.1.6.2 BP1


Following bugs are fixed in this patch set;

Bugs fixed by each of the patches in the Oracle Business Intelligence 11.1.1.6.4 patchset are described in the Readme file for each patch.
Bugs fixed in this patch (1 of 7) are shown in the following list:
13560245:BIDOMAIN/CONFIG/JDBC NOT FOUND.
13504454:BLK - BIINSTANCE COPYCONFIG FAILURE ESSBASE MAXL LOGIN IS FAILING
13510938:NEED OFFICIAL WAY TO INVOKE _CONFIGURERPD
13628293:EMPTY PROCUREMENT DASHBOARD IN RC4
13565722:BLK: BI T2P PASTECONFIG ERRORED OUT WITH UNABLE TO PARSE JMS_WEBLOGIC_JNDI_URL
13589944:BI T2P - PASTECONFIG INSTANCE IS FAILING WITH JAVA.LANG.UNSATISFIEDLINKERROR
13619973:INCLUDE ESSSERVER HOST NAME IN THE MOVEPLAN
13683204:STRESS:FA:CRM ERROR RESPONSE[NQSERROR: 43082] ILLEGAL OPERATION ATTEMPTED CLOSED
13724975:RUP2 AIX HCM STARTERDB POSTCONFIGURE FAILED
13779029:BI T2P BI RPD PLUGIN OPERATION ERROR WHILE LOADING SHARED LIBRARIES LIBARICU23
13687239:RUP2_RC4 BI DOMAIN - BI ANALYTICS DATASOURCE TEST FAILS
13780076:USE BIPROV PROPERTIES FROM 13694505
13404296:BI PROVISIONING FACADE MUST TRIM RPD IN INSTANCE FOR SELECTED FA OFFERINGS
13485655:T2P ERROR MSG EXECUTING WLST SCRIPT APPEARS DURING BIINSTANCE PASTECONFIG
13896014:RPDTRIM INCORRECT PROPERTY BIPROV.BI-HOME.DIR IN BI-CONTENT.XML FILE
13896152:TRIMRPD NOT ABLE TO CREATE BIPROJECTS.TXT BASED ON FAOFFERING LIST BAD XPATH ERR
13896209:TRIMRPD RELATIVE BI ORACLE HOME LOCATION PASSED TO SCRIPTS DURING RPDTRIM
13898786:TRIMRPD PLEASE MASK THE RPD PASSWORD WHICH IS LOGGED DURING _TRIMRPDTARGET EXEC
13910554:MISSING CONNECTION PROPERTIES IN OBIEE RPD
13926479:TRIMRPD FOR WINDOWS THE PROPS FILE SHOULD INCLUDE FORWARD SLASH IN DIR PATHS


Unfortunately, this patchset has bugs of its own. Following three are known so far:
14228519 ADMINTOOL CLIENT MISSING ALL FILES UNDER EXTENDER DIRECTORY IN CLIENT INSTALLER
14244844 NAVIGATE TO URL ACTIONS BASED ON ENCODED URLS MAY RESULT IN DOUBLE ENCODING
14636489 11.1.1.6.4 ADMINTOOL CLIENT INSTALLER DIALOG TITLE IS SHOWN AS "11.1.1.6.2"

OBIEE 11g Training from Oracle

Looks like Oracle launched classroom trianings for OBIEE 11g.

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=609&p_org_id=1001&lang=US&get_params=dc:D75629GC10,p_preview:N

It is a 4 day course offered at a price of $4000.

I saw following locations where it is currently offered in classrooms:

Date
Location
Instruction Language
Price
Start Time
End time
20130205Feb-05-2013
English
US$ 4000
09:00 AM
5:00 PM
20130205Feb-05-2013
English
US$ 4000
09:00 AM
5:00 PM
20130219Feb-19-2013
English
US$ 4000
09:00 AM
5:00 PM
20130225Feb-25-2013
English
US$ 4000
09:00 AM
5:00 PM
20130408Apr-08-2013
English
US$ 4000
09:00 AM
5:00 PM
20130422Apr-22-2013
English
US$ 4000
09:00 AM
5:00 PM



Course Objectives
·         Create and modify Oracle Business Intelligence analyses
·         Use hierarchical columns in analyses and views
·         Perform administration tasks related to the development and configuration of dashboards
·         Build and use views and graphs in analyses
·         Combine analysis criteria using set operations and execute direct database requests
·         Perform pre- and post-aggregate filtering using filters, groups, and selections
·         Add geographical mapping to analyses
·         Use Oracle Business Intelligence Mobile to view BI content on a mobile device
·         Create and modify dashboards
·         Use Oracle BI for Microsoft Office to integrate Oracle BI analysis and dashboard content
·         Configure Agents using Delivers to get the results of analyses and deliver them to subscribers

Course Topics

Introduction to Oracle Business Intelligence Enterprise Edition
·         Introduction to Oracle BI
·         Architecture overview
Working with Oracle Business Intelligence Analyses
·         Introduction to Oracle BI Analysis Editor
·         Oracle BI column types
·         Working with analyses in Oracle BI
·         Using advanced formatting
Administering the Presentation Catalog
·         Maintaining the Oracle BI Presentation Catalog in the Catalog page
·         Oracle BI and catalog security overview
·         Managing security using roles
·         Understanding security inheritance
·         Setting object permissions
·         Setting system privileges
·         Archiving catalog items
Limiting and Grouping Data in Analyses
·         Introduction to filters and selections
·         Creating, editing, and grouping filters
·         Adding prompts to analyses
·         Dynamic filtering
·         Using saved analyses as filters
·         Creating groups
·         Creating calculated items
·         Creating selection steps
Oracle Business Intelligence Analyses: Advanced Features
·         Setting analysis properties
·         Combining analysis criteria by using set operations
·         Executing direct database analyses
·         Editing logical SQL generated by an analysis
·         Creating a link to a saved analysis
·         Creating an Excel Web Query file
Working with Views and Graphs in Analyses
·         Introduction to views, graphs, and editors
·         Working with views in Compound Layouts
·         Creating and editing graphs
·         Linking master-detail views
·         Performing common view tasks
Visualizing Data: Gauges, Maps, and Mobile
·         Introduction to Gauge views
·         Working with Gauge views
·         Introduction to Map views and their components
·         Creating and editing Map views
·         Introduction to Oracle Business Intelligence Mobile
·         Working with and searching content in BI Mobile
Measuring Results with Key Performance Indicators
·         Introduction to KPIs
·         Creating KPIs, setting trending, dimensionality, and thresholds
·         Introduction to KPI Watchlists
·         Creating a KPI Watchlist
·         Changing Dimensionality for a KPI Watchlist event
Showing Results With Pivot Tables
·         Introduction to pivot tables
·         Creating, arranging, and formatting a pivot table
·         Using hierarchical columns
·         Sorting in pivot tables
·         Setting aggregation and using totals
·         Showing an item's relative value
·         Building calculations and displaying running sums
Creating Oracle Business Intelligence Dashboards
·         Introduction to dashboards and dashboard pages
·         Creating and editing dashboards
·         Using the Dashboard Builder
·         Exploring dashboard oject properies and options
·         Publishing dashboard pages
·         Creating personal customizations and using other page options
Configuring Oracle Business Intelligence Dashboards
·         Types of dashboard content
·         Embedding content in dashboards
Creating Dashboard Prompts and Variables
·         Overview of variables
·         Introduction to dashboard prompts and prompt types
·         Adding a named dashboard prompt to a dashboard
·         Adding a hidden named dashboard prompt to a dashboard
·         Creating additional prompt page and setting page preferences
·         Variables and prompts
·         Adding variable prompts to a dashboard
·         Wiring dashboard prompts
Using Oracle Business Intelligence Delivers
·         Introduction to Oracle BI Delivers
·         Configuring delivery devices and adding delivery profiles
·         Introduction to alerts
·         Adding an Alert Section to a dashboard
·         Overview of Agents
·         Configuring an Agent
·         Using Analysis and KPI conditions to deliver content with Agents
·         Subscribing to an Agent
Integrating Analyses with MS Office
·         Introduction to Oracle BI Office Add-in
·         Working with Oracle BI content in Microsoft Office applications
Working with Oracle Business Intelligence Briefing Books
·         Introduction to Oracle BI Briefing Books
·         Adding content to Briefing Books
·         Editing Briefing Books
·         Downloading and viewing Briefing Books
·         Adding a list of Briefing Books to a dashboard
·         Using Briefing Books with Oracle BI Delivers