Dear Friends,
I am trying to Calculate Cash Flow using Script Logic *RUN_PROGRAM CALC_ACCOUNT.
Requirement is to include Company Code as one of the selections in the Script Logic to restrict the DM Package-execution for a particular Company Code. None of the below scenarios works, it selects all the Company Codes, and the restriction does not work.
Your help is much appreciated.
ENTITY Type Dimension name: COMPANY_L
Scenario 1: Simple Variable selection without OTHER
*RUN_PROGRAM CALC_ACCOUNT
CATEGORY = %CATEGORY_SET%
CURRENCY = %RPTCURRENCY_SET%
TID_RA = %TIME_SET%
ENTITY=%COMPANY_L_SET%
CALC = CF2
*ENDRUN_PROGRAM
Corresponding DM Package Modifications:
PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%ENTITY_DIM%,%CURRENCY_DIM%,%TIME_DIM%") ____________________________________________________________________________________________
Scenario 2: GROUP/Scope is outside OTHER
*RUN_PROGRAM CALC_ACCOUNT
CATEGORY = %CATEGORY_SET%
CURRENCY = %RPTCURRENCY_SET%
GROUP = %SCOPE_SET%
TID_RA = %TIME_SET%
OTHER = [ENTITY=%COMPANY_L_SET%] CALC = CF2
*ENDRUN_PROGRAM
Corresponding DM Package Modifications:
PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%GROUP_DIM%,%ENTITY_DIM%,%CURRENCY_DIM%,%TIME_DIM%") _____________________________________________________________________________________________
Scenario 3: GROUP/Scope is inside OTHER
*RUN_PROGRAM CALC_ACCOUNT
CATEGORY = %CATEGORY_SET%
CURRENCY = %RPTCURRENCY_SET%
TID_RA = %TIME_SET%
CALC = CF2
OTHER = [ENTITY=%COMPANY_L_SET%;GROUP = %SCOPE_SET%]
*ENDRUN_PROGRAM
Corresponding DM Package Modifications:
PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%GROUP_DIM%,%ENTITY_DIM%,%CURRENCY_DIM%,%TIME_DIM%") ____________________________________________________________________________________________
Scenario 4: Hard coding the company code
*RUN_PROGRAM CALC_ACCOUNT
CATEGORY = %CATEGORY_SET%
CURRENCY = %RPTCURRENCY_SET%
TID_RA = %TIME_SET%
OTHER = [ENTITY=6600]
CALC = CF2
*ENDRUN_PROGRAM
Corresponding DM Package Modifications:
PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%") ___________________________________________________________________________________
Scenario 4: Just company code variable in OTHER
*RUN_PROGRAM CALC_ACCOUNT
CATEGORY = %CATEGORY_SET%
CURRENCY = %RPTCURRENCY_SET%
TID_RA = %TIME_SET%
OTHER = [ENTITY=%COMPANY_L_SET%]
CALC = CF2
*ENDRUN_PROGRAM
Corresponding DM Package Modifications:
PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%ENTITY_DIM%,%CURRENCY_DIM%,%TIME_DIM%")
Message was edited by: Mala Sun