> "What is the definition and purpose of an olap catalog? how can I create one? what do I add to it? and how do I add things to it? I am using Oracle 10g with JDeveloper 9.0.4 and BI Beans 9.0.4" The OLAP

A selection of books that I've been looking at recently. [http://www.amazon.co.uk/exec/obidos/ASIN/007222729X/qid=1101645531/markrittmansh-21/026-3961103-0724440] Imentioned the other week [http://www.rittman.net/archives/001129.html]that I had recently ordered Richmond Shree's and Kirtikumar Deshpande's&

Over the last couple of weeks I posted a couple of articles that generated a lot of feedback, so much so that I thought it worth posting an update article summarising some of the comments I received. The articles were on subjects that tend to pretty much divide the Oracle

If you've been looking at the available material and presentations [http://www.rittman.net/archives/001101.html] on Enterprise Planning & Budgeting [http://www.oracle.com/applications/epb.html], you've probably got a good idea now of the capabilities of this new product. What isn'

> "Hi, Mark, You paper 'Oracle 9i OLAP Uncovered' inspired me to explore more on this exciting subject. First let me confirm with you that Discoverer's own OLAP feature is implemented based on (or using) 9i/10g ROLAP. Is it true? Regardless of your answer

> "Hi, Mark, You paper 'Oracle 9i OLAP Uncovered' inspired me to explore more on this exciting subject. First let me confirm with you that Discoverer's own OLAP feature is implemented based on (or using) 9i/10g ROLAP. Is it true? Regardless of your answer

A couple of alternative event 10046 resource profilers you might want to take a look at. AppsDBA Resource Profiler [http://home.comcast.net/~arivenes/utilities_resource.htm] : "The AppsDBA resource profiler is a perl based event 10046 interval resource profiler. The resource profiler will parse an Oracle event 10046

Beginning SQL: Differences Between Oracle and Microsoft [http://www.nocoug.org/download/2004-05/BegSQL.pdf] by Les Kopari : "If you're new to SQL or just new to Oracle SQL, perhaps coming from a Microsoft SQL Server environment, it may seem like the two versions should be very

Reading through thecomments [http://www.rittman.net/mt/mt-comments.cgi?entry_id=1130]following on from my "Is Oracle A Legacy Technology" [http://www.rittman.net/archives/001130.html] posting, and in particularMogens N rgaard's reference [http://www.rittman.net/mt/mt-comments.cgi?entry_id=1130]

Lucas Jellema from Amis has written up anexcellent blog article [http://technology.amis.nl/blog/index.php?p=266]on a real-life use of table functions and the Oracle 10g model clause. > "From time to time there is a need in my SQL queries to have access to

Oracle seeks to broaden BI use with new offering [http://www.adtmag.com/article.asp?id=10261] : "Oracle Corp. is poised to make what a company executive calls a "big push" in the business intelligence market in an effort to get customers to take advantage of as

One of the new features coming up in OWB "Paris" is "Experts", which allows you to reuse OWB components to build your own custom ETL applications. A typical use of this feature is to put together an "expert" script that obtains the name of

Just a short note to say that I'm still here. It's been incredibly busy following the UKOUG event and I'm currently working for a client in Glasgow doing some database and application tuning. Normal service will be resumed in due course...

It's almost time again for the UKOUG Conference & Exhibition [http://conference.ukoug.org], which this year is taking place a month early and is running on the 1st - 3rd November up at the ICC in Birmingham. There's a number of presentations, workshops and panel

Howard Rogers [http://www.dizwell.com] dropped me a line earlier today to say that his Windows Laptop RAC paper is available for download again. The paper can be download fromhttp://www.dizwell.com/html/exotic_oracle.html, and Howard's put a redirect in place so requests to

In this month's article for DBAZine [http://www.dbazine.com], put together in collaboration with fellow bloggerJustin Lokitz [http://www.orablogs.com/oragis/], I look atGIS-Enabling Your Oracle Data Warehouse [http://www.dbazine.com/rittman6.shtml]. "GIS" is short for Geographic Information Systems and describes the

"Performance War", Craig Shallahamer : [http://searchoracle.techtarget.com/tip/0,289483,sid41_gci1015343,00.html?track=NL-94&ad=494757] "Every great Greek battle commander (Pausanias, Themistocles, Aristides, just to name a few) was either exiled, sacked, indicted, or fined by the very people he sought to

There was an interesting question [http://www.freelists.org/archives/oracle-l/10-2004/msg00948.html] on Oracle-L the other day about system performance when CPU utilisation goes up towards 100%: > "I'm not a hardware guy or sys admin person so forgive me if this is a stupid

When Worlds Collide, Content Joins Data [http://www.transformmag.com/showArticle.jhtml?articleID=50900292] : "The systems that manage content and data are on a collison course. New synergies will change the course of content. The technologies that manage unstructured content and structured data are on a collision course, and

The other day I posted an article about dimensions in Oracle 9i, and went through an example where we created some dimensions using an analytic workspace. The particular part of the article went as follows; > "...  Next, we need to create some dimensions. In our case we want to

Better to Best NDS : [http://www.oracle.com/technology/oramag/oracle/04-nov/o64sql.html] "In recent years, dynamic SQL has become a much more common aspect of PL/SQL programming. Prior to the availability of Native Dynamic SQL (NDS) in Oracle8i, dynamic SQL was available in PL/SQL only

[http://www.amazon.co.uk/exec/obidos/ASIN/1904705391/markrittmansh-21/026-3961103-0724440] If you're in your mid-thirties and work in the IT industry you probably grew up using home computers such as theSinclair Spectrum [http://wotsit.thingy.com/haj/ads-images/size1/spectrum-feb83.jpg], Commodore-64, Acorn Atom and Atari 800.

A reader asks: > "I am new to OLAP and Oracle OLAP and I have a question. I have an Oracle 10g Database with relational tables in it. I want to create dimensions and cubes from that data. Do I need to create separate dimension and fact tables from

I was looking through Steve Adams' Ixora site [http://www.ixora.com.au] the other day and I came acrossthis presentation [http://www.ixora.com.au/tips/layers.zip] that talks about another approach to Oracle tuning. Entitled "Tuning By Layers" [http://www.ixora.com.au/tips/

Dashboard Design: Why Design is Important [http://www.dmreview.com/editorial/newsletter_article.cfm?nl=dmdirect&articleId=1011285&issue=20081] : "Effective design is crucial for dashboards. A good information design will clearly communicate key information to users and makes supporting information easily accessible. Dashboards and visualization are