Cash Flow Calculation selects all Company codes!

[Former Member]

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

[former_member186338 · Accepted solution]

The correct syntax is:

OTHER = [COMPANY_L=%COMPANY_L_SET%]

other require real dimension names!

[Former Member · Accepted solution]

Hi Vadim,

Thank you for your Answer and your help.

Do I have to change anything else in DM Package?

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%ENTITY_DIM%,%CURRENCY_DIM%,%TIME_DIM%")

Once again thank you.

Message was edited by: Mala Sun

[former_member186338 · Accepted solution]

"Do I have to change anything else in DM Package?

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%ENTITY_DIM%,%CURRENCY_DIM%,%TIME_DIM%")"

- No!

%ENTITY_DIM% is equivalent of COMPANY_L

[Former Member · Accepted solution]

Thank you Sir. Have a wonderful week-end!