Weblog for the AMIS Technology corner
Raymond de Vries
This user hasn't shared any biographical information
Posts by Raymond de Vries
Oracle Business Intelligence Standard Edition One – now available.
27/6/2007 - 11:41 pm
Posted in Data Warehousing & BI, General, Oracle | No comments
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 Analytics stack of products and consists [...]
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 the previous release was Siebel [...]
Cognos 8 BI or Oracle BI EE (Siebel Analytics) – not a difficult choice
25/3/2007 - 3:01 pm
Posted in General | 5 comments
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 therefore I was interested to see [...]
When creating Cubes in OWB10g R2, are materialized views automatically created as well?
7/11/2006 - 1:21 am
Posted in General | 2 comments
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 (On demand or On commit). [...]
OWB 10g R2 – Changing the repositories password disables the Control Center
13/10/2006 - 1:01 am
Posted in Database, Databases, General, Oracle | 3 comments
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 Centers password to be changed [...]
Using an Oracle database link to connect to Excel
4/8/2006 - 1:47 am
Posted in Data Warehousing & BI, Database, Databases, Devel. + PL/SQL tools, General, Oracle, Oracle Development Tools | 5 comments
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 of doing the same but [...]
The long awaited Oracle Warehouse Builder 10g R2 is now available
24/5/2006 - 11:26 am
Posted in Data Warehousing & BI, General | 2 comments
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 Database products (from release [...]
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 database objects, view and edit table [...]
Oracle 10g R2 does not support Oracle Warehouse Builder.
11/9/2005 - 9:37 pm
Posted in Data Warehousing & BI, Database, General, Oracle | 4 comments
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 and Runtime, the installation process uses [...]
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 the end of the document.
XSL [...]
