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 11.1.2.2 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 11.1.2.2 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: http://docs.oracle.com/cd/E17236_01/epm.1112/esb_dbag/daprcset.html

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]

Wednesday Sep 19, 2012

OBIEE 11.1.1 - How to enable HTTP compression and caching in Oracle iPlanet Web Server

1. To implement HTTP compression / caching, install and configure Oracle iPlanet Web Server 7.0.x for the bi_serverN Managed Servers (refer to document http://docs.oracle.com/cd/E23943_01/web.1111/e16435/iplanet.htm)

2. On the Oracle iPlanet Web Server machine, open the file Administrator's Configuration (obj.conf) for editing. (Guidelines for modifying the obj.conf file is available at http://download.oracle.com/docs/cd/E19146-01/821-1827/821-1827.pdf)

3. Add the following lines in obj.conf file inside <Object name="default"> . </Object> and restart the Oracle iPlanet Web Server machine:

#HTTP Caching

<If $path =~ '^(.*)\.(jpg|jpeg|gif|png|css|js)$'>
ObjectType fn="set-variable" insert-srvhdrs="Expires:$(httpdate($time + 864000))"
</If>

 

<If $path =~ '^(.*)\.(jpg|jpeg|gif|png|css|js)$'>
PathCheck fn="set-cache-control" control="public,max-age=864000"
</If>

 

#HTTP Compression

 

Output fn="insert-filter" filter="http-compression" vary="false" compression-level="9" fragment_size="8096"


Tuesday Sep 18, 2012

HPCM 11.1.2.2.x - How to find data in an HPCM Standard Costing database

When working with a Hyperion Profitability and Cost Management (HPCM) Standard Costing application, there can often be a requirement to check data or allocated results using reporting tools e.g Smartview. To do this, you are retrieving data directly from the Essbase databases related to your HPCM model. For information, running reports is covered in Chapter 9 of the HPCM User documentation. The aim of this blog is to provide a quick guide to finding this data for reporting in the HPCM generated Essbase database in v11.1.2.2.x of HPCM.


[Read More]

Friday Aug 24, 2012

Performance of Run Time Prompt Limits in Calc Manager

When using run time prompt limits in Calc Manager, performance is faster when using Essbase member list functions that are explicitly defined and accessed directly in Planning.[Read More]

Changing the Planning Language

If Essbase is set to a language other than English, the language should be changed in Planning to improve the stability of the Planning JVM during periods of heavy usage. In order to change the Planning language, open the setCustomParamsPlanning.bat (Windows) or SetCustomParamsPlanning.sh (Unix) located in the MIDDLEWARE_HOME/user_projects/epmsystem1/bin folder.[Read More]

Wednesday Jul 18, 2012

Essbase “Virtual Cube” BSO Tuning

Essbase “Virtual Cube” BSO Tuning

An Essbase “virtual cube” is a specific design setup where transparent partitioning is used and consists of multiple source databases that are partitioned to a single target Block Storage (BSO) database.  The single target BSO database is empty meaning contains no data.  The purpose of this design setup is so that end users have one consolidated BSO cube for reporting.  In some cases, the target BSO database may have different dynamic calc member formulas then the source databases.  Also, the target BSO database may have more dimensions to accommodate the source databases and may have different sparse/dense configuration since source databases are tuned with data accordingly.

The Essbase Database Administration Guide mentions how to tune Essbase BSO databases that contains data; however, there is no documentation on how to tune a BSO database that contains no data like in a “virtual cube” setup. 

[Read More]

Monday Jul 16, 2012

Charts in BI not rendering after applying OBIEE 11.1.1.6.2BP1

Issue:  Charts are no longer rendering in IE or FF after applying OBIEE 11.1.1.6.2 BP1

The reason that charts are failing to render is due to the fact that our update process does not touch the custom directories (skins, styles). It will only update the default skins and styles directories (s_blafp and sk_blafp). The reason is that we do not want to overwrite any customizations done by customers / partners.

Note: If you are using a custom skins directory, you will have to copy the BIChart.swf from the default directory or the install directory into your custom skins directory. If you do not replace the file, the charts will not render. This change requires that the OracleBI Presentation Services Component be restarted via the opmnctl process as well as for the browser cache to be cleared. Once that has been done, you will be able to render the charts.

[Read More]

Friday Jul 13, 2012

Oracle Hyperion Financial Management (HFM) Configurable Dimensions FAQ

What is Configurable Dimensions?

Configurable Dimension allows the HFM administrator to set the number of custom dimensions in the application. For each dimension it is possible to set the size of the dimension and give a short name and a long name (alias).

[Read More]

Tuesday Jun 26, 2012

HPCM 11.1.2.x - Outline Optimisation for Calculation Performance

When an HPCM application is first created, it is likely that you will want to carry out some optimisation on the HPCM application’s Essbase outline in order to improve calculation execution times. There are several things that you may wish to consider.

[Read More]

Tuesday Jun 05, 2012

OBIEE 11.1.1.5 or above: Admin Server unavailability is not impacting OBIEE tasks

Applies To: 11.1.1.5, 11.1.1.6

Admin Server unavailability is not impacting OBIEE tasks. By setting virtualize tag to true (in EM) to manage multiple LDAP providers, it is enabling failover and HA on authentication and authorization inside OBIEE. Following are the test cases used for testing impact on OBIEE, if Admin Server is not available:

 

a. Test 1: Admin Server crashes and impact on OBIEE

Scenario: All OBIEE components are up and running.

b. Test 2: Admin Server had not been started and impact on OBIEE.

Scenario: OBIEE Server bi_server1 is started, but Admin Server isn’t

For more details on each of the above test, click here to download the Test Results

Links to Official documentations below:  

http://docs.oracle.com/cd/E23943_01/bi.1111/e10543/privileges.htm#BIESC6077

http://docs.oracle.com/cd/E23943_01/bi.1111/e10543/privileges.htm#BABHFFEI

http://docs.oracle.com/cd/E23943_01/bi.1111/e10543/authentication.htm#BIESC6075