Oracle BI Suite EE Real-time BI: EDW with a Real-time Component I apologize for the long delay in getting this last portion of the Real-time discussion in place. Since I wrote the first two installments, we've had the BI Forum (US and UK versions), plus a flurry of activity around Rittman Mead in the US, followed up by
Business Insights OBIEE 11g Bootcamp Scheduled for August 1st - 5th in Atlanta This is just a quick note to announce that we have scheduled another OBIEE 11g Bootcamp course in Atlanta in early August. We've been working on the OBIEE 11g material since we received the first beta release, and we've run successive versions of this material through
Oracle BI Suite EE Oracle BI EE 11g - Reporting on Hyperion Financial Management (HFM) - Part 1 This has been my second longest sabbatical since i started blogging 4.5 years back. More than a month since my last post. Rather than going into the reasons of why(& sounding cliched) i thought i will kick start my postings again with one another new BI EE 11g
Oracle BI Suite EE OBIEE Calculations, MDX Functions, Flattened Measures, and Essbase Sources When you starting working with Essbase sources and OBIEE, how you create calculations quickly becomes one of the more interesting aspects of working with the two technologies. With Essbase, you've got a powerful multi-dimensional database that features many functions and calculation capabilities that you'd like
Business Insights Rittman Mead at ODTUG Kscope 2011 I'm still not used to saying "Kscope"... it sounds like a medical screening that I know I should get when I turn 40. Regardless, I'm looking forward to the event for all the usual reasons: seeing good friends, seeing all the great speakers in
Oracle BI Suite EE Incremental Essbase Metadata Imports Now Possible with OBIEE 11g If you were an early adopter of Essbase integration with OBIEE, the 10g release had a number of restrictions that made it hard to use in production. Chief amongst these was the lack of any ability to refresh the physical model of the Essbase database within the Oracle BI Repository,
Oracle BI Suite EE What Skills Does an Oracle BI Developer Need in 2011? Back in 2009, I wrote a blog post entitled "What Skills Does an Oracle BI Developer Need in 2009" [http://www.rittmanmead.com/blog/2009/03/what-skills-does-an-oracle-bi-developer-need-in-2009/] . At the time, OBIEE 11g was in the planning stage, Oracle had
Technical Rittman Mead at the UKOUG EPM Conference, July 2011 Over the past few days the UKOUG has been running it's UKOUG Conference Series: EPM & Hyperion 2011 [http://hyperion.ukoug.org/] event in Weybridge, near London, and Jon Mead and I went along yesterday to take part. Thank you to everyone who came to my session on
Technical ODI 11g New Mapping and Interface Features - Part 3 - OBIEE Lineage In the first two parts of this min-series, I looked at the new mapping and interface features with ODI 11.1.1.3 [https://www.rittmanmead.com/blog/2011/06/odi-11g-new-mapping-and-interface-features-part-1/], and yesterday I took a look at Load Plans [https:
Technical ODI 11g New Mapping and Interface Features - Part 2 - Load Plans Yesterday I posted on the blog an overview of some of the new interface (mapping) features in the original, 11.1.1.3 release of Oracle Data Integrator 11g [https://www.rittmanmead.com/blog/2011/06/odi-11g-new-mapping-and-interface-features-part-1/]. In today's posting,
Technical ODI 11g New Mapping and Interface Features - Part 1 About a year or so ago I posted an entry on this blog highlighting the new architectural features of Oracle Data Integrator 11g [http://www.rittmanmead.com/blog/2010/09/odi-11g-now-available-for-download/]. At the time, I talked about the new user interface, integration with WebLogic Server
Business Insights Data Warehouse Global Leaders Forum, Athens Mark and I have just spent the last couple of days at the DW Global Leaders Forum in Athens. The DW Global Leaders Forum is an Oracle-run customer program that connects a number of EMEA Data Warehouse clients with each other, Oracle and a small number of partners. The
Business Insights Last Two Days for the ODTUG Kscope11 $250 Discount! Just a quick note to remind any who's not yet registered, that the cu [http://odtug.wordpress.com/2011/06/07/the-time-is-now/]t-off date for registering for ODTUG KScope'11 with the $250 discount [http://odtug.wordpress.com/2011/06/07/the-time-
Business Insights OBIEE 11g for Hyperion Users - Are We There Yet? In a couple of weeks time it's the OUG Conference Series EPM & Hyperion 2011 Conference [http://hyperion.ukoug.org/default.asp] in the UK (now there's a mouthful), and along with such Hyperion luminaries and Oracle ACE Directors as Edward Roske and Eric Helmer, I&
Business Insights Rittman Mead Public Training Courses - June 2011 <title></title> <!-- 5 COLUMN CONTAINER --> <table width="600" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="20"> </td> <!-- LEFT COLUMN --> <
Oracle BI Suite EE Oracle BI EE 11.1.1.5 - Repository Command Line Switches - Importing New Projects into RPD One of the hidden features of BI Admin Tool is the ability to run certain commands from command line. I have written about some of the use cases of this here [http://oraclebizint.wordpress.com/2008/05/02/oracle-bi-ee-101332-automating-password-updates-of-connection-pools-and-users-
Business Insights Geography Hierarchies I have been thinking about address a lot recently, in part it was moving house and all of the 1001 people that need to be notified. In the main, though, it was thoughts inspired by a data warehouse project I am working on. For this DWH people are geo-located
Technical Not The Only 11.1.1.5.0 In Town Just a short posting to mention that earlier this month Oracle released version 11.1.1.5.0 of Data Integrator Look out for more Rittman Mead postings on ODI over the coming months
Oracle BI Suite EE BI Applications 7.9.6.3 - What's New? Along with BI EE 11.1.1.5, there was also a major release of BI Apps 7.9.6.3. This is a major release not because of the new features but instead this is the first release that uses BI EE 11g natively. In fact this release does
Business Insights Real-time BI: Federated OLTP/EDW Reporting The typical approach in Federated OLTP/EDW reporting environments is to use a BI tool such as OBIEE to do horizontal federation. This means combining data from multiple sources at the same grain in a single logical table. One note of clarification: my use of the word "federated"
Oracle BI Suite EE Oracle BI EE 11.1.1.5 - New JDeveloper Extensions As covered by Mark earlier [https://www.rittmanmead.com/blog/2011/05/whats-new-in-obiee-11-1-1-5-ps1/], BI EE 11.1.1.5 has some significant new features and is a definite upgrade for customers using BI EE 11.1.1.3(even for 10g customers)
Oracle BI Suite EE OBIEE 11.1.1.5 and Oracle OLAP Support One of the welcome (but strangely unheralded) new features introduced with OBIEE 11.1.1.5 is support for Oracle OLAP as a data source. Earlier releases of OBIEE supported Oracle OLAP through SQL access, either directly through SQL views or through cube-organized materialized views, and there was even
Oracle BI Suite EE Real-time BI: An Introduction Discussing real-time data warehousing is difficult because the meaning of real-time is dependent on context. A CIO of an organization that has weekly batch refresh processes might view an up-to-the-day dashboard as real-time, while another organization that already has daily refresh cycles might be
Oracle BI Suite EE Oracle BI EE 11g - Decoding Essbase Connectivity - Part 5 - Security I was actually compiling all my findings of the last 4 posts as a summary post but then realized i haven't actually covered another important part of the Essbase Connectivity i.e. Essbase Security. In today's post let's look at how Essbase Security is
Oracle BI Suite EE Oracle BI EE 11g - Decoding Essbase Connectivity - Part 4 - Logical SQL Generation In the last 3 posts we saw how BI EE generates the MDX and what major factors influence the MDX generated. As a recap, there are 4 main things that we noticed. 1. BI EE generates the most optimal MDX as long as we have all the attribute or Hierarchical
