Category: Usage Tracking

Building on top of the Users

Posted on October 20, 2015 By Adrian Ward

The Usage Tracking (UT) project will build on top of the out of the box tables, and that includes using the “SA System” ‘Users’ table as a starting point for our Users table. Have a look at Gerard blog/Wiki ( is that WikLog?) http://gerardnico.com/wiki/dat/obiee/sa and also, the all important oracle…

Uncategorized

Delete that Index

Posted on October 17, 2015 By Adrian Ward

All indexes are good, right? Wrong. An index can make a join fly. but it can also slow you down. As I’ve said many times before, most of the time I delete or hide indexes, especially on an Exadata box and add carefully. However, whilst query performance is helped by…

Uncategorized

Catch Up

Posted on October 7, 2015 By Adrian Ward

When I announced last week that we are putting together a Usage Tracking project, I assumed that people would know WHY. To me it seemed obvious, having implemented this type of system for the last 15 years that I have worked in OBIEE (nee Siebel Analytics). So, Why do we…

Uncategorized

Addidici Usage Tracking Project – Part 01

Posted on September 21, 2015 By Adrian Ward

Today is day one of a new project to keep me busy, The OBIEE Usage Tracking Project. The aim of the project is to build a system to analyse usage data. This will include a database build, ODI code, RPD and Catalog metadata. This will all be free to download….