Hi gurus,
I am facing a problem, when I'm trying to automate Master Data from a flat file to a dimension. I make a prompt to load the data, but when I try to upload to the UJD_TEST_PACKAGE program, I select it from the matchcode but nothing is update in the AnswerPrompt. It appears blank.
My prompt that is places in my desk is the following one:
BW_TO_BPC_Centro_Gestor.txtu200E
and it contains:
%FILE% /sapmnt/BWD/global/ZCIC_FICHEROS_CARGA_BPC/CIC_CEGE_ENTE.csv
%TRANSFORMATION% ROOTWEBFOLDERSCICOFINANDATAMANAGERTRANSFORMATIONFILESEXAMPLESCIC_TRANSF_DM_GPFUNDSCT.xls
%DIMNAME% COSTCENTER
%UPDATE% 1
If we put the prompt manually in the AnswerPrompt an error occurs:
/CPMB/MODIFY : Completed in 0 seconds
/CPMB/CLEAR : Completed in 0 seconds
-
-
FILE /sapmnt/BWD/global/ZCIC_FICHEROS_CARGA_BPC/CIC_CEGE_ENTE.csv TRANSFORMATION ROOTWEBFOLDERSCICOFINANDATAMANAGERTRANSFORMATIONFILESEXAMPLESCIC_TRANSF_DM_GPFUNDSCT.xls DIMNAME COSTCENTER UPDATE 1
-
-
XML file (...%TRANSFORMATION%) is empty or is not found
Cannot find document/directory
Application : PRESU. Package status: ERROR
We think that the problem is in the "#" that we put as separations, but we don't know how to put this prompt in the AnswePrompt
So if you know any solution to this problem, please let me know.
Best regards,
Gorka I.