As already OBIEE Performance Monitoring v1.1 also version 2.0 of our Oracle BI monitoring solution is deployed completely free of charge! Find the details for obtaining the configuration files at the end of this article.
As v1.1 focuses on performance monitoring coming from a SLA perspective version 2.0 introduces some usage trend reports and a more detailed prompt for filtering queries. Please refer to documentation of version 1.1 for performance monitoring reports' functionalities. As optimal OBIEE performance corresponds to optimal handling by users please have a look to our Oracle BI training bundle for introducing OBIEE to end users implementing a particular training concept and our Oracle University OBIEE Analyses Insights expert seminar.
OBIEE performance and usage trend monitoring is solely based on Oracle BI Usage Tracking. You can obtain everything described below for free (please refer to the end of the post).
OBIEE monitoring dashboard prompt now provides several filter possibilities to be able to search for detailed data. Thus you can for example analyse the origin of concrete performance issues or you can have a look to certain areas of interest.
Fields provided for filtering the monitoring reports are:
Year: year of query start date
Quarter: quarter of query start date
Month: month of query start date
Subject Area: the subject area of a query
Dashboard Catalog Area: root catalog path of dashboard location, e.g. /shared/OBIEE_UK/
Analysis Catalog Area: root catalog path of analysis location, e.g. /users/gerd/
Dashboard Name: the name of a dashboard
Analysis Name: the name of an analysis
User Id: user login
Day: a between filter for day level searching
Not all filters make sense for each analysis. But just don't use them in such a case. Catalog Area filters are very helpful when restricting queries to certain catalog storage locations. Keep in mind that filtering on Dashboard Catalog Area only returns queries initiated from opening a dashboard or dashboard page while Analysis Catalog Area calculates on queries released from a dashboard or from the OBIEE catalog. Ad hoc reports not saved in the catalog are not longer considered then.
Usage per Queries
Usage trend per queries shows number of queries within a time period (month, quarter or year). Charts illustrate overall query number, query numbers by dashboard, catalog and ad hoc usage and percentage share of these categories.
Category figures are mutually exclusive. They are calculated as follows:
Dashboard Query #: number of queries initiated from a dashboard
Analysis Query #: number of queries initiated from the catalog and not from a dashboard
Ad hoc Query #: number of queries initiated neither from the catalog nor from a dashboard
Usage per Users
Trend per users equals ot usage trend per queries. Figures are based on distinct active users. Percentage share of categories doesn't apply here, because calculation isn't mutually exclusive for user numbers. A user can use Oracle BI in each category, therefore sum of the three categories is most likely greater than User #.
Period offers Start Hour. When combining start hour with day filter prompt (e.g. filter on today) you can see how many users are active intraday.
Usage per Top 10 Analyses
Top 10 analyses by number of queries including runtime average and average of data rows selected (due to privacy we cannot show names in the table chart).
Usage per Top 10 Dashboards
Top 10 dashboards by number of queries including runtime average and
average of data rows selected (due to privacy we cannot show names in the
Release Notes v2.0
The reports are integrated into two dashboards separated by performance and usage trend. Oracle BI repository and reports are based on OBIEE 220.127.116.11.1. For installation or downgrading support just contact us.
Please feel free to send us your specific analysis requests for Oracle BI report performance and usage trend monitoring. We will try to integrate them in the next release.
Obtain OBIEE Performance and Usage Trend Monitoring
As already mentioned we provide all relevant configuration files completely for free. Just contact us or send an e-mail to email@example.com. Please provide your company contact data. We don't use the data for marketing purposes. We just want to know who is using our OBIEE monitoring solution.
Please add us to your network: Twitter • LinkedIn • Facebook • Google+
We will share additional information, updates, etc. via our social sites.