Yet more Patches for OBIEE

The Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.140114 is now available, fixing a huge list of bugs. There are plenty more bugs in the product so expect many more patches to come.

OBIEE News is out! Edition of 13th January!

Blogs from Siebel Essentials, and John Goodwin.

Videos from Oracle Analytics such as “The Bold Data Project: Big Data Fact Or Fantasy”

http://youtu.be/kx3mjXbBdk4

Blogs of the week

See our blogger database here.

1. OBIEE Version 11.1.1.7.140114 Now Released

The Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.140114 is now available to download via My Oracle Support | Patches & Updates. Follow the links for the single bundle patch (Patch 17886497) and the Dynamic Monitoring Service patch (Patch 16569379). Also available – Document entitled “OBIEE 11g 11.1.1.7.140114 Bundle Patch is Available for OBIEE and Exalytics” ([Doc ID 1614076.1])

2. Oracle BI Mobile HD 11.1.1.7.0.2365 Now Available

Features include:

Using Oracle Business Intelligence Mobile, you can view, analyze and act on all your analyses, dashboards, scorecards, reports, alerts and notifications on the go.
Oracle Business Intelligence Mobile allows you to drill down reports, apply prompts to filter your data, view interactive formats on geo-spatial visualizations, view and interact with Dashboards, KPIs and Scorecards.
You can save your analyses and Dashboards for offline viewing, and refresh them when online again; thus providing always-available access to the data you need.
This app is compatible with Oracle Business Intelligence 11g, version 11.1.1.6.2BP1 and above.

3. OBIEE 11g User Interface (UI) Performance Is Extremely Slow With Internet Explorer 8

Debashis Paul blogs about struggling with OBIEE 11g (11.1.1.5) and IE 8 . He then goes on to find the solution behind ‘HTTP 304 errors’.

4. One of Bill Gates’ favorite graphs redesigned

Bryan Pierce of Perceptual Edge writes a piece regarding a graph selected by Bill Gates to be included in a recent edition of Wired Magazine that he guest edited. He explained why he included the graph as follows:”I love this graph because it shows that while the number of people dying from communicable diseases is still far too high, those numbers continue to come down. In fact, fewer kids are dying, more kids are going to school and more diseases are on their way to being eliminated. But there remains much to do to cut down the deaths in that yellow block even more dramatically. We have the solutions. But we need to keep up the support where they’re being deployed, and pressure to get them into places where they’re desperately needed.”

But how well does the graph tell this story? Read this post for his analysis.

5. Case study: How to implement object level security and data level security in OBIEE 11g – Part 1

Bojie He says, “Recently my team has implemented data level security and object level security in OBIEE 11G for a client who is selling their data to external customers. The requirement is very quintessential of any BI Project and the implementation process is trivial. Therefore, I have decided to detail the process, which I think can be very beneficial to any future security implementation.”

6. 2 Challenges of Converting Legacy Reporting Into OBIEE

This post by Andriy Yakushyn names the 2 Challenges of Converting Legacy Reporting Into OBIEE as Functionality and User Interface..

7. OBIEE 11g – How to Make Drop Down List Box default to latest data value available in the List

This post by Pravin Khadakkar answers the Customer Question “The customer would like to make drop down list box default to latest data value available in the list. There is a hidden request which points towards the transactional data availability rather than dimensional values. For e.g. there is a global filter list box defined on Date column, by default the list should shown all date values available irrespective of transactional data is available or not. So there are two different requests we are talking here, the first one to restrict list of dimensional attribute based on transactional data available and then take the latest at default.”

This blog is an attempt to show how this customer request can be fulfilled by using SQL’s within global filter definition. It is made more interesting when subject area has more than one logical fact.

8. Geospatial Analytics in OBIEE – Part II – Shapefiles and Map Builder

Ajay Sreedharan firstly goes through the 8 steps in the shapefile import process. Then we can go to the database and query the spatial table. In his next post, he will be discussing Oracle Map Viewer and how Oracle BI is finally plugged in to the equation.

9. Top 10 OBIEE Upgrade Strategies and considerations

Arun Kumar lists the top OBIEE upgrade strategies and consideration, not necessarily in any specific order, as the order of significance would depend upon individual implementation scenarios. He then goes on to say, “In addition to the above considerations, while upgrading, you might want to take advantage of new features of the target version, for example mobile platform support in 11g, like iPads i.e. iOS mobile devices. Android fans no need to be broken hearted yet, as OBIEE has plans for android support in its pipeline.”

This week on LinkedIn

Ujjal Das shared a link to a free magazine. Subscribe for free by following the instructions on the link.

Boris Dahav posted OBIEE BUNDLE PATCH 11.1.1.7.140114 AKA 11.1.1.7.4 is available

Kashinathan K shared Hierarchical Retrieval In ORACLE or Hierarchical Queries

Paul Anderson posted HowTo Videos: Using Smart View to access data in OBIEE. This links to the YouTube channel Oracle BI TechDemo – OBIEE Samples which has a series of “How to” videos showing how to use Oracle Smart View to access data in Oracle Business Intelligence Enterprise Edition (OBIEE) and display it in MS Office (Excel, Power Point). The examples are built using the Sample App v309.

Smart View with OBIEE – Managing Connections: