Rittman Mead Blog - Oracle BI Suite EE

Exalytics - TimesTen and OBIEE connectivity

Two of the key components in Exalytics are OBIEE and the TimesTen in-memory database. Configuring them to work together, particularly in non-standard configurations, can be fiddly, so here is a guide on how to make sure you get it right. The aim To recap, the aim of this configuration is

Technical

OBIEE 11.1.1.6.2 BP1 - Logical SQL Diagnostic view

New in 11.1.1.6.2 BP1 is the Logical SQL Diagnostic view for a report. There's nothing in the release notes about it, nor the documentation, so it's possible that it's a debug option that ought to have been disabled by the

Technical

Applying patches to OBIEE : 11.1.1.6.2 BP1

The recent release of OBIEE 11.1.1.6.2 BP1 [https://www.rittmanmead.com/blog/2012/07/obiee-11-1-1-6-2-bp1-new-features-oracle-bi-mobile-hd-and-patching-upgrade-considerations/] weighs in with a hefty eight individual patches to apply. They use the standard Oracle opatch mechanism. Here we see how to apply the patches, and note any "gotchas"

Technical

Downloading OBIEE patches from Oracle with wget

Last week saw the release of OBI 11.1.1.6.2 BP1 [https://www.rittmanmead.com/blog/2012/07/obiee-11-1-1-6-2-bp1-new-features-oracle-bi-mobile-hd-and-patching-upgrade-considerations/] , and with it, some eight patches to download (seven OBIEE, plus one JDeveloper). A very useful option when downloading the patches, particularly if you are working on Linux servers

Technical

Running the RCU from the commandline

OBIEE uses the Repository Creation Utility, or RCU, to create a set of schemas that are required and hold internal metadata such as Usage Tracking and Scheduler tables. When you run RCU, you are given a GUI interface to specify the database connection details, schema prefixes, and so on. It

Technical

Using OBIEE against Transactional Schemas Part 1: Introduction

What’s the pervasive myth surrounding the Oracle Business Intelligence Enterprise Edition (OBIEE) product suite? OBIEE is only useful for reporting against star schemas. It’s true that the Business Model and Mapping (BMM) layer in OBIEE always presents a dimensional model, or star schema, to report developers, but our

Technical

So What Do I Get With Exalytics That I Couldn't Build Myself?

One of the hottest topics at the recent Brighton and Atlanta BI Forum events [https://www.rittmanmead.com/blog/2012/05/biforum2012downloads/] was Oracle Exalytics, with attendees rightly sceptical about what Exalytics provided that you couldn't build yourself, or indeed whether there was an benefit beyond the highly-specced

Technical

Create Your Own Custom OBIEE 11g On-Site Course!

Rittman Mead offer on-site and public Oracle BI, DW and EPM training courses [http://www.rittmanmead.com/training], and historically our most popular on-site training course has been our TRN202 OBIEE 11g Bootcamp [http://www.rittmanmead.com/training/listing-of-courses/trn202-oracle-bi-ee-11g-bootcamp/] . We've delivered this course to dozens of customers

Technical

OBIEE Administration Tool - Import Metadata shows no schemas

Importing Metadata with the Administration Tool The client-only install of the OBIEE 11g Administration Tool is installed with a set of OCI libraries. This means that it can support basic Oracle Database interaction, without the need for a full Oracle Client installation on the machine. For example, you can update

Technical

OBIEE performance tuning myth : BI Server logging

One of the frequent recommendations around performance in OBIEE that one hears is a blanket insistence on disabling the BI Server log. It is a line that is repeated by Oracle support, propogated in "Best Practice" guides, and repeated throughout blog posts on the subject. Antony Heljula did

Technical

Public training schedule for 2012-H2 announced

Rittman Mead offer training courses at centres in Brighton UK, Atlanta GA, Bengaluru India, and Melbourne Australia. These courses are our standard, "bootcamp" courses, five days in length, and is typically taught by consultants such as Mark Rittman, Robin Moffatt, Stewart Bryson, Ashley Beauman and Venkatakrishnan J. If

Business Insights

Exalytics Test Drive - April 18th 2012 in London

Some people may have seen that Rittman Mead became the first partner in the UK to buy an Exalytics box in the Oracle newsletter [https://blogs.oracle.com/emeapartnerbiepm/entry/rittman_mead_first_uk_partner], and as a result we can uniquely offer our customers and community the chance to

Rittman Mead Life

New Wednesday Seminar Series from Robin and Mark

Robin Moffatt mentioned the other day that we've launched a number of new training initiatives [https://www.rittmanmead.com/blog/2012/03/new-training-courses-and-seminars-from-rittman-mead/], including a series of seminars, running on Wednesday afternoons [http://www.rittmanmead.com/training/webinar-series-2012/] and presented either by myself or Robin, aimed at OBIEE

Business Insights

Rittman Mead BI Forum 2012, Brighton & Atlanta : Registration Now Open!

I'm very pleased to announce that registration for the Rittman Mead BI Forum 2012, running in Brighton and Atlanta in May 2012, is now open, with details of the event and how to register on this page [http://www.rittmanmead.com/biforum2012]. [http://www.rittmanmead.com/biforum2012] This

Oracle BI Suite EE

OBIEE 11.1.1.6 : New Dashboard, Analysis and Reporting Features

So apart from support for a new type of repository storage [http://www.rittmanmead.com/blog/2012/02/obiee-11-1-1-6-mds-xml-repositories-and-integration-with-source-control/] , and enablement of the Oracle Exalytics In-Memory Machine [http://www.rittmanmead.com/category/oracle-exalytics/], OBIEE 11.1.1.6 brought in a number of new features that could be of benefit

Business Insights

Oracle Exalytics : An Example Optimization Exercise

It's Saturday afternoon, and I'm writing this whilst on a plane going over to Dallas, Texas, traveling to what will be my first Hotsos Symposium [http://www.hotsos.com/sym12.html]. For anyone mainly working in the BI world who's not heard of the

Oracle BI Suite EE

Oracle Exalytics Week : How Does it Perform, and How Can I Test It?

This week we've been looking in-depth at the new Oracle Exalytics In-Memory Machine, the new Exa-appliance from Oracle aimed at the BI tier in an Oracle BI/DW system. We've looked at what problem Exalytics looks to solve, how it's architected and how TimesTen

Oracle BI Suite EE

Oracle Exalytics Week : The Summary Advisor

This week we've been taking an in-depth look at Oracle Exalytics In-Memory Machine, the new engineered system from Oracle that combines Sun hardware with customized versions of Oracle Business Intelligence, Oracle Essbase and Oracle TimesTen, all running on 64-bit Oracle Linux. Here's a quick recap of

Oracle BI Suite EE

Oracle Exalytics Week : Exalytics & TimesTen - Under the Covers

So in the first two postings in our Exalytics week series, we looked at why Oracle created Exalytics, and what Exalytics actually comprises of. If you missed the first two postings in the series, here's the week's agenda including links that I'll complete once

Oracle BI Suite EE

Oracle Exalytics Week : Introducing Oracle Exalytics In-Memory Machine

In the first post in this Oracle Exalytics week series, we looked BI in general and how users wanted fast, consistent response times from their dashboards and reports. The are several potential solutions for improving query performance including adding materialized views and indexes, using MOLAP technologies such as Oracle Essbase

Oracle BI Suite EE

Oracle Exalytics Week : The Case for Exalytics

OBIEE 11.1.1.6 was released last week [https://www.rittmanmead.com/blog/2012/02/obiee-11-1-1-6-now-available-for-download-release-highlights/] , and what with all the news on the new features, and support for version control in the BI Administration Tool [https://www.rittmanmead.com/blog/2012/02/obiee-11-1-1-6-mds-xml-repositories-and-integration-with-source-control/] , the thing that most excited

Business Insights

Agile Data Warehousing with Exadata and OBIEE: ETL Iteration

This is the fourth entry in my series on Agile Data Warehousing with Exadata and OBIEE. To see all the previous posts, check theintroductory posting [https://www.rittmanmead.com/blog/2011/12/agile-data-warehousing-with-exadata-and-obiee-introduction/] which I have updated with all the entries in the series. In the last post, I describe

Oracle BI Suite EE

Hyperion Profitability & Cost Management - Overview

Recently i have been doing lot more work on the Oracle EPM stack than on the Oracle BI stack. So, i will be writing more on the various Oracle EPM products like HFM, Planning, FDQM etc in the forthcoming weeks. To sort of kick start the series of postings, i

Business Insights

Configuring OBI 11g to use port 80

Introduction By default, OBI 11g will listen for connections on port 7001 or port 9704 depending on your installation type. There are several reasons you may want to change this, and one of them would be to make it use port 80, the default http port. If you use port

Business Insights

Agile Data Warehousing with Exadata and OBIEE: Model-Driven Iteration

After laying the groundwork with anintroduction [https://www.rittmanmead.com/blog/2011/12/agile-data-warehousing-with-exadata-and-obiee-introduction/] , and following up with a high-level description of the requiredpuzzle pieces [https://www.rittmanmead.com/blog/2011/12/agile-exadata-obiee-puzzle-pieces/], it's time to get down to business and describe how Extreme BI works. At Rittman