In a previous post, I described how the Oracle BI Cloud Service (BICS) integrates with Oracle Cloud (Fusion) Apps. For users of on premise Oracle BI, there are other methods of integrating with Fusion Apps. The easiest of which is Oracle BI Applications 11g as it comes with prebuilt content, data warehouse and ODI ETL […]
John Whitaker
John is a Senior Project Manager in the National Oracle Business Analytics Practice. He has over 18 years of experience in the design, development and implementation of Enterprise Software Applications including Business Intelligence, Data Warehousing and Industry Analytics solutions. John has expertise in leading large scale projects in multiple industries including Fortune 500 companies, leading research universities and government agencies. He is currently specializing in the development of Oracle BI Cloud Services solutions including Retail, Healthcare and Higher Ed Analytics.
Blogs from this Author
OBIEE Bundle Patch 12.2.1.0.161018 is Available
Oracle has released a new bundle patch for OBIEE 12c platforms, version 12.2.1.0.161018. The bundle patch can be found in the My Oracle Support Patches & Updates section, the direct link is here: https://support.oracle.com/rs?type=patch&id=24695761. It can be applied to OBIEE 12.2.1.1.0 and OBIEE 12.2.1.0.0. In addition to patching the OBIEE application server, developers and administrators need to […]
What you need to know about BICS Remote Data Connector (RDC) 1.1
For companies that are happy with their on-premise data warehouse there is a fear of having to create a new data warehouse when migrating to the cloud. Luckily for Oracle BI Cloud Service customers there are two excellent ways to avoid having to redo your warehouse. The first method is using Oracle BICS Data Sync to do […]
Best Practices for loading Oracle Cloud App Data into BICS
My last post on BICS and Cloud (Fusion) Apps Integration Architecture described how BICS Data Sync 2.2 can read the OTBI metadata to allow for near real time trickle feeds from Oracle Cloud Applications. As I described in that post, there are multiple ways to load data from the Oracle Cloud Applications into BICS. The […]
See OBIEE 12c and EPM 11g in Action: Sample App 607 EPM Plug-in
OBIEE 12c has seamless integration with the EPM 11.1.2.4. The OBIEE BI Admin tool can read EPM metadata and import it into the OBIEE RPD which allows you to quickly incorporate Hyperion data sources. When you integrate the EPM datasources, the full features of the OBIEE 12c platform are available to you. This includes OBIEE […]
Oracle BICS and Cloud (Fusion) Apps Integration Architecture
In my last post, I described the methods of reporting from Oracle Cloud (Fusion) Apps. In that post I illustrated the advantage of using BICS and Data Sync to provide a true Enterprise Data Warehouse due to its abilities to integrate data from all our your cloud, relational, big data and flat file sources. This […]
Oracle BICS and Cloud (Fusion) Apps Integration Overview
Oracle provides multiple ways of reporting from Oracle Cloud (Fusion) Apps. Oracle HCM Cloud, CX Cloud, SCM Cloud and Cloud ERP all have Oracle Transactional Business Intelligence (OTBI) built into the application. In addition, Oracle Business Intelligence Cloud Service (BICS) can also access Oracle Cloud application data and load it into the BICS Database via Data Sync. While […]
Oracle BICS now delivers Insight to your Inbox
In the August 2016 update of Oracle BI Cloud Service (BICS), Oracle has added a great new feature: scheduled report delivery, simply called Deliveries. In a nutshell, Deliveries is a scheduling system that emails reports on an instantaneous or regular basis. The scheduler itself is found in the BICS Console as seen below. Once you click on […]
A Logical Solution to Financial Reporting Using OBIEE and Essbase
Effective and efficient financial reporting is crucial for the success of semiconductor companies. It is critical to track revenue, shipments, and order backlogs in order to properly utilize company assets. In addition to understanding the current financial position of the company, there needs to be visibility into company forecasts in order to do proper financial and manufacturing planning. Data […]
See OBIEE 12c in Action: Configure Sample App Demo Part 2
In Part 1 of this series, I explained how to prepare your system for VirtualBox and download and extract the .ova file from the Oracle OTN site. This post describes how to deploy the image, setup the virtual machine settings, how to set up your network adapters and run a critical patch. At that point […]
See OBIEE 12c in Action: Configure Sample App Demo Part 1
Shortly after the release of OBIEE 12.2.1.1, OBIEE Sample Application version 607 was released. This Sample App is extremely robust and nicely highlights the updates to OBIEE 12c including Data Visualization improvements and really shows off what OBIEE 12c can do. In addition to the core Sample App, an EPM Plug-in for Sample App is available, […]
OBIEE 12.2.1.1 supports additional Big Data & Cloud apps
OBIEE release 12.2.1.1 not only boasts improved Data Visualization capabilities as I outlined earlier this week, but there are many important updates to source system support. One of the main drivers of this is that OBIEE now supports DataDirect 7.1.5. For those of you unfamiliar with DataDirect, it is a set of ODBC drivers from Progress Software […]