Skip to Content
author's profile photo Former Member
Former Member

Script Logic is not working Properly in BPC 10.0

Hi ,


*XDIM_MEMBERSET MEASURES = YTD
*XDIM_MEMBERSET DATASRC = BAS(EXTERNAL_DATASRC)
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*DESTINATION_APP = MGMT_INPUT
*SKIP_DIM = INTCO
*SKIP_DIM = FLOW
*ADD_DIM PRODUCT = NO_PRD, PRODUCTSRC = NO_PS, PRODUCTTYPE = NO_PRD_TYPE, MARKET = M_NO_MKT

//PART 1: TRANSFER G_NONE AND LC

*WHEN GROUPS
*IS G_NONE
*WHEN RPTCURRENCY
*IS LC
*WHEN CATEGORY.DATA_TO_MGMT_INPUT
*IS "CAT_TO_MOVE"
//*WHEN ACCOUNT.DATA_TO_MGMT_INPUT
//*IS "ACC_TO_MOVE"
*WHEN DATASRC.DATA_TO_MGMT_INPUT
*IS<>""
*WHEN ACCOUNT.ACCTYPE
*IS INC,LEQ
*REC(FACTOR = -1,DATASRC = DATASRC.DATA_TO_MGMT_INPUT)
*IS AST,EXP
*REC(FACTOR = 1,DATASRC = DATASRC.DATA_TO_MGMT_INPUT)
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
//*ENDWHEN
*COMMIT

The part highlighted in red is not working properly.could someone suggest any other solution.

Thanks in Advance.

Thanks,

Ranjan

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 14, 2012 at 12:00 PM

    Hi Ranjan,

    Test for empty in *IS is not working. The workaround can be like:

    *SELECT(%MGMTINPUT%,"[DATA_TO_MGMT_INPUT]",DATASRC,"[DATA_TO_MGMT_INPUT]<>''")

    *WHEN DATASRC.DATA_TO_MGMT_INPUT

    *IS %MGMTINPUT%

    ...

    Or simply put "No" instead of empty value in DATA_TO_MGMT_INPUT and use:

    *IS <> "No"

    B.R. Vadim

    P.S. And please, remove COMMIT from your code - useless with WHEN/ENDWHEN

    Add a comment
    10|10000 characters needed characters exceeded

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.