how to convert the sap BPC MS scriptlogic to sap BPC NE scripts

[Former Member]

Hi,

i need to convert the sap bpc ms script logic to sap bpc nw script logic, if anybody have any conversion tools  please send me the link or guide me the how to convert the logic's..

or please convert the below allocation script..

*INCLUDE SYSTEM_CONSTANTS.LGL 

*SYSLIB SYSTEM_LIBRARY.LGL

*ALLOCATION                      NAC_BOPALLOC

*DESCRIPTION=NAC_BOPALLOC

*FACTOR = USING/TOTAL                       

*DIM ACCOUNTG WHAT = WB_BOP;                          WHERE = WB_BOP;                       USING = BOP;                                                                      TOTAL = BOP;                     

*DIM DATASRC                                           WHAT = D_ZGLOBAL;        WHERE = <<<;             USING = TOTALADJ;                             TOTAL = TOTALADJ;                     

*DIM SBU                  WHAT = WB_NAC;                    WHERE = BAS(NAC);   USING = <<<;                           TOTAL = NAC;   

*DIM LOB                               WHAT = NO_LOB;                                       WHERE = BAS(TOTALLOB);                     USING = <<<;                                                                       TOTAL = TOTALLOB;         

*DIM MB                                WHAT = NO_MB;                                         WHERE = <<<;             USING = <<<;                                          TOTAL = TOTMB;   

*DIM TIME                             WHAT = %YEAR%.ANNUAL;                    WHERE = <<<;                                            USING = 2010.TOTAL;                                 TOTAL = 2010.TOTAL;        

*DIM CATEGORY                WHAT = FINAL;                        WHERE = <<<;                            USING = TFORECAST;                              TOTAL = TFORECAST;                 

*DIM RPTCURRENCY       WHAT = USD;                                              WHERE = USD;                   USING = <<<;                                                                       TOTAL = <<<;                      

*DIM PRODUCT                  WHAT = NO_PROD;           WHERE = BAS(TOTFAT);  USING = <<<;                                                                       TOTAL = <<<;                      

*ENDALLOCATION

*ALLOCATION                      GC_BOPALLOC

*DESCRIPTION=GC_BOPALLOC                                                                                                                                                                                    

*FACTOR = USING/TOTAL                       

*DIM ACCOUNTG WHAT = WB_BOP;                          WHERE = WB_BOP;                       USING = BOP;                                                                      TOTAL = BOP;                     

*DIM DATASRC                                           WHAT = D_ZGLOBAL;        WHERE = <<<;             USING = TOTALADJ;                             TOTAL = TOTALADJ;                     

*DIM SBU                  WHAT = WB_GC;                      WHERE = BAS(GC);   USING = <<<;                           TOTAL = GC;         

*DIM LOB                               WHAT = NO_LOB;                                       WHERE = BAS(TOTALLOB);                     USING = <<<;                                                                       TOTAL = TOTALLOB;         

*DIM MB                                WHAT = NO_MB;                                         WHERE = <<<;             USING = <<<;                                          TOTAL = TOTMB;   

*DIM TIME                             WHAT = %YEAR%.ANNUAL;                    WHERE = <<<;                                            USING = 2010.TOTAL;                                 TOTAL = 2010.TOTAL;        

*DIM CATEGORY                WHAT = FINAL;                        WHERE = <<<;                            USING = TFORECAST;                              TOTAL = TFORECAST;                 

*DIM RPTCURRENCY       WHAT = USD;                                              WHERE = USD;                   USING = <<<;                                                                       TOTAL = <<<;                      

*DIM PRODUCT                  WHAT = NO_PROD;           WHERE = BAS(TOTFAT);  USING = <<<;                                                                       TOTAL = <<<;                      

*ENDALLOCATION

*ALLOCATION                      EGI_BOPALLOC

*DESCRIPTION=EGI_BOPALLOC                                                                                                                                                                                   

*FACTOR = USING/TOTAL                       

*DIM ACCOUNTG WHAT = WB_BOP;                          WHERE = WB_BOP;                       USING = BOP;                                                                      TOTAL = BOP;                     

*DIM DATASRC                                           WHAT = D_ZGLOBAL;        WHERE = <<<;             USING = TOTALADJ;                             TOTAL = TOTALADJ;                     

*DIM SBU                  WHAT = WB_EGI;                      WHERE = BAS(EGI);   USING = <<<;                           TOTAL = EGI;       

*DIM LOB                               WHAT = NO_LOB;                                       WHERE = BAS(TOTALLOB);                     USING = <<<;                                                                       TOTAL = TOTALLOB;         

*DIM MB                                WHAT = NO_MB;                                         WHERE = <<<;             USING = <<<;                                          TOTAL = TOTMB;   

*DIM TIME                             WHAT = %YEAR%.ANNUAL;                    WHERE = <<<;                                            USING = 2010.TOTAL;                                 TOTAL = 2010.TOTAL;        

*DIM CATEGORY                WHAT = FINAL;                        WHERE = <<<;                            USING = TFORECAST;                              TOTAL = TFORECAST;                 

*DIM RPTCURRENCY       WHAT = USD;                                              WHERE = USD;                   USING = <<<;                                                                       TOTAL = <<<;                      

*DIM PRODUCT                  WHAT = NO_PROD;           WHERE = BAS(TOTFAT);  USING = <<<;                                                                       TOTAL = <<<;                      

*ENDALLOCATION

*ALLOCATION                      GIIM_BOPALLOC

*DESCRIPTION=GIIM_BOPALLOC                                                                                                                                                                                 

*FACTOR = USING/TOTAL                       

*DIM ACCOUNTG WHAT = WB_BOP;                          WHERE = WB_BOP;                       USING = BOP;                                                                      TOTAL = BOP;                     

*DIM DATASRC                                           WHAT = D_ZGLOBAL;        WHERE = <<<;             USING = TOTALADJ;                             TOTAL = TOTALADJ;                     

*DIM SBU                  WHAT = WB_GIIM;                    WHERE = BAS(GIIM);   USING = <<<;                         TOTAL = GIIM;     

*DIM LOB                               WHAT = NO_LOB;                                       WHERE = BAS(TOTALLOB);                     USING = <<<;                                                                       TOTAL = TOTALLOB;         

*DIM MB                                WHAT = NO_MB;                                         WHERE = <<<;             USING = <<<;                                          TOTAL = TOTMB;   

*DIM TIME                             WHAT = %YEAR%.ANNUAL;                    WHERE = <<<;                                            USING = 2010.TOTAL;                                 TOTAL = 2010.TOTAL;        

*DIM CATEGORY                WHAT = FINAL;                        WHERE = <<<;                            USING = TFORECAST;                              TOTAL = TFORECAST;                 

*DIM RPTCURRENCY       WHAT = USD;                                              WHERE = USD;                   USING = <<<;                                                                       TOTAL = <<<;                      

*DIM PRODUCT                  WHAT = NO_PROD;           WHERE = BAS(TOTFAT);  USING = <<<;                                                                       TOTAL = <<<;                      

*ENDALLOCATION

*ALLOCATION                      GICMB_BOPALLOC

*DESCRIPTION=GICMB_BOPALLOC                                                                                                                                                                             

*FACTOR = USING/TOTAL                       

*DIM ACCOUNTG WHAT = WB_BOP;                          WHERE = WB_BOP;                       USING = BOP;                                                                      TOTAL = BOP;                     

*DIM DATASRC                                           WHAT = D_ZGLOBAL;        WHERE = <<<;             USING = TOTALADJ;                             TOTAL = TOTALADJ;                     

*DIM SBU                  WHAT = WB_GICMB;               WHERE = BAS(GICMB);   USING = <<<;                         TOTAL = GICMB;                     

*DIM LOB                               WHAT = NO_LOB;                                       WHERE = BAS(TOTALLOB);                     USING = <<<;                                                                       TOTAL = TOTALLOB;         

*DIM MB                                WHAT = NO_MB;                                         WHERE = <<<;             USING = <<<;                                          TOTAL = TOTMB;   

*DIM TIME                             WHAT = %YEAR%.ANNUAL;                    WHERE = <<<;                                            USING = 2010.TOTAL;                                 TOTAL = 2010.TOTAL;        

*DIM CATEGORY                WHAT = FINAL;                        WHERE = <<<;                            USING = TFORECAST;                              TOTAL = TFORECAST;                 

*DIM RPTCURRENCY       WHAT = USD;                                              WHERE = USD;                   USING = <<<;                                                                       TOTAL = <<<;                      

*DIM PRODUCT                  WHAT = NO_PROD;           WHERE = BAS(TOTFAT);  USING = <<<;                                                                       TOTAL = <<<;                      

*ENDALLOCATION

*ALLOCATION                      GIE_BOPALLOC

*DESCRIPTION=GIE_BOPALLOC                                                                                                                                                                                   

*FACTOR = USING/TOTAL                       

*DIM ACCOUNTG WHAT = WB_BOP;                          WHERE = WB_BOP;                       USING = BOP;                                                                      TOTAL = BOP;                     

*DIM DATASRC                                           WHAT = D_ZGLOBAL;        WHERE = <<<;             USING = TOTALADJ;                             TOTAL = TOTALADJ;                     

*DIM SBU                  WHAT = WB_GIE;                     WHERE = BAS(GIE);   USING = <<<;                         TOTAL = GIE;          

*DIM LOB                               WHAT = NO_LOB;                                       WHERE = BAS(TOTALLOB);                     USING = <<<;                                                                       TOTAL = TOTALLOB;         

*DIM MB                                WHAT = NO_MB;                                         WHERE = <<<;             USING = <<<;                                          TOTAL = TOTMB;   

*DIM TIME                             WHAT = %YEAR%.ANNUAL;                    WHERE = <<<;                                            USING = 2010.TOTAL;                                 TOTAL = 2010.TOTAL;        

*DIM CATEGORY                WHAT = FINAL;                        WHERE = <<<;                            USING = TFORECAST;                              TOTAL = TFORECAST;                 

*DIM RPTCURRENCY       WHAT = USD;                                              WHERE = USD;                   USING = <<<;                                                                       TOTAL = <<<;                      

*DIM PRODUCT                  WHAT = NO_PROD;           WHERE = BAS(TOTFAT);  USING = <<<;                                                                       TOTAL = <<<;                      

*ENDALLOCATION

*COMMIT

[former_member186338 · Accepted solution]

Hi Sarath,

There are no conversion tools, you have to do it manually with full understanding of differences between MS and NW. Here:

Remove:

*INCLUDE SYSTEM_CONSTANTS.LGL

*SYSLIB SYSTEM_LIBRARY.LGL

Replace:

*ALLOCATION                      NAC_BOPALLOC

*DESCRIPTION=NAC_BOPALLOC

with:

*RUNALLOCATION

And remove useless *COMMIT

Vadim

[Former Member · Accepted solution]

THANK U VADIM.

I NEED TO ONE MORE SCRIPT CONVERT THIS ALLOC_EXPENSE BPC MS SCRIPT TO NW SCRIPT:

*FOR %PROD%=INVFUND,ASeries,BSeries,CSeries,DSeries,NONSERIES

*RUNALLOCATION

*FACTOR = 1                           

*DIM DATASRC                        WHAT = METHOD;        WHERE = <<<;            

*DIM SBU                     WHAT = GENADM;                    WHERE = BAS(ALLCHANNEL);                                    

*DIM PRODUCT                        WHAT = NONSERIES;               WHERE = %PROD%;

*ENDALLOCATION

*NEXT

*COMMIT

*XDIM_MEMBERSET SBU = GENADM,1000000,2000000,3000000,4000000

*WHEN DATASRC

*IS "METHOD"

*WHEN CATEGORY

*IS "BUDGET"

*WHEN SBU

*IS <> "GENADM"

*WHEN signeddata

*IS 1

*REC(EXPRESSION=-GET(ACCOUNTG="FTEPERC",DATASRC="CALCULATION"),DATASRC="APPLALLOCRATE")

*IS 2

*REC(EXPRESSION=-GET(ACCOUNTG="BENPERC",DATASRC="CALCULATION"),DATASRC="APPLALLOCRATE")

*IS 3

*REC(EXPRESSION=-GET(ACCOUNTG="SQUAREFEETPERC",DATASRC="CALCULATION"),DATASRC="APPLALLOCRATE")

*IS 4

*REC(EXPRESSION=-GET(ACCOUNTG="WTDAVG",DATASRC="CALCULATION"),DATASRC="APPLALLOCRATE")

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

*FOR %PROD%=INVFUND,ASeries,BSeries,CSeries,DSeries,NONSERIES

*RUNALLOCATION

*FACTOR = USING                               

*DIM DATASRC                        WHAT = CALCULATION;            WHERE = GROWTHRATE; USING = APPLALLOCRATE;           

*DIM SBU                     WHAT = GENADM;                    WHERE = BAS(ALLCHANNEL);   USING = <<<;                                    

*DIM PRODUCT                        WHAT = NONSERIES;               WHERE = %PROD%; USING = <<<;

*ENDALLOCATION

*NEXT

*COMMIT

[former_member186338 · Accepted solution]

Hi Sarath,

You have to do it YOURSELF!!! With full understanding of business logic!

Just for info:

*WHEN signeddata

*IS 1

is not supported in BPC NW! No condition on signeddata.

You can check value using ternary operator in REC:

*REC(EXPRESSION=%VALUE%==1 ? ([ACCOUNTG].[FTEPERC],[DATASRC].[CALCULATION]) : 0, DATASRC="APPLALLOCRATE")

GET is also not supported - use tuple expression like:

([ACCOUNTG].[FTEPERC],[DATASRC].[CALCULATION])

And remove COMMIT!!!

Vadim

[Former Member · Accepted solution]

Thank you Vadim..