on 06-10-2015 2:48 PM
Hi experts,
I wrote script logic to transfert data from one model to another,
in simulation mode,the script seems to work correctly
nevertheless, while executing in save mode, or using a datapackage, i face this king of log,
does someone already face this issue ?
tks a lot :
36 records scanned
18 records skipped
18 records processed
18 records generated
Time to scan data: 0.09 sec.
------------------------------
Time to prepare final strings: 0.00 sec.
Total processing time: 0.09 sec.
Model: CA - Records to be posted are 18 (calc diff = 0)
ACTIVITY,AUDITTRAIL2,DDAY,RPTCURRENCY,VERSION,SCOPES,TIME,CATEGORY,ENTITY,PYRAMID_CA,SIGNEDDATA
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0048,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0161,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0178,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0214,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0359,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0393,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0455,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0499,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0560,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0572,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0573,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0575,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0603,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0679,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0686,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0692,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,FR0761,IND_COMPV1,1.0000000000
NO_ACT,INPUT,NO_DAY,LC,VDEF,S_CP_H,2012.JAN,REEL,LD0B05,IND_COMPV1,1.0000000000
Time to validate records: 0.00 sec.
call 1 completed and data posted in 0.64 sec.
Run completed in 0.67 sec.
****************************************************************************************************
End time --->15:36:38 - Date: 2015-06-10
****************************************************************************************************
Impossible d'enregistrer l'enregistrement d'en-tête : ACTIVITY,AUDITTRAIL2,DDAY,RPTCURRENCY,VERSION,SCOPES,TIME,CATEGORY,ENTITY,PYRAMID_CA,SIGNEDDATA
0 warning errors writing data:
Hi Olivia,
Are you wondering about the 18 records skipped? I think the reason may be that you're scoping Category CP_V1 and REEL but you're only selecting CP_V1 in your *WHEN statement. To check what's in the scope, enter the following before your existing *WHEN statement and run in simulation mode:
*WHEN *
*IS *
*REC(SCOPES=#test)
*ENDWHEN
*GO
This creates temporary records of everything scoped, and allows you to compare to what's been posted. (I'm using SCOPES for my temporary member as you only have scoped one member of this dimension, so there is no need to analyse on SCOPES.)
Hope this helps!
/Cecilia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Olivia,
that log tells me that 18 records should be written to the database. What would you expect to happen instead?
When transferring data between models you have to make sure that you match up the correct dimensions and add all the ones not in the source model. Do you use *DESTINATION_APP?
BR,
Arnold
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arnold,
tks for your reply,
in fact, the log show you the simulation mode ; it seems that the "transformation" between both model are correct.
i try to transfer Data from OWNERSHIP to CA model :
//selection de l'année
*SELECT (%TIMYR%,"[YEAR]","TIME","[ID]='%TIME_SET%' ")
*SELECT (%TIMYR1%,"[YEAR]+1","TIME","[ID]='%TIME_SET%' ")
//selection des mois a partir de la selection
*SELECT(%TIMBAS%,"[ID]","TIME","YEAR='%TIMYR%' AND CALC='N' ")
*SELECT(%TIMBAS1%,"[ID]","TIME","YEAR='%TIMYR1%' AND CALC='N' ")
//selection des magasins
*SELECT(%ENTMAG%,"[ID]","ENTITY","ENT_TYP='MAGASIN' AND CALC='N' ")
*DESTINATION_APP=CA
*RENAME_DIM O_ACCOUNT = PYRAMID_CA
*SKIP_DIM =CUSTOMER
*ADD_DIM ACTIVITY = NO_ACT
*ADD_DIM AUDITTRAIL2 = INPUT
*ADD_DIM DDAY = NO_DAY
*ADD_DIM RPTCURRENCY = LC
*ADD_DIM VERSION = VDEF
*XDIM_MEMBERSET O_ACCOUNT = PCON
//*XDIM_MEMBERSET CUSTOMER = I_NONE,I_NPLUS1
*XDIM_MEMBERSET ENTITY = %ENTMAG%
//*XDIM_MEMBERSET ENTITY = FR0178
*XDIM_MEMBERSET SCOPES = S_CP_H
*XDIM_MEMBERSET CATEGORY = CP_V1,REEL
*XDIM_MEMBERSET TIME=%TIMBAS%
//*XDIM_MEMBERSET TIME= 2012.JAN
*WHEN CATEGORY
*IS CP_V1 //transfert des status comparables - horizons temporel périodic sur 12 mois (et non 24 mois)
*REC(FACTOR=1,O_ACCOUNT="IND_COMPV1",CATEGORY="REEL",NOADD)
*ENDWHEN
*COMMIT
User | Count |
---|---|
16 | |
3 | |
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.