By Olivier Bennardo-Oracle on Apr 06, 2016
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.
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.
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.
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.
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.
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).
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
<property name="oracle.security.jps.ldap.policystore.refresh.interval" value="6000000"/>
Do not forget to restart everything after modifying this file.
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.
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.
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.
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
– Clone up the existing 126.96.36.199 environment.[Read More]
– Move the cloned copy to the new location / host (same 188.8.131.52.0 version at this point).
– Patch new location / host (184.108.40.206) to the 220.127.116.11 level.
– Switch to Production.
This wlst/python script connects to bi security web service to
authenticate a user specified in the "ObieeWebServiceClient.properties"
file. In 18.104.22.168, this calls:
getAuthenticatedUserWithLanguageAndProperties operation of the
/bisecurity/service web service.
In 22.214.171.124, 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]
A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: Ahmed Awan] Please note the CEAL blog posts are for information and demonstration purposes only and are not official documentation or supported by Oracle Support.