Oracle Announce Future Fusion BI Strategy

Thursday, March 23rd, 2006 by Mark Rittman

Well, Oracle have finally announced what their future BI strategy is going to
be, and it looks pretty exciting. It’s been a fairly open secret that Siebel
Analytics was going to be the centrepiece of Oracle’s Fusion BI Strategy going
forward, but there’s been various rumours going around about exactly how that
might happen, going from OracleBI Discoverer being [...]

Should I, shouldn’t I

Wednesday, March 22nd, 2006 by Peter Scott

Browsing the UKOUG website I see that the deadline for paper abstracts for the November conference is 1st May. As I had thoughts of pitching up with a DW presentation of some sort I better get my thinking cap on. I have a few ideas which I might run past people here in the UK.
Although [...]

Rewrite problems

Tuesday, March 21st, 2006 by Peter Scott

One of the Oracle 9.2 data warehouses my team manages uses nested materialized views for the aggregation strategy. Nesting of aggregates can reduce the workload on the batch as ‘expensive’ roll-ups only need happen once. The downside to nesting is that in order to make query re-write work for the higher-level nested tables we must [...]

Ten Tips for a Successful Oracle Warehouse Builder Project

Tuesday, March 21st, 2006 by Mark Rittman

I worked for a client the other week that asked me to come up with some tips
and best practices for Oracle Warehouse Builder. Without giving the game away
(otherwise you’d never pay to hire me) here’s ten tips for working with Oracle
Warehouse Builder 10g.

Don’t skimp on the design and analysis phase. Just because Oracle
Warehouse Builder is [...]

XML Publisher 5.6 Conclusions

Monday, March 20th, 2006 by Mark Rittman

I said the other week, when I wrote the first two articles about 5.6 Enterprise, that’d I’d come back in a few days to report on how straightforward it was to put together more complicated reports. I’ve been delayed since then by putting together the OTN article on XML Publisher [...]

Website Design & Build: tymedia.co.uk