FDM Import script fails
edited Oct 29, 2016 5:00AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 3 commentsAnswered ✓
Pleas assist, I'm not sure what is missing here. The interface table has data. The only change done was putting a package that clears the table to ensure that there's data for only one batch. Since the change has been implemented i'm getting the no data error when i run the input script.
| 'Initialize objects | |
| Set cnSS = CreateObject("ADODB.Connection") | |
| Set rs = CreateObject("ADODB.Recordset") | |
| Set rsAppend = DW.DataAccess.farsTable(strWorkTableName) |
| strPeriod = UCase(Replace(Replace(RES.PStrPer," ",""),Right(RES.PStrPer,4),"")) | |
| strPeriod = strPeriod & UCase(Right(Year(RES.PdtePerKey),2)) |
| 'Build WHERE CLAUSE | |
| 'If Left(StrPeriod,3)="MAR" Then | |
| ' strWhereClause = strWhereClause & " WHERE (UPPER(PERIOD_NAME)='" & StrPeriod & "' " |
Tagged:
1