Oracle and Data Warehouses

Monday, September 1st, 2014 by

If you follow Blogs and Tweets from the Oracle community you won’t have missed hearing about the recent release of the first patch-set for Oracle 12c. With this release there are some significant pieces of new functionality that will be of interest to Data Warehouse DBAs and architects. The headline feature that most Oracle followers […]

SampleApp v406 – Automatic startup of OBIEE

Tuesday, June 17th, 2014 by

Last week Oracle released v406 of SampleApp. SampleApp is a one-stop-shop for a demonstration of pretty much any conceivable thing that OBIEE is capable of, and then some more on top of it. It is a VirtualBox appliance with everything on the one machine (Database, OBIEE, Endeca, TimesTen, Essbase, etc), and demonstrates basic analysis building […]

Incremental refresh of Exalytics Aggregates using TimesTen

Thursday, January 10th, 2013 by

Introduction One of the key reasons that Exalytics can deliver sub-second response times is the use of TimesTen in-memory database to hold data pre-calculated to various levels of aggregation as required by the reports. Last year I wrote about Alternatives to the Summary Advisor when considering how to build and maintain these aggregates in TimesTen […]

OBIEE Administration Tool – Import Metadata shows no schemas

Thursday, May 24th, 2012 by

Importing Metadata with the Administration Tool The client-only install of the OBIEE 11g Administration Tool is installed with a set of OCI libraries. This means that it can support basic Oracle Database interaction, without the need for a full Oracle Client installation on the machine. For example, you can update row counts in the Physical […]

Event Triggers in BI Publisher 11g

Tuesday, December 20th, 2011 by

Event Triggers in BI Publisher 11g give the facility to call a function in Oracle either before or after a data set is refreshed. The function must return a boolean (true/false), and if it returns false the data model will abort execution. In this article I will demonstrate how to pass a parameter through to […]

Website Design & Build: