| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Data Mashup"
(Created page with "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...") |
|||
| Line 2: | Line 2: | ||
This can be useful for displaying OLAP, Relational and Excel data together, without the need for many error prove VLookUp() formulae. | 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. | ||
| + | |||
| + | [[Image:JoinedTables1.png|350px|centre]] | ||
Revision as of 14:40, 29 April 2016
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.
