on 2014 Feb 19 11:45 AM
Hi Experts,
I am trying to upload master data hierarchy through flat file.My Transformation file is getting validated properly, While running the package to upload master data from flat file I am getting error TIME VERSION OF DIMENSION CUSTOMER DOES NOT EXIST.
Problem is coming in production server only, it was not coming in development server. Snap shots of my transformation file, flat file and error coming is attached.
Kindly Guide me through this.
Thanks and Regards
Rakhi
Hi Rakhi,
Have you enabled Time-dependent Hierarchy option for CUSTOMER dimension?
B.R. Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Look on the following notes:
http://service.sap.com/sap/support/notes/1817729
http://service.sap.com/sap/support/notes/1804957
Vadim
Message was edited by: Vadim Kalinin corrected second note!
Thanks Vadim for your support,
I upgraded my EPM SP LEVEL to 14 and applied following solution as suggested by SAP.
If your BPC version is upgraded to 801 SP04, not installed directly.
It's necessary to do the following.
1. Goto transaction SE38.
2. Run program UJS_ACTIVATE_CONTENT.
3. Only check 'Update Default DM Instructions' and leave all others
default.
4. Execute.
Now this issue is resolved.
But another error is coming now which was not coming earlier:
While running the package for master data upload from BW Info-object, now an option is coming-"CLEAR ALL MEMBERS FOR OVERWRITE MODE BEFORE LOADING", this was not coming earlier. My package is getting failed with details "can not configure CLEAR ALL MEMBERS task". Previously same master data was getting uploaded successfully.
Thanks
Rakhi
"and applied following solution as suggested by SAP ..." - that was clearly stated in the note 1804957 that I recommended you to read. Manual Post-Implement - means that the result is not coming automatically after note installation or upgrade to new SP.
What package are you exactly running? Provide the name and DM advanced script! Do you know how to view the script?
Vadim
Hi Vadim,
I am using Package /CPMB/IMPORT_IOBJ_MASTER
Advanced script is:
PROMPT(MASTERSELECTION, %INFOOBJECT%, %SELECTION%, "Please select the infoobject and the selection",,)
PROMPT(RADIOBUTTON,%WRITEMODE%,"Write Mode",2,{"Overwrite","Update"},{"1","2"})
PROMPT(RADIOBUTTON,%FORMAT%,"Choose format.",1,{"Internal Format","External Format"},{"1","0"})
PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)
PROMPT(DIMENSIONNAME,%DIMNAME%,"Dimension name:",,,%DIMS%)
PROMPT(RADIOBUTTON,%CLEAR_ALL%,"Clear all members for overwrite mode before loading?",0,{"No","Yes"},{"0","1"})
INFO(%TEMPNO1%,%INCREASENO%)
INFO(%TEMPNO2%,%INCREASENO%)
INFO(%TEMPNO3%,%INCREASENO%)
INFO(%TEMPNO4%,%INCREASENO%)
INFO(%TEMPNO5%,%INCREASENO%)
INFO(%TEMPNO6%,%INCREASENO%)
INFO(%TEMPNO7%,%INCREASENO%)
TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,OUTPUTNO,%TEMPNO1%)
TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_SELECTION,%SELECTION%)
TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,INFOOBJECT,%INFOOBJECT%)
TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_FORMAT,%FORMAT%)
TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,OUTPUTNO,%TEMPNO2%)
TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_SELECTION,%SELECTION%)
TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,INFOOBJECT,%INFOOBJECT%)
TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_FORMAT,%FORMAT%)
TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO,%TEMPNO1%)
TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO2,%TEMPNO2%)
TASK(/CPMB/MERGE_IOBJ_MD_DATA,MASTERDATA_SELECTION,%SELECTION%)
TASK(/CPMB/MERGE_IOBJ_MD_DATA,INFOOBJECT,%INFOOBJECT%)
TASK(/CPMB/MERGE_IOBJ_MD_DATA,OUTPUTNO,%TEMPNO3%)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,FORMULA_FILE_NO,%TEMPNO7%)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SUSER,%USER%)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SAPPSET,%APPSET%)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SAPP,%APP%)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,DIMNAME,%DIMNAME%)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,OUTPUTNO,%TEMPNO4%)
TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,INPUTNO,%TEMPNO4%)
TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,OUTPUTNO,%TEMPNO5%)
TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,OUTPUTNO2,%TEMPNO6%)
TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,INPUTNO,%TEMPNO3%)
TASK(/CPMB/BPC_MASTER_DATA_TARGET,INPUTNO,%TEMPNO5%)
TASK(/CPMB/BPC_MASTER_DATA_TARGET,DIMNAME,%DIMNAME%)
TASK(/CPMB/BPC_MASTER_DATA_TARGET,WRITEMODE,%WRITEMODE%)
TASK(/CPMB/BPC_MASTER_DATA_TARGET,FORMULA_FILE_NO,%TEMPNO7%)
TASK(/CPMB/BPC_MASTER_DATA_TARGET,CLEAR_ALL,%CLEAR_ALL%)
TASK(/CPMB/BPC_TXT_DATA_TARGET,INPUTNO,%TEMPNO6%)
TASK(/CPMB/BPC_TXT_DATA_TARGET,DIMNAME,%DIMNAME%)
It is showing- Package Status:Runnig
Thanks
Rakhi
Hi Vadim,
I deleted two lines from advanced Script of Package:
PROMPT(RADIOBUTTON,%CLEAR_ALL%,"Clear all members for overwrite mode before loading?",0,{"No","Yes"},{"0","1"})
TASK(/CPMB/BPC_MASTER_DATA_TARGET,CLEAR_ALL,%CLEAR_ALL%)
And now package is running successfully.
Thanks a Lot for your guidance
Rakhi
User | Count |
---|---|
10 | |
5 | |
4 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.