EDMCS Idea... Need Ability to define controlling hierarchy for FCGL so inheritance can work

Need Ability to define controlling hierarchy for FCGL so inheritance can work

Description:

Currently inherited properties are not supported for FCGL applications because the properties are exported from a list view point. 

With this idea you should be able to identify a "controlling" hierarchy view point for the FCGL dimension that will define the property value on the list view point.

Use Case and Business Need:

Account Type is the best use case for this. Since account type is typically set very high in the hierarchy and all descendants have the same value, inheritance is the best data governance method for managing this property. Doing this allows members to be added and a value based on the hierarchy location is determined by default. Then when there are contra accounts the data steward only has to manage these few exceptions.

Status:

Under Oracle Review

More details:

A simple drop down on the FCGL default view inspector could allow for the assignment of the "controlling" hierarchy view point for inherited properties.

Or, when defining a FCGL property as inheritable, you can have the hierarchy view point list drop down selection there.

Once the controlling hierarchy view point is defined, the values on the list view point for FCGL will be calculated from the controlling hierarchy inherited value. 

Oracle EDMCS Idea... Allow saved connections to be used in exportDimension EPM Automate command

Allow saved connections to be used in exportDimension EPM Automate command

Description:

In the Feb 2020 Release of EDM there was an updated command added to EPM Automate for EDM called exportDimension. This new command is missing the ability to specify a defined connection for the export. 

We need the ability to specify the saved connection in EDM for this command so that we can send exports to both EPM targets (Consolidations & Planning) along with ERP (FCGL) targets. 

Use Case and Business Need:

The business wants to use a consistent batch scripting tool without the overhead of REST API or OIC build efforts. Using EPM Automate allows for simple batch command line automation from EDM into the supported applications. 

As an Oracle Cloud application, it is expected that simple configuration in needed to integrate from EDM to EPM or FCGL application as these are out of the box "detected application adapters" provided in EDM for EPM and FCGL.

More details:

Having the option in the exportDimension command or a new command called something like exportDimensionWithConnection is a must have to complete the enterprise data governance process from reference data inception through approval and ultimately into the target consuming applications.

How Does IT Manage Financial Master Data?

Traditionally, financial data marts and operation data stores are built and managed by IT. So how does the business user view and manage the hierarchies and metadata attributes without IT getting in the way? Coming from the IT side of the house, I have had the opinion that the business might “know the business”, but given the opportunity to manage a technical system they will take shortcuts and ultimately bring the IT solution back to a level they are comfortable with…and thanks to Bill Gates, Microsoft Excel ends up trumping the investment in technology.

I have found that there needs to be a bridge between IT and business users. By the nature of a bridge, there is a span that straddles an open gap with the potential if not built correctly the plunge can be a long and ‘fatal’ fall.

There are many companies offering workflow tools to bridge the gap by helping the communication between business and IT. Alone these solutions still leave opportunity for failure as IT is managing systems it does not have an intimate ownership in. Nor does IT have the knowledge to determine if the business is going to request a change that will impact the system. IT presumes that if the software allows the change than there is no reason why not to do it. As we all have experience one time or another, this is a bad assumption.

Of the many tools I have worked with, currently the Oracle Data Relationship Management (DRM) tool (formally Hyperion MDM / Razza Dimension Server) fills the gap between business and IT. Using a tool such as this gives a strong user interface that the business can use and buy into while allowing IT to be involved by building edit checks and integrity checks into DRM. Additionally it provides IT the vested ownership while keeping the business from impacting their own “business rules”. Not to mention IT’s data governance policies are enforced which keeps IT happy.

A win, win for everyone… right?

Why not EPMA…who needs DRM?

Over the past several months, and quite possibly the past year or two, there have been numerous discussions regarding the need for a separate master data management (MDM) tool such as Hyperion / Oracle Data Relationship Management (DRM) to manage Hyperion metadata outside of the Enterprise Performance Management Architect (EPMA) tool that comes with Hyperion System 9 and Oracle Fusion 11.
Recently at a users’ conference, I heard comments like “EPMA is DRM ‘Light’” and “EPMA is DRM with a Web interface”.
Hyperion, and obviously now Oracle, has invested deeply in EPMA and it is difficult to identify how and where it might differ from the DRM product. Oracle has even used portions of the DRM base code and underlying architecture in EPMA and when looking at vapor-ware demos, you might draw similar conclusions to those quotes above. In reality, EPMA, in its current state, is a pumped up version of the old Hyperion HUB as it relates to metadata management. Granted, EPMA has updated the user interface leveraging the glyphs (icons) and nomenclature from DRM while completely missing the intellectual aptitude that a master data tool provides.
Below are the key uses that were provided in a recent Oracle presentation as well shows the difference between EPMA and DRM:
EPMA
• Unifies and aligns application administration processes across the Hyperion EPM system
• Imports and shares business dimensions in the Dimension Library
• Builds, validates, and deploys applications in the Application Library
• Designs and maintains business rules in Calculation Manager
• Loads and synchronizes transaction data into and between EPM applications
DRM
• Manages change of business master data across enterprise applications
• Consolidates and rationalizes structures across source systems
• Conforms dimensions and validate integrity of attributes and relationships
• Synchronizes alternate business views with corporate hierarchies
• Key Features include:
i. Versioning and Modeling
ii. Custom rules and validation
iii. Configurable exports
iv. Granular security
v. Change tracking
*Oracle Hyperion Data Relationship Management, Fusion Edition 11.1.1- Robin Peel