Tuesday, 26 August 2014

Oracle BI Mobile HD App

Oracle yesterday released new version of Oracle BI Mobile HD App for Apple products (see App Store). Changes are:
  • iPad: Improved Thumbnail Previews. On the iPad, thumbnail previews now refresh every time the analysis is opened. This eliminates the need to remove the app in order to clear stale previews. NOTE: For performance reasons, if a preview is less than five minutes old, it is not updated.
  • iPad: Mobile Layout. By default, analyses and dashboards open with the desktop layout on the iPad. There is now an option that allows you to toggle to the mobile layout. The layout applies to each analysis or dashboard individually, and persists for the duration the analysis or dashboard remains open. Tap Options, then tap Mobile Layout. Toggle back to Original Layout.
  • All Column Values Option for Prompts. For prompts that support the 'All Column' selection option, this is now available in Oracle BI Mobile. In the prompts dropdown, tap All Column Values to select all options at once.
  • iPhone: Spacing of icons in navigation bar. The icons in the bottom toolbar are now evenly spaced.
  • Security Toolkit Enhancement. Now when you get the security toolkit, you also get a sample XCode project along with it.
  • Bug Fixes and SSO Enhancements
Android App was updated to version a few days earlier providing Google Search integration (see Google Play).

Saturday, 16 August 2014

OBIEE Performance Monitoring with Usage Tracking

We provide the reports below and the OBIEE repository implementation deployed completely free of charge! Find the details for obtaining them at the end of this article.

Oracle BI application operating and users often ask for a simple solution to monitor overall OBIEE analysis and report performance. Question often comes up when discussing service level agreements (SLAs) for Oracle BI. SLA discussions for BI applications can become very complex, because there are many factors which impact reporting performance like database/application server hardware, data growth, number of concurrent users and complexity of user initiated queries ... just to list a few of them. When initiating BI projects normally information on these topics isn't very accurate. Therefore sizing is often a best guess on imprecise preconditions. Furthermore you shouldn't declare "Any report must return results within 10 seconds!" in your SLAs. That's easy to break.

Well, BI and of course OBIEE solutions generally evolve. You will have to monitor and optimise performance regularly. To optimise you need to know what reports users run actually, to be able to decide if you need restructuring (physical or logical). Very often it's sufficient to help users build enhanced analyses. Therefore SLAs are nice, but they don't help you to get a long running optimal Oracle BI solution which causes lowest possible costs.

To get an OBIEE report performance overview we created an Oracle BI performance monitoring solution based on Usage Tracking. Usage Tracking is an internal OBIEE tracking component. Once activated it tracks all data on report performance. For analysing purposes no additional implementation is needed, you just need to retrieve the relevant information. You can obtain the 4 reports within a dashboard and corresponding OBIEE repository for free (see below).

Performance per Bucket
Bucket report returns performance information based on categories. The chart tells you immediately that 87% of queries succeed within 30 seconds and 96% of queries succeed within 2 minutes.

OBIEE Performance per Bucket

Detailed table provides different figures for each runtime category:
Query #: number of queries
Cache Hit #: number of queries having at least one cache hit
DB Query #: number of queries executing only database requests
RT Avg: runtime average (seconds)
RT Cache Avg: runtime average for queries having at least one cache hit
RT DB Avg: runtime average for queries executing only database requests
Rows Avg: average number of selecting data rows per query
Cache Hits per Query: average number of cache hits per query
DB Queries per Query: average number of database requests per query

Performance per Hour
Hour report shows intraday system workload and runtime average.

OBIEE Performance per Hour

Performance per Subject Area
Usage of subject areas and corresponding runtime.

OBIEE Performance per Subject Area

Performance per User
Most active users and how OBIEE system serves their requests.

OBIEE Performance per User

Release Notes v1.0
The reports are integrated in a dashboard to be able to select specific time periods. Oracle BI repository and reports are based on OBIEE Reports are additionally provided in OBIEE XML structure. For installation or downgrading support just contact us.

As being the first release for OBIEE performance monitoring we are aware that there are many questions not covered yet, especially for detail reporting. Please feel free to send us your specific analysis requests for Oracle BI report performance monitoring. We will try to integrate them in the next release.

Release Notes v1.1
Added additional filters for Date, Subject Area and User Id to the dashboard prompt allowing you to query for detailed data within each analysis. This should provide good means when users complain about performance.

Obtain OBIEE Performance Monitoring
As already mentioned we provide all relevant configuration files completely for free. Just contact us or send an e-mail to info@ga-itbs.de. Please provide your company contact data. We don't use the data for marketing purposes. We just want to know who is using our OBIEE performance monitoring solution.

Please add us to your network: TwitterLinkedInFacebookGoogle+
We will share additional information, updates, etc. via our social sites.

We allow you to use and modify our solution fully or partially. You can provide it for free to your clients. In any case you agree to our terms of use as follows and you will integrate terms and conditions into each of your OBIEE monitoring analysis based on ideas or code from our solution (just copy it from the Static Text view of one of our reports):

© OBIEE performance monitoring v1.1 by G.A. itbs GmbH - OBIEE expert training and consulting. Terms of use: Free of charge if this declaration, copyright and links above are not removed. Reselling prohibited. We disclaim all implied warranties with regard to this monitoring model or any analyses based on this subject area. You agree to indemnify, defend and hold us harmless from any liability, loss, claim and expense (including reasonable legal fees) related to the use of this software. You can change the implementation and/or provide it to your clients if these terms and conditions are observed and agreed by all parties involved. Furthermore terms will be integrated into each OBIEE monitoring analysis based on ideas or code from this solution. Documentation and updates are provided in our blog.

Tuesday, 12 August 2014

OBIEE Change Analysis Subject Area

Assume you created a more or less complex OBIEE analysis with a lot of views and settings. It perhaps looks like:

OBIEE Analysis

If you want to reuse the analysis and report settings in a new report, then there exists a very fast solution for changing the OBIEE subject area which keeps all the settings. Go to Advanced tab and search for subjectArea in the Oracle BI Analysis XML (usually located at the top):

To change the subject area you need to know the name of the new one, e.g. Supply Chain Process. Now just substitute as follows and press Apply XML:

subjectArea=""Delivery Process""
subjectArea=""Supply Chain Process""

As new OBIEE subject area probably doesn't contain the same fields as the old one you will see a lot of errors that fields cannot be found. Change back to Criteria tab and use Column Formula editor to change to the fields needed in the new subject area. Don't delete the fields and add new ones, because thus you would need to adapt your views again.

Be careful not to overwrite your old Oracle BI analysis. Press Save as first ;-)
Interested in some more end user topics? Check out Oracle BI useful things.

Wednesday, 6 August 2014

OBIEE 11g Overview Class (Schedule)

Oracle University released a new overview class for Oracle BI (OBIEE).
Booking via +49 (0) 8709 / 915 202 or training@ga-itbs.de

Course: Oracle BI 11g: Overview
Duration: 1 day 
Location: online (Live Virtual Class)

Date 18-Aug-2014

G.A. itbs GmbH is official Oracle University partner and reseller.
Learn Oracle from Oracle and get top service and the best price!

Monday, 4 August 2014

Oracle BI Summary

We sometimes provide summaries on our blog articles separated into the areas OBIEE user interface and Oracle BI server technology and project success. Today's turn is for the second area.

LinkedIn users discussed our OBIEE project success stories and told us, why they use Oracle BI:
 And of course, Oracle released some updates for Oracle BI technology:
Our managing director Gerd is presenting at DOAG 2014 (the German Oracle User Group conference). The talk will be in German, but he would be very pleased about talking to you personally in Nuremberg.