Skip to Content

RUN A PACKAGE FROM BW ANSWER PROMPT BPC 10 NW

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 06, 2014 at 05:22 AM

    Hi Michele,

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

    Mean while you can refer following thread

    Regards,

    Shrikant

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.