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 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 More