Friday, 12 September 2014

OBIEE Performance and Usage Trend Monitoring v2.0

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).

Monitoring Prompt
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.

OBIEE Monitoring Prompt

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.

OBIEE Usage Trend per Queries I

OBIEE Usage Trend per Queries II

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 #.

OBIEE Usage Trend per Users

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).

OBIEE Usage per Top 10 Analyses

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 table chart).

OBIEE Usage per Top 10 Dashboards

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 11.1.1.7.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 info@ga-itbs.de. 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: TwitterLinkedInFacebookGoogle+
We will share additional information, updates, etc. via our social sites.

We allow you to use and modify our solution fully or partially. You can provide it for free to your clients. In any case you agree to our terms of use as follows and you will integrate terms and conditions into each of your OBIEE monitoring analysis based on ideas or code from our solution (just copy it from the Static Text view of one of our reports):

© OBIEE monitoring v2.0 by G.A. itbs GmbH - OBIEE expert training and consulting. Terms of use: Free of charge if this declaration, copyright and links above are not removed. Reselling prohibited. We disclaim all implied warranties with regard to this monitoring model or any analyses based on this subject area. You agree to indemnify, defend and hold us harmless from any liability, loss, claim and expense (including reasonable legal fees) related to the use of this software. You can change the implementation and/or provide it to your clients if these terms and conditions are observed and agreed by all parties involved. Furthermore terms will be integrated into each OBIEE monitoring analysis based on ideas or code from this solution. Documentation and updates are provided in our blog.

No comments:

Post a Comment