Technical Wrapping up Collaborate 10 It's been a fun week in good old Las Vegas. Though in the end I broke even at the tables, I enjoyed holding a large amount of the Mandalay Bay's money for them for two or three days, just to give it all back to them
Technical EPM 11.1.2 - Getting Started and Installation I have finally managed to download & install the necessary binaries for the EPM 11.1.2 Essbase installation. When i started the download, i was actually wary of downloading the 64 bit Essbase since 11.1.2 is a significant rewrite when compared with the previous 11.1.1.
Technical Oracle EPM 11.1.2 – Finally released and available on E-Delivery After checking non-stop for the last couple of weeks, finally managed to start the download of EPM 11.1.2. Yes, its officially released for download now and is available in E-Delivery [http://edelivery.oracle.com]. Some of the significant new features in this release are 1. Oracle Financial Close
Technical Oracle BI EE 10.1.3.4.1 – Number of Members in a Level & Aggregate Navigation One of the less known/less used capabilities of BI EE is the ability to switch between Aggregate tables based on the number of members in a level. For example, lets consider the screenshot shown below In most cases, we will not have the necessity to alter the number shown
Technical Collaborate 10 - The Early Days One of the things I had expected to do this week was to write about some of my BI and DW highlights from Collaborate 10. However, that is not to be. I am currently sitting at home in the UK, a victim of a cloud of volcanic ash that has
Technical Oracle EPM 11.1.1.3 & Oracle OLAP 11g – Reporting on Oracle OLAP using Essbase Excel Add-in/Smartview - XOLAP This is the week of Colloborate 2010 [http://www.collaborate10.org/] conference. Mark, myself, Pete and Stewart were scheduled to present this year but due to the European Airspace closure, myself and Pete haven’t been able to actually travel this year. Its a real shame as we all really
OWB11gR2 for Windows Now Available The 11gR2 release of Warehouse Builder [http://www.oracle.com/technology/software/products/warehouse/index.html] came out for Windows towards the end of last week, firstly as part of the wider Oracle Database 11gR2 download, and then in the standalone version. Now that there's a Windows client
Technical Exadata in Retail Presentation I recently gave a presentation at the Oracle Extreme Performance Data Warehousing Seminar [http://www.oracle.com/webapps/events/EventsDetail.jsp?p_eventId=103412&src=6802174&src=6802174&Act=115] about a project we have been working on with a client. The client is in the retail
Technical Realtime Data Warehouses In a little over two weeks I will be giving my Real Time Data Warehousing talk at Collaborate [http://collaborate10.ioug.org/Education/BIWATrainingDays/tabid/83/Default.aspx] 10 in Las Vegas. I will cover a variety of techniques and not just change data capture. However, in my opinion, CDC
Technical Hyperion Financial Reporting (HFR) 11.1.1.3 – Reporting on Relational Sources – XOLAP Hyperion Financial Reporting (HFR) is one of the simplest and very robust reporting tools that is currently part of the Oracle BI EE Plus bundle. It has excellent multi-dimensional reporting capabilities and scales very well unlike Web Analysis. Part of the reason for this is, there is not much metadata
Previewing the Oracle BI Publisher Online Layout Builder Jorge Anicam's blog post the other day [http://oraclebiblog.blogspot.com/2010/03/bi-publisher-layout-builder-preview-in.html] reminded me about the online layout builder preview that's been available in the past couple of releases of Oracle Business Intelligence Publisher 10g. As a quick recap, BI Publisher up until
Technical Oracle Warehouse Builder 11gR2 - Using Code Templates - Loading Metadata from Essbase to Relational Tables - Part 2 In the first part of this series here [https://www.rittmanmead.com/blog/2010/03/17/oracle-warehouse-builder-11gr2-importing-essbase-cubes-using-odi-knowledge-modules-part-1/] , i had shown how to go about using the ODI RKM's from within Warehouse Builder to reverse engineer Essbase metadata. Though i did promise to come back sooner on the rest
Business Insights An Update on the BI Forum, OBIEE EMG and US Conferences It's been particularly hectic over the past few weeks, with several new projects kicking off, training being delivered around Europe and a couple of trips over to the States, but I'm back in the UK now gradually catching up with blog posts and articles. As it&
Technical Transcend and Segment-Switching As you read this most recent post on the capabilities of Transcend, I'd like to pose a question to you: would you consider using Transcend in your environment if it was open-sourced? Currently, we implement Transcend as part of the Rittman Mead Rapid Deployment Framework for our clients,
Technical Configuring ODI 10.1.3.6 to use Oracle Golden Gate for Changed Data Capture If you've an interest in Oracle data warehousing and ETL, you'll probably have noticed the recent announcements around the Oracle acquisition of Golden Gate [http://www.oracle.com/goldengate/index.html]. Golden Gate were a company that produced a cross-platform data replication and changed data capture
Technical Oracle Warehouse Builder 11gR2 – Importing Essbase Cubes using ODI Knowledge Modules – Part 1 One of the new features introduced in OWB 11gR2 is the ability to import metadata objects through JDBC drivers. So, as long as we have an external API providing the JDBC interface to OWB, OWB should be able to leverage that and import the metadata through the API. For example,
Technical Thoughts on Change Data Capture In little over a month I will be in Las Vegas speaking at Collaborate 10. There is a lot of BI / DW talks this year and for the first time with BIWA Training Days branding [http://collaborate10.ioug.org/Education/BIWATrainingDays/tabid/83/Default.aspx#view] . Rittman Mead will be
Oracle BI EE 10.1.3.4.1 – Solutions – Puzzle 4 The 4th puzzle in this series was a reasonably simple one which basically demonstrates a capability that allows end users to bypass the security applied in the BI Server layer. There are 3 possible solutions for this Solution 1: Using Evaluate EVALUATE was introduced in the 10.1.3.3.
Inside the Oracle BI Server Part 3 : BI Server In-Memory Joins In the previous two postings in this series, I looked at the architecture of the Oracle BI Server, and how it processes incoming queries from Oracle BI Answers. In the latter article I touched on the concept of BI Server in-memory joins, and in this article I want to expand
OBIEE Content at ODTUG Kaleidoscope 2010 As well as organizing our own BI Forum in the UK, another event I've had a hand in is ODTUG Kaleidoscope 2010 [http://www.odtugkaleidoscope.com/], which is due to run from June 27th - July 1st in Washington D.C. I've been the content lead
Inside the Oracle BI Server Part 2 : How Is A Query Processed? In the first article on this series about the Oracle BI Server [https://www.rittmanmead.com/blog/2010/02/25/inside-the-oracle-bi-server-part-1-the-bi-server-architecture/] , I looked at the architecture and functions within this core part of the OBIEE product set. in this article, I want to look closer at what happens when a
Oracle BI EE 10.1.3.4.1 – Puzzlers – Puzzle 4 – Bypassing Security On to the 4th puzzle in this Puzzle series. This is a very interesting Puzzle at least from the perspective of BI EE Security. We all know that BI EE provides comprehensive security within the repository. For example, the screenshot below shows that the column CHANNEL_DESC can be accessed
Oracle BI EE 10.1.3.4.1 – Solutions – Puzzle 3 After almost a week of me giving out the Puzzle 3, there was hardly any interest for this one (just couple of odd replies requesting clarification of the Puzzle). Probably this is because this one has no direct practical usage and also there are lots of possibilities. But to me
Inside the Oracle BI Server Part 1 : The BI Server Architecture The session that I'm giving at the BI Forum in Brighton in May [http://www.rittmanmead.com/biforum2010] is entitled "Inside the Oracle BI Server", and I'm aiming to take a closer look at the architecture and functionality of this key OBIEE component. We&
Technical Oracle 11g Pivot One of the things that I often come across is the "up-dateable fact", that is a fact that starts life "incomplete" and changes overtime. Examples include things such as support calls that start life as "open" then progress through "responded", "resolved&
