Rittman Mead - Delivered Intelligence

Now that the 9.2.0.4.1 Oracle Database patchset is available, together with the Analytic Workspace Manager and OWB9.2, I thought I’d take a look at the different options available for populating an Analytic Workspace and making the data available for querying using SQL.
Rather than manually building and populating analytic workspaces using the OLAP Worksheet and OLAP […]

Jonathan Lewis has written a few articles that might be of interest to Oracle data warehousing developers;

An Explanation Of The Bitmap Star Transformation
An Introduction To Bitmap Indexes
An introduction to the latest Oracle 9 variant on bitmap indexes - the bitmap join index
Why isn’t Oracle using my index?
An examination of the benefits of Locally Managed Tablespaces

Jonathan’s running […]

“Hi Mark,
I am facing a problem in accessing Oracle Cubes with ASP. How to access cubes using ASP or VB code? Presently i am using MS Analysis services with Data Source pointing to Oracle Cubes, and in asp code i am using MSOLAP provider and ADOMD Which i think is not a suitable solution because […]

A recent poster on the OTN OLAP Forum had a problem applying the Oracle OLAP Patch 3140662. This patch is sometimes needed when BI Beans can’t connect to the OLAP Catalog, and is applied after the 9.2.0.4.1 patchset required for the Analytic Workspace Manager. The patch consists of a single SQL script, “alterses.sql” that needs […]

“Hi Mark,
I am facing a problem in accessing Oracle Cubes with ASP. How to access cubes using ASP or VB code? Presently i am using MS Analysis services with Data Source pointing to Oracle Cubes, and in asp code i am using MSOLAP provider and ADOMD Which i think is not a suitable solution because […]

There’s a good thread going on the OTN Discoverer Forum regarding showing full descriptions in Discoverer LOVs. The original question to the group was;

“What I have is an OLTP system with Oracle Forms on top of it. I am implementing Discoverer 4.1 to give the users a adhoc tool.
Now we have code values and what […]

A new version of Discoverer Plus/Viewer 9iAS, version 9.0.2.54, is now available on metalink as patch no. 3079487.
It supercedes the version of Discoverer that comes with 9ias 9.0.2.0.1 (9.0.2.39) and the 9.0.2.53.x versions that most people have in production, and comes with the following new functionality;

Blank passwords now allowed for connections
New configuration parameters for stylesheets
Changes […]

I’ve had a couple of bits of useful feedback on two of last weeks stories.
First up is “Creating Database Standard Form Analytic Workspaces“, where I talked about the new DB_CREATE_STDFORM utility that takes migrated Express databases that contain Express Objects metadata, and migrates them to database standard form so that they can be accessed by […]