We are on 22.214.171.124 and we have a scheduled task that runs everyday to track FR Usage. I am not super technical and I am not the developer of this script, but it basically grabs the log file (I believe it is either FRReportSvr or FRUserLogin) loads it into Oracle and parse it. Then we report the outcome on Oracle Application Express (APEX). It basically shows how many people ran which report, when, how many times, etc. We also do ranking of report usage based on periods, so you can track which reports are being used, which report usage has been declining over time, how the newly developed reports have been doing, etc. It is pretty useful.1 person found this helpful
Does it sound like something you would develop?
In workspace you can access "Navigate -> Administer -> Usage Tracking"1 person found this helpful
Here you enable the tracking information. After configuring you can write SQL queries or develop an interactive report to gather the information you need. They are stored in the Workspace/BI database under the V8_USAGE* tables.
Edited by: Nicholas King on May 23, 2011 12:56 PM
Thanks for the reply ,
I need more information about that log file. Can you please give me the location of the file(FRUSERLOGIN.log or FRREPORTSVR.log).I search my entire server but i could not find it.If you can give me any hint like where can i find it or do i need to enable any option which will start generating this file.
Thanks for you help
Edited by: RSG on Jun 9, 2011 9:12 AM
Not sure where is it at on 11.1.2, but on 126.96.36.199 it is located in the Hyperion\logs\BIPlus folder.
we are on 188.8.131.52 and even i was not able to see the log files in logs\BIPuls actually the whole BIPuls folder is missing. Am i missing something?
has anyone found the location to the log files?
If you are looking for usage tracking log of FR then look for <epm drive>:\Oracle\Middleware\user_projects\domains\<yourdomain>\servers\<FRserver>\logs\FRLogging.log
Thank you Celvin that helped!