Cognos Release Cognos ReportNet

Saturday, September 27th, 2003 by Mark Rittman

Cognos have launched a replacement for Impromptu, their venerable web-based reporting tool, and it’s causing quite a stir in the BI market.
Credited by some with being the real reason behind the recent series of mergers in the BI & reporting market, Cognos ReportNet is a fully web-based reporting suite that includes tools for developing, […]

Why Data Warehouse Dimensions Should Be Kept To A Minumum

Thursday, September 25th, 2003 by Mark Rittman

Data warehouse fact tables contain one or more measures (such as ‘volume sold’, ‘cost price’ and ‘retail price’) and one or more dimensions. When the data model is first put together, the number of dimensions is usually quite small, and centre around common business areas like organization, time and geography. As the data model is […]

Securing Data Warehouses With OID, Advanced Security And VPD

Thursday, September 25th, 2003 by Mark Rittman

Once the domain of a small group of knowledge workers within an organization, data warehouses are increasingly becoming a critical part of an overall  I.T. infrastructure. Organizations have come to depend on the information held in data warehouses and data marts, and often the warehouse is the only source of information within an organization that […]

Keeping Warehouse Dimensions To A Minimum

Thursday, September 25th, 2003 by Mark Rittman

Data warehouse fact tables contain one or more measures (such as ‘volume sold’, ‘cost price’ and ‘retail price’) and one or more dimensions. When the data model is first put together, the number of dimensions is usually quite small, and centre around common business areas like organization, time and geography. As the data model is […]

OWB10g Data Quality Features

Tuesday, September 23rd, 2003 by Mark Rittman

Mark Van De Wiel and Ali El Kortobi put together a presentation for Oracleworld on the data quality features in Oracle Warehouse Builder 10g. It covers the name and address cleansing and match-merge features, the new debugging facility and the module snapshot feature.
What’s particularly interesting about the new features is the match-merge facility, which allows you […]

Update to Article About Oracle Departures

Tuesday, September 23rd, 2003 by Mark Rittman

An update to the story posted on 19th July about Oracle’s Mark Jarvis and George Roberts resigning.
Jon Wilkinson points out an error in Reuters description of Charles Phillips, who is described in the article as a former star software analyst at Morgan Stanley. In fact, according to Jon,

“Charles Phillips (or Chuck as he is […]

Securing Data Warehouses with Advanced Security, OID and VPD

Thursday, September 18th, 2003 by Mark Rittman

Once the domain of a small group of knowledge workers within an organization, data warehouses are increasingly becoming a critical part of an overall  I.T. infrastructure. Organizations have come to depend on the information held in data warehouses and data marts, and often the warehouse is the only source of information within an organization that […]

The SQL MODEL Clause

Tuesday, September 16th, 2003 by Mark Rittman

Apart from the announcement that a future version of Discoverer will fully support Oracle OLAP multidimensional queries, the most important new business intelligence feature of Oracle 10G is the ‘SQL Model Clause’.
Outlined in Tom Kyte’s recent white paper at Oracleworld, the SQL Model clause allows users to embed ’spreadsheet-like’ models in a SELECT statement, in […]

Oracle 10g - A Self Managing Database?

Tuesday, September 16th, 2003 by Mark Rittman

One of the most interesting new features of Oracle Database 10g is the new ’self-managing’ framework outlined in this white paper by Sushil Kumar, available on the Oracleworld site. Automatic maintenance and tuning has always been one of the key product differentiators for Microsoft SQL Server and with Oracle 10g, features that meet and match […]

Installing Oracle 9iR2 on Red Hat 9

Saturday, September 13th, 2003 by Mark Rittman

Keen to run Oracle on Red Hat 9 but having problems with libraries and kernel parameters? This article over at ITToolbox gives you step-by-step instructions on installing Oracle 9i Release 2 on Red Hat 9, including the installation of the backward-compatability and software development packages required to get the installation up and running first-time.