Cloud

2016 was the year hybrid cloud arrived in the mainstream as many organizations sought to dip their toes and explore the potential benefits. With the beginning of the year now out of the way, results have begun to pour in on motives, anticipation, and vision towards the future. The latest insights into where hybrid cloud […]

Release 12 of Oracle Sales Cloud is just around the corner and with it comes some great improvements that make it an even more compelling solution for enabling modern sales in the cloud. Oracle Engagement Cloud is the crown jewel of the release, combining Oracle’s leading sales and service capabilities. From a single screen, users […]

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

This past Sunday, Hollywood celebrated the achievements of film with the 89th annual edition of the Oscars. What was once a small gathering in the Hollywood Roosevelt Hotel has now become a global extravaganza of glitz, glamour, and inspiration. While the Academy celebrated the latest achievements at the movies, they must also look forward. While […]

In an Oracle Hyperion Financial Management (HFM) application, you can always create alternate hierarchies. We have created them for Entity, Accounts, and any of the custom dimensions. The guideline is always when the consultants leave, the HFM administrator must be able to efficiently maintain the application and meet the company’s management information and reporting needs. […]

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

Healthcare organizations face a mountain of challenges with the management of their data. As put forth in the Health Insurance and Patient Accountability Act (HIPAA) of 1996 and subsequent rulings on personal health information (PHI), health maintenance organizations must take specific precautions and care for patient data or face financial consequences. Additionally, healthcare organizations are […]