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

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

“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 [...]