Rittman Mead - Delivered Intelligence

If you read my article the other day on the architecture of OracleBI Suite Enterprise Edition, here’s a walkthrough of creating a simple report and dashboard. It’s using the Siebel version of the tools as the Oracle branded versions aren’t available yet on OTN, but the steps are the same regardless. In this walkthrough, you [...]

The OLAP Survey 2006 is now looking for participants, with this message from Gordon Laver: "We would very much welcome your participation in The OLAP Survey 6. This is the largest independent survey of business intelligence users worldwide. The Survey will obtain input from a large number of users to better understand their buying decisions, [...]

Tuning data warehouse queries is not always easy; when you take into account complications such as parallel query, bitmap indexes, star transforms, and query rewrite then there is a lot going on to confuse the picture. This is further complicated by the sort of SQL generated by query tools, especially those of the drag and [...]

Oracle Business Intelligence Suite Enterprise Edition is Oracle’s “next generation” business intelligence platform. Centred around Oracle BI Analytic Server, a business intelligence “application server”, Oracle BI Suite Enterprise Edition comes with a range of ad-hoc, presentation and delivery tools and supports connectivity to a range of heterogeneous data sources. Unlike products such as OracleBI Discoverer, [...]

One of our customers sent in some SQL that took ages to run. On the face of it was not doing anything difficult, it just inserted the results of an aggregate query into another table. The select part of the query joined two large partitioned tables on the partition key to restrict the result set [...]