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)
As usual we have the code we will be building in the Github, see
Next we will need to add the columns that help to answer those questions (remember those in http://blog.obiee.co.uk/catch-up/).
So, now we put our thinking caps on..