Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Analyzing Usage Tracking Data in Fusion Analytics Web
Use the attached workbook to help find slow-running queries in your Fusion Analytics Web (FAW) implementation.
The workbook uses the 'Common - Usage Tracking' subject area. To run, just download the attached .dva and import it into your FAW environment.
The first canvas groups queries into buckets by how long it takes them to run.
Then right-click on a cell and select 'Drill to Query Detail'. This takes you to a second canvas which shows additional details about the queries. For example, if it is a saved query, the report will show the path where it resides in the catalog. Then, you can further investigate a query to determine why it is slow.
The drill only works for users defined in Fusion. If a user is defined in the local IDCS/IAM, the user login will appear as null and no further drilling is possible.
The workbook is just a template, feel free to edit it to meet your needs.