Data Warehousing & BI
Business Intelligence such as OLAP, BI Beans, Discoverer, Data Mining and Data Warehousing such as OWB
DBMS_COMPARISON – to compare and synchronize tables (new in Oracle 11g)
One of the interesting new pieces of functionality in Oracle 11g is offered by the DBMS_COMPARISON package. This package allows us to compare two tables – or two views on tables – and inform us on the differences in data. More specifically: the package can summarize if there any changes between the data sets and if so how many. It can also inform us in detail about the specific rows that are different between the two. Finally, DBMS_COMPARISON can converge the data sets, taking one of the two as the master and fully aligning the other one. Using DBMS_COMPARISON, we get on-demand replication for ordinary tables, within schemas, across schemas or even across databases.
In this article, I will demonstrate – on the 11.1.0.6 (Beta) release for Windows – how I can compare table EMP with a clone, whose data has been modified. We will then see how we can re-align the clone with the original (master) table. In this example, I work within a single schema. However, everything I do can be done across schemas and even across a database link, catering for custom data replication scenarios.
Here is our challenge: (more…)
Building a report in XML Publisher
Last week I made my first steps with XML-Publisher 5.6 Desktop and I am very pleased with the simplicity you can create a report in such a short time. When you follow these instructions you can see it yourself. After you have installed the XML-Publisher 5.6 Desktop you open Microsoft Word and you are ready to create the report.
You can start with the header of the report and place for example a logo in the header. In the left corner you see a XML-Publisher menu.
First you have to (more…)
Oracle Business Intelligence Standard Edition One – now available.
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…)
Gauge charts in SQL or How to produce the world's ugliest speedometers
I may be at JavaOne 2007, the important work still has to go on. Hence the latest in a series of SQL powered charts and graphs: the Gauge or Speedometer. Using nifty graphical tricks and the SQL*Plus 3D Pack, I managed to create a query that can render visually compelling, not very interactive charts, such as the one below, showing the Salary Sum for the three departments in the EMP table:
Other valuable queries-turned-charts include the number of objects per object type in our database and of course the salary per employee in the EMP table. The possibilities are endless with this new innovative high end graphical solution.
See the stunning and grossly unfair distribution of wealth in Department 20: (more…)
Oracle BI Suite seminar Utrecht
Last Wednesday I visited the Oracle BI seminar in Utrecht. Underneath you find a brief description of the highlights.
First of all Wouter van der Brugghen presented the Oracle BI strategy. Main strategic focus of Oracle BI is summarized below:
- Primary marketing tagline is: Pervasive BI, meaning BI for everybody. As an example the Cisco organisation was mentioned, which started with 500 expert users, now has 20.000 users and will grow towards almost all 40.000 employees worldwide. (more…)
My first steps with Oracle BI Publisher Enterprise Edition 10.1.3.2: create a report based on the OraBlogs rss-feed
After receiving a new, pretty powerful laptop, on Thursday and installing the Oracle BI Enterprise Edition on Friday, this weekend sees my first steps with the BI Publisher (previously known as XML Publisher). My colleague Marcos is our (AMIS’s) real expert in this area – you may have seen some of this articles on our weblog in the recent past. He writes about Matrix Reports and other more advanced topics, I am just starting out with the tool. I will tell the tale of getting started and creating a first report – one that displays an overview of the most recent blog articles aggregated by the orablogs site.
Here is the report I create in this article, shown as Excel document :
The steps are: (more…)
Recent Comments