FDQM We load periodic data for Balance sheet accounts but we ned to export YTD balances to HFM
edited Sep 26, 2011 7:12AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 1 commentAnswered
FDM can not accumulated prrevious periodic data to current monthin FDM when export to HFM. E.G
Periodic Periodic YTD
May June
Cash 1000 500 1500
We need to export $1500 to HFH only balansesheet accounts only.
We get the periodic data on amonthly basis for Balancesheet and incomeexpense accounts. We need to export $1500 to HFM. Please let us know the solution
for profit and loss we just need periodic only.Currently I am loading value as periodic and I have no issue.I want to load YTD value from FDM to HFM which means I need to add previous months periodic value to current month period value for Balance sheets accounts only to come up with YTD values during validation process so I can export to HFM. see example I have given you its loading periodic value but not calculating YTD values. Is there any script you can write where FDM add previous month periodic value with current month and move to as
Periodic Periodic YTD
May June
Cash 1000 500 1500
We need to export $1500 to HFH only balansesheet accounts only.
We get the periodic data on amonthly basis for Balancesheet and incomeexpense accounts. We need to export $1500 to HFM. Please let us know the solution
for profit and loss we just need periodic only.Currently I am loading value as periodic and I have no issue.I want to load YTD value from FDM to HFM which means I need to add previous months periodic value to current month period value for Balance sheets accounts only to come up with YTD values during validation process so I can export to HFM. see example I have given you its loading periodic value but not calculating YTD values. Is there any script you can write where FDM add previous month periodic value with current month and move to as
0