There are a number of products in the EPM suite. In my mind, the core products are
- Hyperion Financial Management (HFM)
- Planning & Essbase
- Financial Data Quality Management (FDM)
While there are clearly other very important products in the EPM suite (HSF, Financial Reports, DRM), the core products have a wide installation base and continually see enhancements and new functionality. Of these core, and to some degree most EPM products, FDM is the only application to include a myriad out of the box reports.
Out of the box, FDM includes 90+ reports that function without any additional configuration! If you consider the average time it can take to create a Financial Report (.5-2 days depending on complexity), the value of these pre-built reports cannot be understated. In this post, I explore these reports and highlight those that, in my experience, have the highest utility.
|Trial Balance||Detailed information about source data processed through FDM|
|Process Monitor||Detailed status reporting of the workflow process|
|Location Analysis||Mapping & System Log information|
|Trend||Trended views of source/trial balance information|
|Variance||Period/Category differences for source/trial balance information|
|Audit||Trial balance investigation; Map changes|
|Listing||FDM application metadata information|
|Security||User security & usage|
|System||Application & adaptor settings|
|Journal||Detailed information about data processed as journal entries|
|Archive||Detailed information about documents archived during the workflow|
|Batch||Detailed information about batch processes|
|Dimension Grouping||Provides pivot table like views of source/trial balance information|
This report displays the source and target accounts & entities. The true value add of this report is the 2 data columns. The first shows the data that was imported from the source system and the second shows the data that FDM loaded to the target application. This dual data column allows a user to quickly identify any records that required the sign flip flag to be adjusted.
This report displays the workflow status of each location in the application. The report respects the location hierarchy. Each location has 5 steps (yes 5) that are tracked. The Export workflow step is broken into 2 steps as an export may complete successfully but the load to the target system may fail. The date & time stamp of the last process executed is also displayed.
This report allows a user to enter a target account – or a target account pattern (ex: account begins with 51) – and the report will show all the records in FDM for all the locations that make up the balance of that target account. The records are filtered based on the location security that a user has in FDM. This report was the precursor to drill through and still has great utility because it does not require an input level intersection across any dimension except account.Map Monitor For Location
This report displays each of the addition, changes & deletions to the mapping for a particular location. This is highly efficient way to determine who changed a map, when and from what-to what.
This report displays the key settings (Import Format, Validation Rule, Parent, etc) for each location in the system.
This report shows the last time a user actually logged into the application. This report can help you assess for which users a license should be maintained.
This report will provide detailed information about each of the events that are captured in the FDM application log. This report can be used to determine when and action was performed and by whom. In the event of an error, this report is critical to gathering additional information about the error.Import Analysis
I saved my favorite report for last! This report is critical to identifying the source of slow import performance. The report displays the elapsed time for each step performed during a data file import. Utilizing this report can help an administrator understand if there is a database performance issue or if the maps are simply inefficient. For any FDM shop, this report is a MUST use!
You may be asking yourself – “What about the batch reports?” While the batch reports provide good information about the batch process, I prefer to develop email status reporting that distills the information into a more user-friendly format. See my post on enabling lights out automation for more information and a sample email format that I use to augment the batch reporting in FDM.
Don’t let this post be the end of your learning. I encourage each of my clients to explore the report sets and each of the reports that are available. You may uncover a report that gives you exactly what you need!