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 usual we have the code we will be building in the Github, see
https://github.com/Addidici/usage_tracking/blob/master/011_create_users.sql
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..