Business Intelligence – Oracle

Archive for November 12th, 2007

IBM to buy COGNOS

Posted by Venkatakrishnan J on November 12, 2007

Close on the heels of SAP acquiring BOBJ, it looks like IBM is all set to buy out the remaining well known pure play BI Vendor Cognos. More details on the acquisitions can be obtained here and here. Well, it looks like the battle is only among  the big wigs now. Its only a matter of time before Microstrategy and the other remaining small vendors are acquired. Based on the reports it looks like this acquisition would help furthering IBM’s on-demand initiative. If you have any thoughts on this acquisition feel free to post them in the comments section.

Advertisements

Posted in Acquisitions, All Posts, General | 1 Comment »

Oracle BI EE 10.1.3.3.1 – BI Managements packs are now Available

Posted by Venkatakrishnan J on November 12, 2007

Looks like the BI Management packs are already out. For those of you who are not aware of Management Packs, this is what the Documentation has got to say about this

Oracle Business Intelligence Management Pack is an integrated solution for ensuring the performance and availability of Oracle Business Intelligence Enterprise Edition (OBI-EE). Using the pack, one may get proactive alerts on impending problems on the application, examine run-time statistics to troubleshoot and tune performance, compare configurations across different environments, keep track of configuration changes, and proactively enforce configuration policies in order to avoid configuration related problems. The pack may be used with other Oracle Enterprise Manager management packs and plug-in’s to achieve end-to-end management of the entire application environment, including both Oracle and non-Oracle databases, operating systems, storage and network devices.”

This pack provides an integrated solution for ensuring the performance and availability of Oracle Business Intelligence Enterprise Edition. Using the pack, you can receive proactive alerts on impending problems for the application, examine run-time statistics to troubleshoot and tune performance, compare configurations across different environments, keep track of configuration changes, and proactively enforce configuration policies to avoid configuration-related problems. You can use the pack with other Oracle Enterprise Manager management packs and plug-ins to achieve end-to-end management of the entire application environment, including both Oracle and non-Oracle databases, operating systems, storage, and network devices.

Key product features include: Application performance management

   Dashboards and reports

   Alert notifications

   Historical metrics

   Blackouts

   O/S management

Configuration management

   Automatic discovery

   Configuration snapshot

   Configuration comparison

   Change history

   Configuration policies

For more details refer the documentation here

Posted in All Posts, OBI EE Plus | 1 Comment »

Oracle BI EE 10.1.3.3/2 – Working with CLOB Fields

Posted by Venkatakrishnan J on November 12, 2007

I recently came across a question on an internal forum wherein the question was whether OBI EE has support for CLOBs? As you would already know, BI Publisher has native support for both CLOB and BLOB fields. Unfortunately, there is no document that states the support/de-support for CLOB on BI EE. In the example that i am going to try for testing CLOBs in BI EE, i would be using the SH schema. I have basically added one more field in my GEOGRAPHY dimension called GEOGRAPHY_DESC which is a CLOB field.

      

Lets try creating a simple report out of this CLOB field.

      

      

As you would see above this has resulted in an error. But as you would see above this has resulted in an OCI specific error and not an OBI EE error. So, i thought of taking a look at the actual SQL that was getting fired in the backend.

      

As you see, the SQL fired actually had a distinct clause which is not supported for CLOB fields. Even GROUP BYs are not supported for CLOBs (You can test this SQL plus or SQL Developer).

      

Since the query generated was because of the repository design(the geography was a dimension and hence the distinct clause got added), i thought i would give it a try using direct database requests.

      

      

Looks like CLOBs are indeed not supported directly since even in a direct database request we do not get the actual data. We only get some junk characters. So, the only way as of now is to use the DBMS_LOB package to break the CLOB into small chunks and then use them in the reports. For example, you can directly use the EVALUATE and DBMS_LOB.SUBSTR on the CLOB field to get the data.

      

      

So till we get actual support use the DBMS_LOB package.

Posted in All Posts, OBI EE Plus | 4 Comments »