Platforms and Technology

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

We will continue to explore the top 5 healthcare provider trends for 2017. My previous posts in this blog series highlighted our first two trends: Handing the Patient Portal Reins to the Patient and Connecting the Patient to Connected Health. In our third trend we will look at how the increased demand for mobile will […]

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

It’s the beginning of February, which means that tax season has begun. Mixed between the mess of W-2 forms and receipts are overwhelmed tax preparation professionals working towards the yearly April deadline while navigating through a complicated tax code. Whether you’re a first-time filer or have numerous done it many times before, missing a few […]

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

Valentine’s Day, despite its retail foundations, is a great day to reflect on what we are grateful for and the things we love. Even though not all of us will be giving or receiving chocolates and roses, there are still many other things to love, including cloud computing. Let us count the ways: Cloud is […]

According to Forrester’s recent CRM trends report geared to help users navigate the future of CRM in 2017, the use of customer relationship management (CRM) solutions should be viewed as the foundational building block to power your customer experience (CX) strategy. For Salesforce users looking to tap into the true power of the platform, your […]