Tuesday Aug 05, 2014

OBIEE 11g: Configuration Management for OBIEE in Enterprise Manager Cloud Control 12c

(in via Senthil)

The Oracle Business Intelligence Enterprise Edition (OBIEE) support team have provided a new knowledge article for OBIEE configuration management:

OBIEE 11g: Configuration Management for OBIEE in
Enterprise Manager Cloud Control 12c
Doc ID 1912834.1

This article will assist in understanding how to use Enterprise Manager Cloud Control to manage OBIEE configurations and includes:

  • Compare configuration data to detect changes
  • Compare patches applied across different systems
  • Create custom Comparison Templates
  • Use Configuration Extensions to collect additional files/data

The article also assists in identifying changes in configuration that maybe resulting in differences in the behavior of similar systems.

The content by itself will not fix "performance" but its use is beneficial to identify differences in configuration between slow and fast performing systems that would be expected to behave the same.

An article of interest relating to slow performing Dashboards ... visit:

OBIEE 11g: How To Diagnose Slowly Performing Dashboards
using Enterprise Manager Cloud Control
Doc ID 1668236.1

Friday Jun 13, 2014

Use Enterprise Manager Cloud Control to monitor OBIEE Dashboards

(in via Senthil

If your OBIEE is set up in the following way:

  1. The OBIEE repository is an Oracle Database and is set up as a data warehouse
  2. Usage tracking is enabled in OBIEE.
    ( For information on how to enable usage tracking in OBIEE, refer to the following link: Setting Up Usage Tracking in Oracle BI 11g )
  3. The OBIEE instance is discovered in EM Cloud Control.
    ( For information on how to discover an OBIEE instance in Cloud Control, refer to the following link: Discovering Oracle Business Intelligence Instance and Oracle Essbase Targets )
  4. The OBIEE repository is discovered in EM Cloud Control.
    ( For information on how to discover an Oracle database, refer to the following link: Discovering, Promoting, and Adding Database Targets )

then we've got news for you:

KM Article:  OBIEE 11g: How To Diagnose Slowly Performing Dashboards using Enterprise Manager Cloud Control (Doc ID 1668236.1)

takes you step by step through monitoring the SQL query performance behind your OBIEE dashboard.

This Diagnostic approach ...

  • .. will help you piece together information on BI dashboard performance, e.g. processing time from the different layers of the BI system including the repository.
  • .. should enable you to get to the bottom of slow dashboards by using the wealth of information available in EM Cloud Control on OBIEE and Oracle DB.
  • .. will NOT fix any performance issues on its own, but will help identify bottlenecks while processing dashboard requests.

(layout and post: Torben, authorized: Lia)

Tuesday Mar 20, 2012

Enterprise Manager in EPM 11.1.2.x...a game of hide and seek!

guest article: Maurice Bauhahn:

Users of Oracle Hyperion Enterprise Performance Management and may puzzle why the URL http://<servername>:7001/em may not conjure up Enterprise Manager Fusion Middleware Control. This powerful tool has been installed by default...but WebLogic may not have been 'Extended' to allow you to call it up (we are hopeful this ‘Extend’  step will not be needed with The explanation is on pages 425 and following of the following document:


A close look at the screen dumps in that section reveals a somewhat scary prospect, however: the non-AdminServer servlets had all failed (see the red down-arrow icons to the right of their names) after the configuration! Of course you would want to avoid that scenario!

A rephrasing of the instructions might help:

  1. Ensure the WebLogic AdminServer is not running (in a default scenario that would mean port 7001 is not active).

  2. Ensure you have logged into the computer as the installing owner of EPM. Since Enterprise Manager uses a LOT of resources, be sure that there is adequate free RAM to accommodate the added load.

  3. On the machine where WebLogic AdminServer is set up (typically the Foundation Services machine), run \Oracle\Middleware\wlserver_10.3\common\bin\config (config.sh on Unix).

  4. Select the 'Extend an existing WebLogic domain' option, and click the 'Next' button.

  5. Select the domain being used by EPM System.
    - Typically, the default domain is created under /Oracle/Middleware/user_projects/domains and is named EPMSystem.
    - Click 'Next'. Under 'Extend my domain automatically to support the following added products'
    - place a check mark before 'Oracle Enterprise Manager - [oracle_common]' to select it.
    - Continue accepting the defaults by clicking 'Next' on each page until
    - on the last page you click 'Extend'.
    - The system will grind for a few minutes while it configures (deploys?) EM.
    - Start the AdminServer.

  6. Sometimes there is contention in the startup order of the various servlets (resulting in some not coming up). To avoid that problem on Microsoft Windows machines you may start and stop services via the following analogous command line commands to those run on Linux/Unix (these more carefully space out timings of these events):
    • Ensure EPM is up:
    • Ensure WebLogic is up:
    • Shut down WebLogic:
    • Shut down EPM:

 Now you should be able to more successfully troubleshoot with the EM tool:


This blog talks about the latest news and upcoming events regarding Oracle EPM and BI.
Tanya Heise


« August 2016