Skip to Content
-1
Former Member
Oct 28, 2019 at 09:24 PM

BPC Validation of Transformation file results in error

176 Views Last edit Oct 28, 2019 at 09:34 PM 2 rev

I'm trying to run Validate Process Transformation File on one of my Transformation files that pulls from a BW InfoProvider cube. When I open my transformation file Line 1 - *OPTIONS is highlighted red. I click on Validate Process Transformation file and immediately get the error "Object reference not set to an instance of an object".

I've looked over the file and the logic appears to be fine. Any ideas where I can look next or what I am overlooking?

BusinessObjects Planning and Consolidations 2.5.301.77941

EPM 2.5.301.77941

*OPTIONSFORMAT = DELIMITEDHEADER = YESDELIMITER = ~AMOUNTDECIMALPOINT = .SKIP = 0SKIPIF =VALIDATERECORDS=YESCREDITPOSITIVE=YESMAXREJECTCOUNT=ROUNDAMOUNT=*MAPPINGDM_AUDITTRAIL=ZNETGRSFGDM_CATEGORY=*NEWCOL(ACTUAL)DM_COMPCODE=*IF(0COMP_CODE = *STR() THEN *STR(NONE); 0COMP_CODE)DM_C_ACCOUNT=*IF(ZWBSLEV2 = *STR() THEN 0GL_ACCOUNT ; ZWBSLEV2)DM_C_MGMT_ORG=*IF(ZMGMTORG = *STR() THEN *STR(PC_NONE); ZMGMTORG)DM_FLOW=0FISCPERDM_INTERMGMT =*IF(ZPR_PFCTR = *STR() THEN *STR(I_PC_NONE);*STR(I_)+ ZPR_PFCTR)DM_INTERCO=*IF(0PCOMPANY=*STR() THEN *STR(I_NONE) ;0PCOMPANY)DM_OP_NON_OP=*IF(ZOPERFLAG = *STR() THEN *STR(OP); ZOPERFLAG)DM_RPTCURRENCY=*NEWCOL(USD)DM_SCOPE= *NEWCOL(S_NONE)DM_TIME=0FISCPERAMOUNT=*IF(ZDATATYPE = *STR(SUMMARY) THEN ZAMOUNT; *STR(0))*CONVERSIONDM_TIME=CF_CONSOLIDATION_TD_ZGL_C002.xls!CONV_DM_TIMEDM_C_ACCOUNT=CF_CONSOLIDATION_TD_ZGL_C002.xls!CONV_DM_C_ACCOUNTDM_OP_NON_OP=CF_CONSOLIDATION_TD_ZGL_C002.xls!CONV_DM_OP_NON_OPDM_AUDITTRAIL=CF_CONSOLIDATION_TD_ZGL_C002.xls!CONV_DM_AUDITTRAILDM_INTERCO=CF_CONSOLIDATION_TD_ZGL_C002.xls!CONV_DM_INTERCODM_FLOW=CF_CONSOLIDATION_TD_ZGL_C002.xls!CONV_DM_FLOWDM_C_MGMT_ORG=CF_CONSOLIDATION_TD_ZGL_C002.xls!CONV_DM_C_MGMT_ORG