First Look: Enterprise Data Management October 2019 Release
The 19.10 release of Enterprise Data Management (EDM) not only delivers major new enhancements, but it also significantly closes the gap and brings EDM closer to parity with Data Relationship Management (DRM), it’s on-premise cousin. I have to say, this is my favorite EDM release so far (okay, I might have said that before but it’s true!).
In this blog, I’d like to focus on 3 specific enhancements:
1) Financial Consolidation and Close (FCCS) Adapter
2) Audit History
3) Compare Selected Nodes
Look for other blog posts coming soon to highlight other features such as the one we’ve all been waiting for: Derived Properties!
Financial Consolidation and Close (FCCS) Adapter
In this release, a new packaged adapter was introduced for FCCS. This is the 5th adapter for EDM following Planning, Planning Modules, Financial Cloud GL, and Custom.
As with the other packaged adapters, the FCCS adapter is similarly designed and easy to use. Specify a smattering of application and dimension registration details and Bob’s your uncle - you have created your very first EDM application for FCCS.
Here’s a quick overview of the setup:
- Application Settings
On the primary Application Settings screen, specify your Currency, Intercompany, Alias, and Smart List details. Note that if you specify the application as an “Extended Dimensionality Application,” you can create up to 4, count ‘em 4, custom dimensions (or 3 if multi-GAAP is enabled). Otherwise, you can specify only 2 custom dimensions (or 1 if multi-GAAP is enabled).
The Dimensions screen is very similar to other packaged adapters. Input your dimension name, dimension type (Account, Entity, Movement, or Custom), and Shared Nodes flag. Attribute dimensions can also be specified. In this example, I created 4 dimensions including a custom dimension called Detail.
And that’s it! A final summary screen is displayed. Click Apply to create your application.
As with other packaged adapter applications, your EDM FCCS application provides built-in validations (refer to the excellent Oracle EDM product guide for details) to proactively detect master data quality issues that would impact FCCS, as well as direct connectivity to the FCCS Inbox/Outbox for importing/exporting of dimensions.
EDM has provided a strong audit function since Day 1, but from a “request” perspective. Within a request, details of each individual line item change were displayed. But if I wanted to search transaction history from a global perspective (e.g. by user, date range, or node name), that was not possible – until now. You will now see an Audit card on the EDM home page.
Note: A new Auditor role has been created to specifically provide access to this function.
For anyone who loves DRM, you will find the EDM audit/transaction history functions in much the same way. You can filter audit history by several parameters including:
- Data Chain (by application/dimension/node type/hierarchy set)
- Actions (Add, Update, Insert, Move, Rename, etc.)
- Node Name
- Request ID
- User Name
- Time Frame
And results can be downloaded to Excel for further analysis and offline viewing. Pretty cool.
Compare Selected Nodes
I love this feature! I heavily use the Compare feature (missing nodes, relationship differences, and property differences) in all my EDM projects. I find it to be an excellent feature, except for two constraints. One was addressed recently in that you were not able to easily convert compare results into a request file to resolve the differences. That option is now available.
And now the second issue has been addressed – you can now compare a subset of nodes between two viewpoints, and you are not forced to compare entire viewpoints. Most of my clients have multiple EDM applications and complex dimensions with many alternate hierarchies across those dimensions. Until now, I was forced to create alternate viewpoints (new node set, same hierarchy set/node type) so I could isolate primary or alternate hierarchies specifically for comparison purposes. That is no longer necessary! You can now compare the structure under a subset of the viewpoint by selecting a specific parent node.
Want to know another nice feature with this new enhancement? You can now compare bottom nodes within the selected parents. Very useful when you need to ensure level 0 members are in sync between two different rollups where the parent levels are intentionally different.
That’s it for now. I’d love to hear your thoughts and questions on EDM 19.10 and be sure to check back soon for a follow-up blog post on derived properties.
For comments, questions, or suggestions for future topics, please reach out to us at firstname.lastname@example.org. Follow Alithya on social media for the latest information about EPM, ERP, and Analytics solutions to meet your business needs.