Tracing Data Lineage and Impact Analysis in Oracle Enterprise Metadata Management 12c

Saturday, September 19th, 2015 by

At the beginning of the year, I wrote a couple of posts about Oracle Enterprise Metadata Management, one about how to install the tool and another one explaining the harvesting (importing) and stitching (relating) processes. A lot of things have happened since then, including a new version of OEMM released on May with some nice […]

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 […]

Website Design & Build: