Defining a New Relation Between a Relational Data Table and a Cube Data Source Using Keys
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
Procedure
Results
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.
Parent topic: Combining OLAP Data and Other Data in the Same Analysis
Related concepts