Analytics Software

Hi All,

We are trying to load data into HFM by using FDM using ERPI integrator adaptor.here issue is revnue and expense accounts are loading as periodic insted of YTD,so we have to load revenue ane expense should load as YTD format.

oracle analyst given us refrence doc(How to Import Balances into FDM as YTD Even Though ERPi Extracts in Periodic [ID 1077823.1]) script for this: The below script we have created in script editor as import (dataPump).then after where we have to map this import script,i am not sure this script is right or not.

even we have tried to import data from EBS still importing periodic for revenue and expense accounts.

Any one plz help me here.

**********************************

Function TestImport2(strField, strRecord)
'------------------------------------------------------------------
'Oracle Hyperion FDM DataPump Import Script:
'
'Created By: admin
'Date Created: 1/11/2010 8:46:02 AM
'
'Purpose:
'
'------------------------------------------------------------------
Int BEGIN_BALANCE_DR
Int BEGIN_BALANCE_CR
Int PERIOD_NET_DR
Int PERIOD_NET_CR
Dim Account_Type

If InStr(1,strRecord,"|")=0 Then
RES.pblnskip = False
Exit Function
End If

'Check to make sure this isn't the first row
If DW.Utilities.fParseString(strRecord, 50, 38, "|") = "BEGIN_BALANCE_DR" Then
Res.pblnskip = True
Exit Function
End If

'Parse out the different value columns in the import file
BEGIN_BALANCE_DR = DW.Utilities.fParseString(strRecord, 50, 38, "|")
BEGIN_BALANCE_CR = DW.Utilities.fParseString(strRecord, 50, 39, "|")
PERIOD_NET_DR = DW.Utilities.fParseString(strRecord, 50, 40, "|")
PERIOD_NET_CR = DW.Utilities.fParseString(strRecord, 50, 41, "|")
Account_Type = DW.Utilities.fParseString(strRecord, 50, 42, "|")

'Do Some Math

If LCase(account_type) = "1" Then
TestImport2 = (BEGIN_BALANCE_DR - BEGIN_BALANCE_CR + PERIOD_NET_DR - PERIOD_NET_CR) * (-1)
Else
TestImport2 = (BEGIN_BALANCE_DR - BEGIN_BALANCE_CR + PERIOD_NET_DR - PERIOD_NET_CR)
End If

End Function
'--------------------------------------------------------------------------------

Thanks,
sri