Rittman Mead Blog - Oracle BI Suite EE

Create a Mobile BI App for iOS, Android or BlackBerry within 5 Days!

A few weeks ago I posted an article on the blog about the new Oracle BI Mobile App Designer [http://www.rittmanmead.com/blog/2013/08/a-first-look-at-the-obiee11g-mobile-app-designer/] , an HTML5-based mobile app builder for OBIEE 11.1.1.7.1. BI Mobile App Designer differs from Oracle BI Mobile HD in

Oracle BI Suite EE

OBIEE as a Data Source for Qlikview, and the New "Direct Discovery" Feature: Part 2

In my last post [https://www.rittmanmead.com/blog/2013/09/obiee-qlikview-dd1/] I explored how to use Qlikview, an in-memory query tool similar in concept to Endeca Information Discovery, to connect to OBIEE's BI Repository and use it as a data source. The conclusion was that a Qlikview

Oracle BI Suite EE

OBIEE as a Data Source for Qlikview, and the New "Direct Discovery" Feature: Part 1

A recent release of Qlikview [www.qlikview.com] added a new feature called "Direct Discovery" [http://bi-review.blogspot.co.uk/2013/04/first-look-at-qlikview-direct-discovery.html] , that allows Qlikview reports to directly access a database datasource on-demand . Qlikview, by default, loads all required data up-front into its own in-memory column-store

Oracle BI Suite EE

Using DAC11g to Replicate BI Apps DW Tables into TimesTen

A couple of months ago Peter Scott and I wrote a series [https://www.rittmanmead.com/blog/2013/06/using-oracle-timesten-with-oracle-bi-applications-part-1/] of [https://www.rittmanmead.com/blog/2013/06/using-oracle-timesten-with-oracle-bi-applications-part-2/] posts [https://www.rittmanmead.com/blog/2013/07/using-oracle-timesten-with-oracle-bi-applications-part-3/] on using Exalytics with the Oracle BI Apps, with the idea begin

Oracle BI Suite EE

New Feature in OEM Cloud Control 12cR3 - Exalytics Server Management

A few months ago a wrote a series [https://www.rittmanmead.com/blog/2013/04/obiee-oem12cr2-and-the-bi-management-pack-part-1-introduction-to-oem12cr2/] of [https://www.rittmanmead.com/blog/2013/04/obiee-oem12cr2-and-the-bi-management-pack-part-2-installation-and-configuration/] posts [https://www.rittmanmead.com/blog/2013/04/obiee-oem12cr2-and-the-bi-management-pack-part-3-but-what-does-it-do/] about the new 12cR2 release of Oracle Enterprise Manager Cloud Control, which re-instated the BI

Oracle BI Suite EE

Using Non-Oracle, and Cloud-Hosted Databases with OBIEE 11g

The vast majority of our customers use Oracle Database [http://www.oracle.com/us/products/database/overview/index.html] as the underlying data source for OBIEE 11g, sometimes on Exadata but almost always the Enterprise Edition [http://www.oracle.com/us/products/database/enterprise-edition/overview/index.html] of the database.

Oracle BI Suite EE

Three Ways to Improve Efficiency With Better Documentation

I was at a client site recently, and as part of a front-end development effort we had added some documentation within the web catalog. They had never seen anything like it and started referring to it as “smart” documentation. Quite frankly, I was more than a bit taken aback by

Oracle BI Suite EE

OBIEE 11.1.1.7 + Essbase : Essbase Filters within Fusion Middleware 11g Security

Data and metadata filters are used with Essbase to limit access to data in a cube. When you use data filters to restrict access to a certain set of dimension members in the cube, the end-user can see that the member exists, but can't see any data associated

Oracle BI Suite EE

Conclusions on Storing Detail-Level Data in Oracle Exalytics

Last week I wrote a blog post on the topic of storing lots of detail-level data in Oracle Exalytics [http://www.rittmanmead.com/blog/2013/07/storing-detail-level-data-in-oracle-exalytics/] , not the primary use-case for the product but something we're increasingly asked about. Most implementations of Exalytics use OBIEE's

Oracle BI Suite EE

Optimizing TimesTen for Exalytics Queries using TimesTen's Index Advisor

Late last week I posted an article on our blog on loading detail-level data into Exalytics [http://www.rittmanmead.com/blog/2013/07/storing-detail-level-data-in-oracle-exalytics/] ; whilst the article was intended really as an introduction to Essbase Aggregate Storage Option, and how it could offer an alternative to TimesTen when storing large

Oracle BI Suite EE

Storing Detail-Level Data in Oracle Exalytics

Although the primary use-case for TimesTen within Oracle Exalytics is to store relatively-small aggregate tables created using the Summary Advisor [http://www.oracle.com/technetwork/issue-archive/2012/12-may/o32bi-1578015.html] , many customers have asked us whether it's possible to store their entire reporting dataset in TimesTen. With 1TB

Oracle BI Suite EE

Rittman Mead BI Masterclass Tour: India, October 2013- Register Now!

I'm very pleased to announce a one-off Rittman Mead BI Masterclass Tour [http://www.rittmanmead.com/indiabimasterclass2013/] that we're organising, in partnership with ODTUG, to take place in India in October 2013. Along with the US and UK, India has the largest amount of readers of

Oracle BI Suite EE

Exalytics X3-4 Now Available, 2TB RAM + SSD and Supports OBIEE 11.1.1.7

It's been on the Oracle Tech Price list for a while now, but Oracle Exalytics In-Memory Machine X3-4 was officially launched this week, with headline new features of 2TB of RAM (up from 1TB in the earlier, X2-4 version), and 2.4TB of SSD flash disk. This new

Oracle BI Suite EE

The Rittman Mead scripts github repository

Here at RittmanMead we’re big fans of working smarter, not harder. One of the ways we do this is not re-inventing the wheel. There’s only so many ways that products such as OBI and ODI can be implemented, and we’ve probably seen most of them. The corollary

Oracle BI Suite EE

MDS XML versus MUDE Part 4: Simple Multi-Branch Development

After getting our MDS XML repository ready for development in the last post [https://www.rittmanmead.com/blog/2013/07/mds-xml3/], I am ready to demonstrate what multi-user development without MUDE would look like using Git as our version control system (VCS). Let me apologize for the slightly different username

Oracle BI Suite EE

Accelerating Hadoop/Hive OBIEE Queries Using Exalytics and the Summary Advisor

A few weeks ago I blogged about the new Hadoop/Hive support in OBIEE 11.1.1.7 [https://www.rittmanmead.com/blog/2013/04/obiee-odi-and-hadoop-part-2-connecting-obiee-11-1-1-7-to-hadoop-data-sources/] , and how it enables users to query "big data" sources with no need to know Hadoop or MapReduce. As this feature is

Oracle BI Suite EE

Patch OBIEE the quicker way - with OPatch napply

Since 2012, Oracle's patching strategy for OBIEE has been Bundle Patches released approximately once a month. These bundle patches are usually cumulative ones, applied on top of the .0 version of the product. Patching is done through Oracle’s standard OPatch tool, which manages the application of patches

Oracle BI Suite EE

MDS XML versus MUDE Part 3: Configuring MDS XML with Git

In the previous installment of this series [https://www.rittmanmead.com/blog/2013/06/mds-xml2/], I gave an overview of MUDE (multi-user development environment), and described it's strengths and weaknesses, hopefully presenting a fair assessment on both sides. For a recap, here are three properties that I think

Oracle BI Suite EE

Embedding a D3 Visualisation in OBIEE

In this blog entry, my first since joining the company as a consultant a little over a month ago, I will be taking you through the process of embedding a D3 visualisation into OBIEE. In my first few weeks in this new role I've had the pleasure or

Oracle BI Suite EE

Using OBIEE SampleApp 305 in VM Fusion

Oracle distribute the new OBIEE SampleApp [http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html] as a VirtualBox image, but it is dead easy to run it on VM Fusion instead. Here’s how: 1. Unzip the SampleApp archive files [http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html] , and

Oracle BI Suite EE

New With OBIEE 11.1.1.7 and SampleApp v305 - Essbase Cube Spin-Off

Now that the new v305 OBIEE SampleApp that we previewed in May [http://www.rittmanmead.com/blog/2013/04/previewing-the-new-obiee-11-1-1-7-sampleapp/] is out, I thought it'd be a good time to take a look at an experimental feature added into OBIEE 11.1.1.7's logical SQL

Oracle BI Suite EE

MDS XML versus MUDE Part 2: What is MUDE?

Mark Rittman once joked during a presentation on OBIEE and SCM that "MUDE" (multiuser development environment) was the closest thing to a dirty word in the OBIEE documentation. I know many people who feel that way... some justified, some perhaps not, as MUDE has certainly gotten better in

Oracle BI Suite EE

MDS XML versus MUDE Part1: Introduction

The links below represent all the entries in this series: MDS XML versus MUDE Part 2: What is MUDE? [https://www.rittmanmead.com/blog/2013/06/mds-xml2/] MDS XML versus MUDE Part 3: Configuring MDS XML with Git [https://www.rittmanmead.com/blog/2013/07/mds-xml3/] MDS XML versus MUDE

Oracle BI Suite EE

Photos and Presentation Downloads from the Rittman Mead BI Forum 2013, Brighton & Atlanta

Well, we're all back home now after two very successful Rittman Mead BI Forum events [http://www.rittmanmead.com/biforum2013] in Brighton [http://www.rittmanmead.com/blog/2013/05/previewing-the-brighton-bi-forum-2013/] , and then Atlanta [http://www.rittmanmead.com/blog/2013/05/agenda-and-details-for-the-atlanta-rm-bi-forum-2013/] , earlier this month in May 2013. Around

Oracle BI Suite EE

Testing aggregate navigation on OBIEE and Exalytics

One of OBIEE’s many great strengths is aggregate navigation; the ability to choose from a list of possible tables the one which will probably give the optimal performance for a given user query. Users are blissfully unaware of which particular table their query is being satisfied from, since aggregate