Summaries

Saturday, May 20th, 2006 by Peter Scott

David Aldridge, aka the OracleSponge has recently blogged on the three ‘P’s of Data Warehousing. David commented that the “pseudo P”, summarisation, was perhaps the most important. Well, I must say that I agree with him there.
In whatever form, be they conventional tables or materialized views, summaries can dramatically boost performance for user queries. True […]

UKOUG BI & Analytics Special Event, London

Thursday, May 18th, 2006 by Mark Rittman

Like

Lisa Dobson and

Peter Scott, I went along to the
UKOUG
BI & Analytics Special Event at the Grange City Hotel, London earlier this
week. As the UKOUG BIRT SIG Chair, I helped to organise the event and did one of
the presentations, on behalf of my company,
SolStonePlus. These special events are
sort of mini BI "summits", and take place every […]

UKOUG BI & Analytics Special Event, London

Thursday, May 18th, 2006 by Mark Rittman

Like

Lisa Dobson and

Peter Scott, I went along to the
UKOUG
BI & Analytics Special Event at the Grange City Hotel, London earlier this
week. As the UKOUG BIRT SIG Chair, I helped to organise the event and did one of
the presentations, on behalf of my company,
SolStonePlus. These special events are
sort of mini BI "summits", and take place every […]

The Only Thing Better Than Spurs Winning the Champions League

Wednesday, May 17th, 2006 by Mark Rittman

… Is watching Arsenal
lose it.

Still, at least Thierry Henry
got to meet
some of his new team-mates.
I’m so happy I think I’ll go and buy one of those new
MacBooks. Days like this don’t come
around often.

XML Publisher 5.6.2 Available for Download

Friday, May 12th, 2006 by Mark Rittman

If you read my articles earlier this year on XML Publisher 5.6 RC2, you’ll be
interested to know that the full production version, now known as XML Publisher
5.6.2, is available for download from
http://edelivery.oracle.com. It’s a bit of a convoluted download process
(choose a language, press OK, enter your details, accept the export restrictions
and then select "Oracle […]

An Oracle Answers and Oracle Dashboard Walkthrough

Thursday, May 11th, 2006 by Mark Rittman

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, […]

An Oracle Answers and Oracle Dashboard Walkthrough

Thursday, May 11th, 2006 by Mark Rittman

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 are a sales […]

Participate in the OLAP Survey 2006

Wednesday, May 10th, 2006 by Mark Rittman

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, the implementation cycle and the […]

An interesting case

Tuesday, May 9th, 2006 by Peter Scott

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 […]

A Guide to OracleBI Suite Enterprise Edition

Monday, May 8th, 2006 by Mark Rittman

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, Oracle Reports Services and
Oracle Portal, […]