My current blog looks at the logical or business model. In particular how to connect fact tables so that you can get numbers from more than one fact in the same report – and actually show results. This aspect of OBIEE seems to cause a fair...
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 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
Union, UNION ALL and Intersect in OBIEE11g Some times the data model does not allow you to create a single query to get the results you need. then we are forced to do a Union. (actually they are 4 possible operations Union, Union All, Minus and...
Read More