Oracle

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

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

After teaching several HFM 11.1.2.4 Create & Manage Applications courses, I have found several functionality advantages of HFM 11.1.2.4. 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 […]

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

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

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

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

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

Intercompany elimination report is a very useful tool in analyzing intercompany balances. Plug Accounts play a major role as they store differences in intercompany balances and they group accounts with the same Plug Account in the Report. This allows HFM to match balances between Entities and the related Intercompany Partner. How do we get rid […]

We have all heard how having CRM integrated with Eloqua is a huge step in the overall thought process of data-driven marketing. I wholly agree with that, but what if you could integrate with more than your CRM to gather the data necessary to impact a customer buying without sales involvement? What would that look […]