Rittman Mead Blog - Technical Insights

Tagged

Technical

A collection of 878 posts

Oracle 11g Partitioning

Last time I mentioned [https://www.rittmanmead.com/blog/2008/08/28/bitmap-index-examples/] that I have been helping Mark with some demonstrations of the Data Warehouse features of modern (notably 11g) Oracle databases. Having a few minutes spare I decided to take a look at partitioning. I have long been

Bitmap Index Examples

Between assignments (mostly, OBIEE and BI Applications work) and a family holiday in the Austrian Alps I have been helping Mark with some of the examples he will be demonstrating as part of his 11g Data Warehousing Seminar [https://www.rittmanmead.com/blog/2008/07/15/oracle-11g-data-warehousing-seminar-denmark/]. I must confess

Resolving Fan Traps and Circular Joins using OBIEE

If you're looking to migrate data from a Discoverer system to Oracle Business Intelligence Enterprise Edition, one of the first things you'll probably end up thinking about is how your (not necessarily star schema-based) End User Layer will translated to a (star schema mandatory) Common Enterprise

Tuning 11g Data Warehouse Schemas using the SQL Access Advisor

One of the new features in Oracle Database 11g that I've been meaning to try out for a while now is the SQL Access Advisor, part of the 11g Tuning Pack. Given that one of Oracle's key product directions is to make administering the database as

Looking for Oracle BI Applications Training For Your Team?

A new course we've recently developed is one around the Oracle BI Applications 7.9.5 [http://www.rittmanmead.com/category/biapps/]. Covering the initial setup, data load and mapping customizations and using an Oracle E-Business Suite 11.5.10 data set, we initially developed this course for

Oracle EPM 11.1 (aka Hyperion System 9.5) Now Available for Download

Edward Roske over at the Look Smarter blog [http://edelivery.oracle.com/] recently picked up on the release of the new Oracle EPM System 11.1 over at edelivery.oracle.com [http://edelivery.oracle.com]. Edward notes that this release is initially Windows only and includes improvements to Essbase an

Advert - Short-term consultancy

As I mentioned before, Rittman Mead Consulting really does consulting, it's in the company name!! Although a lot of the posts on the company blog are based on our presentations, our work is not all speaking at conferences and delivering training. My colleagues and I are often working

OBIEE on the Apple iPhone

Chris Claterbos from Vlamis [http://www.vlamis.com] has picked up on the story [http://www.vlamis.com/blog.php/?p=66] that one of the first official iPhone apps is a front-end for Oracle BI Enterprise Edition. The App Store hasn't gone live over here yet, but

New OWB Product Roadmap on OTN

I'm not sure how much significance we should attach to it (in terms of it being new news), but there's an updated product roadmap document for OWB [http://www.oracle.com/technology/products/warehouse/pdf/owb_roadmap.pdf] now available on OTN. Apart from the details

Finally I managed to write a post

A time for a post Well, it has now been close to 5 months since I joined Rittman Mead Consulting. Right after I joined up, all my previous blog posts were migrated to the RMC blog. The ensuing blog silence on my behalf did cause some people to wonder and

ODTUG Kaleidoscope 2008 Day 1

I'm over in New Orleans at the moment for ODTUG Kaleidoscope, this is the first day of the conference with a series of full-day symposiums on ApEx, Fusion Middleware and Essbase development. The main conference sessions then start tomorrow with myself and Borkur presenting later in the week.

Competing on Analytics using OBIEE

On Tuesday I presented a paper entitled Competing on Analytics using OBIEE at the UKOUG BIRT SIG in London. The idea behind the paper was to explore how companies use Business Intelligence, Data Warehousing and Analytics, how they can extend their use in an organisation and hence gain competitive advantage

Teaching data warehousing

One of my first tasks on joining Rittman Mead Consulting was to develop a new three-day course on data warehouse design. A few weeks ago I had the opportunity to 'road test' some of the course content in a different presentation format; a tutorial-style workshop. Although I had

UK Higher Education Seminar : Wed 25th June, 2008, Reading

If you're in the UK Higher Education Sector and are users of Oracle's business intelligence software, one of the technologies you're probably spending a lot of time looking at is the new Oracle Business Intelligence Enterprise Edition suite of products. We're particularly

People vs Tools and Techniques

One of the things I am doing at the moment is reviewing our delivery methodology, looking at how different techniques and can be used with the current stack of Oracle BI tools to effectively deliver projects. This involves looking the tools currently on offer, such as OBI EE or Warehouse

Essbase and OBIEE Article Now Up On OTN

My new article on Essbase and Oracle BI EE [http://www.oracle.com/technology/pub/articles/rittman-essbase.html] has just gone up on OTN. It covers the steps you'd need to go through to build a simple Essbase database based on the SH Sample Schema that comes with

Rapid development using OBI EE (and what about the Data Warehouse?)

We are often told that one of the benefit of OBI EE is the speed and ease of development. Data sources can easily be added into the system, users can then quickly build queries and the results are easy to distribute. While I completely support this, to me this leaves

Advert: OBIEE Developer Training

I've just updated our training page with details of our Oracle BI Suite Enterprise Edition developer course [http://www.rittmanmead.com/training/listing-of-courses/oracle-bi-suite-enterprise-edition-design-build-and-dashboards-5-days/] . This course is aimed at organizations who have recently bought OBIEE and are looking to train their development team up on creating the metadata

Web 2.0 Round Table with Charles Phillips, London

I mentioned the other week that I got an invite to a roundtable session with Oracle's President, Charles Phillips, at the Lanesborough Hotel in London. The session itself was last Friday and so I thought I'd go along, there were I think around eight bloggers, analysts

Dates and times comment

A few days ago, Farooq posted some comments on an old post of mine [https://www.rittmanmead.com/blog/2007/06/21/status-changes-over-time/]. The final comment in our exchange concerned storing activities in our data warehouse by time (actual hour and minute). This is quite a common requirement, especially where

Working with OBIEE in Birmingham, and plans for the BI Apps

I've just arrived in Birmingham to be ready for a week of OBIEE data modeling for one of our clients up here. They have built an application that now needs some reports added, they've gone for OBIEE and my job is to create the logical model,

Cube Organized Materialized Views

Yesterday, Mark mentioned [https://www.rittmanmead.com/blog/2008/03/25/new-white-paper-on-cube-organized-materialized-views/] a new Oracle white paper on Cube Organized Materialized Views - now that is a bit of a mouthful and shouts out to be made COMV or something equally short and saving of typing. I say that because

News on the Book

A year or so ago I mentioned that I'd started work on a book [https://www.rittmanmead.com/blog/2006/12/06/announcing-oracle-press-oracle-business-intelligence-suite-developers-guide/] for Oracle Press entitled "Oracle Business Intelligence Suite Developers Guide" with a projected release date of the first part of this year. Whilst

New White Paper on Cube Organized Materialized Views

I noticed on the Oracle OLAP blog [http://www.oracle.com/technology/products/bi/db/11g/pdf/comparision_aw_mv_11g_twp.pdf] the other day that a new white paper on Cube Organized Materialized Views [http://www.oracle.com/technology/products/bi/db/11g/pdf/comparision_aw_mv_11g_

Migrating OBIEE Logical Models to use a Data Warehouse : Part 3

In the final part of my series on migrating an OBIEE installation from direct application access to a data warehouse, I'm finally going to plug my new data warehouse into my OBIEE logical model. Previous to this, in the first posting I created a single logical model over