on 12-23-2014 11:11 AM
Hi all!!
I'm working with SAP BPC NW 10 version.
We have created packages for DM where we need to appear the name of the dimension and not the technical name that have in BW, when select the list.
For example:
We have this pack in which the user has to select 3 dimensions, but we need another specific name.
Any suggestion?
Thanx in advance
Merry Xmas!
Hi Monica,
Please provide the advanced script of DM package!
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim,
This is the script:
(Where bold are the dimension the user select)
PROMPT(COPYMOVEINPUT,%SELECTION%,%TOSELECTION%,"Selección de Miembros a Seleccionar: Centro Gestor/BU Relevante, Ejercicio y Versión.","%ENTITY_DIM%,%TIME_DIM%,%CATEGORY_DIM%",0)
INFO(%TEMPNO1%,%INCREASENO%)
INFO(%ACTNO%,%INCREASENO%)
INFO(%SELECTION_KEYDATE%,)
TASK(/CPMB/CM_CONVERT,OUTPUTNO,%TEMPNO1%)
TASK(/CPMB/CM_CONVERT,ACT_FILE_NO,%ACTNO%)
TASK(/CPMB/CM_CONVERT,SAPPSET,%APPSET%)
TASK(/CPMB/CM_CONVERT,SAPP,%APP%)
TASK(/CPMB/CM_CONVERT,SELECTION,%SELECTION%)
TASK(/CPMB/CM_CONVERT,TOSELECTION,%TOSELECTION%)
TASK(/CPMB/CM_CONVERT,KEYDATE,%SELECTION_KEYDATE%)
TASK(/CPMB/CLEAR_SOURCE_CUBE,CHECKLCK,0)
TASK(/CPMB/CLEAR_SOURCE_CUBE,SELECTION,%TOSELECTION%)
TASK(/CPMB/CLEAR_SOURCE_CUBE,KEYDATE,%SELECTION_KEYDATE%)
TASK(/CPMB/CLEAR_SOURCE_CUBE,DUMPLOADMODE,3)
TASK(/CPMB/APPEND_LOAD,PREPROCESSMODE,0)
TASK(/CPMB/APPEND_LOAD,TARGETMODE,2)
TASK(/CPMB/APPEND_LOAD,INPUTNO,%TEMPNO1%)
TASK(/CPMB/APPEND_LOAD,ACT_FILE_NO,%ACTNO%)
TASK(/CPMB/APPEND_LOAD,RUNLOGIC,0)
TASK(/CPMB/APPEND_LOAD,CHECKLCK,0)
TASK(/CPMB/APPEND_LOAD,KEYDATE,%SELECTION_KEYDATE%)
Thanx!
You can't rename labels in the COPYMOVEINPUT prompt - the real dimension names are used here. Strange that you name dimensions like: Z_PO_AI... usually more user friendly names are used
And you can add another dimension name like:
"%ENTITY_DIM%,%TIME_DIM%,%CATEGORY_DIM%,THEREALNAMEOFOTHERDIM"
Vadim
Hi Vadim, I know name of the dimensions are difficult but was requirement of IT department. So, If i can`t rename labels in the COPYMOVEINPUT prompt, there are another prompt that allow to do this? I used your last comment added the script THEREALNAMEOFOTHERDIM, but still not working... Any suggestion? Thanx! Mon.
"THEREALNAMEOFOTHERDIM"= THE REAL NAME OF OTHER DIM
If you want to add some another dimension to selection - for example you have dimension Z_XXXXXXXX (it's just a sample!!!!) then:
PROMPT(COPYMOVEINPUT,%SELECTION%,%TOSELECTION%,"Selección de Miembros a Seleccionar: Centro Gestor/BU Relevante, Ejercicio y Versión.","%ENTITY_DIM%,%TIME_DIM%,%CATEGORY_DIM%,Z_XXXXXXXX")
Look on the syntax:
"%ENTITY_DIM%,%TIME_DIM%,%CATEGORY_DIM%,Z_XXXXXXXX"
Vadim
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
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.