If you have two columns with the same dimension values in a cube data source as well as in a relational data source and you want to display the data in the same visualization you may need to apply the
KeyOf method to match the values.
Before you begin
You must have a data table based on a cube data source and one data table from a relational source available in the analysis.
Procedure
-
On the menu bar, select
.
-
Go to the
Column Matches tab.
-
In the
Data tables list, select the cube data source.
-
Click
New.
-
In the
New Match dialog, select the other data table of interest under
Right data table.
-
Make sure the columns with the matching information are selected in the
Left matching column and
Right matching column selectors.
-
Open the column selector for the cube column under Left Matching column and select
Methods to open the menu.
-
Select
KeyOf.
Comment: It is not possible to use
KeyOf as a transformation, it must be applied directly as a method on the matching column.
-
Click
OK to close all dialogs.
Results
You can now show data from both the cube data and the relational data in the same visualization.
Note: When you are using a cube hierarchy on an axis in a visualization you will automatically see the caption and not the key. To explicitly show the keys in your visualizations, you might need to set up a custom expression.