BPC 7.5 NW - HIER NODE in PROMPT using Formule in Package ?

[former_member199510]

Hi, is posible request in PROMPT HIER NODE value for send to ScriptLogic ?

I need request HIER NODE for 0COSTCENTER.

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%CECO_DIM%")
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,COPIA_CECO.LGF)

Any idea ?

[former_member199510]

Hi, i fix the problem.

This is my PROMPT:

PROMPT(SELECT,,,,"%CATEGORY_DIM%,CeBE,Modelo,Sociedad,Tipo_vta")
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,COPIA_PCC.LGF)

This is my ScriptLogic:

//COPIA DESDE ENERO A DICIEMBRE, PARAMETROS DE VEHICULOS NUEVOS

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET CeBe = %CeBe_SET%
*XDIM_MEMBERSET CUENTA = ZACB0001, ZACB0004, NA
*SELECT(%MOD%, "[ID]", Modelo,[TIPO]=%Modelo_SET%)
*XDIM_MEMBERSET Modelo = %MOD%
*XDIM_MEMBERSET Moneda_Ppto = CLP, USD, NA 
*XDIM_MEMBERSET PARAMETRO = NA, ZACB003
*XDIM_MEMBERSET CentroDeCosto = NA
*XDIM_MEMBERSET Sociedad = %Sociedad_SET%
*XDIM_MEMBERSET Sucursales = NA
*XDIM_MEMBERSET Tipo_vta = %Tipo_vta_SET%
*XDIM_MEMBERSET RPTCURRENCY = LC
*XDIM_MEMBERSET TIME = %YEAR%.JAN
*XDIM_MEMBERSET MEASURES = "PERIODIC"

*WHEN TIME

*IS %YEAR%.JAN

*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.FEB )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.MAR )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.APR )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.MAY )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.JUN )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.JUL )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.AUG )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.SEP )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.OCT )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.NOV )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.DEC )

*ENDWHEN
*COMMIT

Was necesary use Property "TIPO" in dimension Modelo and fill using name the HierNode "Camiones"

Then when select in Prompt HierNode "Camiones" filter working.

*SELECT(%MOD%, "[ID]", Modelo,[TIPO]=%Modelo_SET%)

*XDIM_MEMBERSET Modelo = %MOD%

This assume value the Prompt in Select:

[TIPO]=%Modelo_SET%

Bye.

[esjewett]

Yup, that's correct. Don't know what I was thinking by leaving %CECO_DIM% in there. You can only use dynamic replacement variables like %CATEGORY_DIM%, %ACCOUNT_DIM%, %TIME_DIM%, and %ENTITY_DIM% here. All other dimension names must be hard-coded, as you discovered.

Ethan

[former_member199510]

Hi, but exist any other alternative for use in ScriptLogic Node Hier from DM Package selection ?

Thank you.

[former_member199510]

This code not working.

PROMPT(SELECT,,,,"%CATEGORY_DIM%,%CECO_DIM%")

My Prompt is:

PROMPT(SELECT,,,,"%CATEGORY_DIM%,CeBE,Modelo,Sociedad,Tipo_vta")
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,COPIA_PCC.LGF)

My ScriptLogic is :

//COPIA DESDE ENERO A DICIEMBRE, PARAMETROS DE VEHICULOS NUEVOS

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET CeBe = %CeBe_SET%
*XDIM_MEMBERSET CUENTA = ZACB0001, ZACB0004, NA
*XDIM_MEMBERSET Modelo = %Modelo_SET%
*XDIM_MEMBERSET Moneda_Ppto = CLP, USD, NA 
*XDIM_MEMBERSET PARAMETRO = NA, ZACB003
*XDIM_MEMBERSET CentroDeCosto = NA
*XDIM_MEMBERSET Sociedad = %Sociedad_SET%
*XDIM_MEMBERSET Sucursales = NA
*XDIM_MEMBERSET Tipo_vta = %Tipo_vta_SET%
*XDIM_MEMBERSET RPTCURRENCY = LC
*XDIM_MEMBERSET TIME = %YEAR%.JAN
*XDIM_MEMBERSET MEASURES = "PERIODIC"

*WHEN TIME

*IS %YEAR%.JAN

*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.FEB )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.MAR )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.APR )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.MAY )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.JUN )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.JUL )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.AUG )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.SEP )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.OCT )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.NOV )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.DEC )

*ENDWHEN
*COMMIT

My Node is : %Modelo_SET%

Any idea ?

[Former Member]

HI,

What Ethan suggested was to select parent node while executing logic. and based on the parent node selected the logic gets executed for all child nodes of the parent node selected.

But my understanding from your question is, you wanted to select the list of all dimension members in script logic based on the value of HIR (Property of a Dimension) selected in the Prompt of DM Package.

If i am right then you can use some Text Prompt and get the value for HIR property in that and pass it to your script logic scoping statement which filters based on the value you have entered in DM Prompt.

Note:

Document on linking the values from prompt with script logic through DM package is explained in the How To Guide of the link below,

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d01ce779-f1b2-2b10-07ba-da3734013...

Hope this helps,

Regards,

G.Vijaya Kumar

[esjewett]

Hi,

The SELECTINPUT prompt will only allow the user to select non-calculated members. If you would like the user to be able to select calculated members like hierarchy nodes, then you can use SELECT. For example:

PROMPT(SELECT,,,,"%CATEGORY_DIM%,%CECO_DIM%")

Ethan

[former_member199510]

Is correct define this when need use NODE Hier ?

*XDIM_MEMBERSET Modelo = %Modelo_SET%

Thank you.

[former_member199510]

Hi i try using SELECT, ScriptLogic process values, but all values the Dimension "Modelo" not only for Hier Node.

//COPIA DESDE ENERO A DICIEMBRE, PARAMETROS DE VEHICULOS NUEVOS

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET CeBe = %CeBe_SET%
*XDIM_MEMBERSET CUENTA = ZACB0001, ZACB0004, NA
*SELECT(%MOD%, "[ID]", Modelo,[ID]<>'')
*XDIM_MEMBERSET Modelo = %MOD%
*XDIM_MEMBERSET Moneda_Ppto = CLP, USD, NA 
*XDIM_MEMBERSET PARAMETRO = NA, ZACB003
*XDIM_MEMBERSET CentroDeCosto = NA
*XDIM_MEMBERSET Sociedad = %Sociedad_SET%
*XDIM_MEMBERSET Sucursales = NA
*XDIM_MEMBERSET Tipo_vta = %Tipo_vta_SET%
*XDIM_MEMBERSET RPTCURRENCY = LC
*XDIM_MEMBERSET TIME = %YEAR%.JAN
*XDIM_MEMBERSET MEASURES = "PERIODIC"

*WHEN TIME

*IS %YEAR%.JAN

*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.FEB )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.MAR )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.APR )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.MAY )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.JUN )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.JUL )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.AUG )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.SEP )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.OCT )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.NOV )
*REC(EXPRESSION=%VALUE%, TIME = %YEAR%.DEC )

*ENDWHEN
*COMMIT

*SELECT(%MOD%, "[ID]", Modelo,[ID]<>'')

*XDIM_MEMBERSET Modelo = %MOD%

Any idea for limit to Hier Node use in SELECT the DM Package ?

Thank you.