Business wants to create a process to import the 5 years plan from Planning application to HFM.
We are facing an issue importing the data from planning application to FDMEE import stage with the periods.
For Period x we need to import MTD data
For period y we need to import YTD data
Y1 : MTD Jan-DEC
Y12 to Y5 : YTD Dec
However, MTD and YTD are in the Period Dimension. Setup is :
Year total -> JAN-DEC
YTD -> JAN_YTD to DEC_YTD (dynamicaly calculated using Shared members)
We are unable to get FDMEE to take MTD period for Y1 and YTD for Y2 to 5 since we cannot map all those periods.
Is there a way to do it?
What version of Hyperion(including patch level)?(e.g HFM 18.104.22.168.205,FDMEE 22.214.171.124.210)
You could export dynamic dense member data but it could severely impact your export time hence you must test such first to see if it is feasible.
Secondly have you tested loading the data into HFM into the applicable members and having HFM simply handle what is period versus YTD ? HFM has a View dimension.