Hi
I am trying to copy data from one application to another, using destination_app (NOT BADI)
The source applicatin holde the initial planning of projects the target application holds approved project. There are different Category dimensions and two different project (PSP) dimensions.
The source project dimension PSP_TEMP have two properties PSP_FLYT and PSP_TARGET. PSP_FLYT to flag that the project should be moved and PSP_TARGET is the ID og the target project dimension PSP.
My logic looks like this.
*XDIM_FILTER PSP_TEMP=[PSP_TEMP].properties("PSP_FLYT")="Y"
*DESTINATION_APP = Prognose
*SKIP_DIM = REVISION
*ADD_DIM PROGNOSEVERSION = OPR_BUD
*RENAME_DIM PSP_TEMP = PSP
*XDIM_MEMBERSET TID = 2010.SEP
*XDIM_MEMBER REVISION = REV00
*WHEN TID
*IS 2010.SEP
*REC(EXPRESSION=%VALUE%,PSP_TEMP=PSP_TEMP.PSP_TARGET)
*ENDWHEN
The above logic returns the follwing log:
LGX:
*XDIM_FILTER PSP_TEMP=[PSP_TEMP].properties("PSP_FLYT")="Y"
*DESTINATION_APP = Prognose
*SKIP_DIM = REVISION
*ADD_DIM PROGNOSEVERSION = OPR_BUD
*RENAME_DIM PSP_TEMP = PSP
*XDIM_MEMBERSET TID = 2010.SEP
*XDIM_MEMBER REVISION = REV00
*WHEN TID
*IS 2010.SEP
*REC(EXPRESSION=%VALUE%,PSP_TEMP=PSP_TEMP.PSP_TARGET)
*ENDWHEN
-
-
LOG:
LOG BEGIN TIME:2010-04-15 13:56:57
FILE:ROOTWEBFOLDERSENDK_XJAD ADMINAPPInitieringTEST.LGF
USER:ENERGINETXJAD
APPSET:ENDK_XJAD
APPLICATION:Initiering
GET_DIM_LIST(): I_APPL_ID="Initiering", #dimensions=9
AKTIVITET,ARTSKONTO,MEASURES,MEDARBEJDER,PRISNIVEAU,PROFITCENTER,PSP_TEMP,REVISION,TID
#dim_memberset=2
PSP_TEMP:99_0001_01_01,99_0001_01_02,2 in total.
TID:2010.SEP,1 in total.
REC :%VALUE%
CALCULATION BEGIN:
QUERY PROCESSING DATA
QUERY TIME : 1431.00 ms. 10 RECORDS QUERIED OUT.
QUERY REFERENCE DATA
QUERY TIME : 1490.00 ms. 10 RECORDS QUERIED OUT.
CALCULATION TIME IN TOTAL :1532.00 ms.
20 RECORDS ARE GENERATED.
CALCULATION END.
ENDWHEN ACCUMULATION: 20 RECORDS ARE GENERATED.
DATA TO WRITE BACK:
AKTIVITET ARTSKONTO MEDARBEJDER PRISNIVEAU PROFITCENTER PROGNOSEVERSION PSP TID SIGNEDDATA
AKT01 53200 EKS_OMK FAST 1100 OPR_BUD 99_0001_01_01 2010.SEP 0.00
AKT01 61005 EKS_OMK FAST 1100 OPR_BUD 99_0001_01_01 2010.SEP 0.00
AKT01 61010 EKS_OMK FAST 1100 OPR_BUD 99_0001_01_01 2010.SEP 0.00
AKT01 90015T 10046 FAST 1100 OPR_BUD 99_0001_01_01 2010.SEP 0.00
AKT01 90015T 10627 FAST 1100 OPR_BUD 99_0001_01_01 2010.SEP 0.00
AKT01 90015T 1100 FAST 3030 OPR_BUD 99_0001_01_01 2010.SEP 0.00
AKT02 61010 EKS_OMK FAST 1100 OPR_BUD 99_0001_01_01 2010.SEP 0.00
AKT03 53300 EKS_OMK FAST 1100 OPR_BUD 99_0001_01_01 2010.SEP 0.00
AKT03 61010 EKS_OMK FAST 1100 OPR_BUD 99_0001_01_01 2010.SEP 0.00
AKT03 90020 EKS_OMK FAST 1100 OPR_BUD 99_0001_01_01 2010.SEP 0.00
AKT01 53200 EKS_OMK FAST 1100 OPR_BUD 20_0601_01_01 2010.SEP 80808.00
AKT01 61005 EKS_OMK FAST 1100 OPR_BUD 20_0601_01_01 2010.SEP 33.00
AKT01 61010 EKS_OMK FAST 1100 OPR_BUD 20_0601_01_01 2010.SEP 344.00
AKT01 90015T 10046 FAST 1100 OPR_BUD 20_0601_01_01 2010.SEP 28.00
AKT01 90015T 10627 FAST 1100 OPR_BUD 20_0601_01_01 2010.SEP 5.00
AKT01 90015T 1100 FAST 3030 OPR_BUD 20_0601_01_01 2010.SEP 445.00
AKT02 61010 EKS_OMK FAST 1100 OPR_BUD 20_0601_01_01 2010.SEP 56678.00
AKT03 53300 EKS_OMK FAST 1100 OPR_BUD 20_0601_01_01 2010.SEP 5678.00
AKT03 61010 EKS_OMK FAST 1100 OPR_BUD 20_0601_01_01 2010.SEP 333.00
AKT03 90020 EKS_OMK FAST 1100 OPR_BUD 20_0601_01_01 2010.SEP 230.00
20 RECORDS HAVE BEEN WRITTEN BACK.
WRITING TIME :921.00 ms.
SCRIPT RUNNING TIME IN TOTAL:4.27 s.
LOG END TIME:2010-04-15 13:57:01
-
-
The source project are selected by *XDIM_FILTER PSP_TEMP=[PSP_TEMP].properties("PSP_FLYT")="Y" and return PSP_TEMP:99_0001_01_01,99_0001_01_02,2 in total.
The PSP_TARGET value for those two are 20_0601_01_01 and 20_0601_01_02.
And finally my question:
To make this logic work I have to create :99_0001_01_01,99_0001_01_02 in the target application and as can be seen in the DATA TO WRITE BACK the first 10 lines are source with 0 in signdata the the last 10 the correct data.
Is this a bug or have I done something wrong. This is based on a logic from BPC 5.1M and here it works fine.
We are on BPC 7.5.0.1
Edited by: Jesper Høgh Andersen on Apr 15, 2010 2:29 PM