What are Late Arriving Facts? In data warehouses, dimensions are processed first and the facts are loaded later, with the assumption that all required dimension data is already available in the system and a Parent fact is already available before a child fact. But, this scenario may not always be the case because the nature […]
Technical
Considerations for Integration Strategies
This year, organizations will manage more data than ever, especially as they expand how they engage with customers. However, the lack of an appropriate strategy will hamper these efforts, causing harm to organizational efficiency, agility, and customer care. As we have discussed on this blog in the past, one way to address these challenges is […]
The Plugin-Free Web: Is Your Business Ready?
John and Amy sit down with their morning coffee and start browsing the news. Unfortunately, they both get served an advertisement with a malicious applet inside. John’s computer is passively infected with a virus which spreads inside his company’s network but Amy’s computer is unaffected and her company is safe. What’s the difference between John […]
Perficient Accelerates Partnership with CA Technologies to Drive APIM
Perficient announced today an expansion of its partnership with CA Technologies to provide industry-leading services for managing enterprise-scale application program interfaces (APIs). CA Technologies fuels digital transformation for companies by providing solutions that help them plan, build, test, deploy, operate, and secure software in ways that ensure success in the application economy. APIs are routines, […]
DevOps Enables Healthcare Insurance Transformation
Developers have more access than ever to the right tools and resources that enable favorable development outcomes. Open source solutions over the past few years have gained particular interest for their low cost, agile, and interoperable characteristics, enabling the development and acceleration to market of mobile, web, and social solutions. Such was the challenge of […]
Open Banking And PSD2 [Trend To Watch]
In an effort to create more competition in the financial services industry, give consumers more control over their data, and enhance consumer protection, new regulations, such as the revised Directive on Payment Services (PSD2), have been adopted in Europe. Some companies, such as BBVA, were early adopters of technology (e.g., APIs) that opened access to […]
The Wonderful World of Oracle HFM Alternate Hierarchies
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. […]
Enabling HTTPS for a Mule Application
Enabling HTTPS is a common task when developing HTTP based applications. With many platforms, such as Apache server, WebLogic, JBoss etc, it’s simply a matter of clicking a checkbox, or change one config line. For a Mule application, it takes a bit more finessing. There are plenty of posts and online resources discussing it. Yet […]
Business Process Management (BPM) Impact on Financial Services Trends of 2017
I recently read through a guide on the Top 15 Financial Services Trends for 2017 by my friend and colleague Eugene Sefanov. Business Process Management (BPM) platforms continue to add more capabilities for greater impact on all industry verticals allowing organizations to remain relevant in an ever changing digital economy. The following is some insights […]
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 […]
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 […]