cancel
Showing results for 
Search instead for 
Did you mean: 

Name dimension for DM Package

monica_marquez2
Participant
0 Kudos

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!

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Hi Monica,

Please provide the advanced script of DM package!

Vadim

monica_marquez2
Participant
0 Kudos

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!

former_member186338
Active Contributor
0 Kudos

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

monica_marquez2
Participant
0 Kudos

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.

former_member186338
Active Contributor
0 Kudos

Ups!

For data copy you HAVE to use COPYMOVEINPUT (to specify source and destination dimension members). There is no other useful PROMPT for this.

Do you really put "THEREALNAMEOFOTHERDIM"??? You have to put some real dimension name you want to add to selection prompt...

Vadim

monica_marquez2
Participant
0 Kudos

Hi Valdim

I wrote the code like you said....

PROMPT(COPYMOVEINPUT,%SELECTION%,%TOSELECTION%,"Selección de Miembros a Seleccionar: Centro Gestor/BU Relevante, Ejercicio y Versión.","%ENTITY_DIM%,%TIME_DIM%,%CATEGORY_DIM%","THEREALNAMEOFOTHERDIM")

It is possible that this wrong?

Thanx!

Mon.

former_member186338
Active Contributor
0 Kudos

"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