Usage Tracking is used to monitor system and ad-hoc query performance and to provide input on usage trends for use in billing users and departments for resources. Usage tracking is particularly useful in determining user queries that are creating performance bottlenecks, based on query frequency...
Read MoreOracle’s OBIEE 11g now has the option to create an action link from an analysis, dashboard, KPI etc. which basically means you can add a link to direct the user elsewhere, within the OBI catalogue or to an external system or web page. The beauty...
Read MoreOracle has released new OBIEE 11.1.1.9.0 and available for download. Some highlights of the new features in this version are: Improved installer NOT supported on 32-bits Operating Systems. Better Administration Features: New monitoring operations via Mbeans,additional information in Usage Tracking tables, new INSTANCECONFIG.xml and NQSCONFIG.INI settings Improved Aggregate Persistence...
Read MoreA customer asked me to create an analysis on top of a Name - Value table. A table where instead of having one row for each key, there are multiple rows with the structure of Key_Value / Attribute_Name/ Attribute_Value. This structure is very nice for...
Read MoreHow to add an additional category for the total to a graph in OBIEE? Sometimes in the requirements you need to present a breakdown of values by categories and their total on one chart. In the example below this is done for horizontal bar graph, but...
Read MoreStep by Step Installation of OBIEE 11g version 11.1.1.7 on top of SQL Server RCU Infrastructure of the Environment: OS : Windows 2008 R2 64 bit Server RAM : 196 GB Environment : Windows OBIEE Version : 11.1.1.7 Repository Database : MS SQL Server 2008 R2 Since i am installing OBIEE on a VM with DHCP (Dynamic...
Read More
This blogs covers configuring SSL for OBIEE 11g in a scenario where the SSL certificate is not in a format that WebLogic Server (WLS) readily accepts: Java KeyStore (JKS) file. First, a certificate request (.csr) should have been generated on the server where SSL will be configured...
Read MoreUbuntu like systems are not in the list of Oracle 12c Database Supported OS, so you should be careful and use it at most for Development and not as Production Database Server In this post we will be installing Oracle Database 12c Release 1 (12.1.0.2.0) – Enterprise Edition on...
Read MoreLorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean vitae ornare diam. Vestibulum odio dui, pulvinar quis volutpat vitae, ultricies at orci. Ut pellentesque libero at eros posuere, ut rhoncus nibh venenatis. Duis lorem augue, sodales ut nibh eu, fringilla ornare quam. Curabitur tempus condimentum...
Read More
Open 11.7.0.0 Make sure no Env exist named ORCALE_HOME in Click Next Skip Software updates and then click Next User weblogic Password **************** Click Next Create folder in c driver named middleware Follow below screenshots LOGIN Screen Setting up OBIEE as a service https://arunsadagopan.wordpress.com/2013/12/06/installing-obiee-services-as-windows-services/ http://paulcannon-bi.blogspot.co.uk/2012/07/deploy-obiee-11g-as-services-under.html Patching Latest Patch for 11.7.0.0 set ORACLE_HOME=C:\Middleware\Oracle_BI1 set PATH=%ORACLE_HOME%\bin;%PATH% set JAVA_HOME=%ORACLE_HOME%\jdk set PATH=%JAVA_HOME%\bin;%PATH% set PATH=%ORACLE_HOME%\OPatch;%PATH% Download Latest and follow...
Read More