Building on top of the Users

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 Docs (11g) http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/sa_system.htm#BIESG3137   As […]

Read More Building on top of the Users

Delete that Index

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 an index, and updates too […]

Read More Delete that Index

Catch Up

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 Seibel Analytics). So, Why do we need a usage tracking ‘Warehouse’ […]

Read More Catch Up