on 2022 Sep 26 3:15 AM
Hi All,
We are copying data set using Data Manager package script logic with below selections. When user selects multiple audit trails script logic is failing with below error. Please let us know how to overcome this issue when user selects multiple audit trails.
Data Manager Selections : Version : 001
Audit trail : ECCLOAD,BPCLOAD
ENTITY: 2500
TIME : 2022.FEB
SCRIPT
XDMIM_MEMBERSET TIME = BAS(%TIME_SET%)
XDMIM_MEMBERSET VERSION = %CATEGORY_SET%
XDIM_MEMBERSET ENTITY AS %EN%= BAS(%ENTITY_SET%)
XDIM_MEMBERSET AUDITTRAIL AS %INDS% = %AUDITTRAIL_SET%
WHEN AUDITTRAIL
*IS %INDS%
FOR %INDS1% = %INDS%
*REC (ENTITY = %EN%, AUDITTRAIL = IN_%INDS1%)
*ENDWHEN
*NEXT
ERROR :UNKNOWN DIMENSION KEY WORD "BPCLOAD"
Thanks in advance
Chandu
Request clarification before answering.
*REC (ENTITY = %EN%, AUDITTRAIL = IN_%INDS1%)
The closing bracket was missing in *REC
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
chanduguduru9
Are you trying to summarize the two audittrails and writing it to new audit members as below?
Once your FOR is processed the below will be the script
WHEN AUDITTRAIL
*IS ECCLOAD,BPCLOAD
*REC (ENTITY = %EN%, AUDITTRAIL = IN_ECCLOAD)
*ENDWHEN
WHEN AUDITTRAIL
*IS ECCLOAD,BPCLOAD
*REC (ENTITY = %EN%, AUDITTRAIL = IN_BPCLOAD)
*ENDWHEN
chanduguduru9
You need to be specific here on what you mean by "Output". If you just want to copy ECCLOAD to IN_ECCLOAD and BPCLOAD to IN_BPCLOAD then try below code. (any leaf Audit trail member passed by user to IN_****) provided IN_*** exists
FOR %INDS1% = %INDS%
WHEN AUDITTRAIL
*IS %INDS1%
*REC (ENTITY = %EN%, AUDITTRAIL = IN_%INDS1%)
*ENDWHEN
*NEXT
Better approach is to handle this by creating an attribute in AUDITTRAIL dimension and populating the attribute with IN_*** memebsra gainst the audit members and use that in script.
User | Count |
---|---|
5 | |
2 | |
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.