1. SET WEBLOGIC LDAP Log on to the WebLogic Console as the weblogic adminsitrator account: http://[BI SERVER]:7001/console Navigate to the following screen “Security Realms > myRealm”: Click on the “Providers” tab and then click on the “Lock and Edit” button: Click on the link for “DefaultAuthenticator”: Set the...
Read More
1. Oracle BI Server Query Cache Configure the Oracle BI Server to maintain a local, disk-based cache of query result sets (query cache). The query cache enables the Oracle BI Server to satisfy many subsequent query requests without accessing back-end data sources, thereby increasing query performance. As...
Read More
Create Audit Schema with RCU Here are the steps: Go to $RCU_HOME/bin and execute the ‘rcu’ command Choose Create at the starting screen and click Next. Enter your database details and click Next. Choose the option to create a new prefix, for example ‘BIP’, ‘KAN’, etc. ...
Read MorePatch Name wls1036_upgrade_generic.jar Reference https://www.youtube.com/watch?v=Be6hrYTANQE Just Click Next and Next MAKE SURE ALL OBIEE SERVICES ARE DOWN AND CLOSED IN PROCESS Open CMD prompt C:MiddlewareOracle_BI1jdkbinjava –jar “c:/10_3_6.jar” [counter style="style2" number="1" text="Counter"]...
Read More
Where are these images located? All images are stored in the 'browser look and feel plus' folder of the BI Server, you've probably seen this notated as 's_bflap'. This folder exists in two locations and it is critical that any image you upload be housed in...
Read More
OBIEE Reports/ Dashboards/Analysis Export to Unix/Windows/FTP Procedure 1 using EjB: Oracle Business Intelligence 11g, doesn’t provide any built-in method to allow Agent to automatically export/archive OBIEE11g content (Entire Dashboard(or) Dashboard Page(or) Analysis(or) Conditional Report of Agent(or) even Briefing Book) to file system, although this can be done...
Read More
ORACLE DATA VISUALIZER DESKTOP (DVD) Installation Oracle have recently released a desktop version of their Data Visualizer tool – which had until now just been a browser based tool available in an OBIEE 12c installation or the two BI Cloud or DV Cloud services. The current version...
Read MoreBI Publisher with JFreeChart an Open Source plotting API in order to generate plots that are not provided by BI-Publisher such as the Gantt chart type. The main steps are as follows: 1) Create the BIP data model: as an example I used the sample Gantt data mentioned...
Read More
1) Oracle Business Intelligence Suite Enterprise Edition (OBIEE) – comprehensive suite of enterprise BI products that delivers a full range of analysis and reporting capabilities – Contains components like BI Answers, Interactive Dashboards, Disconnected Analytics, Briefing Books, BI Administrator – Latest Version > 12.2.1.0.0 (as on 04-June-16) 2) Oracle Business Intelligence...
Read More