Sunil S. Ranka's Weblog

Superior Data Analytics is the antidote to Business Failure

Posts Tagged ‘OBIEE’

What is Oracle Business Intelligence Cloud Service ( BICS )

Posted by sranka on August 11, 2016

Recently we have been getting lots of traction on BICS , existing OBIEE customers been asking for BICS . In nutshell :

BI Cloud Service enables organisations of all sizes to quickly and cost effectively deploy business intelligence with the simplicity of the cloud..

Silent features of BICS :

  • No need of software installation
  • No need of software maintenance
  • No upfront costs, low monthly subscription
  • Customers can get started in hours
  • 100% cloud based
  • Robust reporting with interactive visuals, auto-suggestions, detailed formatting, export, and more
  • Powerful analytics platform with advanced calculations and analytic functions
  • Easy self-serve data loading
  • Rich data integration options
  • Mobile access with no extra programming required
  • Comprehensive sharing framework
  • Role-based fine grain security
  • Simple self-service administration

Key Benefits :

  • Fast access and low cost speed time to value
  • Quick start means users are productive quickly
  • A single BI platform for all users helps consolidate analytic investments
  • Timely access to data means greater impact
  • Streamlined operations and reduced burden on IT

Summary :

Based on my past experience of working on OBIEE on premise, BICS is a good alternative for any IT organisation, BICS gives all the needed feature of On-Premise installation and flexibility of operation, management , and most importantly low cost solution. In next few post, I will describe more about BICS tool and features.

Hope this helps

Sunil S Ranka

“Superior Data Analytics is the antidote to Business Failure”



Posted in Uncategorized | Tagged: , , , , | Leave a Comment »

How to find Oracle Integrated Lights Out Manager (ILOM) ip Address on Exalytics

Posted by sranka on September 3, 2013

Hi All

Recently while upgrading our Exalytics box from PS1 to PS3 for OBIEE patch-set, one of the requirement was to  upgrade firmware and to complete the firmware we needed ILOM address. During the upgrade team found out the default ILOM IP was not working and there was a change in the ILOM ip address. To confirm the ip address, we used below command, thanks to Oracle Support to prompt reply . Thought would be a good piece of information as most of the existing Exalytics customers are going through the upgrade.

To get the ILOM IP address please login as root and run following command ::

ipmitool sunoem cli "show /SP/network"

Once you run the above command, you will see below results and you would need to look for the ipaddress.

Connected. Use ^D to exit.

-> show /SP/network

 commitpending = (Cannot show property)
 dhcp_server_ip = none
 <strong>ipaddress =</strong>
 ipdiscovery = static
 ipgateway =
 ipnetmask =
 macaddress = 00:21:28:8E:10:E8
 managementport = /SYS/SP/NET0
 outofbandmacaddress = 00:21:28:8E:10:E8
 pendingipaddress =
 pendingipdiscovery = static
 pendingipgateway =
 pendingipnetmask =
 pendingmanagementport = /SYS/SP/NET0
 sidebandmacaddress = 00:21:28:8E:10:E9
 state = enabled

Hope this helps.

Sunil S Ranka

“Superior BI is the antidote to Business Failure”

Posted in Uncategorized | Tagged: , , , , , , | Leave a Comment »

Big Data : A Perfect data strom

Posted by sranka on July 25, 2013

Hi All,

Lately I have been spending lot of time on Big Data, its application, architecture and processes. As part of the process, my thoughts on Big Data in print Media. I hope you would enjoy reading.

Hope this helps.

Sunil S Ranka

“Superior BI is the antidote to Business Failure”

Posted in Uncategorized | Tagged: , , , , , , , | Leave a Comment »

Oracle Apache Hadoop Hive ODBC Driver For OBIEE

Posted by sranka on July 3, 2013

Hi All,

Last few months have been a crazy ride, wrapping up on new opportunities and getting upto speed on Hadoop took all the free time away . During my read on Hadoop , I always wondered why we dont have out of the box ODBC driver? I tried using out of the box ODBC driver given by HortonWorks and it worked up to certain extend but running using cloudera was a challenge. Finally to the sigh, with Oracle has introduced Oracle Apache Hadoop Hive ODBC Driver For OBIEE.

So far extracting the data using Hadoop have never been a challenge, but using the data to make sense out of it has been a constant challenge.  With this integration, there would be some amount of relief with the existing investment people have made in OBIEE. Hive’s SQL dialect, called HiveQL doenst support the full SQL-92 specification, please refer Metadata Repository Builder’s Guide for not supported features.

For details on where to start please refer Metadata Repository Builder’s Guide.  For importing the metadata from Hive you will have to download ODBC driver from oracle support web, for details please refer DocID 1520733.1 .

In coming weeks I will be working more on Big Data approach and Solutions. 

Hope this helps

Sunil S Ranka

“Superior BI is the antidote to Business Failure



Posted in 11g, Me, OBIEE | Tagged: , , , , , , , , , , | Leave a Comment »

Business Intelligence (BI) Vendor Management

Posted by sranka on June 11, 2013

Hi All,

Companies are getting lot lesser value than the amount of dollars they are spending on BI vendors. Following article oulines some of the processes and way to get the maximum out of a vendor.

Hope this helps

Sunil S Ranka

“Superior BI is the antidote to Business Failure

Posted in Uncategorized | Tagged: , , , , , , , | Leave a Comment »

Bye Bye 2012 !!! Welcome 2013

Posted by sranka on December 31, 2012

Hi All

It just seems like yesterday, but its again time of the year where we need to recap what took place last year. 2012 was a year of “World coming to an End“, Thank to God, IT directors didn’t think the same and didnot spent all the dollars. 2012 Year started on high note with 11G picking up its momentum.  But at point client took their own time to decide on upgrades. With bitten badly of older releases of OBIEE , the foul taste still didn’t leave customers too happy. was a solid answer to many questions and .6 followed the foot steps.

Year 2012 saw an increase trend in business looking for more agility and flexibility in BI solutions, oracle’s acquisition of  “Endeca” could be a potential solution. Next few releases we would see endeca and OBIEE getting a focal convergence.  Personally 2012 was a satisfactory year, changing roles from delivery to more strategic was one of the move I personally enjoyed. Few successful pre-sales engagements and client visit to Dubai were few memorable events.

2012 OOW, was a year of Oracle Cloud. A year back cloud was a box, but in 2012, the cloud was the only thing. Larry’s keynote was much awaited, right from db to application, everything was in cloud.2012 OOW, was a year of repeat content, but saw some improvement in software releases. Year after year presentations seemed the same. One thing which I personally liked was demo of Endeca’s integration with EBS.  This integration has tremendous potential, but time ahead would prove the facts. Hands on exposure to endeca, Exalytics was satisfactory. This year distinction at OOW was stress on Big Data. It was more on how to use Big Data technologies and oracle db.  Over all OOW 2012 was a time well spent affair.

Oracle Captions

Oracle Product Offerings at OOW-2012

Treasure Island Party

Treasure Island Party

Pearl Jam at OOW 2012

Pearl Jam at OOW 2012

Personally it was a satisfactory year, along with professional career, had a great joy of bundle with tiny 10 toes, a baby boy (Saarth). With Saarth’s arrival, now we have a complete family (Rinku – Wife, Samvi – Daughter, Saarth – Son ). Samvi was waiting for Saarth for a long time.

Along with this, I had my 1st media print on future of BI ( Article starts from Page 47).

In all 2012 was a satisfactory year, waiting for 2013. Thank You for all your continue support and looking forward for the same in 2013.

Wishing Every one a Happy and Prosperous New Year, Be Safe!!!!!!


Sunil S Ranka

“Superior BI is the antidote to Business Failure”

Posted in Uncategorized | Tagged: , , , , , | Leave a Comment »

Huge Temp FIles (nQS*.TMP) files are generated by the BI Server

Posted by sranka on December 4, 2012

Hi All

Hope you all had great Thanks Giving break, I was away from action as I was in the man made wonders of Dubai attending a client proposal. In short Dubai is a wonderland and would take some time off to write about the same. At one of the recent client visit, ran into a very basic peculiar issue, thought would share with you all.

It was 10G to 11G upgrade and after running 11G server for sometime, huge temp files (nQS*.TMP) were getting created. Due to this client file system was getting filled up and at times they had to restart the server. After spending few hours came across some suggestions from Oracle support, hence thought it would be worth while sharing with you all.

The Temp files have the following 3 main functions functions

  • Perform data manipulations required by column request functions and/or formulae that cannot be pushed down to the source database(s).
  • Perform data sorts to combine and/or aggregate return sets.
  • Prepare the final result set for OBIPS processing.

Possible Solutions

  • Use aggregated tables instead of detail tables so that less number of rows are pulled resulting in smaller dataset to be processed
  • Reducing the column width will reduce the tmp file size.
  • If possible Avoid unnecessary processing like Sort, Formatting , front end calculation
  • Use data base ORDER BYs to reduce the load
  • Configure multiple file location for temp file storage (‘WORK_DIRECTORY_PATHS’ param in NQSConfig.ini)

For more details please refer to oracle document ID 857571.1 and 863864.1.

Hope This Helps

Sunil S Ranka
“Superior BI is the antidote to Business Failure”

Posted in Uncategorized | Tagged: , , , , , | Leave a Comment »

OBIEE Bug Fixes

Posted by sranka on February 26, 2012

Hi All

As has released, people are interested in what is stored in BI antique. Below is the link which lists all the possible list of bug fixes.

Hope This helps

Sunil S Ranka

“Superior BI is the antidote to Business Failure”

Posted in Uncategorized | Tagged: , , , , , | 2 Comments »

Fusion Applications – Overview of Business Intelligence and Reporting components

Posted by sranka on February 8, 2012

Hi All,

While looking through Oracle Support came across an informative “Overview of Business Intelligence and Reporting components”


Fusion Applications includes a variety of Business Intelligence and Report functionality. Some of these are exposed to the end-user, and some exist as middleware layers.

This document briefly lists the components, their common acronyms and the functionality that they bring to Fusion Applications.

Please note that the column titled “Function” contrass whether the component is a tool (infrastructure), or content (an analysis or report definition which is delivered with Fusion Apps).

BI Component Function Description Where exposed in the Applications UI (example)
Oracle BI Enterprise Edition (OBIEE) Middleware Tools and infrastructure Oracle BI Enterprise Edition (Oracle BI EE) is a comprehensive set of enterprise business intelligence tools and infrastructure that includes a scalable and efficient query and analysis server, an ad-hoc query and analysis tool, interactive dashboards infrastructure, proactive intelligence and alerts functionality, and an enterprise reporting engine. Underlies most BI analyses and reports. N/A
Analysis Editor Ad-hoc analysis designer The “Analysis Editor” (or Answers) lets you explore and interact with information by visually presenting data in tables, graphs, pivot tables, and so on. You can include the views that you create in an analysis, for display in Fusion Apps pages or dashboards. A sub-component of OBIEE. Via Reporting Pane or Navigator: Tools
Essbase Middleware Tools and infrastructure Oracle Essbase is an online analytical processing (OLAP) server that provides an environment for deploying prepackaged applications or developing custom analytic and enterprise performance management applications. Example usage:  underlies Financial Reporting. Financials > GL
BI Composer Ad-hoc analysis designer BI Composer is a simple-to-use wizard that allows you to quickly and easily create, edit, or view analyses without the complexities of the Analysis Editor. A sub-component of OBIEE. Via Reporting Pane or Navigator: Tools
Oracle Transactional Business Intelligence (OTBI) Analyses Oracle Transactional Business Intelligence is a complete, prebuilt BI solution that deliver intuitive, role-based intelligence throughout an organization. It uses Oracle BI Enterprise Edition as it’s technology layer to provide an easy-to-use interface for business users to perform current state analysis of their business applications.
Pre-constructed queries and reports are executed real time against the transactional schema supported by a layer of view objects.
An OBIEE repository (.rpd) and Web Catalog are supplied.
CRM Sales  Opportunity Watch Real Time
Oracle Business Intelligence Applications (OBIA) Analyses Oracle Business Intelligence Applications are complete, prebuilt BI solutions that deliver intuitive, role-based intelligence throughout an organization.
Oracle Business Intelligence Applications analyses use a data warehouse. Oracle Business Intelligence Applications supplies the warehouse database schema and the logic that extracts data from the Oracle Fusion Applications transactional database and loads it to the warehouse. Oracle Fusion Applications end users interact with the information in the Oracle Business Analytics Warehouse via analyses exposed on Fusion Applications pages, also using Oracle BI Enterprise Edition components (such as Analysis Editor, BI Composer and Dashboards).
Datawarehouse Console (DAC) is used to control and orchestrate extract-transform-load (ETL).
Informatica PowerCenter ETL tool is a third-party ETL platform (available from eDelivery) that performs the detailed extract, transform, and load (ETL) operations for the data warehouse.
An OBIEE repository (.rpd), Web Catalog, DAC repository and Informatica respository are supplied.
Financials > Customer Profitability
Financial Reporting Reports Oracle Hyperion Financial Reporting (Financial Reporting) is a powerful tool for designing and presenting analytic data graphically. You can design traditional financial report formats such as cash management reports, profit and loss statements, and balance sheets. You can also design nontraditional formats for financial or analytic data that include text and graphics.
Use Financial Reporting to create and deliver financial reports to the General Ledger system. Reporting administrators use EPM Workspace with financial reports to create and modify reports, books, and batch definitions and to schedule batch jobs via the reporting scheduler user interface within EPM Workspace. Reporting users run and view reports using the General Ledger user interface; they can launch reports in an IFrame within the General Ledger browser window.
Financials – Financial and Statutory Reporting
BI Publisher (BIP) Middleware Tools and infrastructure WYSWIG Tool for creating pixel precision reports.
Oracle Business Intelligence Publisher is an enterprise reporting tool for authoring, managing, and delivering reports from multiple data sources in multiple formats through multiple channels. A sub-component of OBIEE.
Via Reporting Pane or Navigator:  Tools
BIP Reports Reports Pre-constructed pixel perfect formatted reports Fusion Financials contains over 100 pre-constructed BIP reports, for example. 1099 report
Oracle Real-Time Decisions (RTD) Middleware Tools and infrastructure Oracle Real-Time Decisions enables you to develop adaptive enterprise software solutions. These adaptive solutions continuously learn from business process transactions while they execute and optimize each transaction, in real time, by way of rules and predictive models. A sub-component of OBIEE. N/A
RTD Reports/Content/CRM Sales Predictor Analyses CRM Sales Prospector
Oracle Data Miner (ODM) Middleware Tools and infrastructure Oracle Data Mining automatically finds relationships hidden in data, by expanding SQL  it adds analytical verbs–such as predict, cluster, detect, and classify–also by embedding cutting-edge algorithms in the Oracle Database kernel. Underlies CRM Sales Predictor. N/A
ADF based Reporting Reports Reports and Graphs which use ADF objects to create the UI look and feel , where the data has been sourced from Oracle Business Intelligence. These use an ADF component called BI Logical SQL VO, which in essence is a special type of VO that executes a logical SQL statement against the BI server. These VO’s are referenced in the .rpd ( BI’s common semantic layer)

Note that there are some ADF based graphs and reports which do not use BI as a source for data.







  The above entire text has been taken from oracle support document [ID 1334765.1]

Hope this helps

Sunil S Ranka

“Superior BI is the antidote to Business Failure”

Posted in 11g | Tagged: , , , , , , , , , , | Leave a Comment »

People who all influenced me in Year 2011

Posted by sranka on December 29, 2011

Dear All,

I was sitting around and thinking about few people , whom I met during the course of 2011, some of them left a mark and impression, hence thought of mentioning them in words.

Personally it was satisfactory year,

  • The project I implemented,won “Fusion Middleware Innovation Awards”
  • Implemented 11G with BW-SAP as datasource (odd, on which oracle also wouldn’t bet)
Oracle Fusion Middleware Innovation Award

Oracle Fusion Middleware Innovation Award

  • Met some of the people whom I had always admired likes of murali subramanian and Balaji Yelamanchili from Oracle, Ming Tsai of infosys to mention few.
Murali Subramanian, GM Oracle , India

Murali Subramanian Larry Ellison Of Oracle, India

During my day at Oracle, Murali was talk of town, he was first one to venture into India and grew Oracle’s IDC (India Development Center) from no where to little over 10,000 people in couple of years. I would attribute most of Oracle’s outsourcing success to Murali. 2 hours I spent with him were one of the most cherished moment of OOW and 2011. A truly amazing and down to earth personality.

Balaji Yelamanchili

Balaji Yelamanchili From Oracle

I had opportunity to meet Balaji during collaborate-11 at florida, on behalf of BIWA board, I had invited him as a featured guest. His candid personality was simply astonishing, in spite of being at the that level his eagerness to learn BI was commendable. His customer focused attitude helped one of our key customer to go live against all odds. I heard him again at OOW-11, his transformation from EMC, Documentum to Oracle BI is simply amazing. In all, Oracle BI is in safe hands.

Ming Tsai From Infosys, Managing Director & Chief Client Officer

Ming Tsai From Infosys, Managing Director & Chief Client Officer

I had heard Ming on couple of occasions (OOW-10 and OOW-11), his unique style of presentation had made an impact, even though during OOW-10, kris gopalakrishnan’s presentation was dry, Ming made it interesting, he did justice once again to S.D. Shibulal’s OOW-11 presentation. His stage presence and charisma is some thing adorable. I run into Ming Tsai, during OOW’s Treasure Island party. He was nice and kind enough to spend some time,talk and most importantly he helped setting up camera for nice shot. In short he is well rounded .

Met few more smart people , The Real OBIEE 11G Heros, please read post

Thanks You All for reading following.

Hoping and wishing you all a happy and prosperous new year. Be safe and enjoy.

Sunil S Ranka

“Superior BI is the antidote to Business Failure”

Posted in Me, sunil s ranka | Tagged: , , , , , , , , , | Leave a Comment »

%d bloggers like this: