Oracle | Perspectives on Oracle Technologies for the Enterprise


Perspectives on Oracle Technologies for the Enterprise

Using Physical SQL (PVOs) to Extract ERP Cloud Data from OTBI

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

Read more

Using Logical SQL to Extract ERP Cloud Data from OTBI

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

Read more

BICS Lift and Shift from OBIEE

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

Read more

How to Monitor Essbase Database Fragmentation

Fragmentation of Essbase block storage databases occurs as a result of routine data changes, data loads, and calculations. Essbase has two database statistics that measure database fragmentation: the average clustering ratio and the average fragmentation quotient. Check out this article from the Oracle Customer Engineering & Advocacy Lab for a more thorough description of BSO […]

Read more

Discover New HFM Functionality

After teaching several HFM Create & Manage Applications courses, I have found several functionality advantages of HFM User Functionality Greatest user improvement comes in Smart View and the Journals Extension. Users now have to ability to create and manage journal entries in Excel. We know that any time functionality can be completed in […]

Read more

Why Oracle DRM is Essential for Managing Master Data (Part 4)

We’ve covered exports and validations so far in this blog series. Our next topic is centered on the ability to create attributes, or properties, in DRM. Some examples of properties include: – Address information for branch offices – FEIN numbers and currencies for legal entities – Account type for accounts in EPM and/or EBS applications […]

Read more

Challenges in Financial Planning

It’s well known that many organizations invest a tremendous amount of time and energy preparing the annual operating plan. Mature finance organizations have moved beyond the annual plan to more useful monthly forecasts, rolling plans, and predictive analysis. Regardless of frequency, the budget and forecast cycle is often beset with the same issues: Errors manipulating […]

Read more

A Best Practice for Creating Dynamic Column Reports in BICS

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

Read more

Oracle Eloqua – Subscription Management

You probably have some sort of subscription management today, but is it what you need?  Is it giving your clients and prospects the ability to management what they receive? I want to go through a few items that may help you determine what is the best plan of action regarding managing the options.  The options […]

Read more

An ARCS and FCCS Implementation Success Story [Webinar]

Orthofix International, a global medical device company and a legacy Hyperion Financial Management customer, needed to improve its overall close process, providing better tools to employees, and minimizing its infrastructure footprint. They partnered with Perficient to implement Oracle Hyperion Account Reconciliation Cloud Service (ARCS) and Financial Close Cloud Service (FCCS) to perform account reconciliations and […]

Read more

Perficient Oracle Blog

Perspectives and insights on how you can best leverage your investment in Oracle cloud and on-premises based solutions to enable your business optimization and drive growth.