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.
Prerequisites
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
-
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.
Result
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.
Copyright © TIBCO Software Inc. All rights reserved.