cancel
Showing results for 
Search instead for 
Did you mean: 

RUN A PACKAGE FROM BW ANSWER PROMPT BPC 10 NW

michele_medaglia5
Active Participant
0 Kudos

Hi BPC Friends

I am runnig a bpc package from bw using the following answer prompt

%SELECTION%

/PA_SOP_FR_10/SALES/PRIVATEPUBLICATIONS/MEDAGMI1/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:CATEGORY|BUDGET_V1|DIMENSION:TIME|2015.JAN,2015.FEB,2015.MAR,2015.APR,2015.MAY,2015.JUN,2015.JUL,2015.AUG,2015.SEP,2015.OCT,2015.NOV,2015.DEC

but the package give me this error

SELECTION =

/PA_SOP_FR_10/SALES/PRIVATEPUBLICATIONS/MEDAGMI1/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:CATEGORY|BUDGET_V1|DIMENSION:TIME|2015.JAN,2015.FEB,2015.MAR,2015.APR,2015.MAY,2015.JUN,2015.JUL,2015.AUG,2015.SEP,2015.OCT,2015.NOV,2015.DEC#

[Message]

--------------------------------------------------------------

RUN_LOGIC:Dimension set:"TIME" not assigned in Data Manager

Could you help me to understand what I am wronging about the dimension time in the answer prompt?

thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

Shrikant_Jadhav
Active Contributor
0 Kudos

Hi Michele,

Please provide script logic code which you are running through DM package.

Mean while you can refer following thread

Regards,

Shrikant

michele_medaglia5
Active Participant
0 Kudos

Hi

If I run the package form DM typing the category and time it works

If I run though the process chain using the answer prompt I get the error

my script is the following

*SELECT(%TP_ACC%,"[ID]","KEY_FIGURE","ACCFIN_TP<>'N' ")

*SELECT(%TOPS_ACC%,"[ID]","KEY_FIGURE","ACCFIN_TOPS<>'N' ")

*SELECT(%SKU%, "[ID]",SKU,"[PROFIT_CENTER]<>'' AND [PROFIT_CENTER]<>' ' AND [PROFIT_CENTER]<>'Y' AND [PROFIT_CENTER]<>'PC_' AND [CALC]='N' AND [ID]<>'NO_SKU' AND [ID]<>'NO_PC' AND [CONTROL_AREA]<>'Y' AND [COMPANY_CODE]<>'Y' AND [BU]<>'Y' AND [SUB_BU]<>'Y' AND [BRAND]<>'Y' ")

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET CATEGORY=%CATEGORY_SET%

*XDIM_MEMBERSET SKU = %SKU%

*XDIM_MEMBERSET KEY_FIGURE=%TP_ACC%,%TOPS_ACC%

*XDIM_MEMBERSET COUNTRY=NO_COUNTRY

*DESTINATION_APP=FINANCE

*SKIP_DIM = COUNTRY

*ADD_DIM DATASRC=SALES,CYCLE_PCA=NO_CYCLE_PCA,SKF=NO_SKF

*RENAME_DIM KEY_FIGURE=COST_ELEMENT,SKU=PROFIT_CENTER,SALES_TYPE=FUNCTIONAL_AREA

and so on