Creating Column Matches Based on Keys to View Cube Data in the Same Visualization as Other Data
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.
About this task
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 might need to set up a custom expression.
Parent topic: Combining OLAP Data and Other Data in the Same Analysis
Related concepts