on 05-28-2015 1:55 PM
Hi guys,
This is probably a really easy one to solve, but I've been looking at this (along with several other things) for so long that I'm getting myself muddled up.
Basically, I have a script that pushes a whole load of data from Fixed Assets model into the Consolidation model.
My starting point was existing script in 7.5 MS version, but obviously amended for the short-comings of NW...
What I ended up with was this (I've removed all the sections that I'm not concentrating on right now, to save space:
*SELECT(%FAACCTS%,ID,ACCOUNTFA,SENDTOCONSOL = 'Y')
*SELECT(%INTGEN%,ID,ACCOUNTFA,INT_GEN = 'Y')
//For testing purposes
*FUNCTION INTERNALLY_GENERATED = %INTGEN%
*FUNCTION DESTAUDID = INPUTMANUAL
*FUNCTION DESTCAT = ACTUAL
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET FLOW = F_ADD,F_RC,F_RD,F_IFRS,FC_TRANSFERS,F_ADDC
*XDIM_MEMBERSET RPTCURRENCY = LC
*XDIM_MEMBERSET VALUETYPE = FABV
*XDIM_MEMBERSET ACCOUNTFA = %FAACCTS%
*XDIM_MEMBERSET AUDITIDFA = BAS(TOTAL_FA)
*XDIM_MEMBERSET LEGALENTITY = LE140
*DESTINATION_APP = Consolidation
*SKIP_DIM = ASSETREASON,VALUETYPE,COSTTYPE
*ADD_DIM GROUPS = G_NONE
*RENAME_DIM ACCOUNTFA = ACCOUNTC
*RENAME_DIM AUDITIDFA = AUDITIDC
*WHEN COSTTYPE
*IS COST
*WHEN INTERCO
*IS <> NON_INTERCO
*WHEN FLOW
*IS FC_TRANSFERS
///Not relevant here
*IS F_ADDC
//Not relevant here
*ELSE
//Not relevant here
*ENDWHEN
*IS NON_INTERCO
*WHEN FLOW
*IS FC_TRANSFERS
//Not relevant here
*IS F_ADDC
//Not relevant here
*ELSE
*WHEN ACCOUNTFA
*IS INTERNALLY_GENERATED
//Not relevant here
*ELSE
*REC(FACTOR = 1,ACCOUNTFA = ACCOUNTFA.BS_COST_ACCOUNT,FLOW = "F_GADD",AUDITIDFA = DESTAUDID,CATEGORY = DESTCAT)
*ENDWHEN
//Not relevant here
*ENDWHEN
*ENDWHEN
*ENDWHEN
But my end result in Consolidation is double the value that is sent over. I've looked at this several different ways, and I can't figure out why this is.
My UKJT log shows the following:
LOG:
LOG BEGIN TIME:2015-05-28 14:29:10
FILE:\ROOT\WEBFOLDERS\<Environment> \ADMINAPP\FixedAssets\TEST.LGF
APPSET:<Environment>
APPLICATION:FixedAssets
[INFO] GET_DIM_LIST(): I_APPL_ID="FixedAssets", #dimensions=12
ACCOUNTFA,ASSETREASON,AUDITIDFA,CATEGORY,COSTTYPE,FLOW,INTERCO,LEGALENTITY,MEASURES,RPTCURRENCY,TIME,VALUETYPE
#dim_memberset=8
CATEGORY:ACTUAL,1 in total.
TIME:2014.014,1 in total.
FLOW:FC_TRANSFERS,F_ADD,F_ADDC,F_IFRS,F_RC,...6 in total.
RPTCURRENCY:LC,1 in total.
VALUETYPE:FABV,1 in total.
ACCOUNTFA:20000,20170,22001,22002,22005,...211 in total.
AUDITIDFA:FA_ADJ,FA_AUTO_LOAD,FA_INPUT,FA_JRNL,4 in total.
LEGALENTITY:LE140,1 in total.
REC :%value%*(1)
CALCULATION BEGIN:
QUERY PROCESSING DATA
QUERY TIME : 0.00 ms. 102 RECORDS QUERIED OUT.
QUERY REFERENCE DATA
CALCULATION TIME IN TOTAL :0.00 ms.
45 RECORDS ARE GENERATED.
CALCULATION END.
ENDWHEN ACCUMULATION: 2 RECORDS ARE GENERATED.
DATA TO WRITE BACK:
ACCOUNTC AUDITIDC CATEGORY FLOW GROUPS INTERCO LEGALENTITY RPTCURRENCY TIME SIGNEDDATA
32120 INPUTMANUAL ACTUAL F_GADD G_NONE NON_INTERCO LE140 LC 2014.014 1927108.36 //Exactly double what was expected - 963,554.18
25005 INPUTMANUAL ACTUAL F_GADD G_NONE NON_INTERCO LE140 LC 2014.014 - 1067669.56 //Exactly double what was expected - (533,834.78)
2 RECORDS HAVE BEEN WRITTEN BACK.
WRITING TIME :1.00 ms.
SCRIPT RUNNING TIME IN TOTAL:2.00 s.
LOG END TIME:2015-05-28 14:29:10
The calculation is obviously iterating for some reason, I just can't see why.
I was hoping a fresh pair of eyes might help - any ideas?
We are using CPMBPC release 801 SP9, HANABPC release 801 SP7, SAP_BW release 740 SP9, and I'm using EPM add-in version 21 patch 3 for my reports (if that's relevant)
Thanks very much,
Jason
Hi Jason,
Look on this:
*SKIP_DIM = ASSETREASON,VALUETYPE,COSTTYPE
You have only *XDIM_MEMBERSET VALUETYPE = FABV and nothing to scope other dimensions: ASSETREASON,COSTTYPE
...
Vadim
P.S. For testing use SIMPLE scripts with single members...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Some correction - actually I see only single COSTTYPE in the loop - COST
Better to have:
*XDIM_MEMBERSET COSTTYPE = COST
and remove:
*WHEN COSTTYPE
*IS COST
...
*ENDWHEN
For the rest, you have to scope ASSETREASON
Also you write 4 FLOW: F_RC,F_RD,F_IFRS,F_ADDC to F_GADD
Unknown number of accounts to unknown number of destination accounts: ACCOUNTFA.BS_COST_ACCOUNT
Vadim
User | Count |
---|---|
5 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.