Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Add a way to track report/analysis usage for OTBI
Description
Our clients have been requesting a way to track which reports and analysis are more commonly used than others. Something along the lines of how many times a report or analysis has been accessed, who accessed and some sort of ties with a timestamp.
Ultimately, we are aiming to optimize our OTBI working environment by identifying which reports are not being utilized and determine usage of more complex requested analysis.
Use Case and Business Need
Having a way to track usage of analysis & reports allows our clients to take more ownership of the OTBI environment and identify changes & improvements on reports that are currently not being used.
This improvement allows us to maintain and track users that are utilizing reports, and others that should be using the analysis & reports, but aren't, which would ultimately improve our accountability and that of our clients.
In addition, this will help identify security breaches as well as permit IT to further improve the security in our reporting structure.
More details
There is currently no meta-data in reports that we are aware of, and an SR we recently opened regarding the matter confirmed this was not something yet implemented.
Original Idea Number: 78db4113e4
Comments
-
There is an audit reporting ability that might meet some of your needs. Please see this note:
Fusion Applications BI Publisher : How To Configure And Use Audit In BI Publisher For Fusion SaaS Cloud Customers? (Doc ID 2059102.1)
The Oracle provided report provides history of who ran which report between a Start and End Date.
0 -
When I upload the Audit.xdrz file to BIP it does not show up as a folder. Do you know what I may be doing wrong?
0 -
https://****.fa.us2.oraclecloud.com/xmlpserver/servlet/catalog
You would need to access the catalog on your BIP XMLPserver. Go to Reports & Analytics -> Home Page and replace analytics with xmlpserver in the url. The folder and reports would only be accessible from there
0 -
Hi Aditi, sorry for the delayed response.
By any chance, do you know if there is a profile value somewhere that I need to flip in order to enable the capture of the report access?
I am following the options in that paper, but there is just simply no data in that table. It seems really promising though so I'd like to look into it further if possible.0 -
No, I am sorry. I followed the directions in the document and was able to get results. Try an SR maybe referencing the document?
0 -
This improvement allows us to maintain and track users that are utilizing reports, and others that should be using the analysis & reports, but aren't, which would ultimately improve our accountability and that of our clients.
0 -
Will attempt this. Thank you for your help!
0 -
There were a couple of steps I was missing to get it to work, one being accessing through the servlet as instructed, then entering each report and remapping the data model that came with the sample reports.
This works!0 -
Update on this, this solution only works for 'Reports' and not for 'Analysis' so the issue still persists
0 -
The solution above allows you to track only Reports, but not Analysis
0