Friday Aug 24, 2012
Wednesday Jul 18, 2012
By Ann Donahue on Jul 18, 2012
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
By sujata on Jul 16, 2012
Issue: Charts are no longer rendering in IE or FF after applying OBIEE 188.8.131.52.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
By User809526-Oracle on Jul 13, 2012
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
By Jane Story-Oracle on Jun 26, 2012
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
By Ahmed Awan-Oracle on Jun 05, 2012
Applies To: 184.108.40.206, 220.127.116.11
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:
Tuesday May 22, 2012
By sujata on May 22, 2012
With the release of HFM 18.104.22.168.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]
By Keith Rosenthal-Oracle on May 22, 2012
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]
Wednesday May 16, 2012
By Ahmed Awan-Oracle on May 16, 2012
Applies to EPM 22.214.171.124 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.
By sujata on May 16, 2012
If you are using Internet Explorer, we strongly recommend you to use IE9 in order to get the best performance with 126.96.36.199. With the 188.8.131.52 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.
By Ahmed Awan-Oracle on May 16, 2012
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.
Monday May 07, 2012
By Ahmed Awan-Oracle on May 07, 2012
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:
# BI Publisher
Monday Apr 30, 2012
By sujata on Apr 30, 2012
Please note that Hyperion Business Rules (HBR) is no longer supported with the 184.108.40.206 release. You will need to migrate Business Rules to Calc Manager in 220.127.116.11. 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
By Ahmed Awan-Oracle on Apr 18, 2012
Web catalog upgrade from 10G to 18.104.22.168 or 22.214.171.124 or 126.96.36.199 corrupted some user permissions, this may cause slow user login time and also slowness in accessing the dashboard.
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
By Ann Donahue on Apr 10, 2012
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]
A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]
Popular Whitepaper Downloads
- EPM 11.1.2.x Essbase - DATAEXPORT calc command and CALCLOCKBLOCK/LOCKBLOCK
- Zero Based Budgeting (ZBB) Considerations within Hyperion Planning
- Financial Management 188.8.131.52
- EPM 11.1.2.x - Binding Host Name to have Essbase bind only to the IP address
- Essbase BSO Parallel Calculation and Calculator Cache
- OBIEE 11.1.1 - Tuning Guide Script v1
- Adding trim functions to the column expressions in ODI
- EPM 184.108.40.206.500 - Enable HFM Thin Driver on Exalytics server
- Getting started with Weblogic Scripting Tool for OBI
- Exalytics OVM 3.2.x - Increase Send Queue Length (txqueuelen) for VM guest (DomU) VIF