|MDX expression that returns a member.|
GetCaption would return a display name for a dimension member in a user-friendly format. This function can be used on any dimension (regardless of the field type).
For example, when importing data from Jira, eazyBI creates the "Issue" dimension with multiple hierarchies (default and Issue.Sub-task). The default hierarchy has just two levels Project > Issue. The second hierarchy groups issues by issue type levels (Project > Epic > Parent > Sub-task).
For default hierarchy, you can use the Name function to return the full name (issue key and summary) of a member:
However, it won't work the same for other (not default) hierarchies in the "Issue" dimension. You can return the user-friendly name for members from other hierarchies using the GetCaption function:
If there is just one hierarchy for the dimension, GetCaption would return the same results as the Name function.
Another example is to search and filter Approvals dimension members where the report's current user name belongs to.
The following code would return a user-friendly name for the "Approvals" dimension member which usually is a comma-separated string of users since the dimension Approvals is imported from a multi-user picker custom field.