- SAP Managed Tags
Hi all,
BPC NW 10.1 SP 9, Engine ABAP.
In the model CONSOLIDATION we have the following dimensions:
In the AUDIT_TRAIL dimension there is the member COI_A1
We want to copy in COPY_COI_A.lgf all values on the AUDIT_TRAIL COI_A1 from the last period of the last year to the end period of the first quarter of this year.
If we run the script logic later we want to copy the AUDIT_TRAIL COI_A1 from the last month of the last quarter to the last month of this quarter.
*XDIM_MEMBERSET VERSION=ACTUAL
*XDIM_MEMBERSET TIME=%TIME_SET%
*XDIM_MEMBERSET AUDIT_TRAIL=COI_A1*XDIM_MEMBERSET ENTITY=%ENTITY_SET%
*XDIM_MEMBERSET FLOW=F99
*XDIM_MEMBERSET CURRENCY=%CURRENCY_SET%
*WHEN VERSION
*IS ACTUAL
*WHEN CURRENCY
*IS %CURRENCY_SET%
*WHEN ENTITY
*IS %ENTITY_SET%
*WHEN AUDIT_TRAIL
*IS COI_A1
*WHEN TIME
*IS TMVL(3,%TIME_SET%)
*REC(FACTOR=1, TIME = %TIME_SET%, FLOW=F00)
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*COMMIT
In UJKT we test this script with Data Region:
CATEGORY=ACTUAL
TIME=2016.03
SCOPE=CG_C0
ENTITY=1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1101,
1102,1103,1104,1105,1106,1107,1108,110,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1143,1144, 1145,1146,1147,1148,114,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165 ,1166,1200
CURRENCY=LC,EUR
The expected result is that all the values from the period 2015.16 with the AUDIT TRAIL COI_A1 with Flow F99 are copied to period 2016.03 with Flow F00.
Result in UJKT:
LGX:
*XDIM_MEMBERSET VERSION=ACTUAL
*XDIM_MEMBERSET TIME=2016.03
*XDIM_MEMBERSET AUDIT_TRAIL=COI_A1, COI_A2, COI_A3, COI_A4, COI_A5, COI_B1, COI_B2, COI_B3, COI_B4, COI_B5
*XDIM_MEMBERSET ENTITY=1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1101
*XDIM_MEMBERSET FLOW=F99
*XDIM_MEMBERSET CURRENCY=LC,EUR
*WHEN VERSION
*IS ACTUAL
*WHEN CURRENCY
*IS LC,EUR
*WHEN ENTITY
*IS 1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1101
*WHEN AUDIT_TRAIL
*IS COI_A1
*WHEN TIME
*IS 2016.06
*REC(FACTOR=1, TIME = 2016.03, FLOW=F00)
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*COMMIT
-------------------------------------------------------------------------------------------------------------------------------------
LOG:
LOG BEGIN TIME:2016-05-09 14:53:45
FILE:\ROOT\WEBFOLDERS\CUR7_TEST_SV \ADMINAPP\Consolidation\TEST.LGF
USER:A114679
APPSET:CUR7_TEST_SV
APPLICATION:Consolidation
[INFO] GET_DIM_LIST(): I_APPL_ID="Consolidation", #dimensions=10
ACCOUNT,AUDIT_TRAIL,CURRENCY,ENTITY,FLOW,INTERCO,MEASURES,SCOPE,TIME,VERSION
#dim_memberset=9
CATEGORY:ACTUAL,1 in total.
SCOPE:CG_C0,1 in total.
1102,1103,1104,1105,:0 in total.
VERSION:ACTUAL,1 in total.
TIME:2016.03,1 in total.
AUDIT_TRAIL:COI_A1,COI_A2,COI_A3,COI_A4,COI_A5,...10 in total.
ENTITY:1000,1001,1002,1003,1004,...19 in total.
FLOW:F99,1 in total.
CURRENCY:EUR,LC,2 in total.
SCRIPT RUNNING TIME IN TOTAL:0.00 s.
LOG END TIME:2016-05-09 14:53:45
The values for the AUDIT_TRAIL COI_A1 are not copied to the period 2016.03.
Can anybody please help me why these values are not copied?
Thanks in advance and best regards
Gerd
Accepted Solutions (1)
Answers (1)
Bluesky| User | Count |
|---|---|
| 7 | |
| 7 | |
| 6 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.