Mark Rittman

> "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've had a couple of bits of useful feedback on two of last weeks stories. First up is "Creating Database Standard Form Analytic Workspaces [http://www.rittman.net/2003/10/30.html#a205]", where I talked about the new DB_CREATE_STDFORM utility that takes migrated

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

There's a good discussion going on [http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1271400550105] at asktom.oracle.com [http://asktom.oracle.com] at the moment concerning star queries; take a look if you get a chance.

> "Hi Mark. Do you know where I can find a comparison between the Discoverer Client/Server versus the Discoverer Intranet versions?" If you're interested, i've put together an explanation of the differences between the different Oracle Discoverer client tools, which you can take

I

The 9.2.0.4.1 release of Oracle OLAP [http://otn.oracle.com/products/bi/olap/olap.html] introduces a new concept known as

> "Everytime I do a web search for anything to do with OLAP, I always seem to be directed to your web-site! So I have a query for you, having viewed your presentation on BI Beans. The Oracle9i Release 2 OLAP option appears to allow us to store both

Arup Nanda has written an article for dbazine.com [http://www.dbazine.com/] on the various methods for implementing partitioning for existing Oracle tables [http://www.dbazine.com/nanda6.shtml]. Arup goes through a number of different options, including * Creating the partitioned table from scratch, using CREATE TABLE ... AS SELECT

Garry Robinson [http://www.oracleadvice.com/] has put together a useful guide to iSQL*Plus [http://www.oracleadvice.com/Tips/isqlplus.htm], a version of SQL*Plus introduced from Oracle 9iR2 that is delivered through a web browser. It talks you through setting up the tool, configuring it to work

Ralph Kimball [http://www.ralphkimball.com], author of The Data Warehouse Lifecycle Toolkit [http://www.amazon.com/exec/obidos/ASIN/0471255475/markrittmanso-20], has put together a new article on reviewing data warehouse data models [http://www.intelligententerprise.com/031010/616warehouse1_1.shtml?/bi|busintel] . Ralph was an early advocate [http:

"Oracle has again extended maintenance support for customers of its 8i database on many major platforms, this time until 2005, giving firms another year to migrate to 9i or 10g." reports vnunet.com [http://www.itweek.co.uk/News/1145023] . "The database giant has extended Error Correction

If you've ever had to port a Microsoft SQL Server or Access database over to Oracle, you've probably come across the different way joins are put together for these databases. For example,you might come across a query looking like this; > SELECT pub_name, title

"No one would confuse Microsoft with Oracle. The two software juggernauts have carved out distinctly different markets. So it's not surprising that the companies have differing policies on releasing information about security vulnerabilities." writes Edward Hurley in this searchsecurity.com article [http://searchsecurity.techtarget.com/originalContent/

Frank Bouma's [http://weblogs.asp.net/fbouma/] a .Net [http://www.microsoft.com/net/] developer who normally works with Microsoft SQL Server [http://www.microsoft.com/sql/default.asp]. However, he's recently had to support Oracle 9i for a project he's working on, and

Eric S. Raymond [http://catb.org/~esr/personal.html], he of "The Cathedral And The Bazaar" [http://www.amazon.com/exec/obidos/tg/detail/-/0596001088/markrittmanso-20/104-1962354-7504767] and "The New Hackers Dictionary" [http://www.amazon.com/exec/obidos/tg/detail/-/0262680920/markrittmanso-20/104-1962354-7504767] (good)

"Ease of use and accessibility are essential to widespread acceptance of BI, but simplicity has unfortunately come at the cost of analytic depth." argues Seth Grimes [http://altaplana.com/grimes.html] in this IntelligentEnterprise Article [http://www.intelligententerprise.com/030810/613decision1_1.shtml]. "BI's online

"Prior to Oracle9i, there are two popular methods to extract metadata from data dictionary. The first method involves querying the data dictionary using SQL statements. The second method involves running Export with ROWS=N, then running Import with SHOW=Y. Oracle9i introduces a new Metadata API (DBMS_METADATA package)

The following question [http://groups.google.com/groups?dq=&hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=3F8EE0A5.3090907%40Oracle.Com&prev=/groups%3Fq%3Dcomp.databases.olap%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den] came up on comp.databases.olap: > "I realise that

I had an email through the other day from Guy Mortenson, who I used to work with at Plus Consultancy before he left to find his fortune elsewhere [http://www.rittman.net/2003/07/21.html]. Guy pointed me in the direction of "Scrum", a metholodology that his

UPDATE 19/10/2003 : According to this article by Sanjay Mishra [http://www.dbazine.com/mishra1.shtml], the feature discussed in this posting (using SQL expressions in Direct Path mode) is only available from Oracle 9i upwards. It therefore won't work for Jon's particular problem, although

I had the following response to a recent posting [http://groups.google.com/groups?dq=&hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=3406541.1065527999%40dbforums.com&prev=/groups%3Fq%3Dcomp.databases.olap%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den] on comp.databases.olap regarding

"Tom Kyte swears that if you properly analyze your table, the CBO is at the point where you never need hints. I find I still need them 'occasionally', though not very often. Anyone else have opinions? anyone who beta tested 10g see an improvement in the CBO?

Thanks to Simon Dunn [[email protected]] for this Oracle 9i OLAP Technical Article. "There is a new feature in Oracle 9i OLAP which allows the allocation of numbers. Previously, using Express, any allocations had to be hand-crafted using the Express SPL whilst Express-based applications such as Oracle

As an alternative to using Virtual Private Databases to provide row-level security for an Oracle data warehouse [http://www.rittman.net/stories/2003/09/25/securingDataWarehousesWithOidAdvancedSecurityAndVpd.html] , I put together an alternative security set up for a client that achieves much the same thing. The client's data warehouse