Upload Excel Map Loader using a script
edited Jan 31, 2013 5:01AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 2 commentsAnswered
We are developing a lights out process that moves data through FDM into
Essbase ASO. We have most of it working, but would like another step
that would automatically upload the mapping for the Account dimension,
if the excel file is present.
It would go something like this:
If objFSO.FileExists(“C:\FDM\App\Inbox\Account_Map_Loader.xls”) Then
‘Upload C:\FDM\App\Inbox\Account_Map_Loader.xls HERE
End If
I found a couple of functions that are close, but not for Excel files.
API.IntBlockMgr.InterfaceMgr.fImportMapFromXML(strFilePath, strLoc)
API.IntBlockMgr.InterfaceMgr.fImpTRx(strLoc, strLoadFile, strDim)
I feel like I am close, but just not seeing something that should be obvious. Can anyone give me a push in the right direction?
It would go something like this:
If objFSO.FileExists(“C:\FDM\App\Inbox\Account_Map_Loader.xls”) Then
‘Upload C:\FDM\App\Inbox\Account_Map_Loader.xls HERE
End If
I found a couple of functions that are close, but not for Excel files.
API.IntBlockMgr.InterfaceMgr.fImportMapFromXML(strFilePath, strLoc)
API.IntBlockMgr.InterfaceMgr.fImpTRx(strLoc, strLoadFile, strDim)
I feel like I am close, but just not seeing something that should be obvious. Can anyone give me a push in the right direction?
0