When a certain field in a table contains keys instead of descriptive values, by default the Dimension for this field will contain Members with keys for captions. The ‘friendly’ values for these keys are often stored in a separate table.
To get Member captions from another table:
- Right-click the Dimension and navigate to ‘Edit’.
In the ‘Captions’ section:
- Change the selection to ‘From Other Data Source’.
- Specify the name of the table to get the captions from, the name of the shared column between the tables and the name of the field containing the caption.
|
This feature is also called a Descriptive Join because in effect, an SQL join operation is performed behind the scenes to match captions to the keys.
|