Script logic from 5.1MS to 7.5NW

[Former Member]

1)We are migrating from BPC 5.1MS to BPC 7.5NW. Not sure how to translate the following 5.1MS script logic to 7.5NW.

a) RUN_STORED_PROCEDURE=SPCOPYCATEGORY('FINANCE','%CATEGORY_SET%','%CATEGORY_SET%','LC','BALANCING','%SCOPETABLE%','%LOGTABLE%')

b) PROCESS_EACH_MEMBER= TIME

c) CLEAR_ELIM_FLAGS(FXGAIN,0)

d) CALC_EACH_PERIOD

2) For RUN_STORED_PROCEDURE=SPRUNCALCACCOUNT, I was thinking of using the NW code as:

RUN_PROGRAM CALC_ACCOUNT

FINANCE = %FINANCE_SET%

CATEGORY = [%CATEGORY_SET%]

%SCOPETABLE%

%LOGTABLE%

OTHER = [ENTITY=%ENTITY_SET%]// or OTHER=[ENTITY=C1000] or [ENTITY=%ENTITY_SET%;INTCO=%INTCO_SET%...]

*ENDRUN_PROGRAM

Is this right ?

3) I have the following includes and syslib files being referenced from 5.1MS logic. Do I still need to use these files in 7.5NW ?

*INCLUDE SYSTEM_CONSTANTS.LGL

*SYSLIB CONSOLIDATION_LIBRARY.LGL

*SYSLIB SHELL_LIBRARY.LGL

*SYSLIB SYSTEM_LIBRARY.LGL

*SYSLIB ICELIMWITHCURR.LGL

Any help/input is highly appreciated.

Regards

KV

[Former Member · Accepted solution]

1)We are migrating from BPC 5.1MS to BPC 7.5NW. Not sure how to translate the following 5.1MS script logic to 7.5NW.

a)RUN_STORED_PROCEDURE=SPCOPYCATEGORY('FINANCE','%CATEGORY_SET%','%CATEGORY_SET%','LC','BALANCING','%SCOPETABLE%','%LOGTABLE%')

b) PROCESS_EACH_MEMBER= TIME

c) CLEAR_ELIM_FLAGS(FXGAIN,0)

d) CALC_EACH_PERIOD

*************************************************************

Unfortunately Copy Category never was completely implemented for BPC NetWeaver as a standard function so you would have to do one of a few things:

1) Use standard BPC NW script logic to rebuild the copy category functionality

2) build this functionality into the BPC NW BADI framework.

2) For RUN_STORED_PROCEDURE=SPRUNCALCACCOUNT, I was thinking of using the NW code as:

RUN_PROGRAM CALC_ACCOUNT

FINANCE = %FINANCE_SET%

CATEGORY = %CATEGORY_SET%

%SCOPETABLE%

%LOGTABLE%

OTHER = ENTITY=%ENTITY_SET%// or OTHER=ENTITY=C1000 or http://ENTITY=%ENTITY_SET%;INTCO=%INTCO_SET%.

*ENDRUN_PROGRAM

*************************************************************

I would check the online help... Cut and Paste inline:

Account Transformation as Script Logic

You use this to run an account transformation rule.

Activities

You run this program using the following logic statement:

*RUN_PROGRAM CALC_ACCOUNT(<parameters list>)

Example

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY = %CATEGORY_SET%

CURRENCY = %CURRENCY_SET%

TID_RA = %TIME_SET%

CALC=A

OTHER = [ENTITY=%ENTITY_SET%]// or OTHER=[ENTITY=C1000] or [ENTITY=%ENTITY_SET%;INTCO=%INTCO_SET%...]

*ENDRUN_PROGRAM

NOTE

If there is no other scope against which you need to run the program, delete the OTHER line within the script.

Any software coding and/or code lines / strings ("Code") included in this documentation are only examples and are not intended to be used in a productive system environment. The Code is only intended to better explain and visualize the syntax and phrasing rules of certain coding. SAP does not warrant the correctness and completeness of the Code given herein, and SAP shall not be liable for errors or damages caused by the usage of the Code, except if such damages were caused by SAP intentionally or by its gross negligence.

3) I have the following includes and syslib files being referenced from 5.1MS logic. Do I still need to use these files in 7.5NW ?

*INCLUDE SYSTEM_CONSTANTS.LGL

*SYSLIB CONSOLIDATION_LIBRARY.LGL

*SYSLIB SHELL_LIBRARY.LGL

*SYSLIB SYSTEM_LIBRARY.LGL

*SYSLIB ICELIMWITHCURR.LGL

*********************************************

LGL files are not supported in BPC NetWeaver so these would not work unless you made them LGF files. I would revisit this and see if you actually need the functions or if you can leverage something altogether different.

One of the biggest parts of a BPC NetWeaver integration from BPC Microsoft is the reimplementation of Script Logic. Most of the time this needs to be re-engineered.

Hope this helps.

Cheers, Scott

Edited by: Scott Cairncross on Aug 17, 2010 9:16 PM