Hi - this can be done by attaching a parser business rule or complex expression to the dimension in the Data Source.
Go to the Account Dimension in your Data Source and change the logical operator to 'Complex Expression'
In the complex expression, paste the below script:
'This a prebuilt function in the API that removes characters not valid for an XF name property
Return args.Value = StringHelper.RemoveInvalidNameCharacters(args.Value, False)
This script uses a prebuilt function that will remove unrecognized characters from the field value.
Thanks for the reply Jon- unfortunately when I do this it returns every one of my values as either True or False. Any thoughts as to why this is would happen?
