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 […]
Oracle
Orthofix Implements ARCS and FCCS [Webinar Q&A – Part 2]
In this second post, of a two-part blog post highlighting the Q&A session of a recent Perficient webinar, Orthofix Improves its Financial Close and Consolidations with Oracle Cloud (ARCS & FCCS), we learn a little bit more about the Orthofix environment and implementation. Can you automate the load of GL data into Account Reconciliation Cloud […]
Using ODI to Load an Essbase Exported File to an Oracle Table
Here, we’ll cover the ability to use ODI for one its basic features: extracting data from Essbase and using the exported file to load to a table. It turns out that ODI was not recognizing the file generated by Essbase. Let’s see what we were missing: We have a calc script exporting level 0 data from […]
The Best of Both Worlds – Smart View and Financial Reporting
Clients often ask the question: Is it better to use Oracle Hyperion Smart View or Financial Reporting? The short answer is, why not use both? By understanding both Smart View and Financial Reporting, you can present the same data and the same financial reports. However, each bring a unique set of capabilities to the user. […]
Best Practices for Extracting Data from BICS Using Data Sync
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. […]
Siebel Innovation to Modernize the User Experience – #C17LV
There are many articles and blog posts written about the benefits of Siebel Open UI. So, rather than discussing that topic, I will focus on a new approach and methods and tools to leveraging the best that Siebel Open UI has to offer. Most Siebel implementations generally follow the traditional implementation approach, we get the requirements […]
Oracle Analytics Cloud: Essbase and Many Other Interesting Things
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 […]
BICS Best Practices for Modeling Conformed Logical Dimensions
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 […]
Dynamically Alternate Row Shading in Financial Reporting Studio
I am often asked by clients to create reports that display alternating shaded rows. We’ve all been there, squinting away trying to view those tiny numbers crammed onto a single report. Too often we find ourselves relying upon a ruler to help follow the values across the row as the columns continue to grow across […]
ODI Best Practices to Achieve Fast-Paced ETL (Part 2) #C17LV
Integrating data from non-Oracle source systems with an Oracle prepackage solution is a common practice that requires source to Target integration. While implementing BI Apps/Oracle EHA (Enterprise Healthcare Analytics) with a new source, I used several best practices, which can be leveraged while integrating a new source in an Oracle Warehouse using ODI. As a […]
How to Setup SAML v2 SSO on PBCS with ADFS as Identity Provider
SAML (Security Assertion Markup Language) is a XML-based open standard format to exchange authentication and authorization data between an identity provider (IdP) and a service provider (SP). A SAML-enabled web application allows browser single sign-on (SSO). We have had success implementing SSO for our clients with Active Directory Federation Services (ADFS) as the identity provider […]
Orthofix Implements ARCS and FCCS [Webinar Q&A – Part1]
A recent Perficient webinar, Orthofix Improves its Financial Close and Consolidations with Oracle Cloud (ARCS & FCCS), held a captive audience for a solid 20 minute Q&A session. In this two-part blog post, I’ll share the highlights of questions asked by attendees and answered by both Perficient and Orthofix. Why did you choose the Cloud […]