Planning

Get Involved. Join the Conversation.

Topic

    Wayne Paffhausen
    DM Update 19.06, Producing Flat-File Extracts out of Cloud...
    Topic posted August 6, 2019 by Wayne PaffhausenGold Medal: 3,500+ Points, tagged Financial Planning, Integration, PBCS, Planning, Tip 
    42 Views
    Title:
    DM Update 19.06, Producing Flat-File Extracts out of Cloud Data Management
    Summary:
    As an EPM Administrator or Implementation Specialist, we have all had that moment when someone comes to us and asks for the dreaded extract out of an Enterprise Performance Management (EPM)
    Content:

    As an EPM Administrator or Implementation Specialist, we have all had that moment when someone comes to us and asks for the dreaded extract out of an Enterprise Performance Management (EPM) application.  Depending on the system combination (Hyperion Financial Management (HFM), Planning, etc.) and the file layout specifications, this can be tricky.  Layer in the concept of a Cloud application, and things have now gotten real!

    In an on-premise installation of Financial Data Quality Management Enterprise Edition (FDMEE), we could use scripting within a “custom application” to build an end-to-end approach for delivering a flat-file extract for third party consumption.  With the release of version 19.06, Oracle has further enhanced this concept and brought it to Cloud Data Management (CDM). The Cloud application now provides the ability to design and produce a text file for downstream consumption in Oracle Cloud products (PCMCS, EPBCS, FCCS).  WHOA!

    Wayne Paffhausen - Weve Got You Covered - 7-26-19 Image 1

    The Setup

    I recently busted out the functionality and this is what I have discovered:  It’s crazy simple!

    1. Create a text file with your defined headers

    Wayne Paffhausen - Weve Got You Covered - 7-26-19 Image 2

    1. Create a target application and set your settings

    Wayne Paffhausen - Weve Got You Covered - 7-26-19 Image 3

    3.  Create an import format

    Wayne Paffhausen - Weve Got You Covered - 7-26-19 Image 4

    1. Create a Location & DLR

    Wayne Paffhausen - Weve Got You Covered - 7-26-19 Image 5

    1. Create the desired Maps
    2. Run the Data Load Rule

    Wayne Paffhausen - Weve Got You Covered - 7-26-19 Image 6

    It is that simple!  CDM produces a file that looks similar to this:

    Wayne Paffhausen - Weve Got You Covered - 7-26-19 Image 7

    It can PIVOT!?

    As crazy as it sounds, it can even pivot the data!  I find this extremely helpful as it is a common request to have twelve months of data in column format.  CDM leverages the PIVOT command of the database for this process and creates the pivot file with ease and efficiency.

    Wayne Paffhausen - Weve Got You Covered - 7-26-19 Image 8

    [...]

    To continue to read this post please visit our website.

     

    https://ranzal.blog/2019/07/26/weve-got-you-covered-producing-flat-file-extracts-out-of-cloud-data-management/

    Subscribe to receive notifications about new posts about Cloud updates and other Oracle Cloud Services such as Planning and Budgeting, Financial Consolidation, Account Reconciliation, and Enterprise Data Management.  Follow Alithya on social media for the latest information about EPM, ERP, and Analytics solutions to meet your business needs.For comments, questions or suggestions for future topics, please reach out to us at infosolutions@alithya.com.