Skip to Content
0
Former Member
Aug 14, 2016 at 03:27 AM

Cash Flow Calculation selects all Company codes!

33 Views

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