Posts Tagged ‘BICS’

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

In a recent Perficient webinar, How Western Alliance Bank is Innovating with Oracle Cloud, attendees were treated to not one, but two speakers from Western Alliance Bank! Andrew Boucher, vice president market risk management, and Valentino Hafalia, vice president of FP&A discussed the challenges with the legacy environment and benefits realized with consolidated analytics as […]

Western Alliance Bank had good visibility into profitability but lacked a platform that could pull data from different sources, model it, and create visual stories that empowered users to spot opportunities, forecast efficiently, and reduce risk. Andrew Boucher, former vice president of FP&A at Western Alliance Bank, led the bank’s effort to find a cloud […]

I spend much of my time figuring out what things organizations are doing well when it comes to their enterprise analytics, what makes them better, and how to get there. After a few communications consulting for a new customer, I came to realize that they are likely categorized in one of three groups, most if […]

You are in a hurry and away from your office desk but really need an important piece of information before your next call or meeting. If only Siri or Google Voice can help. These personal assistants can’t answer questions related to your secure enterprise data, at least not without some serious amount of programming. Last […]

With Oracle Data Visualization Cloud Service, your business users can perform self-service analytics, spot patterns, trends, correlations, and construct visual data stories for greater insight into how your product, service, or organization is performing. In this webinar, you will learn how easily users can explore their data in new and different ways through stunning visualizations […]

At the Collaborate 17 conference, I attended the official announcement of the release of Oracle Analytics Cloud (OAC), delivered by John Hagerty, VP of Product Management. It was a clear message from Oracle BI Product Management that Oracle’s Cloud BI offerings are positioned to provide a solution for “Everyone”. “Everyone” here is primarily twofold: First, BI […]

The need exists for the ability to read and extract data from BICS, especially when the ETL strategy involves a Staging approach, as written about in Best Practice to ETL with Data Sync (BICS). But Data Sync does not support the direct data read from BICS. The built-in Oracle (BICS) connection in Data Sync only supports a data write to BICS. […]

A couple weeks ago, Oracle released Oracle Analytics Cloud (OAC). But there was already Oracle Cloud offerings for BI, mainly Business Intelligence Cloud Service (BICS) and Data Visualization Cloud Service (DVCS), so why is this new? And how is it different? Simply, OAC doesn’t abolish its predecessor Cloud BI services, but it makes them more […]

Common dimensions are required for cross-facts reporting, and are oftentimes referred to as conformed dimensions. A dimension can be conformed through its data consolidation, or its logical data model. Data consolidation is useful for conforming the dimension data which has the same hierarchy level, and happens in MDM and ETL processes. A logical dimension is very useful for conforming the […]

There are several analytical capabilities that Oracle Enterprise Performance Management (EPM) products, whether Hyperion on-premises or Cloud EPM, have to offer. Financial reports and ad-hoc analysis in Excel are all great. However, in general EPM reporting capabilities remain restricted to whatever data you have in EPM. Are you looking to do one or more of […]

Perficient is proud to be a sponsor at Collaborate 17, which is being held April 2-6 in Las Vegas. It’s an opportunity for the Oracle user community to come together to share and learn through sessions, panels and networking events. We are honored to have been invited to present on six unique topics across multiple tracks at Collaborate and […]

Now that we have three different approaches to extract Oracle ERP Cloud data from OTBI, there comes the question – what’s the best practice, or which one should you recommend? Before answering the question, let’s take a look at the feature list of each approach so we can understand what they are best at. Feature List […]

Custom SQLs work differently than logical and physical SQLs.  Instead of going through the OBTI subject areas and the Fusion PVOs in the RPD physical layer, custom SQLs are used to create custom data models in BI Publisher to extract ERP Cloud data directly from the Fusion database tables.  The built-in Data Sync Oracle BI Connector does not support […]

Physical SQLs are essentially the same as Logical SQLs. Behind the scenes, Logical SQLs are converted back to physical SQLs by BI server using the OTBI Fusion public view objects (PVOs) defined in the RPD physical layer. Physical SQLs leverage the same Data Sync built-in Oracle BI Connector used by logical SQLs for extracting ERP Cloud data from OTBI. The process […]

This approach is officially recommended by Oracle. Data Sync comes with a built-in Oracle BI Content connector, which can be used to extract ERP Cloud data from OTBI. The connector supports three data extraction modes. SQL – used to extract data from logical SQL queries Report – used to extract data from BI analyses reports Subject Area.Table – used  for extracting […]

Recently I led a comprehensive analysis and POC for lift and shift of on-premises 11g to Oracle BI Cloud Service (BICS). The lift and shift approach is gaining popularity as it offers a hybrid BI Cloud without having to worry about data security and recreating metadata in the cloud. BICS can leverage the on-premises repository […]

If you ever had a requirement or thought of creating an analysis report in BICS to display report columns dynamically, but later had to give it up due to the complexity, you might find this blog post is what you’ve been waiting for. I am going to show you how easily such a report can be created […]

Here are the blogs that I have posted previously as part of my blog series on Oracle DataSync (BICS). Best Practice to ETL with Data Sync (BICS) In this blog, I am going to talk about three different ways to integrate Oracle ERP Cloud data with Data Sync (BICS) through OTBI.         […]

In this blog, I will finish the Best Practice to ETL with Data Sync (BICS) post by showing you how to configure the Data Sync to load data in staging database. First, set up a new database connection in Data Sync for SQL Server or Oracle database. For SQL Server > Set Connection Type to MSSQL > Fill in the rest […]