Thursday Apr 28, 2016

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.


[Read More]

Wednesday Apr 06, 2016

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.


[Read More]

Monday Feb 29, 2016

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) to OBIEE 12c (12.2.1) Visual Analyzer (Doc ID 2105521.1) on MOS.

These instructions assume that the administrator has a working knowledge of GeoSpatial data, MapBuilder, MapViewer and SQL.

Friday Feb 12, 2016

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® Fusion Middleware (FMW), hardware performance tuning fundamentals, web servers, java application servers and database.

Download (Support Doc ID 2106183.1) ===>  White Paper <=== for complete details.


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]