Import Script to load Actuals to YTD and Budget/Forecast Data to Periodic in FDMEE
edited Mar 16, 2020 2:01AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 4 commentsAnswered ✓
Hi All,
I have a requirement where Actual data to be loaded as YTD and Budget/Forecast Data to be loaded as Periodic in FDMEE. Target application is HFM.
I know this is possible by creating 2 Import Formats and by View dimension expression one set to YTD and other for PERIODIC. But we have more than 100 Locations hence recreating and assigning Import Format is not a good idea.
I could find similar script of FDM which I believe performs same kind of load
===========================================
Dim retVal
If RES.PlngCatKey = 14 Then
retVal = "Periodic"
Else
retVal = "YTD"
End If
map_view = retVal
End Function
1