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.

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]

Thursday Oct 16, 2014

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

Tuesday Jul 15, 2014

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 clearing this Urgent Bit in the communication, the message is not transferred from the Scheduler (DB Client) to the Oracle database so by setting DISABLE_OOB=ON the Urgent flag is not sent from Scheduler and the connection works normally.

How-to: On BIServer side only, set DISABLE_OOB=ON in SQLNET.ora file > …/Oracle_BI1/network/admin


Monday Jun 02, 2014

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

Monday Mar 24, 2014

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 is useful when debugging an issue with OBIEE security.

The script has to be run with %ORACLE_HOME%\oracle_common\common\bin\wlst.cmd (sh)

Script is available there: https://blogs.oracle.com/pa/resource/ObieeWebServiceSecurityClient.zip

[Read More]