BPC Validation of Transformation file results in error

[Private_Member_516535]

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

[former_member186338]

Sorry, but you have to provide full info if you want an answer!

Transformation file text

BW data sample screenshot

etc...

[former_member186338]

Sorry, but I will never answer the question when the post author don't look on the post results! Do you really think that your post is OK???

[former_member186338]

P.S.

"BusinessObjects Planning and Consolidations 2.5.301.77941" - there is no such version

"EPM 2.5.301.77941" ?? May be you are talking about AO?

[Private_Member_516535]

We do have the version that the EPM add-in is packaged in with Analysis for Office. SAP Business Objects Analysis Edition for Microsoft Analysis Version 2.5.301.77941.

BPC version

CPMBPC 810 0009 SAPK-81009INCPMBPC SAP Business Planning and Consolidation

[former_member186338]

And what about BPC version and SP? Look in SAP GUI

[Private_Member_516535]

No, I do not think the way it's posted is ok. Sorry, I will remove it if I can't get the post corrected. Sorry for the inconvenience.

I'm actively trying to figure out why the files will not upload. Not sure what you mean by don't look on the post results?

[Private_Member_516535]

Thanks Vadim. Sorry, I'm having trouble uploading files. I will try again. I went thru steps and they load 100% but then do not appear. I'm going thru all tutorials right now to see what issue may be.