Saturday, 24 October 2015

OBIEE 12c released

OBIEE 12c TrellisJust in time for Oracle OpenWorld 2015 Oracle BI OBIEE 12c is released. The new version Oracle Business Intelligence 12c (12.2.1.0.0) is available for download on Oracle OTN for Linux, Windows, Solaris, AIX and UX.

OBIEE 12c TreemapThere are many new interesting OBIEE 12c functionalities to talk about. For now we just want to let you know this great news and provide an overview. We will add more information to new blog posts subsequently. Documentation is available at Oracle Fusion Middleware 12c Help Center.

Any questions? Don't hesitate to ask for our OBIEE expert consulting, support, coaching and training.

Enjoy OBIEE 12c - a great new BI and analytics chapter!

New Features for Oracle BI Users
  • Visual Analyzer
  • Mashup data using Visual Analyzer and Analysis editor
  • New view type named heat matrix
  • Ability to sort graph, heat matrix, pivot table, table, treemap, and trellis views by using a context menu (right-click)
  • Specify whether to multiply data by a 100 to display it as a percentage in an analysis
  • Add data from an external source to an analysis
  • Style and customize KPI Watchlists and every watchlist that appears in a scorecard
  • Set advanced dashboard page properties to specify incoming navigation parameters
New Features for Oracle BI Metadata Repository
  • Logical Level Sequence Numbers for Time Dimensions
  • DISPLAY | SORTKEY Syntax Supported in the SQL ORDER BY Expression
  • Oracle Database Fast Application Notification and Fast Connection Failover Supported by Oracle BI Server
  • Generate Fragmented Aggregates in Aggregate Persistence
  • New Command Line Utilities:
    • Download Repository Command
    • Upload Repository Command
    • List Connection Pool Command
    • Update Connection Pool Command
    • Rename Application Role Command
    • Delete Application Role Command
    • Rename Users Command
    • Delete Users Command
    • List Repository Variables Command
    • Update Repository Variables Command
New Features for Oracle BI System Administrators
  • Invoking WLST From a Single Location
  • Oracle Home Location Redefined and No Middleware Home
  • OPMN is No Longer Used in Fusion Middleware
  • Oracle Web Cache Not Part of Fusion Middleware
  • Moving From Test To Production is Carried Out in a Different Way
  • New Commands For Process Control
  • Managing Metadata In Business Intelligence Archive Files
  • Single Enterprise Install
  • Changes to Scaling Out
  • Simplified Configuration
  • Managing System Component Instances Using Commands
  • Collecting Diagnostic Bundles
New Features in Oracle BI Security
  • BISystemUser and BISystem Removed
  • User GUIDs Removed
  • Database Security Store
  • Easier SSL Configuration
  • Migrating Catalog Groups to Application Roles
New Features for Oracle BI Publisher 12c
  • Generate Explain Plan from SQL Data Set
  • Best Practices Information
Oracle BI 12c Release Notes (12.2.1.0.0)
  • Reports File from BI Search in High Availability Environment
  • Visual Analyzer Does Not Support Bidirectional (BIDI) Languages
  • Avoid Including Internet Protocol Version 6 Addresses in Configuration Files
  • Essbase Connections Require A Shared Logon
  • Treemap View Fails To Download In PDF, Excel, or Powerpoint Format
  • Metadata Dictionary XML Files Must Be Opened in MS Internet Explorer
  • Using The TRENDLINE SQL Function
  • Correction to the TRENDLINE Function Syntax
  • Ignore The Chapter On The BI Systems Management API

Friday, 23 October 2015

Oracle BI Bundle Patch OBIEE 11.1.1.9.5

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

There is currently no detailed patch description available. The patch is currently only available for Linux64. It's tagged to be a recommended security patch. We will publish further news in this blog post.

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

OBIEE 11g: Bugs Fixed in 11.1.1.9.5 (not available at the moment as support document)
OBIEE 11g: Required and Recommended Bundle Patches and Patch Sets

Oracle BI Bundle Patch OBIEE 11.1.1.7.151020

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

There is currently no detailed patch description available. The patch is available for Windows64, Linux32 and Linux64. We will publish further news in this blog post.

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

OBIEE 11g: Bugs Fixed in 11.1.1.7.151020 (not available at the moment as support document)
OBIEE 11g: Required and Recommended Bundle Patches and Patch Sets
Overview of Available Update Patches for Oracle BI Publisher Enterprise 11g

OBIEE Mobile Apps News

Oracle released new version 11.1.1.7.0 (11.7.45) of Oracle BI Mobile HD app for Apple products (see App Store). And that's new:
  • Localization Updates
  • Bug Fixes
  • Handoff Support
  • iOS 9 Support
Oracle BI Mobile HD app requires iOS 8.0 or later. It's compatible with iPhone, iPad, and iPod touch.

Android App is currently in version 11.1.1.7.0.412 as already mentioned in our last OBIEE Mobile blog post (see Google Play):
  •  Share as Image
  • Alerts
  • Presentation Mode (Chromecast)
  • Share Nearby
  • Bug Fixes
  • Support for Oracle Visual Analyzer Content
Please find former Oracle BI Mobile release information also in this blog.

Friday, 31 July 2015

OBIEE Advanced Analytics for Business Users

Maybe you already heard about Gerd's OBIEE expert class Oracle BI Analyses Insights for End Users introducing several interesting OBIEE topics to users. Please find expert session participants' feedback and additional information at:
We now moved forward, adapted and enriched the seminar content to our very own OBIEE Advanced Analytics for Business Users training session. Find out how a clients' employees with controlling background rate the seminar Gerd recently delivered:

"Sound knowledge from a long practical project experience."
"Eye-opener!"
"Practical operation with concrete questions."
"Very professional and helpful. Good approach!"
"Absolute recommendation!"
"It's worth the investment."

We appreciate if you are interested in our OBIEE expert events. Please contact us for more details via +49 (0) 8709 / 915 202 or training@ga-itbs.de.

Friday, 24 July 2015

Oracle BI Mobile Apps

Oracle released new version 11.1.1.7.0 (11.7.21) of Oracle BI Mobile HD app for Apple products (see App Store). And that's new:
  • 64 bit Support
  • Bug and Stability Fixes
  • Minor UI Updates
  • Simple URL to Add a Single Server
Oracle BI Mobile HD app requires iOS 7.1 or later. It's compatible with iPhone, iPad, and iPod touch. The app is optimized for iPhone 5, iPhone 6, and iPhone 6 Plus.

Android App is currently in version 11.1.1.7.0.375 and was not updated yet since our last OBIEE Mobile blog post (see Google Play).

Update October 2015: Android App is now available in version 11.1.1.7.0.412 providing new functionality:
  •  Share as Image
  • Alerts
  • Presentation Mode (Chromecast)
  • Share Nearby
  • Bug Fixes
  • Support for Oracle Visual Analyzer Content
Please find former Oracle BI Mobile release information also in this blog.

Thursday, 16 July 2015

Oracle BI Bundle Patch OBIEE 11.1.1.7.150714

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

Detailed patch description on Oracle Support: OBIEE 11g 11.1.1.7.150714 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 11.1.1.7.150714
OBIEE 11g: Required and Recommended Bundle Patches and Patch Sets
Overview of Available Update Patches for Oracle BI Publisher Enterprise 11g

Thursday, 28 May 2015

OBIEE Data Viewing Default for Fixed Headers Scrolling or Content Paging

OBIEE Freeze Columns isn't really a new functionality of Oracle BI, but we had to perform some investigations after a client installed OBIEE patch 11.1.1.7.150120. Somehow the default setting for data viewing of Table and Pivot Table views changed ot Content paging and was not longer Fixed headers with scrolling content:

OBIEE Table Properties

We didn't care about it in the past, because default value was always scrolling with fixed headers. We couldn't find the following instanceconfig.xml setting in the OBIEE documentation. It's a very helpful option that enables scrolling as default when value is set to true - or defaults to content paging if set to false:

<Views>
...
  <GridViews>
    <DefaultScrollingEnabled>true</DefaultScrollingEnabled>
  </GridViews>

</Views>

Thursday, 14 May 2015

OBIEE 11.1.1.9 released

Did you already wait for OBIEE 11.1.1.9 to be released? So, here we go. The new Oracle BI version OBIEE 11.1.1.9.0 is now available for download at Oracle OTN.

If you need upgrade support then just ask for our OBIEE services. New features as provided in several Oracle BI documentation books and some undocumented functionalities are:
Oracle BI Users
  • Oracle Scorecard and Strategy Management: specify the number of decimal places to include in scores
  • Dashboards: create custom export layouts for exporting dashboard content to Excel
  • Manage accounts: replace account entries in the Access Control List (ACL) and to manage unresolved accounts
  • Selection steps: use variables to override values in selection steps
  • Export functionality: several new and changed components, export options Excel 2003 and Powerpoint 2003 no longer included in menu
  • Analyses: search within the subject areas, global variables and save columns to the Oracle BI Presentation Catalog for reuse in other analyses
  • New Treemap chart for visualisation
  • New Skyros style (similar to Oracle BI Cloud Service)
  • Horizontal layout for buttons and check boxes in Dashboard Prompts
  • Upload of custom images
  • HTML5 images instead of Flash
Oracle BI Metadata Repository Builders
  • Whole rpd checkout option added to multiuser menu
  • Several aggregate persistence improvements
  • Initialization block written in JSON syntax
  • Translation keys have been added to all presentation objects
  • Cloudera Impala supported
  • Access to Hyperion Planning data sources
  • Support for Oracle 12c Database In-Memory, Oracle 12c Database on Exadata and Oracle 12c Database In-Memory on Exadata
Oracle BI System Administrators
  • New properties for full-text search
  • Some new or enhanced configuration elements for export, graphs, table, pivot table and trellis views
  • New NQSconfig.INI settings
  • Debugging Agents using Fusion Middleware Control
  • Session tracking within Usage Tracking component
Oracle BI Security
  • New privileges: add EVALUATE_PREDICATE function, save column
Oracle BI Installation
  • When you perform a new 11.1.1.9 BI installation, Oracle BI Mobile App Designer is automatically installed with the Oracle BI EE components.
Oracle BI Integrators
  • Oracle Business Intelligence includes a SchedulerService Service.
Oracle BI Publisher Administrators
  • Oracle Endeca no longer supported as a data source
  • Support for Oracle WebCenter content server as a delivery destination
  • Configure memory guard on the properties page
And last but not least some excerpts from the Release Notes (please have a look to the documentation if there are any solutions provided):
  • From Oracle BI EE Release 11.1.1.9.0 onwards, Microsoft Windows 32-bit is no longer supported.
  • After upgrading to Oracle BI EE 11.1.1.9.0, OBIEE Mobile App Designer is not updated.
  • Authentication fails against third party LDAP when virtualize is set to true (applicable for Microsoft Active Directory as the identity store). Customers should check the availability of a patch for this issue on their installation platform before continuing to upgrade to 11.1.1.9.0 (Update: patch is available with additional information at Oracle Support).
  • SSL configuration changes required due to new JDK version (when using Oracle BI 11.1.1.9.0 with Weblogic 10.3.6 and JDK 7, download and apply Weblogic patch 13964737).
  • Axis label truncation in trellis views.
  • Export to Excel 2007+ and export to PDF do not support custom CSS styles.
  • Truncated Microsoft Office Excel 2007+ download for table, pivot table and trellis views.
  • Export options do not behave as documented.
  • Use of Custom Images in Analyses and Dashboards is a new feature, but is not documented yet.
  • Excel Analyzer and Online Analyzer deprecated in release 11.1.1.7 and removed from 11.1.1.9.

Oracle BI Cloud Service (BICS)

Oracle BI Cloud ServiceOracle BI Cloud Service aka BICS provides Platform as a Service (PaaS) functionality to clients. As you maybe know new features are added regularly by Oracle without any need for administration, patching or upgrade.

As of April 2015 some the following new features were added:
  • Integrate with Oracle Database Cloud Service (Database as a Service)
  • Upload data models from a file
  • Add your own data to analyses
  • Explore data using Visual Analyzer
Please follow Oracle Support document Oracle Business Intelligence Cloud Service (BICS) - New Features and Enhancements for further updates and history.

Oracle BI Mobile Apps - iOS and Android

Oracle released new version 11.1.1.7.0 (11.6.39) of Oracle BI Mobile HD app for Apple products (see App Store). And that's new:
  • Support for Visual Analyzer content
  • Bug and stability fixes
Oracle BI Mobile HD app requires iOS 7.1 or later.

Android App is currently in version 11.1.1.7.0.375 and was updated at last in March 2015 (see Google Play). New functionalities:
  • Updated UI for material design
  • Optimized for Android 5.x
  • Support for sharing connections via URL
  • Oracle BI Mobile Security Tool Kit available on Oracle Technology Network
  • Simplified server configuration
  • Simplified connection switching
  • Translations
  • Bug fixes
Please find former Oracle BI Mobile release information also in this blog.

Saturday, 9 May 2015

OBIEE Non-Conforming Dimensions

BI Forum 2015Yesterday BI Forum 2015 in Brighton ended with the Gerd's session Driving OBIEE Join Semantics on Multi Star Queries as User (slides available at SlideShare). It was a great pleasure to speak in Brighton and to get quite good information in other OBIEE, data discovery and data visualisation sessions. This article adds some details to presentation just mentioned.

OBIEE multi star queries are a powerful but complex Oracle BI functionality. They allow simple retrieval of new business insights and deliver added value due to cross-functional analyses. Presentation introduces a major change within Oracle BI query logic since release of OBIEE 11.1.1.7.1 (see also Oracle Support document OBIEE: Setting Fact to Total Level Of Hierarchy No Longer Forces Outer Join). Example uses an OBIEE logical model with two non-conforming dimensions Invoice Item and Return:

OBIEE Star Schema Non Conforming Dimensions

The figure Invoice Qty has Return total level set and Return Qty total level of Invoice Item. If conformed content is added to the query then OBIEE performs inner, left or full outer joins on conformed columns depending on filter types applied:
  • Non-conforming inner join when global filters are applied to both non-conforming dimensions.
  • Non-conforming left or right outer join when non-conforming dimensions are filtered mutually exclusive by a global and a local filter.
  • Non-conforming full outer join when only local filters are used for non-conforming dimensions.
Global filters are commonly used filters within a report. They apply to the full query. Local filters just filter measure field content and look like:

FILTER(<measure> USING <expression>)

Presentation slides provide query details and OBIEE generated SQL for all combinations mentioned above. This behaviour isn't feasible for all query cases. For deactivation insert the following statement into the Prefix field of Advanced tab of Oracle BI Answers (same procedure as shown in OBIEE Variable LOGLEVEL and Report Based Logging):

SET VARIABLE FOJ_GRAND_TOTAL_LBM=1;

After applying OBIEE server is forced to only perform full outer joins as prior to OBIEE 11.1.1.7.1.

Saturday, 2 May 2015

OBIEE Graph Conditional Formatting on Other Column

Image below illustrates an example for conditional formatting of OBIEE table views. KPI Value field conditional format is calculated based on Threshold column value. OBIEE system provides Target and Threshold values for improvement of application usability. KPI visualisation is often based on equivalent graph and chart layout but on different targets and thresholds. OBIEE internal threshold calculation providing fixed values like green and red simplifies view development and layout.

OBIEE Table Conditional Formatting

That works quite good for table views, but conditional formatting based on another column isn't possible for graph views like the vertical bar chart shown. Graph conditinal formatting only accepts conditions derived from the same column and comparison with a static value or a presentation variable:

OBIEE Graph Conditional Formatting

Even adaptation of the Analysis XML doesn't help. To solve such a request add two additional KPI Value fields for green and red. Apply calculation as follows to get the result as shown in the image afterwards:

KPI Value Green
CASE
  WHEN "Fact - KPI"."Threshold" = 'green'
  THEN "Fact - KPI"."KPI Value"
END

KPI Value Red
CASE
  WHEN "Fact - KPI"."Threshold" = 'red'
  THEN "Fact - KPI"."KPI Value"
END

OBIEE Graph Conditional Formatting Calculation

Change the vertical bar chart to be a stacked vertical bar chart and apply standard style formatting to show desired colours. Of course, remove legend and fields not used to get an acceptable visualisation.

OBIEE Graph Conditional Formatting Other Column

In combination with OBIEE Change Field Content and OBIEE Change Analysis Subject Area replication of layout gets very easy.

Friday, 24 April 2015

OBIEE On-Board Performance Monitoring

Yesterday I presented at the DOAG 2015 BI, the German Oracle User Group BI conference. As assumed there was a quite good interest and discussion concerning my OBIEE performance monitoring topic.

OBIEE UsageBI performance is a complex topic and there are often many ways to increase it. When checking existing client solutions we recognize frequently that cost-intensive solutions are the first choice and customers don't know what user really do. So at first, start analysing your analytics application:
Enjoy OBIEE,
Gerd

Thursday, 16 April 2015

OBIEE Filter Sliding Last Day of Month

In general OBIEE repositories provide a bundle of date repository variables which update for example every 30 minutes to easily calculate a sliding window on the date dimension. So, users don't have to change their reports in the course of time:

OBIEE Line-Bar Chart

OBIEE Date DimensionWhen having a look to the Oracle BI line-bar chart above it shows figures by the last day of the month in a sliding window. Such a request isn't very common and typically there are no date repository variables for such a requirement. But more likely two variables like

CURRENT_MONTH_YAGO
PREVIOUS_MONTH

should be available. But filtering the last day of several months on a standard date dimension in a sliding window is not possible with these Oracle BI repository variables. The solution is based on the same functionality already introduced in blog post OBIEE Substitute a Filter Variable. When applying the filter set a SQL Expression value as follows:

CASE
  WHEN "Calendar Date"."Month Code" IN
    (1,3,5,7,8,10,12) THEN 31
  WHEN "Calendar Date"."Month Code" IN
    (4,6,9,11) THEN 30
  ELSE 28
END

In the Edit Filter dialogue box it looks like:

OBIEE Edit SQL Expression Filter

The filter of the report will be:

OBIEE Filter

Thursday, 9 April 2015

OBIEE Dashboard Recursive Master-Detail Navigation

Dashboards and its reports are sometimes designed to present as well overview and detailed information. Obviously switching between detail levels can be done by filtering via an OBIEE dashboard prompt which is not very user-friendly, because users have to type the values into the prompt even if the field is already visible in the result set, like Product No in the example dashboard page:

OBIEE Dashboard Master View

It's just an example based on two reports. Such dashboard pages could be much more complex. Intended functionality is quite the same as Master-Detail events do between views of a specific analysis. So, behaviour should be drilling on Product No results in:

OBIEE Dashboard Recursive Detail View

To implement this functionality just set an action link on the report column with destination to be the dashboard page itself so that the same set is filtered when drill down is performed:

OBIEE Dashboard Recursive Action Link

Of course, the Product No value is propagated to the dashboard prompt (if your OBIEE server patch set is not too old). Shown solution also works fine when filtering the dashboard master view on Title first.

Wednesday, 8 April 2015

OBIEE Dashboard Prompt Eliminate Required Field with Implicit Defaults

Sometimes report requisitioners insist on getting table views showing each data row in detail. Without applying a filter such reports in general don't return results within an acceptable runtime. Additionally the Oracle BI server and database are stressed unnecessarily. To avoid long running queries when opening a dashboard you can implement a simple solution. Just set a filter to a value which doesn't exist:


Such a filter implies to provide a prompt for the same field which must be set to be required (see asterisk):


If the user doesn't need to insert a value then the value n/a in the report isn't overriden and query returns an empty result set again. Setting a proper default for the field isn't always possible or makes no sense at all, because users don't know adequate values or want to filter other detail fields, e.g. Title in our case. Thus, Product No has to be set with a default implicitly after selecting a Title. To do so OBIEE dashboard prompt settings should be:


Especially the options Include "All Column Values" choice in the list and Limit values by Title are necessary. Implication after setting the Title:


Product No is set to (All Column Values) without the need to insert values explicitly with the result that the required field is eliminated.

Sunday, 22 March 2015

BI Forum 2015

Already since years Mark and some other people from the OBIEE community invite me to join the BI Forum in Brighton, but I was too busy in the past. That didn't change ;-), nevertheless I blocked the two days in May. I'm very pleased about getting voted from the audience to speak at the BI Forum 2015 (May 6th-8th 2015).

Topic: Driving OBIEE Join Semantics on Multi Star Queries as User

Abstract
One of the most powerful OBIEE functionality is the ability for users to query several star schemas (multi star queries). Most likely users will use non-conforming dimensions in such a case to filter specific data. Doing so since OBIEE 11.1.1.7 SQL generator engine changed the semantic how results are joined. This presentation gives a complete introduction of the possibilities coming along and shows how users can drive inner, left and full outer joins between multi star queries. Presentation will close with a potential bug discussion in the OBIEE SQL generator engine.

See also the preview of three OBIEE sessions in Brighton providing additional information of my presentation at the end of the post.

Looking forward to meet you in Brighton,
Gerd

Friday, 6 March 2015

DOAG 2015 BI


OBIEE On-Board Performance Monitoring ist der Titel unseres Vortrags auf der DOAG 2015 BI am 23.04.2015 in München. Beginn des Vortrags ist um 16:30 Uhr im Track "Performance". Wir freuen uns auf Ihren Besuch, Diskussionen und Erfahrungsaustausch.

Gerd Aiglstorfer stellt eine kostenlose Lösung zur Überwachung der Performance von Oracle BI vor:

"Schlagworte wie Echtzeit und In-Memory suggerieren, dass Performance in heutiger Zeit kein Problem mehr ist. Doch auch neue Technologien können nicht optimal eingesetzt werden, wenn die "alten" Technologien nicht bestens beherrscht werden. Außerdem ist für viele Kunden eine Investition in In-Memory-Technik weder finanziell leistbar noch praktisch notwendig.

Gerade die Performance und BI- und DWH-Anwendungen hängt von vielen, unter Umständen sehr kostenintensiven Faktoren ab. Selbst heute schnelle Systeme können morgen langsam sein. Zu Beginn jeder Maßnahme zur Optimierung der Performance steht daher das regelmäßige Monitoring und Analyse der Nutzung einer BI-Anwendung. Daraus leitet sich die adäquate Maßnahme ab, die nicht zwingend immer nur technischer Natur ist.

Dieser Vortrag stellt eine vom Unternehmen des Referenten entwickelte Oracle BI Performance Monitoring Lösung vor, die ausschließlich auf OBIEE Bordmitteln aufbaut und für interessierte Kunden kostenlos ist. Sie erlaubt Betriebsverantwortlichen, die Systemlast zu überwachen, Engpässe festzustellen und damit hohe BI-Performance zu möglichst geringen Kosten zu gewährleisten."

Thursday, 5 February 2015

Oracle BI Mobile Apps

Oracle released new version 11.1.1.7.0 (11.6.20) of Oracle BI Mobile HD app for Apple products (see App Store). And that's new:
  • iOS 8 Support
  • Immersive Mode. Changes and improvements including Show/Hide options for the Prompts bar, the Page bar, and the title bar.
  • Local iOS Notification for Alerts. Receive your Oracle BI Mobile alerts in the iOS Notification Center, from which your alerts take you directly to the app.
  • iPhone: Improvement to First-Time Help. Now you can reset the first-time help so that it shows again whenever you like.
  • iPad: Improvements to UI. Simplified welcome dialog allows you to quickly choose the demo, the server configuration screen, or offline mode. Simplified sharing options in the Settings screen.
  • Translation Update
  • Bug fixes
Oracle BI Mobile HD app requires iOS 7.1 or later.

Android App is currently in version 11.1.1.7.0.195 and was updated at last in November 2014 (see Google Play).

Monday, 2 February 2015

OBIEE Repository and Reports Master Class


As you maybe know our managing director and OBIEE expert trainer Gerd is regularly present at DOAG events (DOAG = German Oracle User Group). It's a pleasure to announce that we are partnering with DOAG to deliver a Berliner Expertenseminar - a special 2 day DOAG expert training event only taking place in Berlin.

Find details below and don't hesitate to contact us if there are any questions.
Booking via us +49 (0) 8709 / 915 202 or training@ga-itbs.de

Trainer: Gerd Aiglstorfer
Course: OBIEE Repository and Reports Master Class
Date: 29-Sep-2015
Duration: 2 days
Location: Berlin
Language: German
Price (DOAG members): 990 €
Price (others): 1.300 €

How do attendees rate our training classes?
Absolute recommendation! or A brilliant course!

Topics:

You will gain in-depth OBIEE knowledge from an expert delivering Oracle BI projects for more than 10 years. OBIEE repository and reports master class focuses practical project know-how:
  • Efficient and consistent OBIEE modeling and configuration
  • Proven OBIEE repository configuration coding standards
  • Implement a flexible and expandable OBIEE enterprise security model to access business objects (e.g. subject areas and web catalog objects), application components and data
  • Insights for developing reports (derived from our top rated OBIEE seminar, content is described at the end of the article)
  • Advanced reporting (e.g. functions, report aggregation, multi star queries and combined results)
  • Advanced filtering (e.g. global and local filters, presentation variables for different requirements)
And of course there will be time to discuss and give answers to your specific questions in detail.

Wednesday, 21 January 2015

Oracle BI Bundle Patch OBIEE 11.1.1.7.150120

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

Detailed patch description on Oracle Support: OBIEE 11g 11.1.1.7.150120 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 11.1.1.7.150120
OBIEE 11g: Required and Recommended Bundle Patches and Patch Sets
Overview of Available Update Patches for Oracle BI Publisher Enterprise 11g

Oracle support states: This will likely be the final Bundle Patch for 11.1.1.7.

This tip was formerly given in support document 1488475.1 and was removed again (see @BIExperte).
In the end, just don't care about it. OBIEE 12c will be released sooner or later.
Oracle always says that release or patch plans can change.