|MDX expression returning an original string that should be parsed and modified.|
|A substring to look up in the original string value.|
|A new string to use instead of the substring.|
The following example would replace the key (with CAST operator converted as string) from the Issue dimension member with an empty string. As a result, it should return the Issue dimension summary (without issue key)
The following example would replace the comma (,) with a different separator (|) when searching members from the Approvals dimension and filtering those where a current user name can be found in the members for the Approval member name.
The following code would return a user-friendly name for the "Approvals" dimension member which usually is a comma-separated string of users since this dimension is imported from a multi-user picker custom field.
- Function CurrentUserName to return the name for the current user who logged into eazyBI and loads the report.
- Function GetCaption to return the user-friendly name of the member.