Rittman Mead Blog - Technical Insights

Oracle BI EE 11g - Decoding Essbase Connectivity - Part 3

Continuing along with our Essbase series, today lets look at how the various Pivoting operations that are done at the BI EE layer affect the MDX generated. We noticed that whenever we brought in an attribute column from the row-edge to the column edge, the MDX generated by BI EE

Oracle BI Suite EE

Oracle BI EE 11g - Decoding Essbase Connectivity - Part 2

In the last post we saw how BI EE generates Essbase specific MDX while using Attribute columns for a specific case. In today's post we shall look at how the new BI EE 11g specific features like Hierarchical columns and Value-Based hierarchies affect the MDX generated. For continuation

Oracle BI Suite EE

Oracle BI EE 11g - Decoding Essbase Connectivity - Part 1

If you had gone through my blog series for BI EE 10g and Essbase here [http://oraclebizint.wordpress.com/workshop-series/], i would have covered the different ways of controlling the BI EE MDX generated for Essbase Sources. With 11g, that too with the introduction of Hierarchical Columns and Value Based

Technical

UKOUG Exadata Special Event

As part of my role as BIRT SIG chair, I have been involved in organising a special Exadata event later in April. The idea is to test the water to see if there is any traction in the UK for an Exadata special interest group. We originally raised and discussed

Technical

The One Mapping Paradigm

Here at Rittman Mead we have been working on some new methodology and design patterns for ETL. We have long realised that the bottleneck in Business Intelligence and Data Warehousing projects is ETL, so we have been prototyping new techniques to approaching this and trialling them at client's

Oracle BI Suite EE

Diagnostics, Logging and the OBIEE 11g EM Log Viewer

Earlier this week I took a closer look at Enterprise Manager within OBIEE 11g [http://www.rittmanmead.com/blog/2011/03/so-how-does-enterprise-manager-work-within-obiee-11g/] , and in particular the MBeans that Enterprise Manager uses to perform its administration functions. Today I wanted to take a look at the logging that's available

Oracle BI Suite EE

So How Does Enterprise Manager work, Within OBIEE 11g?

Or, "what actually happens when you press the Activate button in Enterprise Manager?" At the end of last week, I put a posting on the blog about WebLogic Server, and what it actually does within OBIEE 11g [https://www.rittmanmead.com/blog/2011/03/so-just-what-does-weblogic-server-do-within-obiee-11g/]. In earlier releases

Oracle BI Suite EE

So Just What Does WebLogic Server Do Within OBIEE 11g?

So now I'm back from my travels, I'm working on the joint OBIEE11g masterclass that I'm running with Tony Heljula, at the RM BI Forum in May. One of the topics that I'm leading on is architecture and internals, and a section

Oracle BI Suite EE

Oracle Data Warehouse Global Leaders Webcast

I'm honored to be delivering a webcast for the Oracle Data Warehouse Global Leaders Program on Tuesday, March 22 at Noon EST. This is an elite program for key global data warehousing customers and is managed by the Oracle data warehousing product management team. It also provides a

Technical

Moving Data

I just looked at the Rittman Mead Blog archive and saw the last post that was written by me was back in August 2010! Where has the time gone? Some of the time has been spent preparing and giving conference and user group talks, (as I write this I am

Oracle BI Suite EE

Looking forward to RMOUG

I'm currently on a plane headed to Denver for the annual RMOUG Training Days conference. This is my second year speaking at RMOUG, which is the largest regional Oracle user group conference in the country (or so they tell me). RMOUG always has a strong database and DBA

Oracle BI Suite EE

Oracle BI EE 11g and Oracle ADF - Part 2 - Real Time reporting using View Objects

In the last part i showed how BI EE 11g and Oracle ADF are integrated through the same Security Framework. In this part, we shall look into another reporting innovation (by use of the common ADF Framework) i.e. real time reporting using BI EE by directly reversing metadata from

Oracle BI Suite EE

Oracle releases BI extension for Open Office

Oracle released a new BI extension for Open Office with the latest Open Office release (v. 3.3) . This extension gives us the ability to embed information from BI EE 10g into Open Office Calc, Writer and Impress documents (equivalents of Excel, Word and Powerpoint). OO Calc supports the ability

Oracle BI Suite EE

Oracle BI EE 11g & ODI 11g - BI Knowledge Modules & SELECT_PHYSICAL

As mentioned in my blog post here [https://www.rittmanmead.com/blog/2010/08/oracle-bi-ee-11g-new-bi-server-functions/], one of the new features of BI EE 11g is the ability to connect directly to the Physical Layer of the Repository using the SELECT_PHYSICAL property. This opens up quite a lot of integration

Technical

Transcend Part 2: Dimensions

In the last post [https://www.rittmanmead.com/blog/2010/12/01/transcend-part-1-mappings/], I described the concept of a "Mapping" entity in Transcend as a bundling of pre- and post-mapping processes that can be executed with a single call. The "Dimension" entity is very similar. In

Technical

Transcend Part 1: Mappings

If you read the blog regularly, then you know that Rittman Mead offers a product called Transcend that is designed to interact with the Oracle Database to make some of the heavy-lifting in ETL mappings very simple. Because we recently released version 2.5 of Transcend, I thought I'

Oracle BI Suite EE

Photos from Training Days 2010, London

Last week was the first of our OBIEE 11g Training Days 2010 [http://www.rittmanmead.com/trainingdays2010] events, held at Holborn Bars in London. Thirty OBIEE developers from around Europe joined us for three days of discussions, demos and optional labs around the new 11g release of Oracle Business Intelligence

Oracle BI Suite EE

Thoughts on BI at Oracle OpenWorld 2010

Well, I'm finally back from San Francisco and Oracle Open World [http://www.oracle.com/openworld], having spent two days at Oracle's HQ in Redwood Shores and then just over a week downtown in San Francisco at the Moscone Center. If you came to any of

Oracle BI Suite EE

Oracle BI EE 11g - Integration with EPM 11.1.2 - HFR & Action Framework

As mentioned in the blog post here [https://www.rittmanmead.com/blog/2010/09/13/oracle-bi-ee-11g-action-framework-integration-with-external-applications/] , one other significant improvement in 11g Action Framework is the ability to browse the Oracle EPM 11.1.2 catalog and then pass the parameters from BI EE to the target EPM reports. Unlike

Technical

Oracle Magazine Article on Essbase 11.1.2

[http://www.oracle.com/technetwork/oramag/2010/10-sep/o50bi-165473.html]My latest article for Oracle Magazine [http://www.oracle.com/oramag] is now available online, and this month it's a joint effort between myself and Venkat. "Using Oracle Essbase Release 11.1.2 Aggregate Storage Option Databases&

Oracle BI Suite EE

OBIEE 11gR1 Now Available for Download

You might have missed it late on Friday afternoon, but the long-awaited 11gR1 release of Oracle Business Intelligence is now available for download on OTN [https://www.rittmanmead.com/blog/2010/08/14/oracle-bi-ee-11g-released-available-for-download/]. Three years in the making, this new release of Oracle's business intelligence platform provides

Oracle BI Suite EE

Oracle BI EE 11g - Released & Available for Download

Looks like BI EE 11g silently made it to OTN yesterday. The software is available for download now. It can be downloaded from here [http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html] . Currently its available only for Windows (32 bit & 64 bit) & Linux (32 bit &

Technical

Partitioning Fact Tables, Part 1

I'm dogmatic about certain aspects of data warehousing. For instance, fact tables should be range partitioned by DATE. I tell my clients all the time: you will have a very difficult time persuading me otherwise. But they always try: they argue about all the attributes that are more

Technical

Oracle OLAP 11g - Reporting in Excel using Simba MDX OLE-DB Provider

If you had looked at my blog entry here [https://www.rittmanmead.com/blog/2010/04/19/oracle-epm-11-1-1-3-oracle-olap-11g-reporting-on-oracle-olap-using-essbase-excel-add-insmartview-xolap/] , i would have shown a way of reporting on Oracle OLAP 11g using the newly introduced Essbase XOLAP. As mentioned there, one of the biggest advantages of using Essbase is its tight

Oracle BI Suite EE

Announcing : Rittman Mead OBIEE 11g Training Days 2010

I'm very pleased to announce our third annual Rittman Mead Training Days [http://www.rittmanmead.com/trainingdays2010/] event, this time focusing on OBIEE 11g and running in London, Atlanta and Bangalore in October and November 2010. Our previous two Training Days events covered a range of Oracle BI