Cloud 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
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 MoreEnterprises uses various BI tools like Cognos, Oracle Business Intelligence Enterprise Edition (OBIEE), Tableau, SQL Server Reporting Services (SSRS) etc to analyse swathe of data and convert raw data into more presentable format like Dashboard, Key Performance Indicators(KPIs) to make well informed decision. The success...
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 More