Mazen Manasseh – Director of Business Analytics

Creating a new Oracle Autonomous Data Warehouse (ADW) Cloud instance is a quick task. But migrating data over from one or more other Oracle databases will require a few steps. This blog series leverages the Oracle Data Pump technique to export and import schemas from Oracle DB into ADW. The overall process consists of 3 […]

The question that is often asked is: Can we leverage the same security we already have in Oracle Fusion SaaS (which includes users, duties, roles and security policies) to secure data in Oracle Analytics Cloud (OAC – an Oracle PaaS)? The answer is Yes. To understand better how this is possible, keep reading. This blog […]

Oracle Analytics Cloud offer several options when it comes to loading data from Oracle SaaS (such as Financials, HCM, Sales, etc…). Using OAC against Oracle SaaS has several advantages, and most importantly being able to perform analytics on data that is not part of the SaaS application. You may be familiar with using Data Sync […]

Reporting on Oracle Fusion and non-Fusion SaaS Apps from Oracle Analytics Cloud (OAC) is a common solution to performing cross-functional reporting from one or more Cloud and non-Cloud applications. The BI capabilities within each of the transaction systems, whether Financials, HCM, Sales or other, are limited when it comes to integrated reporting with external data […]

Following my previous blog post on how to add a new Dimension to a Data Sync task, this post looks at how to add a Fact and perform a lookup on dimensions while loading the target fact table in a data warehouse using Data Sync. To refer to the blog post on adding a Dimension […]

In this and the following post, I will cover the steps entailed in adding dimension and fact tasks in Oracle Data Sync. The latest releases of Data Sync included a few important features such as performing look-ups during an ETL job. So I intend to cover these best practices when adding new dimension and fact […]

If you are already running OBIEE/OBIA on premises and wondering about your options to migrate to Oracle Analytics Cloud (OAC), you are not alone. Many are overwhelmed by this transition and might be asking themselves questions such as “What does it take to get migrated to the cloud? When should I make this transition? What […]

Over the past couple years several Machine Learning (ML) capabilities have made their way into Oracle Analytics Cloud (OAC). If you are using OBIEE or OAC and wanting to apply ML to your data, there is no need to look for an additional software to do that. There are several ways in which ML capabilities […]

Oracle Cloud BI solutions have been available for a few years now and have evolved significantly over the past couple years. If you have been using OBIEE or OBIA (Oracle BI Applications), you are in a pretty good position to start migrating to Oracle Analytics Cloud (OAC). The reason: OAC relies on a similar underlying […]

One of the many multi-dimensional data sources that OBIEE supports is Hyperion Financial Management (HFM). If you have used Essbase as a data source in OBIEE, you will realize that HFM integrates in a similar approach, but not quite the same. While a direct connectivity between OBIEE and HFM is very useful for financial users, […]

Oracle Analytics Cloud (OAC) was updated recently to support direct connectivity with Oracle Planning & Budgeting Cloud Service (PBCS) and EPBCS. Consequently, we can now source data live from PBCS applications without the need to extract and import into OAC. I have seen several financial departments use PBCS as a source for budgets and forecasts […]

“Catching up” is the term that came to mind when I used to check out what’s new with Oracle Analytics in previous years. This year, however, I frankly say I was impressed with what I saw at Oracle Open World last week. The rules of the analytics platform game have changed, tremendously. This is after […]