Last week I noticed that the long awaited Oracle Business Intelligence Standard Edition One was available on e-delivery download site and on Monday (25 June 2007) Oracle officially announced the general availability of Oracle Business Intelligence Standard Edition One. Oracle Business Intelligence Standard Edition One is based on the Siebel […]
Raymond de Vries
Oracle BI Suite EE 10gR3 – My first encounter
Oracle recently released its official version of the Oracle BI Suite Enterprise Edition – 10gR3 (10.1.3.2.0 – also known as the Maui release). This version is based on the Siebel Analytics application stack, which Oracle obtained with the Siebel acquisition. The release is different to the previous release in that […]
Cognos 8 BI or Oracle BI EE (Siebel Analytics) – not a difficult choice
Last week I was invited by Cognos Netherlands to an Infoseminar Cognos 8 BI. I know that Cognos 8 has been in the market since 2005 but I have never had the opportunity to work with or tryout version 8. The last version that I worked with was 7.3 and […]
When creating Cubes in OWB10g R2, are materialized views automatically created as well?
When creating a Cube in OWB10g R2 one has the possibility to define aggregations to be performed for the Dimensions that the cube references. When defining the aggregations you are able to select the aggregation method (sum, max, min, first, last, average, hierarchical average etc.) and the data refresh method […]
OWB 10g R2Changing the repositories password disables the Control Center
If you change the password of the repository owner in Oracle Warehouse Builder 10g Release 2, the Control Center Service will fail to start. It is unusual that Oracle stores the Control Centers password in the database. When you alter the repositories password, Oracle should have arranged for the Control […]
Using an Oracle database link to connect to Excel
Recently I had to extract data from 5 Access databases and 4 Excel files and merge the data into an Oracle table. One method was to export the data from Access to Oracle via ODBC (at that stage I had not heard of Workbench ) but I was sure that there must be a way […]
The long awaited Oracle Warehouse Builder 10g R2 is now available
After a long delay OWB 10g R2 (previously known as Paris) has finally been released for production and can be downloaded from OTN. OWB 10g R2 will not be packaged with the Oracle Development Suite as was the case with release 1 but will now be found packaged with the […]
Oracle introduces free database development tool
Oracle recently released its first production version of a graphical database development tool called “SQL Developer†(version 1.0) – formerly project Raptor. If you have ever worked with Oracle Jdeveloper you will find that SQL Developer has the same look and feel. With this tool you are able to browse […]
Oracle 10g R2 does not support Oracle Warehouse Builder.
Oracle’s latest database release 10g R2 does not support OWB (Oracle Warehouse Builder). All OWB’s up to and including the current version 10.1.0.3 are not certified by Oracle 10g R2 and therefore do not work on the 10g R2 database. The problem is that when you install the OWB Repository […]
XSL – The basics
XSL – the basics This document explains what XSL is and how it could be used. It only covers the basics of XSL but with these basics it will be shown that wonderful things can be done. The XML and XSL examples used in this document can be found at […]
Oracle Warehouse Builder suddenly stops working?
Did you recently try to start your OWB client and found that it suddenly did not want to start? Well you’re not the only one. All OWB users around the world found that from the 28-July-2005 their OWB would not start. The reason is that the JCE package found in […]
Using a function-based index to get fast access to NULL table columns
We had a client that was having performance problems with one of their queries and it was rewarding to be able to solve the problem with knowledge recently gained from the Amis 7UP work shop. The 7UP work shop presented handy new SQL features that were introduced by Oracle from […]
Using a function-based index to get fast access to NULL table columns
One of our clients was having performance problems with one of their queries and it was rewarding to be able to solve the problem with knowledge recently gained at the AMIS 7UP work shop. The 7UP work shop introduces handy new SQL features that were introduced by Oracle from versions […]
Recompiling invalid objects
I recently witnessed a developer recompiling his schema’s INVALID objects by selecting all the invalid objects from the user_objects table and compiling them. This he had to do 3 or 4 times after each other before all the objects were valid. The reason for the objects not all becoming valid […]