Invalid Dimension Department in Model

[former_member294847]

Hi All,

For the first time i am writing the script logic .can anyone please help me the error which iam facing while validating the logics

error shows like this :

Unidentified:Invalid Dimension"department"501_in Model

the script logics is:

*XDIM_MEMBERSET FLOW =Movement
*WHEN ACCOUNT
*IS 2461
*WHEN AUDITTRAIL
*IS Input
*WHEN DEPARTMENT
*IS 503_ADMINST
*REC(EXPRESSION=(%value%)*[[1128].[ACCOUNT],[AUDITTRAIL].[Process driver],[DEPARTMENT].[101_MINING],ACCOUNT=1129,AUDITTRAIL=Calculated])
*ENDWHEN
*ENDWHEN
*ENDWHEN
*COMMIT

Thanks

Regards

Thrilokitha

[former_member186338 · Accepted solution]

Please read:

https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

and provide required info!

Syntax of this line is incorrect:

*REC(EXPRESSION=(%value%)*[[1128].[ACCOUNT],[AUDITTRAIL].[Process driver],[DEPARTMENT].[101_MINING],ACCOUNT=1129,AUDITTRAIL=Calculated])

Has to be:

*REC(EXPRESSION=%value%*([ACCOUNT].[1128],[AUDITTRAIL].[Process driver],[DEPARTMENT].[101_MINING]),ACCOUNT=1129,AUDITTRAIL=Calculated)

Also - do you really have member ID "Process driver"??? With space inside ID?