Adding New Facts and Dimensions to the BI Apps Data Warehouse I've been working with Informatica 8.1.1, the Oracle BI Applications and the DAC (Data Warehouse Administration) for a while now, and over this time I've tried to post a few techniques [https://www.rittmanmead.com/blog/2008/07/11/amending-existing-category-1-sde-
What's new in Oracle Warehouse Builder 10.2.0.4 Last week I mentioned that the Oracle Warehouse Builder 10.2.0.4 patchset was out for Linux and Windows; but what I did not mention what was in it! So to make amends here are a few of the highlights. Firstly, this is not just a bug-fix release,
OWB 10.2.0.4 is out I noticed on Greg Partenach's blog [http://cali97.blogspot.com/2008/07/owb-patching.html] that the 10.2.0.4 patchset had been released. Taking a quick look on Metalink I see that patch 7005587 is out for Linux and Windows - no doubt the other platforms will
Oracle 11g Data Warehousing Seminar - Denmark I'm running a (currently) one-off Oracle 11g data warehousing seminar [http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D48573_1046448&p_org_id=36&lang=DK&source_call=] for Oracle University on the 17th and 18th September in Copenhagen,
Technical 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
Technical 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
Amending Existing Category 1 SDE and SIL Mappings In Oracle BI Apps 7.9.5 In today's posting on the Oracle BI Applications, we're going to add a new attribute to an existing dimension table in the Oracle Business Analytics data warehouse. If you're new to this, this is part of a series of postings on the Oracle BI
Technical 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,
Simple Customization of the Oracle BI Applications Data Warehouse In today's posting on the Oracle BI Applications, we're going to take a look at adding custom data into the BI Apps data warehouse. In my experience there are a number of common scenarios where new data needs to be added to the BI Apps data
So What's In the Oracle BI Apps Data Warehouse? So before we start thinking about how we're going to extend and customize the Oracle BI Applications data warehouse (technically called the "Oracle Business Analytics Warehouse") it's probably worth having a think about what's in the warehouse in the first place. Now
Technical 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
OBIEE, Discoverer, Oracle OLAP and Essbase Users: Complete the BI Survey 8 It's that time of year again when the next BI Survey [http://www.bi-survey.com/] starts collecting responses from BI users around the world. Now at the eight edition, the BI Survey is an independent survey and analysis of hundreds of BI tools users around the world.
Getting Started With Informatica PowerCenter 8.1.1 In the previous postings in my Oracle BI Apps series, I've looked at the BI Apps architecture [https://www.rittmanmead.com/blog/2008/06/22/an-introduction-to-the-oracle-bi-applications/], installation and configuration [https://www.rittmanmead.com/blog/2008/07/03/installing-and-configuring-oracle-bi-
Five Years of the Blog I just noticed today that it's more or less five years to the day since I started writing this blog. It's been an interesting five years both personally and professionally for me; I gave my first conference presentation more or less five years ago, soon after
Performing Initial Data Loads into the Oracle BI Apps 7.9.5 Data Warehouse In a couple of recent articles, (here [https://www.rittmanmead.com/blog/2008/06/22/an-introduction-to-the-oracle-bi-applications/], here [https://www.rittmanmead.com/blog/2008/07/03/installing-and-configuring-oracle-bi-applications-fusion-edition-795/] ) I've given an overview of the Oracle BI
Rittman Mead are Recruiting for a Senior Consultant The past year has been a very exciting and busy one for Rittman Mead with new projects starting in the UK, Europe, Canada and the United States. We're now in a position where we're looking to add another consultant to our team, someone who shares our
Installing and Configuring Oracle BI Applications Fusion Edition (7.9.5) Up until recently, our office installation of the Oracle BI Applications [https://www.rittmanmead.com/blog/2008/06/22/an-introduction-to-the-oracle-bi-applications/] has been based around the 7.9.4 release, and as 7.9.5 is now out and comes with support for Peoplesoft HR
An Introduction to the Oracle BI Applications Whilst OBIEE is in itself a pretty well featured business intelligence platform, it's still only a platform and you have to design and build the data warehouse, metadata repository yourself before you can do any reporting. An alternative to this "do it yourself" approach that Oracle
Technical 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 Days 3 and 4 It's just around 10pm on the Wednesday night now, and I'm back from the main conference party at the ODTUG Kaleidoscope 2008 conference in New Orleans. My hotel room faces on to the Mississippi and looking out of the window, you can see some of the
ODTUG Kaleidoscope 2008 Day 2 I'm now back in my hotel room after having taken part in the Oracle BI, DW & Essbase experts panel, I've got three quarters of an hour spare until the ACE Directors Fusion Middleware Product Briefing that's going on for the rest of the
Technical 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
Traveling from Halifax to New Orleans I'm just getting my things together at the moment before I leave for the airport, as it's Saturday morning and the ODTUG Conference starts tomorrow in New Orleans. I've actually been in Halifax, Canada for the past week so this will be my second
Technical 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
An Interview with Jean-Pierre Dijcks, OWB Product Manager The other week I posted an interview on the blog with Phil Bates , the man behind the architecture of Oracle Business Intelligence Enterprise Edition. As the interview with Phil worked out so well, I thought I'd follow this up with an interview with Jean-Pierre Dijcks, one of
