Using member properties in Data manger package selections

[former_member605075]

Hello All,

I want use member property of Time dimension as Selection in my Default formula package.below are the details.

We have Time id(date) with day granularity.

We are getting ID(Date) in the selection of Data Manager Package,But we want to use Year (Member property )in F4 help Selection without using filters

Below is the advanced script.

PROMPT(SELECTINPUT,,,,"%DIMS%") 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,XYZ.LGF)

Script logic used is : Destination app

System details: We are using BPC 10.1 ,BW 7.4

[former_member186338 · Accepted solution]

Simply use PROMPT(COMBOBOX to select Year.

Please read my blog: https://blogs.sap.com/2014/09/19/dm-promptcombobox-behavior-in-bpc-nw-10-and-75/

Fixed list for 20-30 years is fine.

[former_member605075]

Hi Vadim,

I have included the combox to my advanced script.but while I run the package it is failed

Advanced script with combobox

:PROMPT(COMBOBOX,%VARIABLE%,"Prompt text for user",(type of combobox),TEXT1,{TEXT1,TEXT2,TEXT3,TEXT4,TEXT5}) INFO(%EQU%,=) INFO(%TAB%,;) TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%) TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%) 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,LOGICFILENAME,XYZ.LGF)

I think am missing to assign this variable in logic ,please provide me inputs ,how to assign a variable in logic

%VARIABLE% – to store the selection, can be passed to the script logic as $VARIABLE$

Below is my script logic

*XDIM_MEMBERSET TIME = %TIME%

*DESTINATION_APP = XYZ

*WHEN PLANT

*IS *

*REC(EXPRESSION=%VALUE%,TIME=TIME.DATE_MNTH)

*ENDWHEN