Oracle works quietly with Mozilla [http://news.com.com/Oracle+works+quietly+with+Mozilla/2100-7344_3-5706116.html] : "Oracle and the Mozilla Foundation are keeping a joint venture under wraps, leading to speculation that the database giant may by planning to release an open-source product. The Mozilla

The customer is not always right [http://neopoleon.com/blog/posts/13932.aspx] : "First, though, I’m posting the longest comic I’ve ever drawn - practically a graphic novel by my own standards - illustrating why the customer is not always right. This is an old adage which I think

> "I have a question about drilling from an OracleBI Discoverer for OLAP 10.1.2 worksheet to a Discoverer Plus Relational worksheet. When you pass values from an OLAP worksheet you pass either the dimension name or the dimension value to the associated parameter in the relational worksheet.

Keen eyed readers would have observed that the original two “part ones” of this article merged and slightly downsized, as part of this process the name ‘1b’ was deleted from history. This posting is dedicated to the words and memory of that fallen ‘b-ing’ Attributes and Hierarchies Attributes [http:

Tom Kyte [http://tkyte.blogspot.com/2005/05/any-plans-for-weekend.html]recently wrote on time travel. This got me thinking... time… the fourth dimension… dimensions… data warehouses. In the physical world around us we are used to thinking in three dimensions. A carpenter makes a box; it has

The next meeting of the UKOUG Business Intelligence & Reporting Tools SIG [http://www.ukoug.org/calendar/show_event.jsp?id=798] is taking place on Wednesday, 25th May at theInstitute of Physics, 76 Portland Place London [http://www.ukoug.org/calendar/show_venue.jsp?id=441]. We've

Yesterday I rambled on about tables, indexes and tablespaces. In passing I mentioned changes to partitioning schemes would be another posting.... so here it is. One of my customers operates a chain of outlets across the UK. Most outlets trade 7 days a week. In the original data warehouse sales

The Future of Databases [http://it.slashdot.org/article.pl?sid=05/05/02/1944248&tid=221&tid=198&tid=8] : ""Ever wonder where database technology is going? This is something thatTuring award winner Jim Gray [http://research.microsoft.com/~Gray/]from Microsoft has given

Oracle in talks to buy Siebel [http://blogs.zdnet.com/BTL/?p=1321]: "Oracle is in talks to buy Siebel Systems for a price tag that could reach $5 Billion The Daily Deal reports. The high-level discussions between the two companies have been confirmed by insiders and industry

I've been playing around with one of the OWB "Paris" betas, and one of the things that most struck me about this version of OWB compared to previous ones is the degree to which it utilizes theOLAP Option [http://www.oracle.com/technology/products/bi/olap/

One or two of you might be wondering how I've managed to find the time to write so many articles recently, and the answer to this is down to something youmight have read about a few weeks ago [http://www.journalism.co.uk/news/story1343.shtml] where our

To schedule an OWB mapping or process flow to run at a set time, and optionally to run again after a set interval, without having to deploy it to OEM: First, log on as the Runtime Repository owner, and run the following script to create a function called RUN_OWB_

If you're looking to tune an SQL statement or a batch job, a common way to find out what happened during the execution of the SQL is to run an extended SQL trace and examine the wait events [http://download-west.oracle.com/docs/cd/B14117_01/server.

Neil Raden, who's article onModel-Driven Approaches For BI Projects [http://www.rittman.net/archives/000889.html] I linked to last year, dropped me a line to tell me about some new real-time ETL articles he'd written: > "Mark, I've written some

A number of clients I've worked with recently have been looking to implement OracleBI Discoverer 10.1.2 for OLAP as their general ad-hoc query tool. Whether running against relational OLAP data or data in analytic workspace, Discoverer for OLAP comes with a slick new interface, an

Oracle Rebrands Middleware As Fusion [http://informationweek.com/story/showArticle.jhtml?articleID=161501223] : "Oracle is slapping a new "Fusion" moniker on its array of middleware and development tools. "Oracle Fusion Middleware" to be formally announced Monday, will be the umbrella brand for some 32 products

Supercharging Star Transformations [http://www.evdbt.com/SuperChargingStarTransformations.doc] : "A star transformation is a methodology used to join tables to greatly improve performance of queries on dimensional data warehouse schemas.  Prior to star transformations, the primary join methods available were nested loops, merge, and hash joins.  Like many other

Tom Kyte, who'll you'll probably know through theAskTom [http://asktom.oracle.com/] site and the"Effective Oracle by Design" [http://www.amazon.co.uk/exec/obidos/ASIN/0072230657/markrittmansh-21/026-7358782-2852464] book, has started a blog [http://tkyte.blogspot.com/]. Tom'

One of the medium sized DWH I run is to have all the aggregate summaries rebuilt in few weeks time. The customer is replacing the old mainframe with a new ERP system, and at the same time restructuring their reporting structures and hence asked that we change all of the

Alan Alda's Interviewing Tips for Uncovering Business Requirements [http://www.intelligententerprise.com/showArticle.jhtml?articleID=160403897&pgno=1] : "Alan Alda is still widely known as "Hawkeye" Pierce from the hit television series "M*A*S*H" but he's also the

Tom Kyte :"In Search of the Truth - Or Correlation Is Not The Same As Causation" [http://asktom.oracle.com/pls/ask/download_file?p_file=3067171813508366601] > "... I have two guiding principles with regards to Oracle. One is that every day, each and every day, I learn

Larry's war: Oracle vs. SAP [http://news.com.com/Larrys+war+Oracle+vs.+SAP/2100-1014_3-5650929.html?tag=nefd.pop] :"Ellison's attack on SAP goes far deeper than words, as Oracle's recent acquisitions show. First, Oracle launched a full assault on