Less Than 10 Weeks To UKOUG Tech & EBS Conference, Birmingham, November 30th - Dec 2nd 2009 As the headline says, it's less than 10 weeks to the main UKOUG conference [http://techandebs.ukoug.org/], as ever held at the ICC in Birmingham, UK. This year the event is back to three days and focuses just on technology (including BI&DW) and Oracle E-Business
ODTUG Kaleidoscope 2010 : Call for (BI & DW) Papers ODTUG have just announced that next year's conference, ODTUG Kaleidoscope 2010 [http://www.odtugkaleidoscope.com], will be held in Washington D.C. from June 27th - July 1st 2010, and the call for papers is now open. My first ever Kaleidoscope was in Washington back in 2006, and
Technical Oracle Essbase 11.1.1.3 – Drill-through to BI EE from Smart View – Using Essbase Studio - HOLAP One of the nice little advantages of using Oracle Essbase Studio is the fact that it manages the relational drill through much better than the Essbase Integration Services. With the advent of Essbase studio, all the metadata for relational drill through is pushed back to the Studio server. So, when
Technical Code Templates in OWB11gR2 Part 3 : Hybrid Code Template Mappings If you've read my previous postings on how OWB11gR2 support access to non-Oracle databases [https://www.rittmanmead.com/blog/2009/09/21/code-templates-in-owb11gr2-part-1-introduction-and-support-for-heterogeneous-databases/] , and allows you to create mappings that use non-Oracle sources and targets [https://www.rittmanmead.com/blog/2009/09/21/code-templates-in-owb11gr2-part-2-introduction-to-code-template-mappings/] , you may we wondering
Technical Code Templates in OWB11gR2 Part 2 : Introduction to Code Template Mappings In the first posting in this series [https://www.rittmanmead.com/blog/2009/09/21/code-templates-in-owb11gr2-part-1-introduction-and-support-for-heterogeneous-databases/] on code templates in OWB11gR2, I went through the background to the feature and showed how it provided access to both Oracle, and non-Oracle sources. In this posting I'm going to look
Technical Oracle BI EE 10.1.3.4.1 – Enforcing and Non-Enforcing Outer Joins One of the flexibilities of the BI Server is its ability to fine-tune certain sql queries being fired back to the database. One such example is its ability to enforce certain outer joins when required. For example, lets consider a simple example containing the Customer dimension and the Sales fact
Technical Code Templates in OWB11gR2 Part 1 : Introduction and Support for Heterogeneous Databases One of the new features introduced with Oracle Warehouse Builder 11gR2 [https://www.rittmanmead.com/blog/2009/09/09/a-look-at-the-new-features-in-owb11gr2/] is "Code Templates". This new feature allows you to develop mappings that use the "Knowledge Module" feature of Oracle Data Integrator (referred to in OWB11gR2 as
Vote For Me For the ODTUG Board 2010/2011! Every year the ODTUG [http://www.odtug.com] board hold elections for a number of places on their board, and this year I've decided to stand for election. Over the past few years I've co-chaired the ODTUG BI&DW SIG [http://www.odtug.com/apex/
Technical OWB 11gR2 and BI EE - Creating a Business Model - Part 2 In the last blog entry here [https://www.rittmanmead.com/blog/2009/09/10/owb-11gr2-and-bi-ee-deriving-the-business-model-part-1/] , i had covered the automatic derivation of BI EE business model from OWB 11gR2. Though it works out of the box, in most cases, users will like to have more control on the business model
Updated and Expanded Training Curriculum At Rittman Mead, apart from consulting our other main line of business is training [http://www.rittmanmead.com/training]. We were one of the first organizations to offer Oracle BI EE training, and over the past few years we have helped train up a large number of internal development teams,
Oracle 11g Release 2 Analytics Mark and Venkat have already been blogging about OWB 11g Release 2, but that was not the only new release to slip past Oracle's doors in recent days; 11g Release 2 of the database is also out. I have long loved analytic functions in Oracle - they can
Technical Oracle to Announce New "OLTP"-Focused Database Machine Oracle released details over the weekend of a news conference they are running on September 15th 2009, to announce a new OLTP-focused database machine this time based on Sun hardware [http://www.oracle.com/webapps/events/EventsDetail.jsp?p_eventId=101483]. I'm surprised that this wasn't
Rittman Mead at Oracle Open World 2009 It's just a few weeks now until Oracle Open World [http://www.oracle.com/openworld] in San Francisco, and Rittman Mead will be attending both as speakers and, for the first time, with a booth in the main exhibition hall. From the UK, we have myself, Jon Mead
Oracle BI Meetup at Oracle Open World - Monday, 12th October, 7pm, Thirsty Bear UPDATE: The venue has changed [https://www.rittmanmead.com/blog/2009/10/06/oow-bi-meetup-change-of-venue/] to Johnny Foleys, in O'Farrell Street. I'm organizing an Oracle BI meetup [https://www.rittmanmead.com/blog/2009/08/02/bi-meetup-at-open-world-san-francisco/] for Oracle Open World, on Monday 12th October at 7pm at
Technical OWB 11gR2 and BI EE – Deriving the Business Model – Part 1 One of the most anticipated features(atleast for all BI EE users) of the recently released OWB 11gR2 is its ability to create a BI EE repository directly from its table/view/dimensional objects. This feature to derive BI specific objects was one of the very popular ones when a
A Look at the New Features in OWB11gR2 As well as the 11gR2 release of the Oracle Database coming out last week [https://www.rittmanmead.com/blog/2009/09/08/thoughts-on-the-new-dw-features-in-oracle-database-11gr2/] , accompanying it was the 11gR2 release of Oracle Warehouse Builder, something that the OWB community has been waiting for since the 10gR2 ("Paris") release back
Technical Oracle BI EE 10.1.3.4.1 – BI Server Query Parameters - Driving Tables and Parameterized Sub-Queries Whenever BI Server is used for creating reports containing data from multiple databases, BI Server acts like a mini-database engine. It does a lot of operations itself like joins, sorts, group bys etc, everything in its own memory space. Since it acts like a database engine, it has to have
Technical Thoughts on the New DW Features in Oracle Database 11gR2 Well it's been about a week since Oracle Database 11gR2 [http://www.oracledatabase11g.com/] became available for download on Linux, and we've since had a chance to play around with it and see what's new. The Linux release on 32 and 64-bits is available
Announcing: Rittman Mead Training Days 2009 I'm very pleased to announce details of our second-ever Training Days [http://www.rittmanmead.com/trainingdays2009] event, to be held at the Bloomsbury Hotel [http://www.doylecollection.com/locations/london_city_hotels/the_bloomsbury_hotel.aspx] in London on October 27th - 29th 2009. This year I'
Technical Oracle BI EE 10.1.3.4.1 – OLTP Reporting – Conforming Dimensions and Multi-Grain Fact measures In the last blog entry here [https://www.rittmanmead.com/blog/2009/08/21/oracle-bi-ee-10-1-3-4-1-oltp-reporting-switching-tables-based-on-chosen-dimensions-use-case-1/] , i had shown a very simple transactional reporting use case wherein i made the BI Server to switch tables based on the measures chosen. Basically switching of tables would result in hitting a specific table
Technical Oracle BI EE 10.1.3.4.1 – OLTP Reporting – Switching Tables based on chosen dimensions – Use Case 1 Though BI EE is well known for reporting on Stars, Facts and Dimensions, one of the lesser known or lesser advertised features is its extensive transactional or OLTP modeling capabilities. Steve Devine (our guest author last week) documents his experience well here [https://www.rittmanmead.com/blog/2009/08/17/
Technical Oracle EPM 11.1.1.3 – Hyperion Shared Services integration with external Applications – Java API – Part 1 - Introduction One of the major enhancements that came in the Hyperion EPM 11 release is the availability of Java APIs to access shared services from external applications. In the prior releases, SDK’s were available but those have been enhanced completely now in this release to accommodate new features. Also with
Using OBIEE for Reporting Directly Against Operational Systems [This is a guest blog from Steve Devine from Hitachi Consulting, who we've known for a while and who attended our BI Forum in Brighton last May. Steve, Adrian, Venkat and I were discussing the issue of reporting against non-star schema data models and in particular the issues
Keynotes in Denmark and The Netherlands Apart from our Training Days [http://www.rittmanmead.com/trainingdays2009] event in October, I'll also be delivering keynotes at two events later in the year in Copenhagen and Leiden, The Netherlands. The Danish IT Society Business Intelligence Conference [http://www.dansk-it.dk/arrangementer/1595.aspx] in Copenhagen, Denmark,
Technical A Quik Look at QlikView Outside the world of Oracle, one of the rising stars of the BI world has been Qliktech, the Swedish software company behind QlikView [http://www.qlikview.com/]. QlikView is one of a new breed of desktop, in-memory BI tools [http://www.olapreport.com/Comment_InMemBI.htm] (see also the forthcoming
