About DrillThrough on FDM

2018-08-31FDM

DrillThrough means tracing from the destination account of an EPM system to the source accounts of GL; here we talk about: #JDE as source, #FDM as ETL and #HFM as destination. Experlab, in collaboration with a system integrator, has implemented a solution that reduces the maintenance need of FDM maps for the users. In summary: … Read More

The winning EPM project

2018-08-02Consulting

Ability to transfer skills and knowledge to key users: competence, confidence in the product, perception of this as a “friend” support and not an opponent, full committment in its use. It’s the job of a good senior consultant. The ability of an application to follow a finance process and the technical and functional expertise of … Read More

The power of Smart View

2018-08-01HFM

Knowledge transfer on Oracle Hyperion Smart View is one of the first values added on a successfull EPM project. A couple of training days should be enough to put users in a position to build their analysis views. Afterwards, it takes practice. We put ourselves on the side of the manager of the consolidated financial statements … Read More

Cloud collaboration in Eprcs

2018-07-13EPRCS

In the last implementation of EPRCS, based on HFM on premise, one of the points most appreciated by the customer was the active collaboration between the head of the consolidated  financial statements and the audit firm in sharing the Note and in cloud management of textual comments of the movements of each table. We summarize … Read More

Fdm Report Execution

2018-07-12FDM

Workbench table of FDMEE (Import / Validate / Export): extract on excel: the correct format of source account codes starting with zero, within separators inside them (example, master account/ account / cost center) has been lost. The Fdm report “01_TB Current Location, by Target Acct”, under Workflow > Report Execution> Base Trial Balance Report, returns the correct formats … Read More

EPRCS Statutory Notes

2018-04-19EPRCS

Experlab has developed its application template for the Statutory Notes to the Financial Statements Italian principles. The EPRCS (Oracle Enterprise Performance Reporting Cloud Service) report package is based on a Reference Doclet XLS made with Smart View version 11.1.2.5.720. For the textual part and the titles of the paragraphs the EPRCS variables have been developed linked … Read More

Oracle Hyperion AMS

2018-02-14Experlab Services

Experlab carries out application maintenance, support and training services on existing Oracle Hyperion EPM applications (HFM, Essbase, Planning), in line with the change in the functional requirements coming from the management control. Experlab works on multiple areas, including: METADATA: maintenance of elements or dimensions in existing cubes / applications; WEB DATA ENTRY FORMS / SMART … Read More

Financial Close is coming

2018-01-11Experlab Services

A warm period is coming for the closing of the actual Statutory financial statements and Consolidated group financial statements; many companies develop the final touches on their 2018 budget and medium / long-term plans. Experlab supports Finance and IT users with experienced and qualified Application Maintenance and Support services on all application components of following … Read More

Essbase and Fccs uploads

2017-12-11FCCS

We think that, by developing our FCCS consolidation template we will find so many matches with ESSBASE functionalities. And so, we try to report here. Let’s talk about metadata development in FCCS: here we can use the IMPORT METADATA function, so we build a TXT file with the dimensions we want to import into the … Read More

Movements Consolidation

2017-11-28HFM

What is HFM’s strong point in making the Consolidated Financial Statements? Several points I would say, but today we appreciate the consolidation of each individual balance sheet movement. Imagine an HFM application that, for the purposes of the Notes to the Financial Statements, presents the following flows available for the various sections of the Balance … Read More