Alex,
You can query imported tables using the Elasticube project manager, you should add a sql expression allowing
you to filter any existing table in the Schema. (Open the Elasticube Project Manager - open your Elasticube - Add data - SQL expression)
The SQL lang that supported is transact SQL which means you can join union etc. etc.