CALACCOUNT package status "FAILED:

[former_member313968]

Dear Experts,

I am having problems with my CALCACCOUNT package. we are running CMBPC 801 SP 10, EPM Add-in SP21, .net 3.5 and BW 7.40 SP12.

The calcaccount package is failing with status "FAILED",. it would appear that this is due to some entities which the user running the package does not have access to. No errors encountered if the package is run by a user with admin access.

However, when user runs package they specify the exact entities they would want this package to run for.

[former_member186338 · Accepted solution]

Please provide full info with screenshots etc... Including access rights, entity dimension, rule setup, script to launch, package log...

Vadim

[former_member313968 · Accepted solution]

Dear Vadim,

Thanks for the quick reply. please find details below.

1. Script Logic: CALCACCOUNT.LGF

     *RUN_PROGRAM CALC_ACCOUNT.LGF

     CATEGORY = %VERSION_SET%

     CURRENCY = LC

     TIME = %TIME_SET%

     ENTITY = %ENTITY_SET%

*ENDPROGRAM

2. Package Name: Calc Account

     debug (on)

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

     TASK(/CPMB/RUNCALCACCOUNT_LOGIC,SUSER,%USER%)

     TASK(/CPMB/RUNCALCACCOUNT_LOGIC,SAPPSET,%APPSET%)

     TASK(/CPMB/RUNCALCACCOUNT_LOGIC,SAPP,%APP%)

     TASK(/CPMB/RUNCALCACCOUNT_LOGIC,SELECTION,%SELECTION%)

     TASK(/CPMB/RUNCALCACCOUNT_LOGIC,LOGICFILENAME,CALCACCOUNT.LGF)

3. Run DM Calc Account

     SELECTION =

     /....SCHIMOLI/TEMPFILES/FROM.TMP@@@@SAVE@@@@EXPAND@@

     /DIMENSION:ENTITY|ARMKGQ,BOTQUA,AQBFCT|:

     /DIMENSION:TIME|2016.02|

     /DIMENSION:VERSION|ACTUAL|

     [Message]

     ---------------------------------------------------------------------------------------

     RUN_LOGIC

     Invalid Members [ENTITY]=ARMMPL]

     Invalid members [ENTITY]=BEE012]

     .    

     .

     .

     model: Consolidation. Package status: ERROR

** PLEASE note, the user does not have access to entities ARMMPL and BEE012.

Your assistance is greatly appreciated.

Thanks & Regards,

Godhelp

[former_member186338 · Accepted solution]

Incorrect script:

Instead of line:

ENTITY = %ENTITY_SET%

Use line:

OTHER = [ENTITY=%ENTITY_SET%]

Read help: Account-based Calculations as Script Logic - SAP Business Planning and Consolidation, version for SA...

Vadim

[former_member186338 · Accepted solution]

P.S.

Also:

*RUN_PROGRAM CALC_ACCOUNT //not CALC_ACCOUNT.LGF

...

TID_RA = %TIME_SET% //instead of TIME = %TIME_SET%

CALC=A //Rule ID!

[Former Member · Accepted solution]

Also use *ENDRUN_PROGRAM instead of *ENDPROGRAM

Khokan