| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Data Mashup
Revision as of 14:42, 29 April 2016 by Colin Overton (talk)
Joined tables were introduced in Version 9, and allow tables from different data sources to be combined.
This can be useful for displaying OLAP, Relational and Excel data together, without the need for many error prove VLookUp() formulae.
Example
We will create a joined table that retrieves sales data from a cube and product information from a relational database.
Firstly, we need to create 2 connections, one to each data source.
Then in the Joined Tables screen we add two queries, and join them by selecting the second query and picking the matching columns.
