output to generate for multiple values when user selects multiple values in Data Manager package

[former_member822995]

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

[N1kh1l]

chanduguduru9

*REC (ENTITY = %EN%, AUDITTRAIL = IN_%INDS1%)

The closing bracket was missing in *REC

Nikhil

[former_member822995]

Hi Nikhil,

It's typ error while i posting the question.

Thanks

Chandu

[N1kh1l]

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

[former_member822995]

Hi Nikhil,

Thanks for your quick response. We need to populate output with prefix as IN_*** dynamically for user selected Audit trails. The script is working fine in the case of single audit trail and not working for multiple audit trails.

Thanks

Chandu

[N1kh1l]

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.