Raymond de Vries
(0 comments, 14 posts)
This user hasn't shared any profile information
Posts by Raymond de Vries
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 of the following products:â€¢ Oracle BI Publisher (XML Publisher)â€¢ Oracle BI Answers (ad hoc reporting and analysis tool)â€¢ Oracle BI Interactive Dashboardsâ€¢ Oracle BI Serverâ€¢ Oracle Database 10g Standard Edition Oneâ€¢ Oracle Warehouse Builder (more…)
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 Analytics 7.8 with the Siebel logo having been replaced by an Oracle logo. I never used the Siebel Analytics 7.8 product and can therefore not compare the changes made in the latest release, but according to those that have used both, the changes are minor. Two changes I did notice was XML RSS link possibilities and a direct linkup to Oracle BI Publisher. Oracle BI Enterprise Edition includes the following components: Â· Oracle BI Server previously known as Siebel Analytics ServerÂ· Oracle BI Answers previously known as Siebel AnswersÂ· Oracle BI Interactive Dashboards previously known as Siebel Intelligence DashboardsÂ· Oracle BI Delivers previously known as Siebel DeliversÂ· Oracle BI Disconnected Analytics previously known as Siebel Mobile AnalyticsÂ· Oracle BI Publisher previously known as Oracle XML Publisher
Fusion Intelligence for More >
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 what had all been improved. As I have just started using the Oracle BI EE (Siebel Analytics) set of products, I also found it a good opportunity to compare the two products.
By the end of the presentation I was very pleased with what I had seen as I realized that Oracleâ€™s BI EE set of products were superior. (more…)
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). (more…)
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 automatically as well.
What is a Control Center Service? It is the component that enables you to register locations and deploy from the Control Center Manager, and the ability to execute ETL mappings and process flows.
Should you decide to change the repositories password, donâ€™t forget to execute the following scripts:
- If the Control Center is currently running you need to stop it by running the script: <owb home>/owb/rtp/sql/stop_service.sql
- To change the password in the Control Center execute the script:<owb home>/owb/rtp/sql/set_repository_password.sql. When running the script youâ€™re prompted with the following prompt in SQL*Plus: â€œEnter value for 1:â€.All you need to enter is the new password.
- Finally restart the Control Center by running the script: <owb home>/owb/rtp/sql/start_service.sql
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 then from Oracle’s side. After searching the web I was able to find bits and pieces and eventually all the pieces fitted together to allow me to connect to Excel and Access by using Oracle Heterogeneous Service, which has been available since Oracle 8i. If one searches the web using "Heterogeneous Service" you will find many links but when I started my search I had never heard of this service. The following Oracle documentation has alot of information on this subject, alot more than I though there was to know, for instance that there are Heterogeneous Service (HS) data dictionary views.Here are the 5 basic steps required to create a database link to non-Oracle sources: (more…)