This content has been marked as final. Show 3 replies
What is your target system? Why not load the balances and let that compute the YTD movement? You can do almost anything with FDM, but heavy use of conditionals might put stress on the processing times.
The target system is Hyperion 9.2
The Balance Sheet in HFM has been designed with some accounts requiring movement input, such as Fixed Assets, and some accounts requiring balance input such as intercompany trading balances. We are not planning to re-configure the target system so i need to find an FDM solution for loading a mixture of balances and movements from the source Trial Balance.
without touching the file, I would load it twice. One pass on column 3 as amount, the next on column 4 as amount. Set up conditionals and ignore the amount if it doesn't meet criteria. But I would modify the extract file first if there were opportunity.
but I must say your HFM design is atypical. Most configurations out there make use of a custom member to calculate YTD movement on the balance as loaded. Very simple to do and also allows for custom members that allow input for non cash adjustments for CF reporting purposes.