If you have data in a cube data source and want to be able to use this data to retrieve details about a certain value from a relational data source on demand, or if you simply want to be able to propagate markings from the cube data source to visualizations based on the relational source, you may want to define a relation between the two data tables.
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
.
-
In the Data Table Properties dialog, go to the
Relations tab.
-
Click
Manage Relations.
-
In the
Manage Relations dialog, select the data table to
Show relations for.
-
Click
New.
-
Select the cube data table you want to connect to from the
Left data table drop-down list and the relational data table from the
Right data table drop-down list.
-
Select the column containing the identifiers in the
Left column and
Right column drop-down lists.
-
Provided that the cube data source is on the left, under
Left method, select the
KeyOf method.
Comment: This specifies that the match should be done using the cube key of that identifier and not the actual value.
-
Click
OK to close all dialogs.
Results
The relational data table and the cube data table are now related.
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 need to set up a custom expression.