Oracle Open World 2008, Day 1 : "The X is Coming" I was just walking back from the Thirsty Bear with Tim Hall, when we saw this teaser advert inside the Moscone Center: Presumably this is the new Database Accelerator that hit the blogs [https://www.rittmanmead.com/blog/2008/09/12/so-what-is-oracles-new-database-accelerator/] and news sites [http://www.computerworld.com/action/
Oracle Open World 2008, Day 1 : User Groups and ACE Director Briefing Today was the first day of Oracle Open World in San Francisco, with most of today's sessions being organized by the various user groups. For me, as usual on the first day over here, I was up at around 4am, so I used the time to get my
Technical Loading OBIEE Data Into Essbase Using Essbase Studio 11.1 I'm currently sitting on a British Airways flight over to San Francisco, getting my demos and presentations sorted out for tomorrow. I've got an early start in the morning with an 8.30 slot as part of the IOUG Forum, doing a session on extending and
Technical Tuning an Oracle 11g Data Warehouse Using the DBConsole Advisors I'm currently back in Denmark running the first of my Oracle 11g Data Warehousing Masterclasses [https://www.rittmanmead.com/blog/2008/07/15/oracle-11g-data-warehousing-seminar-denmark/], today was the first day and I'm currently back in the hotel working through some material for tomorrow. One of the main
Technical Oracle BI Training Days Over the past few months the team at Rittman Mead have been busy developing new course content and seeking out suitable venues for our first ever public course, the Oracle BI Training Days [https://www.rittmanmead.com/blog/oracle-bi-training-days-october-22nd-24th-london-uk/] . This course is a fantastic opportunity to learn more about designing,
Technical Testing Advanced (OLTP) Compression in Oracle 11g Another new feature in Oracle 11g of interest to data warehouse developers is Advanced Compression [http://www.oracle.com/database/advanced-compression.html]. This new feature extends the capabilities of segment compression first introduced with Oracle 9i, but crucially makes it work for all DML operations, not just direct path inserts,
Technical Investigating Oracle 11g Interval Partitioning If you've kept abreast of what's new in the latest release of the database, you will probably be aware of three major enhancements to partitioning in Oracle 11g. Firstly, there's the new reference (ref) partitioning where you can partition one table based on a
Technical So, What is "Oracle's New Database Accelerator"? I was just taking a look through the Open World session catalog when I came across what I presume is recently added session, "Oracle’s New Database Accelerator: Query Processing Revolutionized" [http://www28.cplan.com/cc208/session_details.jsp?isid=298677&ilocation_id=208-1&ilanguage=english]
Technical Cube, Rollup, Grouping Sets and Grouping IDs If you've kept up with the various new data warehousing features in Oracle over the past few years, you might have noticed extensions to the GROUP BY clause such as ROLLUP, CUBE, GROUPING SETS and so on. If like me you've glanced at these features and
Technical Live from Denmark I'm currently sitting in my hotel room in Fredericia, Denmark, as tomorrow I'm running a customized version of our OBIEE course for a new customer over here. I flew in to Copenhagen Airport late this afternoon and then got the train from the airport to where
Technical 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
OBIEE Repository Variables, Filtering and Conditional Formatting I'm currently sitting in Galway airport coming back from a few days work, and as I've got an hour or so free I thought I'd take a look at server variables in OBIEE. Repository and Session server variables are something you tend to encounter
Testing the OBIEE 10.1.3.x Multi-User Development Environment Adrian Ward's recent post on multi-user development in OBIEE [http://majendi.blogspot.com/2008/08/multi-user.html], together with some questions I've received about the feature, prompted me to dig out the manuals and start working through this relatively new part of OBIEE on my laptop.
UKOUG BIRT SIG Meeting, London 8th October 2008 The next meeting of the UKOUG Business Intelligence & Reporting Tools Special Interest Group [http://www.ukoug.org/calendar/show_event.jsp?id=3349] is on October 8th, 2008 at the Hilton Hotel Paddington. We've got a special line up this meeting with an extended session by Michelle
Dimension Hierarchy Tables and Slowly Changing Dimensions in the Oracle Business Analytics Warehouse The blog posts I wrote earlier in the week about ragged hierarchies [https://www.rittmanmead.com/blog/2008/08/27/ragged-hierarchy-handling-in-obiee/] and bridge tables [https://www.rittmanmead.com/blog/2008/08/28/the-mystery-of-obiee-bridge-tables/] got me thinking about how these things are represented in the Oracle Business Analytics Warehouse (OBAW), the
The Mystery of OBIEE Bridge Tables If you've played around with the Oracle BI Administrator tool for a while, you may have noticed a box you can tick in the Logical Table Properties dialog, called "Bridge Table". If you're familiar with Ralph Kimball and some of this dimensional modeling ideas,
Technical 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
Ragged Hierarchy Handling in OBIEE Another area I'm looking to cover in my Oracle Open World session on OBIEE data modeling [https://www.rittmanmead.com/blog/2008/08/10/rittman-mead-presentations-at-oracle-open-world-2008/] is support for ragged, skip-level and unbalanced hierarchies. If you've worked with OBIEE for a while and you're from
Technical 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
Technical 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
My Oracle Business Intelligence Open World 2008 Schedule Doug Burns' posting of his Open World schedule [http://oracledoug.com/serendipity/index.php?/archives/1430-My-Openworld-Schedule.html] made me think about mine yesterday evening, and so I fired up the Schedule Builder application (which now uses Oracle Data Mining to predict which other sessions you might be interested in,
Technical 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
Rittman Mead Presentations at Oracle Open World 2008 Rittman Mead are providing a number of presentations at Oracle Open World [http://www.oracle.com/openworld/2008/index.html], taking place in San Francisco from September 21st to 25th 2008. Here's a rundown on the sessions we'll be running or taking part in: Extending and
Oracle Sales Prospector I'm just sitting in my hotel room in Galway, listening to the Galway Races [http://en.wikipedia.org/wiki/Galway_Races] going on down the road and working through an online demo of Oracle's new Sales Prospector [http://sales.oracle.com/en-us/] application. It's
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-and-sil-mappings-in-oracle-bi-apps-795/] I've picked
