How to Enable Usage Tracking on OBIEE 11g (11.1.1.6.5)

A usual requirement is to enable usage tracking to gather statistics about usage of OBIEE, things like performance, which Dashboards/Reports are being utilized, who is logging in, etc. Out of the box, Oracle includes a robust usage tracking capability with OBIEE, and in fact includes a sample RPD with the Usage Tracking Subject area during install.

There are three main components:

• Changes/configuration in the RPD
• Configuration in Enterprise Manager
• SQL to run to setup Usage Tracking schema.

Continue on to read the steps to enable Usage Tracking.

Changing password of the MDS and BIPLATFORM schemas used by OBIEE 11g

At my current engagement, we are required to change the passwords for everything every 60 days. After doing some research I found a blog post by someone who showed how to do this from Enterprise Manager, but they only covered three of the four locations to change the password. As I have mentioned previously, I like automation, so I build a script which takes care of all the tasks.

After the jump is an example script, along with the python for WLST, to perform this task.