Thursday Mar 21, 2013

HPCM - Changing Task Flow Refresh Intervals

In HPCM, users access the “Job Status” task area to view the status of submitted jobs/task flows. In, the task flow information viewed on these screens within HPCM is cached in order to provide better performance. A refresh occurs after each configured interval and new entries are shown after this interval.

[Read More]

Wednesday Mar 13, 2013

Nohup obiee weblogic

To be able to start Weblogic admin server as a process running after the launching shell exits, the in weblogic needs to be created. The following commands are the simplest way to achieve this with OBIEE:[Read More]

Thursday Mar 07, 2013

Using Essbase Query Governors with Forms Containing User Variables

Many Planning customers today are designing forms containing user variables. User variables allow the user to customize the information presented on a form based on the user’s security. In addition, the number of forms maintained in the application is reduced since multiple versions of the same form having different dimension members do not need to be created.

[Read More]

Thursday Jan 24, 2013

Merge Data Slices Before Copying an Aggregate Storage (ASO) Application

Merge Data Slices Before Copying an Aggregate Storage (ASO) Application

When performing an Aggregate Storage (ASO) application copy, it is necessary to merge all data slices first so that all data in the ASO application will be copied properly. The current Essbase documentation does not clearly state a merge of the data is required before running an ASO application copy. An update to the Essbase documentation will be done. However, you can find the documentation update in the current Essbase readme documentation. See the current Essbase readme documentation under Documentation Updates:

Wednesday Jan 16, 2013

OBIEE 11G Installation & Best practices BAPI access for SAP/BW data sources


SAP/BW integrates with BI tools via MDX (Multidimensional Queries), MDX is the de facto industry standard to query OLAP servers.

SAP/BW Server includes an MDX processor to directly query any BW INFOCUBE and INFOQUERY

SAP/BW supports multiple protocols to submit MDX requests:

With OBI EE 11g, both the XMLA adapter and the BAPI adapter are supported

Please Download the documention here
Please have a look at support article here (Doc ID: 1523417.1)

[Read More]

Wednesday Dec 19, 2012

EPM Architecture: Essbase

This week’s post will cover Essbase architecture with all its related components like Provider Services, Administration Services, Integration Services and Essbase Studio.

[Read More]

Tuesday Dec 11, 2012

OBIEE 11.1.1 - (Updated) Best Practices Guide for Tuning Oracle® Business Intelligence Enterprise Edition (Whitepaper)

Applies To: This whitepaper applies to OBIEE release,

Introduction: One of the most challenging aspects of performance tuning is knowing where to begin. To maximize Oracle® Business Intelligence Enterprise Edition performance, you need to monitor, analyze, and tune all the Fusion Middleware / BI components. This guide describes the tools that you can use to monitor performance and the techniques for optimizing the performance of Oracle® Business Intelligence Enterprise Edition components.

You can find new updated copy of OBIEE Tuning Guide Whitepaper on Support note OBIEE 11g Infrastructure Performance Tuning Guide (Doc ID 1333049.1)

Disclaimer: All tuning information stated in this guide is only for orientation, every modification has to be tested and its impact should be monitored and analyzed. Before implementing any of the tuning settings, it is recommended to carry out end to end performance testing that will also include to obtain baseline performance data for the default configurations, make incremental changes to the tuning settings and then collect performance data. Otherwise it may worse the system performance.

EPM Architecture: Financial Performance Management Applications

This is the third post on Oracle EPM System Architecture. It will cover all Financial Performance Management Applications, namely Financial Management, Essbase Analytics Link, Planning, Profitability and Cost Management, Strategic Finance and Disclosure Management. Please be aware of the fact that I also updated the previous posts on Foundation and Reporting and Analysis based on the feedback I got so far.

[Read More]

HPCM - HPCM Standard Costing Generating >99 Calc Scipts

HPCM Standard Profitability calculation scripts are named based on a documented naming convention. From, the script name = a script suffix (1 letter) + POV identifier (3 digits) + Stage Order Number (1 digit) + “_” + index (2 digits) (please see documentation for more information (

This naming convention results in the name being 8 characters in length i.e. the maximum number of characters permitted calculation script names in non-unicode Essbase BSO databases. The index in the name will indicate the number of scripts per stage. In the vast majority of cases, the number of scripts generated per stage will be significantly less than 100 and therefore, there will be no issue. However, in some cases, the number of scripts generated can exceed 99.

[Read More]

Friday Nov 30, 2012

Essbase Analytics Link (EAL) - Performance of some operation of EAL could be improved by tuning of EAL Data Synchronization Server (DSS) parameters

Generally, performance of some operation of EAL (Essbase Analytics Link) could be improved by tuning of EAL Data Synchronization Server (DSS) parameters.

a. Expected that DSS machine will be 64-bit machine with 4-8 cores and 5-8 GB of RAM dedicated to DSS.

b. To change DSS configuration - open EAL Configuration Tool on DSS machine.


[Read More]

Thursday Nov 29, 2012

Using Transaction Logging to Recover Post-Archived Essbase data

Data recovery is typically performed by restoring data from an archive.  Data added or removed since the last archive took place can also be recovered by enabling transaction logging in Essbase.  Transaction logging works by writing transactions to a log store.

[Read More]

Friday Nov 16, 2012

EPM Architecture: Reporting and Analysis

This is a revised post on Reporting and Analysis. Beside the discussion of the Reporting and Analysis core component, which was part of the original post, the reporting tools WebAnalysis, Financial Reporting and Interactive Reporting, have been added to this article. 

[Read More]

Tuesday Nov 13, 2012

EPM Architecture: Foundation

This post is the first of a series that is going to describe the EPM System architecture per component. During the following weeks a couple of follow up posts will describe each component. Shared Services, EPMA and Calculation Manager architecture are covered by this post.

[Read More]

Tuesday Oct 30, 2012

Error java.lang.OutOfMemoryError: getNewTla using Oracle EPM products

Running into a Java out of memory error, it is very common behaviour in the field that the Java heap size will be increased. While this might help to solve a heap space out of memory error, it might not help to fix an out of memory error for the Thread Local Area (TLA). Increasing the available heap space from 1 GB to 16 GB might not even help in this situation.

[Read More]

Thursday Oct 11, 2012

Essbase BSO Data Fragmentation

Essbase BSO Data Fragmentation

Data fragmentation naturally occurs in Essbase Block Storage (BSO) databases where there are a lot of end user data updates, incremental data loads, many lock and send, and/or many calculations executed.  If an Essbase database starts to experience performance slow-downs, this is an indication that there may be too much fragmentation.  See Chapter 54 Improving Essbase Performance in the Essbase DBA Guide for more details on measuring and eliminating fragmentation:

Fragmentation is likely to occur in the following situations:

  • Read/write databases that users are constantly updating data
  • Databases that execute calculations around the clock
  • Databases that frequently update and recalculate dense members
  • Data loads that are poorly designed
  • Databases that contain a significant number of Dynamic Calc and Store members
  • Databases that use an isolation level of uncommitted access with commit block set to zero.
[Read More]