on 12-05-2014 5:11 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.