On May 4th, IT professionals from around the region gathered in St. Louis to attend the 2022 Gateway to Innovation conference. The conference provides a unique opportunity for attendees to network, learn, and gain inspiration from regional successes and national speakers. With over 1,500 attendees, Gateway to Innovation is the region’s premier single-day event […]
Analytics
Why Implement Incorta Analytics for Oracle Fusion Cloud ERP Reporting?
Oracle Cloud ERP offers several built-in tools for reporting. While native reporting tools like Oracle Transactional Business Intelligence (OTBI) and Oracle BI Publisher are well-suited for specific types of operational reporting, they do have limitations when it comes to performing complex and enterprise-wide reporting. It is therefore crucial to complement the Oracle Cloud ERP application […]
A tour of PowerQuery’s M language
In a previous post, I introduced PowerQuery and demonstrated how to perform various SQL-like operations. This article gives a tour of PowerQuery’s M language that underlies each query. let and in If you select a query and click on the “Advanced Editor” button in the Home tab, you’ll see something like this: This is the […]
Data exploration with PowerQuery
Microsoft’s PowerQuery is a neat tool that allows one to perform SQL-like operations on Excel tables. When investigating a database, I actually prefer using PowerQuery over raw SQL for a couple reasons: PowerQuery displays result sets that are much easier to look at than the a typical SQL plaintext result set. It’s easy to immediately […]
Google’s Universal Analytics Is Disappearing: How It Impacts You
In March, Google announced all Universal Analytics (UA) properties will stop processing data on July 1, 2023, and Google Analytics 360 properties (GA360) will stop on October 1, 2023. The alternative? Google Analytics 4 (GA4) is a more robust analytics platform that Google launched in 2020. What makes GA4 different than UA? There are several […]
Enhance Oracle EPM Reporting with Incorta Financial Dashboards
Are you looking to supplement your Oracle EPM applications with enhanced analytics capabilities? If you find yourself trying to achieve one of the following, this blog post introduces you to a Perficient solution that leverages the Incorta Direct Data Mapping technology. Mash up EPM data with data from other systems like ERP, Sales, etc… Drill […]
Data Conversions to Oracle Cloud Supply Chain Management is as easy as 1 – 2 – 3
Implementing enterprise-level software has its challenges. Traditionally, a few of the most demanding and challenging milestones of an implementation project have been the conversions and integrations. Oracle has been quite generous about open “import” interfaces in E-Business Suite (EBS). The new generation of Oracle’s enterprise software solution, Oracle Fusion, especially Oracle Cloud Supply Chain Management […]
The Importance of Third-Party Integrations for Ecommerce Websites
When setting up an online store or marketplace, you must consider the complete business process system. You must determine which services your resource will use and examine third-party integration alternatives throughout the development stage. Please see below a list of integrations to add to a B2B marketplace website or any other ecommerce resource. Payment Integrations […]
Create a React app that shows PowerBI data using REST
Intro Many times a client wants some sort of customized view of the data they have in PowerBI. The truth is, as powerful as it is PowerBI, like all BI tools, offer limited customizability. However, PowerBI comes with a powerful RESTful interface that we can use to show the underlying data however we wish. This […]
Telehealth’s unique purpose in healthcare
The past two years have proven that telehealth and virtual care are here to stay and will gain strength going forward for patients, providers, and payers. With the ability to provide healthcare to a vast array of patients, the next question is “now what?” How can we improve and customize a better experience for patients, […]
Creating & Invoking Custom Function in Power Query
Microsoft’s Power BI is a data and analytics reporting tool that lets you connect to multiple data sources. Once connected to a data source, raw data sets can be converted to dashboards and presented to the team, customer, anyone at any time. In this blog, we will get introduced to the custom function feature available […]
Navigating from EBS Journal Lines to Originating Transactions
Among the frequent requests when building a Financial Data Warehouse based on Oracle EBS is the desire to drill from a General Ledger period balance through the related Journal Entry lines to the underlying transaction in the source application through the Subledger Accounting linkages. Complicating this challenge is the fact that some of the EBS […]