Posts Tagged ‘obiee’

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 […]

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 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 […]

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 […]

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 […]

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 […]

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 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 […]

This post is a follow-up to my previous post: OBIEE Collaborative Analytics Enables Decision Making & Action In this blog, I provide detailed instructions and design aspects of implementing OBIEE Dashboard Commentary levergaing the Write Back feature. There are several steps involved, at the database, middleware and dashboard levels.

Gathering Statistics of a database schema before executing an ODI load plan will improve performance by helping the Optimizer to select optimal execution plan by referring to latest statistics, instead of stale statistics. We can gather statistics of Oracle database schema at a scheduled time of day using the DBMS_SCHEDULER and DBMS_AUTO_TASK_ADMIN packages, However, if […]

Oracle has recently introduced a new version of OBIEE 12c, 12.2.1.1 (not to be confused with the original 12.2.1.0) This is the first point release of the 12c platform and contains a host of changes.  The biggest changes are in the Data Visualization side of the house where the platform has seen significant functionality additions in […]

Organizations that rely on Oracle Business Intelligence (OBIEE) as their standard analytics platform may have already reaped the benefits of a common enterprise reporting solution from a data accuracy and accessibility perspective. However, they are most likely still using traditional means of collaboration. This entails communication of reported results, explanation of what they mean, their […]