us-analytics.png
Contact Us

FDMEE Tutorial: How to Utilize an HFM Application as a Source (Part I)

One of the enhancements to FDMEE 11.1.2.4 is the functionality to utilize a HFM application not only as a Target but also as a Source. This step-by-step tutorial will demonstrate this functionality, e.g. extracting data from HFM instead of a file or ERP such as SAP or EBS. Our next post will demonstrate interfacing this data to an Essbase application as the target.

eBook: Top 10 FDMEE & ODI Tutorials

This post will proceed with version 11.1.2.4 of EPM installed on Windows Server 2012 R2 and with the COMMA4DIM HFM application. 

1. Log into Workspace.

image

2. Navigate --> Administer --> Data Management. 

image1

3. Select the Setup tab and then Target Application that will be the source and target in this example. EPM applications are not specified as a Source System.

Screen_Shot_2015-06-03_at_8.57.34_AM

4. Select Add.

Screen_Shot_2015-06-03_at_9.04.13_AM

5. Select Financial Management.

Screen_Shot_2015-06-03_at_9.06.29_AM

6. Select COMMA4DIM and then OK. 

Screen_Shot_2015-06-03_at_9.17.01_AM

7. Select save after the Application Details have displayed.

Screen_Shot_2015-06-03_at_9.19.29_AM

8. Select Import Format.

Screen_Shot_2015-06-03_at_9.21.17_AM

9. Select Add.

Screen_Shot_2015-06-03_at_9.23.01_AM

10. Select EPM as the Source, which enables the HFM application to be used as a Source.

Screen_Shot_2015-06-03_at_9.25.30_AM

11. Update the remainder of the Import Format Details: Name, Description, and Source as COMMA4DIM and Target Type as EPM. Once this is done, select Save. 

Screen_Shot_2015-06-03_at_9.26.52_AM

12. The COMMA4DIM mappings require an update, which in this circumstance will be to map the same Source Column to the same Target. Once the mapping is complete, select Save. 

Screen_Shot_2015-06-03_at_9.28.40_AM

Screen_Shot_2015-06-03_at_9.32.39_AM

13. Select Location and then Add. 

Screen_Shot_2015-06-03_at_9.35.06_AM

14. Update the Location Details to COMMA4DIM for Name and Import Format. The remainder of the Location Details are defaults and will not be changed in this example. Once the updates have occurred, select Save.

Screen_Shot_2015-06-03_at_9.39.15_AM

15. Select Period Mapping. 

Screen_Shot_2015-06-03_at_9.40.27_AM

16. Create the Period Key by selecting Add and then keying the values displayed. The Target Period Month and Year Target will be utilized as the period and year filter for the data extract; therefore, the values keyed should be consistent with HFM. Select Save and proceed to the next step. 

Screen_Shot_2015-06-03_at_9.43.07_AM

17. Select Category Mapping. 

Screen_Shot_2015-06-03_at_9.58.41_AM

18. Key BudV1 as both the Category and Target Category with a Frequency of Monthly. Select Save once this has occurred. 

Screen_Shot_2015-06-03_at_10.00.19_AM

19. Select Workflow and then Data Load Rule. If needed, update the FDMEE POV for the Location, Period, and Category created in the previous steps. 

Screen_Shot_2015-06-03_at_10.01.56_AM

20. Select Data Load Rule and then Add. 

Screen_Shot_2015-06-03_at_10.03.21_AM

21. Name the rule COMMA4DIM and then select Save.

Screen_Shot_2015-06-03_at_10.04.36_AM

22. A Source Filter is needed for each Dimension Name, which can be selected from the drop down. Every HFM dimension must be specified. Note: Filter Conditions, which provide data from the extract, will be specified. The Year and Period dimension will not be specified.

Select Add to specify a filter, and then from the Dimension Name drop down select Account then the Ellipsis. 

Screen_Shot_2015-06-03_at_10.05.58_AM

23. Select Refresh Members and then Online for the Member List to populate. Once this is done, the Legal member will be added to Selected Members and then OK will be selected. Note: Only select members that have data. Otherwise, zero records will be extracted, which will generate an error message. 

Screen_Shot_2015-06-03_at_10.07.23_AM

Screen_Shot_2015-06-03_at_10.08.12_AM

24. The process of adding a Source Filter for dimensions Channel to View is the same process as Account; therefore, only the selections will be displayed. Once all filters are specified, select Save. 

Screen_Shot_2015-06-03_at_10.09.54_AM

25. If a dimension is not specified or an invalid member is specified for a dimension, an error message similar to the image will be displayed in the log accessible from Process Details. For example, this error message was generated by an invalid year (Y#200 instead of Y#2007 in the Filter Slice).   

Screen_Shot_2015-06-03_at_10.11.02_AM

26. Select Execute.

GetFileAttachment-3

27. When the Execute Rule dialog box displays, select the Import From Source option which automatically selects Recalculate. Once this is done, select Run.

GetFileAttachment-4

28. Click OK.

GetFileAttachment-5

29. Select Monitor and then Process Details. 

Screen_Shot_2015-06-03_at_10.12.39_AM

30. A successful completion is displayed for the Process ID submitted.   

Screen_Shot_2015-06-03_at_10.14.08_AM

31. Select Data Load Workbench to view the record extracted. 

Screen_Shot_2015-06-03_at_10.16.13_AM

Screen_Shot_2015-06-03_at_10.17.51_AM

32. With a successful completion, select the COMMA4DIM application to review the HFM application log. 

Screen_Shot_2015-06-03_at_10.19.05_AM

33. Once the application is accessible, select Consolidation --> Maintenance --> Task Audit, which will display the extract occurred as a Flat File Extract. 

Screen_Shot_2015-06-03_at_10.20.23_AM

 

FREE eBook: The Top 10 FDMEE & ODI Tutorials

New call-to-action

Ask an EPM/BI Advisor

If you're here, you've got questions — and we've got answers. Book your consultation to ask us about any range of topics, including:

  • Evaluating EPM or BI technologies
  • Comparing on-prem vs. cloud
  • Planning upgrades and migrations
  • Estimating project costs and timeframes
  • And much more — ask us anything!

Let our experts tackle your toughest questions for you.

Let's Talk