HFM To Source Data Validation Process
HFM Version 11.2
Currently we validate our data against the source in excel.
1) Tab 1 - All the base accounts and entities - retrieving data from HFM via HS Getvalue
2) Tab 2 - Excel report from source system copied
3) Tab 3 - Difference between Tab 1 and Tab 2 .
This is very manual and time consuming process - looking to improve the process and also see if FDMEE can be used to automate the data validation.
Welcome any suggestions