Wednesday Feb 03, 2016

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.



[Read More]

Monday Feb 01, 2016

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. 


[Read More]

Thursday Jan 14, 2016

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


[Read More]

Tuesday Dec 15, 2015

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.[Read More]

Friday Dec 11, 2015

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. 

Tuesday Dec 01, 2015

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\fmwconfig\jps-config.xml:

<property name="oracle.security.jps.ldap.policystore.refresh.interval" value="6000000"/>

Do not forget to restart everything after modifying this file.

Tuesday Nov 17, 2015

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.

Saturday Oct 10, 2015

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.

Monday Jul 27, 2015

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 different to the way Planning/PBCS stores dates to display on web forms.

It is possible, however, to use the Essbase date format and then convert that date into a Planning/PBCS format for use on a web form in order to populate a Planning/PBCS date member with today’s date i.e. the system date.

[Read More]

Sunday Jun 28, 2015

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.


[Read More]

Friday May 22, 2015

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 expense. For example, when budgeting supply expenses, a ZBB application will include values for each detailed line item, including pencils, pens, paper clips, etc. Given the level of detail required for ZBB applications, careful consideration needs to be taken in order to have optimal performance within Hyperion Planning


[Read More]

Friday Feb 06, 2015

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.
[Read More]

Tuesday Feb 03, 2015

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, Essbase and the applications listen on all interfaces (IP_ANY).

For details on this refer to Essbase Tech Ref

In EPM 11.1.2.4 release, in Configure Essbase Server specifies the host name (in Binding Host Name field) to which Essbase Agent and Essbase Server bind and where an Essbase application process runs.

For details refer to http://docs.oracle.com/cd/E57185_01/epm.1112/epm_install/essbaseAgentPortPanel.html


Friday Jan 30, 2015

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.


 

[Read More]

Monday Jan 05, 2015

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 https://blogs.oracle.com/pa/resource/CheckObieeTuningGuidev4_01-2014.zip automates these checks. It is only reading from the obiee server and it will not modify any values. The script outputs the current values, that you can compare with the recommended ones.


[Read More]