Thursday Jul 19, 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]

Tuesday Jul 17, 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]

Wednesday Jun 27, 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]

Wednesday Jun 06, 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  


Wednesday May 23, 2012

EPM 11.1.2.2 - HFM Rules Editor no longer exists in HFM 11.1.2.2

 With the release of HFM 11.1.2.2.000, the Rules Editor is no longer available.  Per the readme file (http://docs.oracle.com/cd/E17236_01/epm.1112/hfm_1112200_readme.pdf), you will need to download and install Notepad++, which is a free product.

[Read More]

EPM 11.1.2 - EAS Jobs Taking Longer than 5 Minutes Launch Multiple Essbase Sessions

If a job initiated from EAS takes longer than 5 minutes, a new Essbase connection and a new Essbase session will be launched before the first session has completed.  An Essbase connection and a new session will be launched at 5 minute intervals while the job is running in Essbase, creating multiple sessions per job and unnecessarily creating a heavier load on the Essbase agent.

[Read More]

Thursday May 17, 2012

EPM 11.1.2.2 - Enhance support for LDAP/MSAD connection timeouts

Applies to EPM 11.1.2.2 release.

  • Connection timeout (after inactivity in the system) by Firewall or Load Balancer in front of the LDAP/MSAD servers is handled better by recreating the master context every 15 minutes (as needed basis).
  • Can be tuned from the css.xml file by setting the parameter <masterContextTimeToLive>. Oracle recommends to set this value to slightly lower than the timeout on the Firewall or Load Balancer in front of the LDAP/MSAD servers.

EPM 11.1.2.2 - Performance with IE for 11.1.2.2 release

If you are using Internet Explorer, we strongly recommend you to use IE9 in order to get the best performance with 11.1.2.2. With the 11.1.2.2 release, we now use Oracle ADF (Application Development Framework). IE9 leverages Oracle ADF much better than IE7 or IE8 and will give you the best performance. 


EPM 11.1.2 - How to resolve high memory usage for HFM (Financial Management)

If you use Oracle Database Client 10.2.x or 11.1.x for Financial Management, you must set the StmtCacheSize registry setting for Oracle OLE DB to 10 on all Financial Management application servers and Web servers. This is due to a memory issue in Oracle Provider for OLE DB. The registry setting path is: Hkey_Local_Machine\Software\Oracle\Key_Homename\Oledb. Important Note that the 11.2.x Oracle Database Client should not be changed.

To resolve the high memory usage, enable Statement Caching. The configured value must not be zero. The recommended value is between and 1 and 10.

1. Edit the registry value: Hkey_Local_Machine\Software\Oracle\Key_Homename\Oledb Value Name: StmtCacheSize Value (decimal):1, where Key_Homename refers to the appropriate Oracle Home.

2. Stop and restart the Financial Management application processes.

Reference:http://docs.oracle.com/cd/E17236_01/epm.1112/readme/hfm_1112200_readme.html


Tuesday May 08, 2012

OBIEE 11.1.1 - Increase Timeouts in Oracle HTTP Server (OHS) plug-in (mod_wl_ohs.conf)

If you are seeing "Failure of server APACHE bridge" error when try to open large BIP report. This is due to your current Oracle HTTP Server (OHS) timeout parameters defined in plug-in file that are reaching amount of time the plug-in waits for a response to a request from WebLogic Server.

For each <Location> section in OHS file mod_wl_ohs.conf, set the following timeouts for example:

<Location /analytics>
      SetHandler weblogic-handler
       WebLogicCluster <servername>:9704
       WLIOTimeoutSecs 6000
       WLSocketTimeoutSecs 600
</Location>

# BI Publisher
<Location /xmlpserver>
     SetHandler weblogic-handler
     WebLogicCluster <servername>:9704
     WLIOTimeoutSecs 6000
     WLSocketTimeoutSecs 600
</Location>


 

Tuesday May 01, 2012

EPM 11.1.2.2 - Hyperion Business Rules de-supported in this release

Please note that Hyperion Business Rules (HBR) is no longer supported with the 11.1.2.2 release. You will need to migrate Business Rules to Calc Manager in 11.1.2.2. The statement of direction for HBR can be found here - Hyperion Business Rules Statement of Direction (Support Doc ID 1448421.1) - https://support.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1448421.1

The steps for migrating from Business Rules to Calc Manager can be found here (see pages 22-23 regarding the steps needed to be taken depending on your installation type - http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_1112200.pdf


Wednesday Apr 18, 2012

OBIEE 11.1.1 - Web catalog upgrade from 10g to 11g corrupted some user permissions

Web catalog upgrade from 10G to 11.1.1.3 or 11.1.1.5 or 11.1.1.6 corrupted some user permissions, this may cause slow user login time and also slowness in accessing the dashboard.

Resolution:

  • Cleanup Web catalog via instanceconfig.xml using the steps documented in "Validating the Catalog" in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
  • Runcat cmd line commands to cleanup all permissions that appears to be Invalid.

Tip: It is recommended to run all above tasks each & every time content is delivered from a development environment into the production environment (e.g. weekly), as part of the OBIEE administrator's regular backup & maintenance of the catalog.

[Read More]

Tuesday Apr 10, 2012

Essbase 11.1.2 - AgtSvrConnections Essbase Configuration Setting

AgtSvrConnections is a documented Essbase configuration setting used in conjunction with the AgentThreads and ServerThreads settings. Basically, when a user logs into Essbase, the AgentThreads connects to the ESSBASE process then the AgtSvrConnections will connect the ESSBASE process to the ESSSVR application process which then the ServerThreads are used for end user activities. In Essbase 11.1.2, the default value of the AgtSvrConnections setting was changed to 5. In previous Essbase releases, the AgtSvrConnections setting default value is 1.

It is recommended that tuning the AgtSvrConnections settings be done incrementally by 1 or 2 maximum and based on the number of concurrent Set Active/Clear Active calls.

[Read More]

Oracle BI Publisher 11.1.1 - Quick Start Guide

This Guide covers following topics:

  1. Administering BI Publisher
  2. Creating Data Models and Reports
  3. Viewing and Scheduling Reports 

Click here to Download this Quick Start Guide.


About

A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today