Thursday, 25 September 2014

OBIEE Monitoring - Rating

Not long ago we released version 2 of our OBIEE performance and usage trend monitoring solution. In the meantime several interested parties send us a request to get the solution package and we installed it ourselves in our clients' OBIEE environments.

Naturally we'd like to share with you how OBIEE managers, architects, developers and administrators rate the reports provided:
  • "Really great! Thanks a lot for this free service."
  • "Outstanding!"
  • "It works like a charm!"
  • "Quite informative!"
 So, don't hesitate! Review functionalities and start using it!

Saturday, 20 September 2014

OBIEE Dashboard Prompt and Between Operator

OBIEE dashboard prompts can be configured to provide filters with operator BETWEEN. Image below shows an example on a day column.

OBIEE Dashboard Prompt

After applying a low and a high value the query returns all rows with dates between low and high value including the edges, e.g.:


There are two additional options to utilise the between operator in OBIEE dashboard prompts without changing the operator in the prompt itself. You can just insert the low or the high value to get query behaviour as follows:

DAY >= low
DAY <= high

Inserting just the low respectively left value turns the between operator into a greater than or equal operator. Applying the high/right value means to run a query with less than or equal operator. Of course, you can allow the user to select the operator via a dashboard prompt operator select list. That depends on your dashboard requirement. Be aware that using greater or less than operators in a selection may result in decrease of query performance.

Interested in some more end user topics? Check out Oracle BI useful things.

Thursday, 18 September 2014

Top 4 BI Articles

Based on the all-time blog statistics the most popular posts are:

1. Oracle BI Useful Things
2. OBIEE Performance Monitoring (Version 1)
3. BI Success Factors
4. OBIEE Mobile App Designer v2

And of course you should know our BI video.

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

Friday, 5 September 2014

OBIEE Change Field Content

Blog article OBIEE Change Analysis Subject Area mentions by the way that you should use Column Formula editor for replacing field content in Oracle BI Answers. Main reason for this approach is to keep appearance of all views where field reference is used. You just want to change the field to show any other content having no effect on analysis' design. If you use the Delete button and add new columns again, then you must edit all views where field should be inserted. In most cases you will addtionally lose some nice settings in your views.

Let's take a simple selection of fields:

You possibly assume that fields shown link directly to the content delivered by OBIEE. That's not the case. Each field section just represents a specific column. It's a reference which is applied to the views in results tab. You can substitute the source of this reference. Subsitution doesn't affect view references. Therefore you don't lose any view settings when changing the source. Press Edit formula in order to change e.g. Query # figure:

Section Column Formula shows the source of the reference. Use subject area navigation on the left hand side or directly type in the new source, e.g. Runtime Avg observing the correct syntax, of course:

"Fact - OBI Usage"."Runtime Avg"

Interested in some more end user topics? Check out Oracle BI useful things.