Former Member

Oct 29, 2014 at 06:52 AM

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

28 Views

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