BI 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 MoreCloud based BI tools have become increasing popular in recent years especially among small and medium enterprises. The amount of data churns out from enterprises has overwhelmed in past decade or so, turning such swatches of data into useable information is pivotal for any enterprise....
Read MoreORACLE Database Upgrade 11.2.0.1 to 11.2.0.4.0 download the software Oracle 11.2.0.1.0 from oracle support [root@oranode1 ~]# /u01/app/oracle/product/11.2.0/dbhome_2/root.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_2 Enter the full pathname of the local bin directory: [/usr/local/bin]: y Creating y directory...
Read MoreCreate Unifier Domain Click Start > Oracle >Configuration Wizard Replace “base_domain” with “unifier” and click next Enter name and password > Next Select Production > Next Select Administration Server > Next Leave Server Name as “AdminServer” Change Listen Port if it need to be changed. Once 100% then click Next This will start...
Read More
Evaluate() Function in OBIEE to Embedded DB Functions This Evaluate functions (since version 10.1.3.3) enables users and administrators to create more powerful reports by directly calling Database functions in OBIEE from: Either By Oracle BI Answers. OR by using a Logical column (in the Logical Table...
Read More
Conversion Functions The conversion functions convert a value from one form to another. You can also use the VALUEOF function in a filter to reference the value of an Oracle BI system variable. Functions include: CAST CHOOSE IFNULL INDEXCOL TO_DATETIME VALUEOF CAST This function changes...
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 More