cancel
Showing results for 
Search instead for 
Did you mean: 

Data doubling-up during push to different model

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

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...

former_member186338
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Vadim,

As I guessed, you solved it in 2 minutes! I've been looking at this for a day at least, thanks very much!

Cheers,

Jason

Answers (0)