Archivi autore: Stefano Francese

EXPERLAB and EPM Cloud

With seven implementations already live from 2019 to today (five on FCCS, one on PBCS, two on EPRCS) EXPERLAB is increasingly being recognized as a company that invests in new Oracle EPM Cloud technologies; also strong of the experience started in 2005 on traditional Hyperion applications.
We make fifteen years of project history available to CFOs and CIOs.
Together we think about:
– Make a new implementation of EPM Cloud;
– Migrate from EPM on premise to EPM Cloud;
– Stay on EPM on premise, on updated releases;
– Migrate individual application parts from “on premise” to Cloud keeping the two worlds active and managing a “light” passage and in parallel for a period of time.

EXPERLAB is:
Training of young resources on new technologies.
Experience.
Reference point for companies on all traditional and modern EPM.

EPM Cloud integration

We are in front of a company that tells us that it is evaluating Oracle to cover the following Financial Close processes:

– Statutory and managerial reporting;

– Budget and planning;

– Consolidated financial statements.

What can we offer?

Today we will be able to start from EDMCS (Enterprise Data Management Cloud Service) to explain how metadata is imported into a shared environment and how it is distributed in planning and consolidated applications.

We will show the strengths of FCCS (Financial Consolidation and Close Cloud Service) for the consolidated financial statements, and PBCS (Planning & Budgeting Cloud Service) for planning.

We will go back to EDMCS and we will say that in addition to keeping the metadata aligned between different modules, it moves the data from one environment to another: we can show a practical case where the Budget data processed and validated in PBCS is brought to FCCS to be consolidated and compared to the actuals.

On EPRCS (Enterprise Performance Reporting Cloud Service) we will build the reporting book: variance analysis, management reporting, note to the financial statements, supplemental info.

The added value that EXPERLAB brings, beyond the technical competence and constant updating on all Oracle EPM technologies, are the over 15 years of experience in Finance projects of this type and the predisposition to understand the main problems of management control resources.

FCCS case histories

Between 2019 and today ExperLab has managed n.5 implementations of Oracle FCCS applications, n.4 of which are already live and active.
The experience on the Cloud consolidation on Oracle technology grows, after more than 15 years of implementations of the consolidation in HFM.
Here are some of the features of the applications released to our customers:
– N. operating users: between 5 and 15;
– Statutory and managerial consolidation;
– From a minimum of n.8 to a maximum of n.60 companies consolidated in the perimeter;
– Flat and staged consolidated by region, statutory and foreign currency;
– Cash Flow Statement and Notes tables developed in all implementations;
– Import data from different sources, via Data Management;
– Dimensions of managerial analysis such as Channel, Geographical Area, Cost Center, Business Line, Department, Division;
– At least 2 “historical” closing loaded and reconsolidated in all applications;
– Presence of budget and planning scenarios;
– Both new implementations and migrations from HFM.
The relationship with Oracle in identifying the new features introduced in the tool is constant and contributes, together with the technical growth on the tool of our resources, to build the best implementation practices along the various projects.

FDMEE and EPM Cloud

One of the main phases of a migration project from Oracle EPM “on premise” to Oracle EPM Cloud is the transition of the historical data from old to new environment.

Having an FDM EE at home, even if not fully used to upload data from ERP, is of fundamental importance.

This ETL, which we are used to seeing data from JDE, SAP or other sources load into Hyperion, connects our traditional applications with CLOUD applications, maps the existing dimensions with the new ones, migrates the data.

Imagine, in a consolidated financial statement application, that we need to migrate different actual and planning data scenarios, starting from 2015, statutory and managerial. Imagine the need to migrate both the legal entity data and the consolidated data: FDM EE migrates both types, and this allows system integrators and key users a significant time saving in not having to reprocess or reconsolidate, within the new environment , the previous database.

Strongly recommended in the plans to move to the Cloud for the reconstruction of the “historical” Financial Statements and the Notes.

For demos and further information: support@experlab.it

EPM Cloud Migration

Last week we met a company that uses an older version of Oracle Hyperion Financial Management and is considering migrating to the most updated release (11.1.2.4 or 11.2); today they manage both the consolidated and the monthly budget on HFM.
With Epm Cloud Enterprise they could:
1. Separate the two processes on the two separate modules: Oracle FCCS (Consolidated) and Oracle PBCS (Budget);
2. Exploiting cubes and dimensionality of Oracle PBCS to structure the Budget process more;
3. Optimize the execution times of the consolidation process, made heavy by the allocation and monthlyization rules;
4. Use of rules “on demand” to be linked within each phase of the Consolidation and planning process;
5. Bring the Budget data from Oracle PBCS to Oracle FCCS for consolidation through Data Management.

#experlabstories

Services for Actual Fy19

Looking at the closing of the Group Consolidated Financial Statements as at 31.12.2019 ExperLab offers:

  • Assessment on current use of EPM systems, in particular Oracle Hyperion “on premise” and Cloud, and gaap analysis with desired level of use;
  • Training sessions for basic users, key users and administrators;
  • Development of templates to improve the process of loading of financial statements by Legal Entities and ensuring the control of the integrity of the data in the system;
  • Development of templates for the management of manual consolidation entries;
  • Evolution of application structures (metadata), calculation rules, translation, consolidation;
  • Creation of new data analysis reporting along the consolidation process (Translated / Aggregate / Eliminations / Contribution levels).

The aim of the proposal is to provide the key user with a single service package, capable of:

  • Strengthen his skills in the use of the various components of the system;
  • Increase the application’s ability to respond to its Financial Close needs.

Oracle Hyperion 11.2

The new version of Oracle Hyperion EPM “on premise” 11.2 is officially available.
A migration alternative for those customers who have Hyperion version 11.1.2.3 or earlier installed at home.
ExperLab is available to assist Hyperion application key users to understand together migration opportunities to:
– Oracle Hyperion EPM 11.2;
– Oracle EPM Cloud Enterprise.

EPM Cloud implementation

With the Hyperion suite “on premise” Performance Management consultants used to create different separate application modules: HFM for the consolidated statements; Planning, with the Essbase engine, for the Budget and Reporting; just to stay on the main ones.

In the consulting team, the consolidated senior consultant and the senior reporting and budgeting consultant spoke different languages ​​and met with different customer users. The modules were implemented at times that were often far from each others, even years. The owners of the applications changed over time, there was the issue of how to integrate the world of the consolidated with the planning one, at the level of data and metadata.

There was the aspect of the purchase of additional licenses to be made available to the same user who was already “live” on the consolidation application, but had no access to the planning one, and remained interdicted by a “profane” of computer science.

The implementation projects risked being “short-sighted” because a module was implemented without having full visibility of the subsequent process to be covered. Risks of reworks on project streams already released. “River” meetings, where to put together general accounting and analytical accounting.

The implementation activity was more complex and certain reporting or financial close functions had to be reconstructed by passing days to write distant and insurmountable code for finance users and application controllers.

With regard to Hyperion, we have often heard controllers and managers of consolidated talk about “Ferrari” used maybe 10% of their possibilities. Very solid and market-leading applications for all Financial Close processes, but distant for all these reasons from the concept of “user friendly” so dear to users who already have different headaches in the normal activity of finance administration and controlling.

Today we implement also Oracle EPM Cloud Enterprise.

A unique suite that integrates all the Financial Closing modules. The Planning and the consolidated, together with the narrative reporting, or the account reconciliation are in the same environment. They talk to each other. Data Management integrates accounting data and takes them from one module to another; in the planning we launch allocations and manage worfklow and data validation; and then we import everything into the consolidated module to see the budget and forecast numbers at group level, and analyze the variances with the actuals.

The application key user and owner is active on the development of all Financial Close views and has the full history of application choices. It has a global vision of all developments phases and guides consultants within this global vision. Consultants grow in implementation best practices.

The new integrated modules introduce new functions, based on Oracle’s experience in the Performance Management sector on the various Closing processes. Technical and functional release updates on a monthly basis. These are economies of scale for simplified implementations (with less work for the EPM consultant!) and with key users who play more active roles and are owners of more accessible applications and faithful friends in stressful times during the closure days.

Obviously, with the Cloud, we no longer hear about compatibility issues and server or service restarts. But this is yet another theme.

Contact us to understand how ExperLab is already implementing the new Oracle EPM Cloud practice, both on new customers and on “on premise” applications to be progressively migrated to new technologies.

Discovering EPMs status

For the period of December 2019 / January 2020, looking at the financial closing processes of the end of the year, Experlab proposes an assessment meeting where to analyze the following areas:

Existing applications:

  • Applications ability to support the Closing process;
  • Level of user skills in the use of applications;
  • Needs for application new developments on data integration, reporting, calculation rules, user workflows;
  • Integration requirements for new modules.

Old Applications release / no longer covered by Oracle support:

  • Possibility of migration to Oracle EPM «on premise» 11.1.2.4;
  • Possibility of migration to Oracle EPM «on premise» 11.2;
  • Possibility of migration to Oracle EPM Cloud.

Non existing EPM application:

  • Possibility of Oracle EPM Cloud implementation;
  • Possibility of one or more EPM modules «on premise» 11.2 implementation.

The meeting is proposed to the following professionals:

  • Management control;
  • Administration, finance, treasury;
  • IT Departments.

An EPM system for the CFO

At the Oracle Cloud Day summit on November 5th in Milan we will be pleased to present how an Enterprise Performance Management (EPM) system can support the various financial closing processes.
ExperLab consultants, product experts and experts in different areas of management control, will show the strengths of Oracle FCCS and PBCS applications in terms of:
– Data acquisition and integration with different ERP or source accounting systems;
– Elaboration of a budget or consolidated financial statements process, along the various functional phases;
– Workflow, user tasks, review, promotion and data validation;
– Safe and frozen reporting book on web or Excel platforms;
– Use of modern systems, in step with the times, with the introduction of always new functionalities capable of supporting the management control closing processes.