Usage Tracking in OBIEE
Down load UsageTracking Web Catalog
UsageTracking Tables Creation Scripts
Introduction
Oracle BI server supports collection of usage statistics which can use in a variety of ways such as who is running what and when database optimization, aggregation strategies, figuring out most used reports, billing departments as per their usage etc.
Goal
We want to achieve a reporting not the usage of OBIEE. If you install OBIEE you will find a Usage Tracking rpd and catalog in below path
<OBIEE Install Dir>\OracleBI\server\Sample\usagetracking. Alternatively you can download the same from here as well
Down load UsageTracking Web Catalog
Once you have rpd and web catalog for usage tracking- you will need to peform three steps to make everything working.
Step1 : Merge usage tracking rpd with existing rpd
Merge usage tracking rpd with existing rpd
Step 2: Merger usage tracking catalog with existing catalog
Step 3: configuration for storing usage tracking in file or database tables
The best way to store usage tracking is in database tables.Oracle installation directory already have scripts for those tables.If you are just interested storing the usage tracking in file there is very few configuration. But remember whichever the way you choose file or database there is a performance implications.
I will discuss configurations later in another post.
Check this Oracle by Example for detail information with screen prints
2 Responses to “Usage Tracking in OBIEE”
Comment from Dhwani Shah
Time December 14, 2011 at 11:29 pm
Hi Ken ,
Script to create those tables are available @ below folder \OracleBI\server\Sample\usagetracking\SQL_Server_Time
I put the script in this post as well.
Comment from Ken Frantz
Time December 14, 2011 at 1:15 pm
I upgraded the Oracle Usage Tracking RPD file. It appears to be something that will be very useful. However, what about the other tables: S_ETL_DAY, S_ETL_TIME_DAY, and S_NQ_SUMMARY_ADVISOR. Are they available to download somewhere?
Regards,
Ken