Script not aggregating as expected

[Former Member]

I have 3 sections of script that work perfect when you run them individually, they also run perfectly when you run only the first two sections together but when the last one is added I get a totally unexpected result.   They all write to the exact same intersection so I would expect them to aggregate correctly.

Any thoughts on why this last section is causing an issue.

Thank you

///////////////////

//// Eliminate COMM REV MNL

/////////////////

*SELECT(%TOTPC31%, "[ID]", PROFITCENTER, "[CALC]='N'")

*XDIM_MEMBERSET PROFITCENTER=%TOTPC31%

*XDIM_MEMBERSET COMPANYCODE = 7500

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET FLOW = Balance

*XDIM_MEMBERSET TRADINGPARTNER = BAS(TTLINTERCONON)

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ACCOUNT = 471000

*WHEN CATEGORY

*IS ACTUAL

*REC(FACTOR=-1, ACCOUNT="592000",COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*REC(FACTOR=1, ACCOUNT="662100",COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*endwhen

*COMMIT

//

//

//

///////////////////

//// Eliminate DIST REV

/////////////////

*SELECT(%TOTPC32%, "[ID]", PROFITCENTER, "[CALC]='N'")

*XDIM_MEMBERSET PROFITCENTER=%TOTPC32%

*XDIM_MEMBERSET COMPANYCODE = 7100

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET FLOW = Balance

*XDIM_MEMBERSET TRADINGPARTNER = BAS(TTLINTERCONON)

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ACCOUNT = 592019,592020,592021

*WHEN CATEGORY

*IS ACTUAL

*REC(FACTOR=-1, ACCOUNT="592000", COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*REC(FACTOR=1, ACCOUNT="662100", COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*endwhen

*COMMIT

/////////////////

// Eliminate Admin Allow FIA between SRS and MNL

///////////////

*SELECT(%TOTPC65%, "[ID]", PROFITCENTER, "[CALC]='N'")

*XDIM_MEMBERSET PROFITCENTER=%TOTPC65%

*XDIM_MEMBERSET COMPANYCODE = 7200

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET FLOW = Balance

*XDIM_MEMBERSET TRADINGPARTNER = BAS(TTLINTERCONON)

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ACCOUNT = 592023

*WHEN CATEGORY

*IS ACTUAL

*REC(FACTOR=-1, ACCOUNT="592000", COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*REC(FACTOR=1, ACCOUNT="662100", COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*endwhen

*COMMIT

[former_member186338 · Accepted solution]

Hi Nick,

First of all, please remove absolutely useless COMMIT - the only thing it's doing - just reset scope. The script will be simplified!

Test in UJKT and post results.

Vadim

[former_member186338 · Accepted solution]

Optimized script:

*SELECT(%TOTPC31%, "[ID]", PROFITCENTER, "[CALC]='N'") // Why same TOTPC31, TOTPC65??, why select base members of PROFITCENTER?

*XDIM_MEMBERSET PROFITCENTER=%TOTPC31%

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET% // Strange - CATEGORY is fixed to ACTUAL in the script

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET FLOW = Balance

*XDIM_MEMBERSET TRADINGPARTNER = BAS(TTLINTERCONON)

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*XDIM_MEMBERSET RPTCURRENCY = USD

// Eliminate COMM REV MNL

*XDIM_MEMBERSET COMPANYCODE = 7500

*XDIM_MEMBERSET ACCOUNT = 471000

*WHEN CATEGORY

*IS ACTUAL

*REC(FACTOR=-1, ACCOUNT="592000",COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*REC(FACTOR=1, ACCOUNT="662100",COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*endwhen

// Eliminate DIST REV

*XDIM_MEMBERSET COMPANYCODE = 7100

*XDIM_MEMBERSET ACCOUNT = 592019,592020,592021

*WHEN CATEGORY

*IS ACTUAL

*REC(FACTOR=-1, ACCOUNT="592000", COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*REC(FACTOR=1, ACCOUNT="662100", COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*endwhen

// Eliminate Admin Allow FIA between SRS and MNL

*XDIM_MEMBERSET COMPANYCODE = 7200

*XDIM_MEMBERSET ACCOUNT = 592023

*WHEN CATEGORY

*IS ACTUAL

*REC(FACTOR=-1, ACCOUNT="592000", COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*REC(FACTOR=1, ACCOUNT="662100", COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*endwhen

Each part of the script is writing to the same ACCOUNT and COMPANYCODE - overwriting may happen...

Please describe the logic you want to achieve.

Vadim

[former_member186338 · Accepted solution]

P.S. If you have multiple independent WHEN/ENDWHEN loops like:

*WHEN xxx

...

*ENDWHEN

*WHEN xxx

...

*ENDWHEN

*WHEN xxx

...

*ENDWHEN

Then each next loop will overwrite previous if same target is used. Tj aggregate you need to have single loop - try something like:

...

*XDIM_MEMBERSET CATEGORY = ACTUAL

*XDIM_MEMBERSET COMPANYCODE = 7500,7100,7200

*XDIM_MEMBERSET ACCOUNT = 471000,592019,592020,592021,592023

*WHEN COMPANYCODE

*IS 7500

*WHEN ACCOUNT

*IS 471000

*REC(FACTOR=-1, ACCOUNT="592000",COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*REC(FACTOR=1, ACCOUNT="662100",COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*ENDWHEN

*IS 7100

*WHEN ACCOUNT

*IS 592019,592020,592021

*REC(FACTOR=-1, ACCOUNT="592000",COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*REC(FACTOR=1, ACCOUNT="662100",COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*ENDWHEN

*IS 7200

*WHEN ACCOUNT

*IS 592023

*REC(FACTOR=-1, ACCOUNT="592000",COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*REC(FACTOR=1, ACCOUNT="662100",COMPANYCODE="CC_SFGELIM",AUDITTRAIL="EquityAdj")

*ENDWHEN

*ENDWHEN

Vadim

[Former Member · Accepted solution]

Vadim

Thank you for the reply.  I have run my script in it original form through UJKT and below are the results.  I read throught them and was unable to desern any value.   The logic I want to achive is simply adding the result of these three scripts together and writting to one account.  The scripts were written by the consultants that set up our system so I cannot take credit for the poorly written script.    Please let me know if I am doing somthing wrong, Like I said in previous post the first two sections of script run and aggregate just fine but when I addd the third I get un expected result.

LGX:

*XDIM_MEMBERSET PROFITCENTER=00000000000000000000000010001000,0000111010,0000111016,0000111017,0000111018,0000111019,0000111020,0000111030,0000111040,0000111050,0000111070,0000116020,0000121010,0000126010,0000131010,0000131016,0000131017,0000131018,0000131019,0000131020,0000131030,0000131040,0000141010,0000141030,0000161010,0000181010,0000181016,0000181017,0000181018,0000181019,0000181030,0000181040,0000181050,0000181060,0000181070,0000181080,0000181086,0000181087,0000181088,0000181089,0000181090,0000181096,0000181097,0000181098,0000181099,0000181110,0000186010,0000186017,0000186030,0000186040,0000186060,0000211010,0000211020,0000216010,0000221010,0000221016,0000221017,0000221018,0000221019,0000221020,0000221030,0000221040,0000221050,0000221060,0000221070,0000221080,0000226010,0000226030,0000226040,0000226050,0000226060,0000231010,0000231017,0000231018,0000231019,0000231020,0000231030,0000231040,0000231050,0000236010,0000236020,0000236030,0000236050,0000241010,0000241020,0000241030,0000241040,0000241060,0000246010,0000246020,0000301010,0000301017,0000301020,0000306010,0000306020,0000306030,0000401010,0000401020,0000401030,0000401050,0000401060,0000406010,0000406020,0000501001,0000501002,0000501003,0000501004,0000502001,0000502002,0000502003,0000502004,0000502005,0000502006,0000502007,0000502008,0000502009,0000502010,0000502011,0000502012,0000502013,0000502014,0000502015,0000502016,0000502017,0000502018,0000503001,0000503002,0000503003,0000503004,0000503005,0000503006,0000504001,0000504002,0000504003,0000504004,0000505001,0000506001,0000506002,0000506003,0000507001,0000507002,0000507003,0000507004,0000507005,0000507006,0000508001,0000508002,0000509001,0000509002,0000509003,0000509004,0000509005,0000509006,0000509007,0000509008,0000509009,0000509010,0000509011,0000509012,0000509013,0000509014,0000509015,0000509016,0000509017,0000509018,0000509019,0000509020,0000509021,0000509022,0000509023,0000509024,0000509025,0000509026,0000509027,0000509028,0000509029,0000509030,0000509031,0000509032,0000509033,0000509034,0000509035,0000509036,0000509037,0000509038,0000509039,0000509040,0000509041,0000509042,0000509043,0000509044,0000509045,0000509046,0000509047,0000510001,0000510002,0000510003,0000510004,0000510005,0000510006,0000510007,0000510008,0000511001,0000511002,0000511003,0000511004,0000511005,0000511006,0000511007,0000511008,0000511009,0000512001,0000512002,0000512003,0000512004,0000512005,0000513001,0000513002,0000513003,0000513004,0000513005,0000513006,0000514001,0000514002,0000514003,0000514004,0000514005,0000514006,0000514007,0000514008,0000514009,0000514010,0000514011,0000514012,0000514013,0000515001,0000515002,0000515003,0000515004,0000515005,0000515006,0000515007,0000515008,0000515009,0000515010,0000515011,0000515012,0000515013,0000515014,0000516001,0000516002,0000516003,0000516004,0000516005,0000516006,0000516007,0000516008,0000517001,0000517002,0000518001,0000518002,0000519001,0000519002,0000519003,0000519004,0000519005,0000520001,0000520002,0000520003,0000520004,0000520005,0000520006,0000520007,0000520008,0000520009,0000520010,0000521001,0000521002,0000521003,0000521004,0000521005,0000521006,0000521007,0000521008,0000521009,0000521010,0000521011,0000521012,0000521013,0000521014,0000521015,0000521016,0000521017,0000522001,0000522002,0000522003,0000522004,0000523001,0000523002,0000523003,0000523004,0000524001,0000525001,0000525002,0000525003,0000525004,0000525005,0000525006,0000525007,0000525008,0000525009,0000525010,0000525011,0000525012,0000525013,0000525014,0000525015,0000525016,0000525017,0000525018,0000525019,0000525020,0000525021,0000525022,0000525023,0000526001,0000526002,0000526003,0000526004,0000526005,0000527001,0000527002,0000527003,0000527004,0000527005,0000527006,0000527007,0000527008,0000527009,0000527010,0000527011,0000527012,0000527013,0000527014,0000527015,0000527016,0000527017,0000527018,0000527019,0000527020,0000527021,0000527022,0000527023,0000527024,0000527025,0000527026,0000527027,0000527028,0000527029,0000527030,0000527031,0000527032,0000527033,0000527034,0000527035,0000527036,0000527037,0000527038,0000527039,0000527040,0000527041,0000527042,0000527043,0000527044,0000527045,0000527046,0000527047,0000527048,0000527049,0000527050,0000527051,0000527052,0000527053,0000527054,0000527055,0000528001,0000528002,0000528003,0000529001,0000529002,0000530001,0000530002,0000530003,0000530004,0000530005,0000530006,0000530007,0000530008,0000530009,0000530010,0000530011,0000530012,0000530013,0000530014,0000531001,0000531002,0000531003,0000531004,0000531005,0000531006,0000532001,0000532002,0000532003,0000532004,0000532005,0000532006,0000532007,0000532008,0000532009,0000533001,0000533002,0000533003,0000533004,0000534001,0000534002,0000900000,0000909999,0000999991,0000999992,0000999993,0000999994,0000999999,111010,111016,111017,111018,111019,111020,111030,111040,111050,111060,111070,116020,121010,126010,131010,131016,131017,131018,131019,131020,131030,131040,141010,141020,141030,141040,146010,151010,161010,161016,161017,161018,161019,161020,161030,161040,161050,161060,161070,162010,162017,162020,162030,162040,162050,162060,171010,171016,171017,171018,171019,171020,171030,171040,181010,181012,181014,181016,181017,181018,181019,181020,181030,181040,181050,181060,181070,181080,181086,181087,181088,181089,181090,181096,181097,181098,181099,181100,181110,186010,186017,186020,186030,186040,186050,186060,186080,211010,211016,211017,211018,211019,211020,211030,211040,211050,211060,211070,211080,212010,212020,212030,216010,216030,221010,221016,221017,221018,221019,221020,221030,221040,221050,221060,221070,221080,222010,226010,226020,226030,226040,226050,226060,226090,231010,231017,231018,231019,231020,231030,231040,231050,232010,236010,236020,236030,236050,241010,241020,241030,241040,241050,241060,241070,242010,242020,242030,246010,246020,246030,301010,301017,301020,302010,306010,306020,306030,401010,401020,401030,401040,401050,401060,406010,406020,411010,411017,411018,411019,411020,411030,411040,411050,412010,412020,421010,421020,421030,421040,421050,431010,431020,432010,451010,501001,501002,501003,501004,502001,502002,502003,502004,502005,502006,502007,502008,502009,502010,502011,502012,502013,502014,502015,502016,502017,502018,503001,503002,503003,503004,503005,503006,503007,503008,503009,503010,504001,504002,504003,504004,504005,505001,506001,506002,506003,507001,507002,507003,507004,507005,507006,508001,508002,509001,509002,509003,509004,509005,509006,509007,509008,509009,509010,509011,509012,509013,509014,509015,509016,509017,509018,509019,509020,509021,509022,509023,509024,509025,509026,509027,509028,509029,509030,509031,509032,509033,509034,509035,509036,509037,509038,509039,509040,509041,509042,509043,509044,509045,509046,509047,510001,510002,510003,510004,510005,510006,510007,510008,511001,511002,511003,511004,511005,511006,511007,511008,511009,512001,512002,512003,512004,512005,513001,513002,513003,513004,513005,513006,514001,514002,514003,514004,514005,514006,514007,514008,514009,514010,514011,514012,514013,515001,515002,515003,515004,515005,515006,515007,515008,515009,515010,515011,515012,515013,515014,516001,516002,516003,516004,516005,516006,516007,516008,517001,517002,518001,518002,519001,519002,519003,519004,519005,520001,520002,520003,520004,520005,520006,520007,520008,520009,520010,521001,521002,521003,521004,521005,521006,521007,521008,521009,521010,521011,521012,521013,521014,521015,521016,521017,522001,522002,522003,522004,522005,523001,523002,523003,523004,524001,525001,525002,525003,525004,525005,525006,525007,525008,525009,525010,525011,525012,525013,525014,525015,525016,525017,525018,525019,525020,525021,525022,525023,526001,526002,526003,526004,526005,527001,527002,527003,527004,527005,527006,527007,527008,527009,527010,527011,527012,527013,527014,527015,527016,527017,527018,527019,527020,527021,527022,527023,527024,527025,527026,527027,527028,527029,527030,527031,527032,527033,527034,527035,527036,527037,527038,527039,527040,527041,527042,527043,527044,527045,527046,527047,527048,527049,527050,527051,527052,527053,527054,527055,528001,528002,528003,529001,529002,530001,530002,530003,530004,530005,530006,530007,530008,530009,530010,530011,530012,530013,530014,531001,531002,531003,531004,531005,531006,532001,532002,532003,532004,532005,532006,532007,532008,532009,533001,533002,533003,533004,534001,534002,534003,535001,536001,536002,536003,536004,536005,536006,536007,537001,538001,539001,539002,539003,539004,539005,539006,539007,539008,539009,539010,539011,539012,539013,900000,909999,999991,999992,999993,999994,999995,999996,999998,999999,ACC_HLTH,ALLOCATION,ALLOCATION_PC,ALLOC_IAC_ULACUI,ALLOC_IAC_ULMAINT,ALLOC_IAD,ALLOC_IAD_MNLACQUI,ALLOC_IAD_MNLMAINT,ALLOC_IAD_NAACQUI,ALLOC_IAD_NAMAINT,ALLOC_ILU_ACQUI,ALLOC_ILU_MAINT,ALLOC_INVEST_EXPEN,ALLOC_MNLVA_ACQUI,ALLOC_MNLVA_MAINT,ALLOC_MNL_EXPEN,ALLOC_MNL_UL,ALLOC_MNL_ULACUI,ALLOC_MNL_ULMAINT,ALLOC_NAC_EXPEN,ALLOC_NA_EXPEN,ALLOC_NA_ULACUI,ALLOC_NA_ULMAINT,ALLOC_OLDANN,ALLOC_OLDAN_MAINT,ALLOC_PRODUCT,ALLOC_SFN_LE,ALLOC_SRSMF_ACQUI,ALLOC_SRSMF_MAINT,ALLOC_SRS_LE,ALLOC_SSC,ALLOC_TRAD_ACQUI,ALLOC_TRAD_MAINT,ALLOC_UL,ALLOC_UL_ACQUI,ALLOC_UL_MAINT,ALLOC_VUL_ACQUI,ALLOC_VUL_MAINT,ANN,ANNUITY,ANN_CLR_EXP,ANN_CLR_NII,ANN_CLR_TAX,ANN_MNL_EXP,ANN_MNL_NII,ANN_MNL_TAX,AUX_IDX,AUX_IDX2,BOLI_COLI_EXP,BOLI_COLI_NII,BOLI_COLI_TAX,BOLI_SA_EXP,BOLI_SA_NII,BOLI_SA_TAX,DUMMY,GIC_EXP,GIC_NII,GIC_TAX,GRP_A_H,GRP_IDX,GRP_IMM,GRP_IUL,GRP_ORDTRM,GRP_SUP,HU01-DUMMY,IDX_UL_EXP,IDX_UL_NII,IDX_UL_TAX,IMMEDIATE,INDEX,IND_A_H,IND_IDX,IND_IMM,IND_IUL,IND_ORDTRM,IND_SUP,INT_SENS_L_EXP,INT_SENS_L_NII,INT_SENS_L_TAX,INX_ANN_EXP,INX_ANN_L_EXP,INX_ANN_L_NII,INX_ANN_L_TAX,INX_ANN_NII,INX_ANN_TAX,ISL,IUL,LIFE,NODE1,NODE2,NOPROFITCT,NOPROFITCTR,OLD_ANN,OLD_ANN_EXP,ORD_TERM,RECO-DUMMY,SPIA_ANN_EXP,SPIA_ANN_NII,SPIA_ANN_TAX,SPIA_LIFE_EXP,SPIA_LIFE_NII,SPIA_LIFE_TAX,SUBNODE1,SUBNODE2,SUPP_CNTRT,TRD_ANN_EXP,TRD_ANN_NII,TRD_ANN_TAX,TRM_ORD_L_EXP,TRM_ORD_L_NII,TRM_ORD_L_TAX,UL,UNV_LIFE_EXP,UNV_LIFE_NII,UNV_LIFE_TAX,VAN,VAR_ANN_EXP,VAR_ANN_L_EXP,VAR_ANN_L_NII,VAR_ANN_L_TAX,VAR_ANN_NII,VAR_ANN_TAX,VAR_UL_EXP,VAR_UL_NII,VAR_UL_TAX,VUL

*XDIM_MEMBERSET COMPANYCODE = 7500

*XDIM_MEMBERSET CATEGORY = ACTUAL

*XDIM_MEMBERSET TIME = 2014.TOTAL

*XDIM_MEMBERSET FLOW = Balance

*XDIM_MEMBERSET TRADINGPARTNER = BAS(TTLINTERCONON)

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ACCOUNT = 471000

*WHEN CATEGORY

*IS ACTUAL

*REC(FACTOR=-1, ACCOUNT=592000,COMPANYCODE=CC_SFGELIM,AUDITTRAIL=EquityAdj)

*REC(FACTOR=1, ACCOUNT=662100,COMPANYCODE=CC_SFGELIM,AUDITTRAIL=EquityAdj)

*endwhen

*COMMIT

*XDIM_MEMBERSET PROFITCENTER=00000000000000000000000010001000,0000111010,0000111016,0000111017,0000111018,0000111019,0000111020,0000111030,0000111040,0000111050,0000111070,0000116020,0000121010,0000126010,0000131010,0000131016,0000131017,0000131018,0000131019,0000131020,0000131030,0000131040,0000141010,0000141030,0000161010,0000181010,0000181016,0000181017,0000181018,0000181019,0000181030,0000181040,0000181050,0000181060,0000181070,0000181080,0000181086,0000181087,0000181088,0000181089,0000181090,0000181096,0000181097,0000181098,0000181099,0000181110,0000186010,0000186017,0000186030,0000186040,0000186060,0000211010,0000211020,0000216010,0000221010,0000221016,0000221017,0000221018,0000221019,0000221020,0000221030,0000221040,0000221050,0000221060,0000221070,0000221080,0000226010,0000226030,0000226040,0000226050,0000226060,0000231010,0000231017,0000231018,0000231019,0000231020,0000231030,0000231040,0000231050,0000236010,0000236020,0000236030,0000236050,0000241010,0000241020,0000241030,0000241040,0000241060,0000246010,0000246020,0000301010,0000301017,0000301020,0000306010,0000306020,0000306030,0000401010,0000401020,0000401030,0000401050,0000401060,0000406010,0000406020,0000501001,0000501002,0000501003,0000501004,0000502001,0000502002,0000502003,0000502004,0000502005,0000502006,0000502007,0000502008,0000502009,0000502010,0000502011,0000502012,0000502013,0000502014,0000502015,0000502016,0000502017,0000502018,0000503001,0000503002,0000503003,0000503004,0000503005,0000503006,0000504001,0000504002,0000504003,0000504004,0000505001,0000506001,0000506002,0000506003,0000507001,0000507002,0000507003,0000507004,0000507005,0000507006,0000508001,0000508002,0000509001,0000509002,0000509003,0000509004,0000509005,0000509006,0000509007,0000509008,0000509009,0000509010,0000509011,0000509012,0000509013,0000509014,0000509015,0000509016,0000509017,0000509018,0000509019,0000509020,0000509021,0000509022,0000509023,0000509024,0000509025,0000509026,0000509027,0000509028,0000509029,0000509030,0000509031,0000509032,0000509033,0000509034,0000509035,0000509036,0000509037,0000509038,0000509039,0000509040,0000509041,0000509042,0000509043,0000509044,0000509045,0000509046,0000509047,0000510001,0000510002,0000510003,0000510004,0000510005,0000510006,0000510007,0000510008,0000511001,0000511002,0000511003,0000511004,0000511005,0000511006,0000511007,0000511008,0000511009,0000512001,0000512002,0000512003,0000512004,0000512005,0000513001,0000513002,0000513003,0000513004,0000513005,0000513006,0000514001,0000514002,0000514003,0000514004,0000514005,0000514006,0000514007,0000514008,0000514009,0000514010,0000514011,0000514012,0000514013,0000515001,0000515002,0000515003,0000515004,0000515005,0000515006,0000515007,0000515008,0000515009,0000515010,0000515011,0000515012,0000515013,0000515014,0000516001,0000516002,0000516003,0000516004,0000516005,0000516006,0000516007,0000516008,0000517001,0000517002,0000518001,0000518002,0000519001,0000519002,0000519003,0000519004,0000519005,0000520001,0000520002,0000520003,0000520004,0000520005,0000520006,0000520007,0000520008,0000520009,0000520010,0000521001,0000521002,0000521003,0000521004,0000521005,0000521006,0000521007,0000521008,0000521009,0000521010,0000521011,0000521012,0000521013,0000521014,0000521015,0000521016,0000521017,0000522001,0000522002,0000522003,0000522004,0000523001,0000523002,0000523003,0000523004,0000524001,0000525001,0000525002,0000525003,0000525004,0000525005,0000525006,0000525007,0000525008,0000525009,0000525010,0000525011,0000525012,0000525013,0000525014,0000525015,0000525016,0000525017,0000525018,0000525019,0000525020,0000525021,0000525022,0000525023,0000526001,0000526002,0000526003,0000526004,0000526005,0000527001,0000527002,0000527003,0000527004,0000527005,0000527006,0000527007,0000527008,0000527009,0000527010,0000527011,0000527012,0000527013,0000527014,0000527015,0000527016,0000527017,0000527018,0000527019,0000527020,0000527021,0000527022,0000527023,0000527024,0000527025,0000527026,0000527027,0000527028,0000527029,0000527030,0000527031,0000527032,0000527033,0000527034,0000527035,0000527036,0000527037,0000527038,0000527039,0000527040,0000527041,0000527042,0000527043,0000527044,0000527045,0000527046,0000527047,0000527048,0000527049,0000527050,0000527051,0000527052,0000527053,0000527054,0000527055,0000528001,0000528002,0000528003,0000529001,0000529002,0000530001,0000530002,0000530003,0000530004,0000530005,0000530006,0000530007,0000530008,0000530009,0000530010,0000530011,0000530012,0000530013,0000530014,0000531001,0000531002,0000531003,0000531004,0000531005,0000531006,0000532001,0000532002,0000532003,0000532004,0000532005,0000532006,0000532007,0000532008,0000532009,0000533001,0000533002,0000533003,0000533004,0000534001,0000534002,0000900000,0000909999,0000999991,0000999992,0000999993,0000999994,0000999999,111010,111016,111017,111018,111019,111020,111030,111040,111050,111060,111070,116020,121010,126010,131010,131016,131017,131018,131019,131020,131030,131040,141010,141020,141030,141040,146010,151010,161010,161016,161017,161018,161019,161020,161030,161040,161050,161060,161070,162010,162017,162020,162030,162040,162050,162060,171010,171016,171017,171018,171019,171020,171030,171040,181010,181012,181014,181016,181017,181018,181019,181020,181030,181040,181050,181060,181070,181080,181086,181087,181088,181089,181090,181096,181097,181098,181099,181100,181110,186010,186017,186020,186030,186040,186050,186060,186080,211010,211016,211017,211018,211019,211020,211030,211040,211050,211060,211070,211080,212010,212020,212030,216010,216030,221010,221016,221017,221018,221019,221020,221030,221040,221050,221060,221070,221080,222010,226010,226020,226030,226040,226050,226060,226090,231010,231017,231018,231019,231020,231030,231040,231050,232010,236010,236020,236030,236050,241010,241020,241030,241040,241050,241060,241070,242010,242020,242030,246010,246020,246030,301010,301017,301020,302010,306010,306020,306030,401010,401020,401030,401040,401050,401060,406010,406020,411010,411017,411018,411019,411020,411030,411040,411050,412010,412020,421010,421020,421030,421040,421050,431010,431020,432010,451010,501001,501002,501003,501004,502001,502002,502003,502004,502005,502006,502007,502008,502009,502010,502011,502012,502013,502014,502015,502016,502017,502018,503001,503002,503003,503004,503005,503006,503007,503008,503009,503010,504001,504002,504003,504004,504005,505001,506001,506002,506003,507001,507002,507003,507004,507005,507006,508001,508002,509001,509002,509003,509004,509005,509006,509007,509008,509009,509010,509011,509012,509013,509014,509015,509016,509017,509018,509019,509020,509021,509022,509023,509024,509025,509026,509027,509028,509029,509030,509031,509032,509033,509034,509035,509036,509037,509038,509039,509040,509041,509042,509043,509044,509045,509046,509047,510001,510002,510003,510004,510005,510006,510007,510008,511001,511002,511003,511004,511005,511006,511007,511008,511009,512001,512002,512003,512004,512005,513001,513002,513003,513004,513005,513006,514001,514002,514003,514004,514005,514006,514007,514008,514009,514010,514011,514012,514013,515001,515002,515003,515004,515005,515006,515007,515008,515009,515010,515011,515012,515013,515014,516001,516002,516003,516004,516005,516006,516007,516008,517001,517002,518001,518002,519001,519002,519003,519004,519005,520001,520002,520003,520004,520005,520006,520007,520008,520009,520010,521001,521002,521003,521004,521005,521006,521007,521008,521009,521010,521011,521012,521013,521014,521015,521016,521017,522001,522002,522003,522004,522005,523001,523002,523003,523004,524001,525001,525002,525003,525004,525005,525006,525007,525008,525009,525010,525011,525012,525013,525014,525015,525016,525017,525018,525019,525020,525021,525022,525023,526001,526002,526003,526004,526005,527001,527002,527003,527004,527005,527006,527007,527008,527009,527010,527011,527012,527013,527014,527015,527016,527017,527018,527019,527020,527021,527022,527023,527024,527025,527026,527027,527028,527029,527030,527031,527032,527033,527034,527035,527036,527037,527038,527039,527040,527041,527042,527043,527044,527045,527046,527047,527048,527049,527050,527051,527052,527053,527054,527055,528001,528002,528003,529001,529002,530001,530002,530003,530004,530005,530006,530007,530008,530009,530010,530011,530012,530013,530014,531001,531002,531003,531004,531005,531006,532001,532002,532003,532004,532005,532006,532007,532008,532009,533001,533002,533003,533004,534001,534002,534003,535001,536001,536002,536003,536004,536005,536006,536007,537001,538001,539001,539002,539003,539004,539005,539006,539007,539008,539009,539010,539011,539012,539013,900000,909999,999991,999992,999993,999994,999995,999996,999998,999999,ACC_HLTH,ALLOCATION,ALLOCATION_PC,ALLOC_IAC_ULACUI,ALLOC_IAC_ULMAINT,ALLOC_IAD,ALLOC_IAD_MNLACQUI,ALLOC_IAD_MNLMAINT,ALLOC_IAD_NAACQUI,ALLOC_IAD_NAMAINT,ALLOC_ILU_ACQUI,ALLOC_ILU_MAINT,ALLOC_INVEST_EXPEN,ALLOC_MNLVA_ACQUI,ALLOC_MNLVA_MAINT,ALLOC_MNL_EXPEN,ALLOC_MNL_UL,ALLOC_MNL_ULACUI,ALLOC_MNL_ULMAINT,ALLOC_NAC_EXPEN,ALLOC_NA_EXPEN,ALLOC_NA_ULACUI,ALLOC_NA_ULMAINT,ALLOC_OLDANN,ALLOC_OLDAN_MAINT,ALLOC_PRODUCT,ALLOC_SFN_LE,ALLOC_SRSMF_ACQUI,ALLOC_SRSMF_MAINT,ALLOC_SRS_LE,ALLOC_SSC,ALLOC_TRAD_ACQUI,ALLOC_TRAD_MAINT,ALLOC_UL,ALLOC_UL_ACQUI,ALLOC_UL_MAINT,ALLOC_VUL_ACQUI,ALLOC_VUL_MAINT,ANN,ANNUITY,ANN_CLR_EXP,ANN_CLR_NII,ANN_CLR_TAX,ANN_MNL_EXP,ANN_MNL_NII,ANN_MNL_TAX,AUX_IDX,AUX_IDX2,BOLI_COLI_EXP,BOLI_COLI_NII,BOLI_COLI_TAX,BOLI_SA_EXP,BOLI_SA_NII,BOLI_SA_TAX,DUMMY,GIC_EXP,GIC_NII,GIC_TAX,GRP_A_H,GRP_IDX,GRP_IMM,GRP_IUL,GRP_ORDTRM,GRP_SUP,HU01-DUMMY,IDX_UL_EXP,IDX_UL_NII,IDX_UL_TAX,IMMEDIATE,INDEX,IND_A_H,IND_IDX,IND_IMM,IND_IUL,IND_ORDTRM,IND_SUP,INT_SENS_L_EXP,INT_SENS_L_NII,INT_SENS_L_TAX,INX_ANN_EXP,INX_ANN_L_EXP,INX_ANN_L_NII,INX_ANN_L_TAX,INX_ANN_NII,INX_ANN_TAX,ISL,IUL,LIFE,NODE1,NODE2,NOPROFITCT,NOPROFITCTR,OLD_ANN,OLD_ANN_EXP,ORD_TERM,RECO-DUMMY,SPIA_ANN_EXP,SPIA_ANN_NII,SPIA_ANN_TAX,SPIA_LIFE_EXP,SPIA_LIFE_NII,SPIA_LIFE_TAX,SUBNODE1,SUBNODE2,SUPP_CNTRT,TRD_ANN_EXP,TRD_ANN_NII,TRD_ANN_TAX,TRM_ORD_L_EXP,TRM_ORD_L_NII,TRM_ORD_L_TAX,UL,UNV_LIFE_EXP,UNV_LIFE_NII,UNV_LIFE_TAX,VAN,VAR_ANN_EXP,VAR_ANN_L_EXP,VAR_ANN_L_NII,VAR_ANN_L_TAX,VAR_ANN_NII,VAR_ANN_TAX,VAR_UL_EXP,VAR_UL_NII,VAR_UL_TAX,VUL

*XDIM_MEMBERSET COMPANYCODE = 7100

*XDIM_MEMBERSET CATEGORY = ACTUAL

*XDIM_MEMBERSET TIME = 2014.TOTAL

*XDIM_MEMBERSET FLOW = Balance

*XDIM_MEMBERSET TRADINGPARTNER = BAS(TTLINTERCONON)

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ACCOUNT = 592019,592020,592021

*WHEN CATEGORY

*IS ACTUAL

*REC(FACTOR=-1, ACCOUNT=592000, COMPANYCODE=CC_SFGELIM,AUDITTRAIL=EquityAdj)

*REC(FACTOR=1, ACCOUNT=662100, COMPANYCODE=CC_SFGELIM,AUDITTRAIL=EquityAdj)

*endwhen

*COMMIT

*XDIM_MEMBERSET PROFITCENTER=00000000000000000000000010001000,0000111010,0000111016,0000111017,0000111018,0000111019,0000111020,0000111030,0000111040,0000111050,0000111070,0000116020,0000121010,0000126010,0000131010,0000131016,0000131017,0000131018,0000131019,0000131020,0000131030,0000131040,0000141010,0000141030,0000161010,0000181010,0000181016,0000181017,0000181018,0000181019,0000181030,0000181040,0000181050,0000181060,0000181070,0000181080,0000181086,0000181087,0000181088,0000181089,0000181090,0000181096,0000181097,0000181098,0000181099,0000181110,0000186010,0000186017,0000186030,0000186040,0000186060,0000211010,0000211020,0000216010,0000221010,0000221016,0000221017,0000221018,0000221019,0000221020,0000221030,0000221040,0000221050,0000221060,0000221070,0000221080,0000226010,0000226030,0000226040,0000226050,0000226060,0000231010,0000231017,0000231018,0000231019,0000231020,0000231030,0000231040,0000231050,0000236010,0000236020,0000236030,0000236050,0000241010,0000241020,0000241030,0000241040,0000241060,0000246010,0000246020,0000301010,0000301017,0000301020,0000306010,0000306020,0000306030,0000401010,0000401020,0000401030,0000401050,0000401060,0000406010,0000406020,0000501001,0000501002,0000501003,0000501004,0000502001,0000502002,0000502003,0000502004,0000502005,0000502006,0000502007,0000502008,0000502009,0000502010,0000502011,0000502012,0000502013,0000502014,0000502015,0000502016,0000502017,0000502018,0000503001,0000503002,0000503003,0000503004,0000503005,0000503006,0000504001,0000504002,0000504003,0000504004,0000505001,0000506001,0000506002,0000506003,0000507001,0000507002,0000507003,0000507004,0000507005,0000507006,0000508001,0000508002,0000509001,0000509002,0000509003,0000509004,0000509005,0000509006,0000509007,0000509008,0000509009,0000509010,0000509011,0000509012,0000509013,0000509014,0000509015,0000509016,0000509017,0000509018,0000509019,0000509020,0000509021,0000509022,0000509023,0000509024,0000509025,0000509026,0000509027,0000509028,0000509029,0000509030,0000509031,0000509032,0000509033,0000509034,0000509035,0000509036,0000509037,0000509038,0000509039,0000509040,0000509041,0000509042,0000509043,0000509044,0000509045,0000509046,0000509047,0000510001,0000510002,0000510003,0000510004,0000510005,0000510006,0000510007,0000510008,0000511001,0000511002,0000511003,0000511004,0000511005,0000511006,0000511007,0000511008,0000511009,0000512001,0000512002,0000512003,0000512004,0000512005,0000513001,0000513002,0000513003,0000513004,0000513005,0000513006,0000514001,0000514002,0000514003,0000514004,0000514005,0000514006,0000514007,0000514008,0000514009,0000514010,0000514011,0000514012,0000514013,0000515001,0000515002,0000515003,0000515004,0000515005,0000515006,0000515007,0000515008,0000515009,0000515010,0000515011,0000515012,0000515013,0000515014,0000516001,0000516002,0000516003,0000516004,0000516005,0000516006,0000516007,0000516008,0000517001,0000517002,0000518001,0000518002,0000519001,0000519002,0000519003,0000519004,0000519005,0000520001,0000520002,0000520003,0000520004,0000520005,0000520006,0000520007,0000520008,0000520009,0000520010,0000521001,0000521002,0000521003,0000521004,0000521005,0000521006,0000521007,0000521008,0000521009,0000521010,0000521011,0000521012,0000521013,0000521014,0000521015,0000521016,0000521017,0000522001,0000522002,0000522003,0000522004,0000523001,0000523002,0000523003,0000523004,0000524001,0000525001,0000525002,0000525003,0000525004,0000525005,0000525006,0000525007,0000525008,0000525009,0000525010,0000525011,0000525012,0000525013,0000525014,0000525015,0000525016,0000525017,0000525018,0000525019,0000525020,0000525021,0000525022,0000525023,0000526001,0000526002,0000526003,0000526004,0000526005,0000527001,0000527002,0000527003,0000527004,0000527005,0000527006,0000527007,0000527008,0000527009,0000527010,0000527011,0000527012,0000527013,0000527014,0000527015,0000527016,0000527017,0000527018,0000527019,0000527020,0000527021,0000527022,0000527023,0000527024,0000527025,0000527026,0000527027,0000527028,0000527029,0000527030,0000527031,0000527032,0000527033,0000527034,0000527035,0000527036,0000527037,0000527038,0000527039,0000527040,0000527041,0000527042,0000527043,0000527044,0000527045,0000527046,0000527047,0000527048,0000527049,0000527050,0000527051,0000527052,0000527053,0000527054,0000527055,0000528001,0000528002,0000528003,0000529001,0000529002,0000530001,0000530002,0000530003,0000530004,0000530005,0000530006,0000530007,0000530008,0000530009,0000530010,0000530011,0000530012,0000530013,0000530014,0000531001,0000531002,0000531003,0000531004,0000531005,0000531006,0000532001,0000532002,0000532003,0000532004,0000532005,0000532006,0000532007,0000532008,0000532009,0000533001,0000533002,0000533003,0000533004,0000534001,0000534002,0000900000,0000909999,0000999991,0000999992,0000999993,0000999994,0000999999,111010,111016,111017,111018,111019,111020,111030,111040,111050,111060,111070,116020,121010,126010,131010,131016,131017,131018,131019,131020,131030,131040,141010,141020,141030,141040,146010,151010,161010,161016,161017,161018,161019,161020,161030,161040,161050,161060,161070,162010,162017,162020,162030,162040,162050,162060,171010,171016,171017,171018,171019,171020,171030,171040,181010,181012,181014,181016,181017,181018,181019,181020,181030,181040,181050,181060,181070,181080,181086,181087,181088,181089,181090,181096,181097,181098,181099,181100,181110,186010,186017,186020,186030,186040,186050,186060,186080,211010,211016,211017,211018,211019,211020,211030,211040,211050,211060,211070,211080,212010,212020,212030,216010,216030,221010,221016,221017,221018,221019,221020,221030,221040,221050,221060,221070,221080,222010,226010,226020,226030,226040,226050,226060,226090,231010,231017,231018,231019,231020,231030,231040,231050,232010,236010,236020,236030,236050,241010,241020,241030,241040,241050,241060,241070,242010,242020,242030,246010,246020,246030,301010,301017,301020,302010,306010,306020,306030,401010,401020,401030,401040,401050,401060,406010,406020,411010,411017,411018,411019,411020,411030,411040,411050,412010,412020,421010,421020,421030,421040,421050,431010,431020,432010,451010,501001,501002,501003,501004,502001,502002,502003,502004,502005,502006,502007,502008,502009,502010,502011,502012,502013,502014,502015,502016,502017,502018,503001,503002,503003,503004,503005,503006,503007,503008,503009,503010,504001,504002,504003,504004,504005,505001,506001,506002,506003,507001,507002,507003,507004,507005,507006,508001,508002,509001,509002,509003,509004,509005,509006,509007,509008,509009,509010,509011,509012,509013,509014,509015,509016,509017,509018,509019,509020,509021,509022,509023,509024,509025,509026,509027,509028,509029,509030,509031,509032,509033,509034,509035,509036,509037,509038,509039,509040,509041,509042,509043,509044,509045,509046,509047,510001,510002,510003,510004,510005,510006,510007,510008,511001,511002,511003,511004,511005,511006,511007,511008,511009,512001,512002,512003,512004,512005,513001,513002,513003,513004,513005,513006,514001,514002,514003,514004,514005,514006,514007,514008,514009,514010,514011,514012,514013,515001,515002,515003,515004,515005,515006,515007,515008,515009,515010,515011,515012,515013,515014,516001,516002,516003,516004,516005,516006,516007,516008,517001,517002,518001,518002,519001,519002,519003,519004,519005,520001,520002,520003,520004,520005,520006,520007,520008,520009,520010,521001,521002,521003,521004,521005,521006,521007,521008,521009,521010,521011,521012,521013,521014,521015,521016,521017,522001,522002,522003,522004,522005,523001,523002,523003,523004,524001,525001,525002,525003,525004,525005,525006,525007,525008,525009,525010,525011,525012,525013,525014,525015,525016,525017,525018,525019,525020,525021,525022,525023,526001,526002,526003,526004,526005,527001,527002,527003,527004,527005,527006,527007,527008,527009,527010,527011,527012,527013,527014,527015,527016,527017,527018,527019,527020,527021,527022,527023,527024,527025,527026,527027,527028,527029,527030,527031,527032,527033,527034,527035,527036,527037,527038,527039,527040,527041,527042,527043,527044,527045,527046,527047,527048,527049,527050,527051,527052,527053,527054,527055,528001,528002,528003,529001,529002,530001,530002,530003,530004,530005,530006,530007,530008,530009,530010,530011,530012,530013,530014,531001,531002,531003,531004,531005,531006,532001,532002,532003,532004,532005,532006,532007,532008,532009,533001,533002,533003,533004,534001,534002,534003,535001,536001,536002,536003,536004,536005,536006,536007,537001,538001,539001,539002,539003,539004,539005,539006,539007,539008,539009,539010,539011,539012,539013,900000,909999,999991,999992,999993,999994,999995,999996,999998,999999,ACC_HLTH,ALLOCATION,ALLOCATION_PC,ALLOC_IAC_ULACUI,ALLOC_IAC_ULMAINT,ALLOC_IAD,ALLOC_IAD_MNLACQUI,ALLOC_IAD_MNLMAINT,ALLOC_IAD_NAACQUI,ALLOC_IAD_NAMAINT,ALLOC_ILU_ACQUI,ALLOC_ILU_MAINT,ALLOC_INVEST_EXPEN,ALLOC_MNLVA_ACQUI,ALLOC_MNLVA_MAINT,ALLOC_MNL_EXPEN,ALLOC_MNL_UL,ALLOC_MNL_ULACUI,ALLOC_MNL_ULMAINT,ALLOC_NAC_EXPEN,ALLOC_NA_EXPEN,ALLOC_NA_ULACUI,ALLOC_NA_ULMAINT,ALLOC_OLDANN,ALLOC_OLDAN_MAINT,ALLOC_PRODUCT,ALLOC_SFN_LE,ALLOC_SRSMF_ACQUI,ALLOC_SRSMF_MAINT,ALLOC_SRS_LE,ALLOC_SSC,ALLOC_TRAD_ACQUI,ALLOC_TRAD_MAINT,ALLOC_UL,ALLOC_UL_ACQUI,ALLOC_UL_MAINT,ALLOC_VUL_ACQUI,ALLOC_VUL_MAINT,ANN,ANNUITY,ANN_CLR_EXP,ANN_CLR_NII,ANN_CLR_TAX,ANN_MNL_EXP,ANN_MNL_NII,ANN_MNL_TAX,AUX_IDX,AUX_IDX2,BOLI_COLI_EXP,BOLI_COLI_NII,BOLI_COLI_TAX,BOLI_SA_EXP,BOLI_SA_NII,BOLI_SA_TAX,DUMMY,GIC_EXP,GIC_NII,GIC_TAX,GRP_A_H,GRP_IDX,GRP_IMM,GRP_IUL,GRP_ORDTRM,GRP_SUP,HU01-DUMMY,IDX_UL_EXP,IDX_UL_NII,IDX_UL_TAX,IMMEDIATE,INDEX,IND_A_H,IND_IDX,IND_IMM,IND_IUL,IND_ORDTRM,IND_SUP,INT_SENS_L_EXP,INT_SENS_L_NII,INT_SENS_L_TAX,INX_ANN_EXP,INX_ANN_L_EXP,INX_ANN_L_NII,INX_ANN_L_TAX,INX_ANN_NII,INX_ANN_TAX,ISL,IUL,LIFE,NODE1,NODE2,NOPROFITCT,NOPROFITCTR,OLD_ANN,OLD_ANN_EXP,ORD_TERM,RECO-DUMMY,SPIA_ANN_EXP,SPIA_ANN_NII,SPIA_ANN_TAX,SPIA_LIFE_EXP,SPIA_LIFE_NII,SPIA_LIFE_TAX,SUBNODE1,SUBNODE2,SUPP_CNTRT,TRD_ANN_EXP,TRD_ANN_NII,TRD_ANN_TAX,TRM_ORD_L_EXP,TRM_ORD_L_NII,TRM_ORD_L_TAX,UL,UNV_LIFE_EXP,UNV_LIFE_NII,UNV_LIFE_TAX,VAN,VAR_ANN_EXP,VAR_ANN_L_EXP,VAR_ANN_L_NII,VAR_ANN_L_TAX,VAR_ANN_NII,VAR_ANN_TAX,VAR_UL_EXP,VAR_UL_NII,VAR_UL_TAX,VUL

*XDIM_MEMBERSET COMPANYCODE = 7200

*XDIM_MEMBERSET CATEGORY = ACTUAL

*XDIM_MEMBERSET TIME = 2014.TOTAL

*XDIM_MEMBERSET FLOW = Balance

*XDIM_MEMBERSET TRADINGPARTNER = BAS(TTLINTERCONON)

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ACCOUNT = 592023

*WHEN CATEGORY

*IS ACTUAL

*REC(FACTOR=-1, ACCOUNT=592000, COMPANYCODE=CC_SFGELIM,AUDITTRAIL=EquityAdj)

*REC(FACTOR=1, ACCOUNT=662100, COMPANYCODE=CC_SFGELIM,AUDITTRAIL=EquityAdj)

*endwhen

*COMMIT

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

LOG:

LOG BEGIN TIME:2015-01-07 10:39:03

FILE:\ROOT\WEBFOLDERS\SFG_PRD \ADMINAPP\CONSOL\TEST.LGF

USER:NJM3546

APPSET:SFG_PRD

APPLICATION:CONSOL

[INFO] GET_DIM_LIST(): I_APPL_ID="CONSOL", #dimensions=10

ACCOUNT,AUDITTRAIL,CATEGORY,COMPANYCODE,FLOW,MEASURES,PROFITCENTER,RPTCURRENCY,TIME,TRADINGPARTNER

#dim_memberset=9

PROFITCENTER:00000000000000000000000010001000,0000111010,0000111016,0000111017,0000111018,...1104 in total.

COMPANYCODE:7500,1 in total.

CATEGORY:ACTUAL,1 in total.

TIME:2014.TOTAL,1 in total.

FLOW:Balance,1 in total.

TRADINGPARTNER:111010,DUMMY,I_1000,I_1200,I_1300,...22 in total.

AUDITTRAIL:ALLOCATIONS,ALLOCS_DIRECT,ALLOCS_MANUAL,AV_RFWD,CADMIN,...22 in total.

RPTCURRENCY:USD,1 in total.

ACCOUNT:471000,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="CONSOL", #dimensions=10

ACCOUNT,AUDITTRAIL,CATEGORY,COMPANYCODE,FLOW,MEASURES,PROFITCENTER,RPTCURRENCY,TIME,TRADINGPARTNER

#dim_memberset=9

PROFITCENTER:00000000000000000000000010001000,0000111010,0000111016,0000111017,0000111018,...1104 in total.

COMPANYCODE:7100,1 in total.

CATEGORY:ACTUAL,1 in total.

TIME:2014.TOTAL,1 in total.

FLOW:Balance,1 in total.

TRADINGPARTNER:111010,DUMMY,I_1000,I_1200,I_1300,...22 in total.

AUDITTRAIL:ALLOCATIONS,ALLOCS_DIRECT,ALLOCS_MANUAL,AV_RFWD,CADMIN,...22 in total.

RPTCURRENCY:USD,1 in total.

ACCOUNT:592019,592020,592021,3 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="CONSOL", #dimensions=10

ACCOUNT,AUDITTRAIL,CATEGORY,COMPANYCODE,FLOW,MEASURES,PROFITCENTER,RPTCURRENCY,TIME,TRADINGPARTNER

#dim_memberset=9

PROFITCENTER:00000000000000000000000010001000,0000111010,0000111016,0000111017,0000111018,...1104 in total.

COMPANYCODE:7200,1 in total.

CATEGORY:ACTUAL,1 in total.

TIME:2014.TOTAL,1 in total.

[Former Member · Accepted solution]

Just noticed your last post, I will give your suggestion a try and report back.

[former_member186338 · Accepted solution]

I have already explained and proposed some code in my last post. Test it.

"The scripts were written by the consultants" - unfortunately not all consultants are equal

Vadim

[former_member186338 · Accepted solution]

P.S. To get a meaningful log - use Execute (not simulate!) in UJKT

Vadim

[Former Member · Accepted solution]

Your suggestion worked perfect.  I am very grateful for your efforts.

Nick