X

PBCS: For 17.08 and Higher - Understand Business Rules using Calc Manager Log Messages

Introduction Starting in PBCS 17.08, the Log Messages panel in Calculation Manager has been improved to provide better messaging in order to help identify and optimize business rule logic. This blog post is intended to provide the details of these improvements and how to best utilize Calculation Manager Log Messages. Background Log Messages are only provided after execution of business rules within Calculation Manager.  After execution has completed, a new tab “Log Messages” will...

Friday, October 6, 2017 | 2. EPM | Read More

A Simple Guide to HFM Java API

Oracle EPM 11.1.2.4 is available since quite a while now. A lot of customers have adopted this release and start looking into automating common tasks to further increase the user experience and lower the maintenance efforts. Using the Java API, common HFM tasks can be automated easily. This post will provide first steps to log into HFM and run a Consolidation using the Java API. In an earlier blog post, I described the 11.1.2.4 HFM Architecture. Some may remember, that one of...

Wednesday, July 19, 2017 | 2. EPM | Read More

SAML2.0 SSO for PBCS and Oracle Cloud

SSO for Oracle Cloud: Oracle Cloud uses the SAML 2.0 protocol to integrate internal and external users. Oracle Cloud doesn’t support all features of this standard. Oracle Cloud uses the SAML standard to enable secure, cross-domain communication between Oracle Cloud and other SAML-enabled Oracle systems, as well as a selected number of non-Oracle identity management systems located on-premises or in a different cloud. Oracle Cloud SSO also includes a failback mechanism.If SSO...

Wednesday, March 22, 2017 | System Security | Read More

OBIEE 12c: Use HTTP Compression / Caching in OHS 12c for DV mobile

If you intend to use DV on mobile, in order to improve end user experience over slow mobile 4G/LTE networks (with high latency) it is recommended to install Oracle HTTP Server (OHS) 12c and implement the following HTTP compression / caching settings in httpd.conf file: #un-comment or add this line LoadModule deflate_module "${PRODUCT_HOME}/modules/mod_deflate.so" <IfModule mod_deflate.c>       SetOutputFilter DEFLATE </IfModule> ExpiresActive On <IfModule mod_expires.c>      ...

Monday, March 13, 2017 | 1. OBIEE | Read More

Oracle BI Applications on Platform as a Service (PaaS) - Best Practices

The paper provides Oracle’s Best Practices for deploying on Oracle Business Intelligence on Oracle® Cloud Platform as a Service (PaaS), which include Compute, Database Cloud (DBCS), and BI Cloud (BICS) services. The following best practice configurations are based on our real world experiences with installing and configuring Oracle BI Applications and Oracle Business Intelligence on Oracle® Cloud Platform as a Service (PaaS) for key Oracle customers. If below link is not...

Friday, February 3, 2017 | 1. OBIEE | Read More

OBIEE 12c: How to Configure OBIEE to Use Static Contents in Other Web Server

Note: In BIEE 11g the static files / stlyes location is <ORACLE_HOME>/bifoundation/web/app/res directory but in BIEE 12c location is ../domains/bi/servers/obips1/tmp/earmanager/analytics/../res/Below are steps to configure Oracle HTTP Server as the location for static file resource :1. Define a virtual path '/staticfiles' and point it to a physical path '/ohs/bi/bifoundation/web/appv2' by adding a below configuration in httpd.conf file in the OHS instance : Alias...

Friday, October 21, 2016 | 1. OBIEE | Read More

Configuring SSL for EPM 11.1.2.3 & 11.1.2.4 Products

Author: veera.raghavendra.rao@oracle.com This blog is all about how to configure Full SSL for EPM Products. Current document contains all steps that are needed to configure EPM Products in single Node. Steps Include: WebLogic Server (Creation of jks keystores) Oracle HTTP Server : using Oracle Wallet Essbase Server : using Oracle Wallet IIS Server Enabling SSL for Java Applications using EPM Config Utility Configuring SSL enabled Database Configuring SSL enabled External LDAPDirectories...

Wednesday, September 21, 2016 | 2. EPM | Read More

OBIEE Login Fails while searching users from a Large MSAD

Author: veera.raghavendra.rao@oracle.comProblem: OBIEE Login Failed due to max timeout to search and retrieve a user from the base DN when there are multiple sub trees and large user store Oracle Support Doc ID: Using User Filter to Reduce the Number of Users Retrieved from Microsoft Active Directory (MSAD) (Doc ID 1227144.1) Example: Users are from multiple sub trees like below: CN=auuser1,OU=Users,OU=AU,DC=paceal,DC=oracle,DC=com CN=causer1,OU=Users,OU=CA,DC=paceal,DC=oracle,DC=co...

Friday, September 16, 2016 | 1. OBIEE | Read More

OBIEE 12c: Configuring Kerberos SSO for OBIEE 12c

Author: veera.raghavendra.rao@oracle.com Problem Statement: Existing Whitepaper to Config Kerberos SSO for OBIEE is not yet updated for OBIEE 12c (1274953.1) Many customers are raising lots of questions when deploying using DES and AES256 encryption. Additionally, since OBIEE 12c, there was some changes in Security Configuration while Enabling SSO, as SSO Provider Option disappeared in OBIEE 12c UI which is creating lots of confusions. Attached are the Documents toconfigure...

Tuesday, September 13, 2016 | 1. OBIEE | Read More

11g to 12c Migration Fails - "common.components.home" is not supplied

Getting "oracle.security.jps.service.idstore.IdentityStoreException: JPS-02600: libOvd required system parameter of "common.components.home" is not supplied in the JVM command line" error while trying to create 11g bar file, please try adding the following parameter as JAVA_OPTIONS the bi-migration command. “-Dcommon.components.home=$MW_HOME/oracle_common”For example: java -jar -Dcommon.components.home=$MW_HOME/oracle_common $MW_HOME/Oracle_BI1/bi-migration-tool.jar out...

Thursday, September 8, 2016 | 1. OBIEE | Read More

EPM 11.1.2.x – Planning/PBCS Best Practices for BSO Business Rule Optimisation

1. Introduction This document is intended to provide best practices for Business Rule Optimisation for Planning and PBCS models. It will cover items which can be edited within the script only i.e. syntax. Essbase.cfg settings for on premises Planning will not be discussed in this blog. 2. Environment Setting Below are recommended Calculation Commands, which are the elements that instruct the business rule how to execute the calculations. SET UPDATECALC OFF turns off intelligent...

Thursday, April 28, 2016 | 2. EPM | Read More

OBIEE 12c: Integrating BI 12c with HFM

The document describes the steps to configure Hyperion Financial Management with OBIEE 12c. Hyperion Financial Management can be used as a data source in OBIEE 12c. Hyperion Financial Management 11.1.2.3.x and 11.1.2.4.x versions use the ADM thin driver which can be installed and configured on both windows and Linux. HFM communicates with java Host process. Java host should be up and running to import HFM application online or offline. By following the document, one should be...

Wednesday, April 6, 2016 | 1. OBIEE | Read More

OBIEE 12c: Creating a Custom Layer in MapViewer for use with VA

Adding a custom map layer to be used by VA is not trivial but is straightforward. There are three basic steps: · Convert the map data shapefile to a geoJSON file.  · Create a metadata configuration file based on the geoJSON file to be used for display and indexing. · Upload the geoJSON and configuration files to MapViewer. After completing these steps, the new map layer is ready for use in VA. For more details see How To Add A Custom Map Layer (geoJSON) toOBIEE 12c (12.2.1) Visual...

Monday, February 29, 2016 | 1. OBIEE | Read More

OBIEE12c: Best Practices Guide for Infrastructure Tuning Oracle® Business Intelligence Enterprise Edition 12c (12.2.1)

One of the most challenging aspects of performance tuning is knowing where to begin. This guide describes techniques for monitoring and optimizing the performance of Oracle Business Intelligence Enterprise Edition (OBIEE) 12c components. This document is written for people who monitor performance and tune the components in a BI environment. It is assumed that readers know server administration, Oracle® FusionMiddleware (FMW), hardware performance tuning fundamentals,...

Friday, February 12, 2016 | 1. OBIEE | Read More

OBIEE 12c: Increasing the Node Manager JAVA Heap Size

In BI 12c, Node Manager is monitoring not only Web logic Managed Servers but also BI System components. We noticed sometimes that when we are starting all the processes using start.sh, Node Manager is taking long time to start, so in order to fix this, we must increase the java heap size for Node Manager. File "commBaseEnv.sh" containing the Node Manager Java Heap is located @ <ORACLE_HOME>/oracle_common/common/bin. Please update the following MEM_ARG parameter from default of...

Wednesday, February 3, 2016 | 1. OBIEE | Read More

OBIEE 12c: Remove Init block users from the catalog

In BI 12c, it is highly recommended to move to Fusion Middleware Security model instead of using initialization (init) blocks for authentication and authorization, because Data Visualization (DV) doesn't authenticate against init blocks.  When moving from init block security to FMW Security, the users will not be able to login because the accounts were created in the Web Catalog with initialization blocks are not valid any more. In order for the user to login successfully,...

Tuesday, February 2, 2016 | 1. OBIEE | Read More

OBIEE 12c: How to Revoke/Grant Data Visualizations Permissions using WLST

In BI 12c, Oracle introduced Data Visualizations (DV). By default anyone who belongs to BI Content Author has access to Data Visualization. If for some reason the customer wants to prevent the users from accessing the Data Visualizations, then the customer will have to revoke the Data Visualizations permissions from BI Content Author/BI Author (default roles). The administrator user can revoke/grant DV permissions from WLST using these scripts. How to execute the scripts:     1)...

Thursday, January 14, 2016 | 1. OBIEE | Read More

Configuring BI 12c with IIS 8.5

BI 12c supports IIS 7.5 and 8.5 redirection. This document explains the steps to proxy BI requests through IIS 8.5. https://blogs.oracle.com/pa/resource/IIS8.5-BI12c.pdf

Tuesday, December 15, 2015 | 1. OBIEE | Read More

OBIEE 12c: External Subject Area Cache Configuration

Data Blending or Mashup is a new Concept in OBIEE 12c where you can blend your own data with corporate data. External Subject Area Cache aka XSA Cache is new mechanism for caching Excel Files for data blending in databases. This document describes the steps required for configure External Subject Area Cache for Data Blending. Please click here to download this document. 

Friday, December 11, 2015 | 1. OBIEE | Read More

OBIEE 12c: User's group and application role are not applied

Sometimes in OBIEE 12c, you are sure that everything is set properly, and still the user does not have the expected permission. Groups and application roles are properly assigned in Weblogic console and EM. But still, when you log in OBIEE with this user and go to My Account, the roles expected are not there. This happens due to OPSS cache. Duration can be reduced by adding the following property with the right value in Middleware\Oracle_Home\user_projects\domains\bi\config\fmw...

Tuesday, December 1, 2015 | 1. OBIEE | Read More

What you need to know on OBIEE 12c for a successful upgrade

In the document attached, you will find important information on what have changed between 11g and 12c. All you need to know to be able to upgrade successfully from 11g is here.

Tuesday, November 17, 2015 | 1. OBIEE | Read More

How to display images in BICS

For security reasons, it is not currently possible to add images in BICS dashboard using a link like it is done in OBIEE on-premise. However it is possible to display images by using blob columns. The Apex application attached can be used to upload the image in BICS database. The document attached explains how to use this image in a dashboard page.

Saturday, October 10, 2015 | 5. BICS | Read More

EPM 11.1.2.x - Populating Today’s Date in Planning/PBCS with a Business Rule

In a previous CEAL blog, we have discussed how to calculate dates in Planning/PBCS: https://blogs.oracle.com/pa/entry/calculations_using_dates_stored_in As discussed in that blog, for dates in Planning/PBCS, Essbase stores the date as a numerical value e.g. a Start Date of 21st May 2015 would be stored as 20150521. In a non-Planning/PBCS Essbase database, date functionality exists using the number of seconds elapsed since midnight,January 1, 1970 i.e. a non-numerical format...

Monday, July 27, 2015 | 2. EPM | Read More

EPM 11.1.2.x Essbase - DATAEXPORT calc command and CALCLOCKBLOCK/LOCKBLOCK

All dynamic member calculations, whether in an outline member formula or a business rule or calc script, will be calculated using the CALCLOCKBLOCK DEFAULT setting. When running a DATAEXPORT calc script, it is possible to use SET LOCKBLOCK within the script. However, it may not be possible for this setting to be used for the entire export. With DATAEXPORTOPTIONS "DataExportDynamicCalc ON”, only stored blocks will use the SET LOCKBLOCK settingin the script (e.g. Set LOCKBLOCK...

Monday, June 29, 2015 | 2. EPM | Read More

Zero Based Budgeting (ZBB) Considerations within Hyperion Planning

Zero based budgeting (ZBB) applications are becoming increasingly popular as a way to develop a budget, especially for lower growth organizations that are interested in cutting costs. The most significant difference between ZBB applications and traditional budget applications are the level of details captured. Where traditional budgeting applications plan an expense item directly or using a price X quantity formula,ZBB applications will plan every line item related to that...

Friday, May 22, 2015 | 2. EPM | Read More

Financial Management 11.1.2.4

The new Oracle EPM System 11.1.2.4 was released recently and it has some great enhancements especially for Financial Management. As one can see from the new Support Matrix (http://www.oracle.com/technetwork/middleware/bi-foundation/oracle-hyperion-epm-system-certific-131801.xls), Financial Management is available on the Exalytics platform now. There were several changes needed on the architecture, tomake this work. Here is an updated architecture diagram, which is valid for...

Friday, February 6, 2015 | 2. EPM | Read More

EPM 11.1.2.x - Binding Host Name to have Essbase bind only to the IP address

Specify a Binding Host Name to have Essbase bind only to the IP address for the specified Binding Host Name. Otherwise, at startup, Essbase binds on all available IP addresses. In EPM 11.1.2.2 / 11.1.2.3 releases, use "ESSBASESERVERHOSTNAME server_name" that identifies the host where your Essbase application process runs. The value must be a valid host name and must map to an IP address assigned to the computer. If ESSBASESERVERHOSTNAME is not specified in essbase.cfg,...

Wednesday, February 4, 2015 | 2. EPM | Read More

Essbase BSO Parallel Calculation and Calculator Cache

Essbase BSO parallel calculation utilizes calculator cache on a per thread basis. This post is to show the relationship between using parallel calculation and calculator cache. For calc parallel and calculator (calc) cache: Calc Parallel specifies the number of threads per calculation execution Calc Cache is memory used per thread If your calculations contain, for example, CALCPARALLEL 9 and 5 users run this script, then (9 threads * 5 users) = 45 concurrentthreads will be used...

Friday, January 30, 2015 | 2. EPM | Read More

OBIEE 11.1.1 - Tuning Guide Script v1

The obiee tuning guide available here https://blogs.oracle.com/proactivesupportEPM/entry/wp_obiee_tuning_guide lists a number of checks for optimization. The script attached here //cdn.app.compendium.com/uploads/user/e7c690e8-6ff9-102a-ac6d-e4aebca50425/f4a5b21d-66fa-4885-92bf-c4e81c06d916/File/861e8391c6334e32f4038fc42b47b8c7/checkobieetuningguidev4_01_2014.zipautomates these checks. It is only reading from the obiee server and it will not modify any values. The script...

Monday, January 5, 2015 | 1. OBIEE | Read More

Adding trim functions to the column expressions in ODI

Background and Issue Description Product: Oracle Business Intelligence Application OBIA Release: 11.1.1.8.1 and above OLTP Source: JDE90/JDE91 While working with one of our customer who was implementing OBIA 11.1.1.8.1 for JDE 9.0 adaptor, it was noticed that some of the data warehouse columns were having trailing spaces after the data was extracted from JDE source system and loaded into the warehouse. On further analysis it was observed that the JDE system stores the data withpadd...

Tuesday, November 18, 2014 | 4. OBIA | Read More

EPM 11.1.2.3.500 - Enable HFM Thin Driver on Exalytics server

In EPM 11.1.2.3.500, FR web is deployed on Exalytics server enable the HFM thin driver by setting "UseHFMThinDriver" to “true” in jconsole (FRConfig.sh). Once enabled then restart all the services on Exalytics and HFM services on Windows. FRConfig.sh is located under:  <Middleware_Home>/EPMSystem11R1/products/financialreporting/bin

Tuesday, November 18, 2014 | 3. Exalytics | Read More

Getting started with Weblogic Scripting Tool for OBI

This white paper will guide you setting up a development environment, get you started with basic script writing, and point you to useful documentation. We will focus on the interactive and script mode, for embedded mode, please refer to the documentation for examples about instantiating the WLST interpreter in your Java code and using it to run WLST commands and scripts. //cdn.app.compendium.com/uploads/user/e7c690e8-6ff9-102a-ac6d-e4aebca50425/f4a5b21d-66fa-4885-92bf-c4e81c06d9...

Thursday, October 16, 2014 | 1. OBIEE | Read More

Exalytics OVM 3.2.x - Increase Send Queue Length (txqueuelen) for VM guest (DomU) VIF

For VM guest (DomU) VIF interface, by increasing the Send Queue Length (txqueuelen) from 32 or 500 to 10000 can increase network performance 50%. a. How to Increase Send Queue Length in Dom0: In Dom0, you need to perform following permanent changes to make the txqueuelen to 10000:1. Run below ifconfig script by crontab and it will automatically set 10000 for all the VIFs:ifconfig | grep -P '^vif\d+\.\d+' |  awk '{system("ifconfig "$1" txqueuelen 10000")}' 2. Edit /etc/rc.local...

Sunday, September 21, 2014 | 3. Exalytics | Read More

Using the @CURRMBR Function

Using the @CURRMBR Function Essbase provides a suite of calculation functions to facilitate the definition and development of complex member formula calculations. The @CURRMBR calculation function is especially useful with scoping and managing complex calculations. The @CURRMBR (dimension) function is used to return the name of the member currently being calculated in the specified dimension. When using the @CURRMBR calculation function, take intoconsideration if the...

Tuesday, September 9, 2014 | 2. EPM | Read More

Configuring OBIEE 11.1.1.7.x with Full End to End SSL

Author: veera.raghavendra.rao@oracle.com What do we need to configure SSL:1. CA Root Certificate 2. CA Intermediate Certificate (if exists) 3. Java Keystores :: Identity Keystore and Trust Keystore 4. OBIEE Server Certificate 5. If External LDAP Directory like Oracle Internet Directory running in SSL    OID Server’s CA Root Certificate    OID Server’s CA Intermediate Certificate (if exists)    OID Server CertificateThis is a Test Environment where OBIEE is configured in SSL...

Thursday, July 17, 2014 | System Security | Read More

OBIEE 11.1.1 - In case of Firewalls, OBIEE Scheduler may fails to Restart via OPMN or during BI configuration

Issue: If you have Firewall between OBIEE Server and Oracle Database machine, the OBIEE Scheduler component may fails to restart via OPMN or during BI configuration. Workaround:The firewall is setup with 'Urgent Flag'. As per firewall documentation, the Urgent Flag cannot be disabled. It is a global setting and would affect all traffic going in and out in organization. So the issue can be resolved by setting DISABLE_OOB=ON in the SQLNET.ora for BI Scheduler.The firewall is...

Tuesday, July 15, 2014 | 1. OBIEE | Read More

Essbase Outline Rebuilding vs. Migrating After Major Release Upgrade

The 11.1.2.3 Essbase Readme document has been updated to include a change in recommendation with regard to rebuilding versus migrating the Essbase outlines between major release upgrades.  This represents a change in the upgrade process to ensure outlines take advantage of any new structures, features and functionality introduced in the major release. After a major release upgrade, be sure to rebuild all outlines on the new release to eliminate any potential issue where theoutl...

Saturday, July 12, 2014 | 2. EPM | Read More

OLAP_MAX_CONNECTIONS Property Considerations

The OLAP_MAX_CONNECTIONS property controls the maximum number of connections from Planning to Essbase. The default setting is 10, but the property can be increased to allow for more concurrent Essbase connections. The Hyperion Planning Administrator’s Guide recommends a setting of 20 for 100 users and 100 for 500 users. Although the OLAP_MAX_CONNECTIONS property can be increased, the amount the setting can be increased is constrained by the SERVERTHREADSsetting in Essbase....

Monday, July 7, 2014 | 2. EPM | Read More

OBIEE 11.1.1 - Tips for In-place Upgrade from 11.1.1.6 to 11.1.1.7.x

Tips: – Use the Test to Production (T2P) / cloning process (movement scripts). For example: – Clone up the existing 11.1.1.6 environment.– Move the cloned copy to the new location / host (same 11.1.1.6.0 version at this point).– Patch new location / host (11.1.1.6) to the 11.1.1.7 level.– Switch to Production. – How to use movement scripts for OBIEE: 20.1 Introduction to the Movement Scripts , for details refer to: http://docs.oracle.com/cd/E29542_01/core.1111/e10105/clone.htm#CACH...

Monday, June 2, 2014 | 1. OBIEE | Read More

Error Connecting to Planning Application from Smartview

When the OU of a user is changed in the external provider, users can potentially have issues connecting to Planning applications from Smartview.  However, users can still log into Planning just not Smartview. Below are the error messages found in Smartview, Essbase and Shared Services when the OU of a user is changed in the external provider and not synced with Essbase security: · Planning user connecting to Smartview error: “Cannot open cubeview.  Essbase error 1054060. Essbase...

Tuesday, April 22, 2014 | 2. EPM | Read More

BI Web service security client - authentication operations for 11.1.1.6 and 11.1.1.7.x

This wlst/python script connects to bi security web service to authenticate a user specified in the "ObieeWebServiceClient.properties" file. In 11.1.1.7, this calls: getAuthenticatedUserWithLanguageAndProperties operation of the /bisecurity/service web service. In 11.1.1.6, this calls authenticate operation of the /bimiddleware/security/service web service. This returns as part of the xml response the user unique identifier (guid) and other permissions/roles for the user. This...

Monday, March 24, 2014 | 1. OBIEE | Read More

OBIEE 11.1.1 - Advanced Usage of nqcmd command

Following are the useful nqcmd command lines arguments: a. In your environment set the "export SA_NQCMD_ADVANCED=yes" b. Following is the description of the nqcmd command line arguments for BIServer (nqsserver) testing: -d = Datasource.-u = username.-p = password.-s = inputsqlsfile.-o = outputfile. counters will be in outputfile_Counters.txt.-td <secs> = timeduration in secs. nqcmd will run until <secs> elapses.-qsel r = select queries random manner from inputsqlsfile.-ds <secs> ...

Thursday, February 27, 2014 | 1. OBIEE | Read More

BI Checks with WLST - Enable debug, login and parse logs - Part 3

This third post continues with the BIEE 11.1.1.7 Security checks using WLST and Python scripting. This time its all about: * Checks and Displays whether Virtualize=true property is added in the identity store or not, as well as compare with the number of authentication providers. You can use the virtualize_add_remove.py script to change this automatically, but a restart is needed if changed.* Enabling Debug in the target server (e.g. bi_server1) for weblogic security...

Monday, February 3, 2014 | 1. OBIEE | Read More

OBIEE 11.1.1 - Tuning Guide Whitepaper - update available

New updates have been made to the OBIEE "Best Practices Guide for Infrastructure Tuning" whitepaper. This updated whitepaper is for 11g Release 1 (11.1.1.6, 11.1.1.7) and can be downloaded from the My Oracle Support knowledge article: Doc ID 1333049.1 The new revised document contains the following useful new and/or updated tuning items: Optimized JVM switches for Oracle JRockit / Sun JVM / IBM JVM etc New tuning parameters settings / values for JavaHost / OPIS / OBIS components. I...

Friday, January 31, 2014 | Performance Tuning | Read More

BI Check with WLST - SQL Datasources part 2

This second post continues with the BIEE security checks using WLST and python. This time, the following information is gathered about BISQLGroupProvider: *  looking for SQLGroupProvider in the configured providers *  retrieving the SQL queries *  retrieving the JDBC source details *  testing the connection pool, for each server that uses it (make sure your BI server is up and running)*  testing the SQL queries directly against the database, with the test.user and test.group...

Tuesday, January 28, 2014 | 1. OBIEE | Read More

BI Check with WLST - Providers and Technical users part 1

 Checking OBIEE 11.1.1.7.1 security configuration manually is relatively time consuming. Using WLST and Python, it is possible to automate most of these tasks. The following script performs checks on OBIEE configuration for version 11.1.1.7.1+ (It will not work for 11.1.1.7.0 or 11.1.1.6) . It is the first of a 3 part series, and the part 1 covers: Providers, technical users and logins tests *    getting provider lists from weblogic *    getting system.user from EM jmx*   ...

Friday, January 24, 2014 | 1. OBIEE | Read More

Essbase 11.1.2.x - Web Launched EAS Console jnlp

When using the web launched EAS Console with internet explorer (http://<servername>:10080/easconsole/console.html) for the first time , it is possible that you will be prompted to open, find or save the easconsole.jnlp. The reason this dialog box appears is because the jnlp files are not associated with a program. In order to proceed, you will need to save the file e.g. to your desktop. Navigateto the file’s location using windows explorer. Right click on the file, select...

Tuesday, January 21, 2014 | 2. EPM | Read More

OBIEE 11.1.1: Load Testing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Using Oracle Load Testing (OLT) 12.x

Published whitepaper on Load Testing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Using Oracle Load Testing (OLT) 12.x) which can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1611188.1 (Oracle Support Document 1611188.1)

Tuesday, January 7, 2014 | Performance Tuning | Read More

OBIEE Web services with javascript

OBIEE web services provide a large set of operations on ibots, jobs, metadata, analysis, webcat... http://docs.oracle.com/cd/E21764_01/bi.1111/e16364/soa_overview.htmhttp://docs.oracle.com/cd/E23943_01/bi.1111/e16364/methods.htmA wsdl is provided for these services, and it is common to call them in a process running in Weblogic server (java custom application).  However, it is also possible to call them using javascript in a browser, or in a server with a javascript...

Monday, December 9, 2013 | 1. OBIEE | Read More

Calculations Using Dates Stored in Planning

Planning allows users to enter date values in Planning. For example, a start date can be entered as 11/01/2013 if the format is MM/DD/YYYY. Although the values are entered in date format, it is possible to calculate values based on dates entered. Essbase stores values having a date format as numeric values. In the example above the “Start Date” 11/01/2013 is stored in Essbase as the value 20131101. If the “End Date” is 06/30/2014, you can calculate the number of months between...

Friday, November 22, 2013 | 2. EPM | Read More

EPM Infrastructure Tuning Guide v11.1.2.2 / 11.1.2.3

Applies To: This edition applies to only 11.1.2.2, 11.1.2.3. One of the most challenging aspects of performance tuning is knowing where to begin. To maximize Oracle EPM System performance, all components need to be monitored, analyzed, and tuned. This guide describe the techniques used to monitor performance and the techniques for optimizing the performance of EPM components.TOP TUNING RECOMMENDATIONS FOR EPM SYSTEM: Performance tuning Oracle Hyperion EPM system is a...

Thursday, October 17, 2013 | Performance Tuning | Read More

EPM Client cert authentication

If you are planning to use client cert authentication against EPM (http://docs.oracle.com/cd/E17236_01/epm.1112/epm_security_11121/frameset.htm?ch02s13s04.html), there are a few additional elements to consider on top of the documentation: "SSLVerifyclient required|optional" in Oracle Http Server "OHS". This ssl parameter is , amongst other tasks, using trusted certificates in OHS wallet to filter out client certificates in the digital certificates browser prompt. That is, if...

Thursday, September 26, 2013 | 2. EPM | Read More

Essbase 11.1.2.x - Changing Essbase ODL Logging Levels

ODL (Oracle Diagnostic Logging) information is recorded for both the Essbase agent and the Essbase application server. The level of the logging that is recorded can be amended if required. These are the 2 ODL logs for Essbase: EssbaseAgentODLLogger is for the Essbase agent. This writes to the ESSBASE_ODL.log in MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/Essbase/Essbase DefSvrLogger is for the Essbase application server (ESSSVR). This writesto the <appname>_ODL.log...

Wednesday, September 4, 2013 | 2. EPM | Read More

Grid Diagnostics Replaces MassGridStatistics

An earlier blog entry, https://blogs.oracle.com/pa/entry/planning_11_1_2_massgridstatistics, discussed the Planning 11.1.2.1 MassGridStatistics utility for displaying web form load times. Starting with the 11.1.2.2 release, MassGridStatistics has been replaced by the grid diagnostics functionality located with the Planning web interface. In order to access grid diagnostics, select the Diagnosticsitem followed by the Grids item within the Tools menu. Select the forms you want...

Wednesday, August 21, 2013 | 2. EPM | Read More

Disabling Implied Share for an Essbase Application

Implied share is the default behavior in Essbase where a data relationship is shared explicitly between parent and child members in the outline.  Implied share occurs when a parent has a single child or a parent has only one child of many children that consolidates to the parent in an Essbase outline. If you need to disable all implied shares in a given outline, there is an Essbase configuration setting that can be set in the Essbase.cfg file.  As part of the supported steps,...

Tuesday, July 30, 2013 | 2. EPM | Read More

Performance issues after upgrading Essbase outlines from 11.1.1.x to 11.1.2.x

After upgrading Essbase from the 11.1.1.x to 11.1.2.x releases, run through your sanity tests, such as outline dimension build updates, data loads, calculations, queries, etc.  If you encounter any performance issues on the newer release of Essbase (for either ASO or BSO models) as compared to the previous release, rebuild the problematic outline on the current 11.1.2.x release.  It is possibly that the outline did not migrate properly during the upgrade process.   Once you...

Friday, July 19, 2013 | 2. EPM | Read More

HFM 11.1.2.3 / OBIEE 11.1.1.7 Integration using the new ADM thin driver

For details on configuration steps on-how to perform HFM 11.1.2.3 / OBIEE 11.1.1.7 Integration using the new ADM thin driver, download this pdf document.  

Thursday, July 18, 2013 | 2. EPM | Read More

Exalytics V1 - Exalytics Deployment Guide

The Exalytics Deployment Guide is a whitepaper that explains the different types of deployment scenarios that are supported for the Exalytics platform.  It covers the OBIEE, TimesTen and EPM products.  The whitepaper contains the following topics: Performance, Scalability, Sizing Deployment Scenarios Support Installation Types for OBIEE on Exalytics Patching of Software Disk Storage Considerations, including Storage recommendations for OBIEE, TimesTen and Essbase/EPM Backup and...

Thursday, July 18, 2013 | 3. Exalytics | Read More

OBIEE cluster web SSO - ADFS IdP SAMLv2

We posted how to configure OBIEE for SSO using SAML and ADFS , on a single node previously --> there: https://blogs.oracle.com/pa/entry/obiee_web_sso_with_adfs This post describes  how to perform the same, but with a clustered OBIEE deployment. The main change is regarding the necessary use of aWeblogic RDBMS security store to cache SAML assertions across nodes, as well as the configuration of the load balancer. Download the documents here://cdn.app.compendium.com/uploads/use...

Thursday, July 18, 2013 | 1. OBIEE | Read More

Importing server and private key in Oracle wallet

You want to create a wallet containing your server cert and private key provided by your PKI administrator as a yourcert.p12 file. Let s assume the password for the private key is "mypassword". One way is to: a/ convert this p12 to jks keytool -v -importkeystore -srckeystore yourcert.p12 -srcstoretype PKCS12 -destkeystore yournewkeystore.jks -deststoretype JKS You must use the same password for the new jks and the private key = "mypassword"Import in this keystore, the...

Tuesday, June 18, 2013 | System Security | Read More

Highlights of HPCM 11.1.2.3 New Features

The latest release of HPCM provides several new features as well as performance improvements. V11.1.2.3 provides the following: Standard Profitability – Smart View Integration Detailed Profitability – new calculation rules Detailed Profitability – Essbase Integration Detailed Profitability – Stage Balancing Report Standard Profitability – Smart View Integration There is now Smart View integrationincluded within the HPCM Standard Costing user interface. This will provide a...

Tuesday, June 11, 2013 | 2. EPM | Read More

Highlights of Planning 11.1.2.3 New Features

The latest release of Planning includes several performance improvements as well as some new features not present in earlier releases. Some highlights of the new features include: “Member on the Fly” functionality – For Workforce Planning, Capital Asset Planning, Project Financial Planning and Public Sector Budgeting customers, Planning offers “member on the fly” functionality where end users can dynamically add sparse dimension members and use the added members on a...

Monday, June 3, 2013 | 2. EPM | Read More

OBIEE web SSO with ADFS IdP SAMLv2

The intent of this document is to provide a step by step guide for the configuration and installation of a passive claims-based authentication application. A simple passive claims-based mechanism is illustrated in the below list: 1. User accesses a website (https://obiee-server.us.oracle.com:9804/analytics) to consume its services via a web browser. Such websites are called relying parties.2. If the user is not authorized to use the relying party, the web application...

Monday, May 27, 2013 | 1. OBIEE | Read More

EPM 11.1.2.2: How-to Setup Essbase Clustering on Unix

The steps on how to setup Essbase clustering on the 11.1.2.2 release has changed as compared to the previous releases.  This document goes through how to setup Essbase clustering on Unix on the EPM 11.1.2.2 release.  The information provided in this document has been taken from the EPM 11.1.2.2 Installation and Configuration Guide, which can be found here @ http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_1112200.pdf > Download the Essbase clustering on the...

Friday, May 17, 2013 | Installs and Config | Read More

Essbase Aggregate Storage (ASO) - Incremental Outline Updates Triggers a Full or Light Outline Restructure

When performing incremental updates to an Essbase Aggregate Storage (ASO) outline, depending on the nature of the incremental updates, could trigger either a full or light outline restructure. When an incremental update triggers a full ASO outline restructure while input data and aggregate views exist in the database, Essbase will clear the aggregate views but the input data will remain. When an incremental update triggers a light ASO outline restructure while input dataand...

Wednesday, April 24, 2013 | 2. EPM | Read More

HPCM 11.1.2.2.x - Changing Task Flow Refresh Intervals

  In HPCM, users access the “Job Status” task area to view the status of submitted jobs/task flows. In 11.1.2.2.x, 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. By default this interval is set to 1 minute in 11.1.2.2.x. However, this property is configurable and can be changed if required. Check your refresh interval by...

Thursday, March 21, 2013 | 2. EPM | Read More

Nohup obiee weblogic

To be able to start Weblogic admin server as a process running after the launching shell exits, the boot.properties in weblogic needs to be created. The following commands are the simplest way to achieve this with OBIEE: Type these commands: sh cd /yourmw/user_projects/domains/bifoundation_domain/bin source setDomainEnv.sh java -Dweblogic.management.username=yourweblogicadmin -Dweblogic.management.password=yourpassword-Dweblogic.system.StoreBootIdentity=true -Dweblogic.Name=Adm...

Wednesday, March 13, 2013 | Installs and Config | Read More

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. The issue with forms containing user variables is that form retrieval times can vary considerably depending on...

Thursday, March 7, 2013 | Performance Tuning | Read More

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...

Thursday, January 24, 2013 | 2. EPM | Read More

EPM 11.1.2.2 Architecture: Essbase

Since a lot of components exist to access or administer Essbase, there are also a couple of client tools available. End users typically use the Excel Add-In or SmartView nowadays. While the Excel Add-In talks to the Essbase server directly using various ports, SmartView connects to Essbase through Provider Services using HTTP protocol. The ability to communicate using a single port is one of the major advantages from SmartView over Excel Add-In. If you consider using Excel...

Wednesday, December 19, 2012 | 2. EPM | Read More

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

Applies To: This whitepaper applies to OBIEE release 11.1.1.6, 11.1.1.7 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...

Tuesday, December 11, 2012 | Performance Tuning | Read More

EPM 11.1.2.2 Architecture: Financial Performance Management Applications

 Financial Management can be accessed either by a browser based client or by SmartView. Starting from release 11.1.2.2, the Financial Management Windows client does not longer access the Financial Management Consolidation server. All tasks that require an on line connection (e.g. load and extract tasks) can only be done using the web interface. Any client connection initiated by a browser or SmartView is send to the Oracle HTTP server (OHS) first. Based on the path given...

Tuesday, December 11, 2012 | 2. EPM | Read More

HPCM 11.1.2.2.x - HPCM Standard Costing Generating >99 Calc Scipts

HPCM Standard Profitability calculation scripts are named based on a documented naming convention. From 11.1.2.2.x, 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 (http://docs.oracle.com/cd/E17236_01/epm.1112/hpm_admin/apes01.html). This naming convention results in the name being 8 characters in length i.e. the maximum number of characters...

Tuesday, December 11, 2012 | Performance Tuning | Read More

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.     ->Next:     and define: "Job Units" as <Number of Cores dedicated to DSS> * 1.5"Max Memory Size" (if this is 64-bit machine) - ~1G for each Job Unit....

Friday, November 30, 2012 | Performance Tuning | Read More

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.  The information in the log store can then be recovered by replaying the log store entries in sequence since the last archive took place.  The following information is recorded within a transaction log entry: Sequence...

Thursday, November 29, 2012 | Installs and Config | Read More

EPM 11.1.2.2 Architecture: Reporting and Analysis

Reporting and Analysis is the basis for all Oracle EPM reporting components. Through the Java based Reporting and Analysis web application deployed on WebLogic, it enables users to browse through reports for all kind of Oracle EPM reporting components. Typical users access the web application by browser through Oracle HTTP Server (OHS). Reporting and Analysis Web application talks to the Reporting and Analysis Agent using CORBA protocol on various ports. All communication to...

Friday, November 16, 2012 | 2. EPM | Read More

EPM 11.1.2.2 Architecture: Foundation

If applicable, the component will have its standard port next to its name in brackets. EPM Foundation is Java based and consists of two web applications, Shared Services and Workspace. Both applications are accessed by browser through Oracle HTTP Server (OHS) or Internet Information Services (IIS). Communication to the backend database is done by JDBC. The file system to store Lifecycle Management (LCM) artifacts can be either local or remote (e.g. NFS, network share). For...

Tuesday, November 13, 2012 | 2. EPM | Read More

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...

Thursday, October 11, 2012 | Performance Tuning | Read More

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...

Thursday, September 20, 2012 | Performance Tuning | Read More

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 isto provide a quick guide to finding this data for reporting in...

Tuesday, September 18, 2012 | 2. EPM | Read More

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. The following member list functions are defined in Planning @CHILDREN @ICHILDREN @DESCENDANTS @IDESCENDANTS @ANCESTORS @IANCESTORS @SIBLINGS @ISIBLINIGS Member list functions not defined in Planning can also be used. However, any member list function that is not defined in Planning accesses Essbase using the...

Friday, August 24, 2012 | Performance Tuning | 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. The following is an example of the statements to add when the Essbase language is set to Traditional Chinese: “-Dcom....

Friday, August 24, 2012 | Performance Tuning | Read More

Exalytics v1, not able to vertically scale-out Oracle Business Intelligence system components

In Exalytics v1, not able to vertically scale-out Oracle Business Intelligence system components. This issue exists only if Oracle Business Intelligence system components 11.1.1.6.0 are installed in Exalytics using ANT installation script. Solution: To fix vertical scale out for BI System components (OPIS / OBIS / JavaHost) in opmn.xml file, you need to remove following invalid element (</variable>) and add missing element (‘/’) highlighted in red color: <variable...

Thursday, July 26, 2012 | 1. OBIEE | Read More

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...

Wednesday, July 18, 2012 | Performance Tuning | Read More

Architecture history: WebLogic Admin Server failover capabilities on a different machine (Active/passive mode) from version 8 to 12

All descriptions here are talking about the way to make Admin Server restart in Active/Passive mode in a vertical scaling case.    WebLogic compatibility versions with EPM/BI: EPM EPM 9.3.3+ is certified with Oracle WebLogic Server 8.1.6, 9.1+, 9.2+ http://download.oracle.com/docs/cd/E10530_01/doc/epm.931/hsys9_install_start_here_933.pdf EPM 11.1.1.3 is certified with Oracle WebLogic Server 9.2 MP1+ EPM 11.1.1.4 is certified with Oracle WebLogic Server 9.2 MP4+ http://www.oracle.com/t...

Wednesday, July 18, 2012 | 3. Exalytics | Read More

Charts in BI not rendering after applying OBIEE 11.1.1.6.2BP1

Issue:  Charts in BI 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...

Tuesday, July 17, 2012 | Installs and Config | Read More

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). What are the benefits of Configurable Dimensions? Configurable Dimensions provides HFM the flexibility lacking in the traditional tools with predefined fixed structures. HFM applications can be built with the exact number of...

Friday, July 13, 2012 | Installs and Config | Read More

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. Because at least one dense dimension for an application is required to deploy from HPCM to Essbase, “Measures” and “AllocationType”, as the only required dimensions in an HPCM application, are created dense by default. However,...

Tuesday, June 26, 2012 | Performance Tuning | Read More

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...

Tuesday, June 5, 2012 | System Security | Read More

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. Per the documentation (http://docs.oracle.com/cd/E17236_01/epm.1112/hfm_admin.pdf),  see the section called "Creating Rules in Notepad ++".  You will need to import the HFMRules.xml file, which is located in the HFM utilities folder,...

Wednesday, May 23, 2012 | Installs and Config | 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. Currently, the WebLogic HTTP proxy timeout settings for EAS and EAS Console are set at the default...

Wednesday, May 23, 2012 | Installs and Config | Read More

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.

Thursday, May 17, 2012 | Performance Tuning | Read More

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. 

Wednesday, May 16, 2012 | Performance Tuning | Read More

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...

Wednesday, May 16, 2012 | Performance Tuning | Read More

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       ...

Monday, May 7, 2012 | Performance Tuning | Read More

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...

Tuesday, May 1, 2012 | Installs and Config | Read More

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...

Wednesday, April 18, 2012 | System Security | Read More

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...

Tuesday, April 10, 2012 | Performance Tuning | Read More

Oracle BI Publisher 11.1.1 - Quick Start Guide

This Guide covers following topics: Administering BI Publisher Creating Data Models and Reports Viewing and Scheduling Reports  Click here to Download this Quick Start Guide.

Tuesday, April 10, 2012 | Installs and Config | Read More