extending-ebs-for-cloud

Oracle OpenWorld Recap: 3 Takeaways on Reporting for Hybrid and Cloud Environments

In September, I attended Oracle OpenWorld 2019 and it was chock full of announcements and sessions on how Oracle is winning in the Cloud and showcasing its march towards delivering the “world’s first completely and truly autonomous cloud.”

I was most intrigued with conversations focused on the state of customer cloud migration strategies and on its Cloud product roadmap as it relates to reporting and analytics, and specifically the latest advancements with Oracle EBS.

Here are three key takeaways:

Hybrid is the new normal for cloud migrations

Oracle understands that not all customers are ready for Cloud Applications and that “hybrid” is the new normal. In its product sessions, Oracle promoted a co-exist strategy for customers to extend EBS with cloud applications that improves upon existing EBS modules or for adding functionality not available within any existing EBS modules. Furthermore, Oracle suggested that a co-exist strategy to extend EBS should start with “edge” cloud applications.

From my peer conversations at the event, many customers are looking towards a hybrid cloud strategy for adopting the four major pillars of Oracle Cloud Applications: ERP Cloud (financials, procurement, projects, EPM), SCM Cloud, CX – Customer Experience Cloud, and HCM Cloud. This makes the most sense for large complex enterprises that have invested heavily in Oracle EBS for managing change in determining how their existing integrations will evolve.

Shifting focus to pre-built content for cloud reporting and analytics 

With calling OBIA content complete, it’s clear that Oracle is shifting its focus on creating analytics specifically for Oracle Cloud Applications rather than investing in analytics for Oracle EBS. For instance, Oracle announced the availability of Oracle Analytics for Fusion Apps, which includes packaged analytics, dashboards, reports, KPIs built on Autonomous Data Warehouse.

This development aligns with Oracle’s move to support customers pursuing a hybrid-cloud strategy, but this also means that customers will have to rely on system integrators and custom development to fill the gaps. While the Oracle Analytics roadmap is impressive, just like OBIA, I suspect there will be room for improvement. Stay tuned for further analysis on what will be necessary to determine the gaps.

Continued support for EBS

Oracle’s latest release of EBS version 12.2.9 includes some legislative changes in Financials, improvements in lease and finance management, and improvements with Property Manager and there was excitement around its latest Enterprise Command Center (ECC) dashboards. We expect future releases of EBS will offer improvements to underlying middleware without customers having to go through a full upgrade of EBS applications.

What’s clear from my discussions is that EBS users still need help with accelerating their reporting and analytics initiatives. But with more modules only being offered through Oracle Cloud, this can become a challenge for organizations wanting to take advantage of the latest applications.

At Magnitude we’re building the next generation of Noetix to support reporting and analytics for full and hybrid cloud deployments. Noetix Cloud Analytics delivers near real-time reporting from a single operational reporting data store through business views to simplify access to data from Oracle Cloud Applications and Oracle EBS.

To learn more about our Operational Reporting solutions for Oracle, let’s have a conversation.

replacing-oracle-deliver

How to Ensure a Smooth Transition away from Oracle Discoverer

As a reporting tool of choice for many, how are you handling the transition away from Oracle Discoverer?

A complexity with Oracle Discoverer is that it requires extensive setup of the End User Layer to effectively engage reporting capabilities before users can create and modify reports. To ensure a smooth migration, organizations need to find the right tools that can give users the same capabilities and access they had in Discoverer, while allowing them the benefit of the recent advancements in reporting platforms.

Here are five reporting tips to ensure a smooth migration away from Discoverer:

  • Understand the reports that you have today in Oracle Discoverer. You don’t want to convert a copy of a copy of a report. Depending on how many user groups you have in Oracle Discoverer today, this may take some time to take stock of the scope of reporting. One approach to get prepared is by querying the EUL schema in EBS for the run statistics of the reports saved to the database through Discoverer.
  • Make a priority to quickly identify mission-critical reports that run the day-to-day operations. This is needed so you can convert them in the fastest way possible to get your users familiar with a new tool and to relieve the pressure of simply converting each report. This may require copying the SQL, for now, into the new tool. For a quick win, you’ll want to show progress while you implement a new solution.
  • Map your reports to new data model. After you’ve taken inventory of the reports used across the organization, open up Excel and start listing out the columns in those reports. Your objective will be to map your reports to a new data model and find any gaps that may exist in the new data model.
  • Address reporting gaps. Look for reporting gaps by extending the new data model to meet the needs of users. This exercise can save hundreds of hours of converting each report into a new tool. You only need to address the gaps by changing the data model that will support all of your reports. For example, you may have one table that is being used by 100 reports. In those 100 reports, there is a column that is missing in the new data model. You’ll only need to add that new column to the table once to support 100 reports.
  • Render reports into new tool. Once you have your new data model that supports all of your reports, the next job will be to actually render the reports into the new tool. Your mission is two-fold: replace Discoverer and the underlying data model and manage the change the users will go through with using the new tool. Instead of having your team taking on the task of rendering each report for the users, this is a good opportunity for users to get accustomed to the new tool. This is all about keeping the self-service capability they had in Discoverer intact.  This only works if you have addressed all of the gaps in the data model and provided them with more than just what is in the SQL of an individual Discoverer report.

We’ve helped our customers successfully transition from Oracle Discoverer to their BI platform of choice and increase their user satisfaction, even for the most advanced Discoverer users with Noetix.

For more on this topic, check out the webinar on-demand: How to ensure a smooth, successful transition away from Oracle Discoverer

How to Overcome the Business Intelligence Challenges of Today and Tomorrow

As a follow-up to our Reconciling Oracle Projects with the General Ledger demo, we’ll dive deeper on examining the top business intelligence (BI) challenges and provide insights for streamlining the manually-intensive process of implementing reporting tools and enterprise-wide BI initiatives.

Today’s BI and analytics leaders face enormous complex challenges in just trying to keep up with the rapid pace of evolving ERP architectures. They also need to deal with integration headaches while trying to bridge the gap for future needs of user groups.

Watch this video to learn how to prepare your organization for the future while addressing current business needs with a centralized data platform with pre-built, extensible content using your BI platform of choice.

Key topics:

  • How organizations are making use of pre-built content to accelerate their business analytics
  • Getting started with centralizing your organization’s data from multiple ERPs and external applications
  • Best practices for giving your user groups the confidence they need to become self-reliant
  • Demonstration of combined reporting from an Azure SQL Database and Power BI in action, including: Oracle Projects, Oracle Financials, Discover Replacement, MDM and CPQ Cloud

Check out our resource library for more operational reporting, strategic reporting or business intelligence insights or request a personalized demo!

Reconciling Oracle Projects with the General Ledger

Oracle EBS Financials, Power BI and NoetixViews

As a follow-up to our Simplifying Account Reconciliations demo, we’ll examine the complexity of reconciling Oracle Projects with the General Ledger, a pain point for many finance departments.

To streamline your financial reporting, you need timely access to financial data to know exactly what are the budgeted versus actuals and what are your asset account balances for any given time period.

Watch our on-demand demo of Oracle EBS Financials and Power BI and we’ll address the fundamental question: How can we use our real-time views to assist with reconciling Oracle Projects with the General Ledger?  

We’ll outline the four steps for Power BI report development process:

  • Understanding your reporting requirements
  • Research NoetixSearch via access to Noetix Generator
  • Determining if any Views need to be joined or extended
  • Creating Power BI reports and publishing to Power BI service for Excel

To learn more about NoetixViews for streamlining the manually-intensive process of implementing reporting tools and enterprise-wide BI initiatives, request a personalized demo today!

Simplifying Account Reconciliations: Oracle EBS Financials, Power BI and NoetixViews

Account reconciliations are a critical process during month-end close. But given the complexity of the Oracle EBS data model, it’s a struggle for most business users to create reports on their own. Read more

Using Power BI Excel Integration to Improve month end close process

Whether you are trying to accelerate your period-end close process, manage expenses or improve cash flows, you need access to your financial data. If your organization is running on Oracle, then you know how notoriously difficult it is to report from Oracle EBS with its complex data models and thousands of tables. Read more

Live webinar series: Master Noetix products to streamline all your reporting

Join us for our live webinar series for tutorials and demonstrations on maximizing Noetix products to simplify your organizations’ reporting needs. Read more

New application data management ideas

Five New Application Data Management Innovations in 2018

As we reflect upon 2018, it’s been a tremendous year of technology innovation and product momentum for Magnitude. We’ve invested in significant capabilities to help businesses address mission critical challenges across the enterprise data lifecycle. Read more

Reporting on Oracle Cloud Applications with EBS

The first post in this series discussed the 9 biggest BI challenges in postmodern ERP era. This post discusses Magnitude’s approach to address Oracle E-Business Suite (EBS) customers who are increasingly adopting Oracle ERP Cloud applications (OCA). Read more

The 9 biggest BI challenges in postmodern ERP era

A recent Gartner report, 2018 Strategic Roadmap for Postmodern ERP, describes how today’s organizations tend to focus on monolithic, vendor-first Enterprise Resource Planning (ERP) strategies that do not support their digital business initiatives. The report further recommends a postmodern ERP strategy that includes the integration of differentiated and innovative capabilities that are beyond the core strengths of the common ERP platforms. Read more