Combine data from two SSAS cubes

[bikram_laishram]

I am not sure if this has been answered before but as of today do we have a possibility to combine data from two different SSAS cubes. Our system collects and stores transactional data from various departments and these transactions have been summarised on a monthly level for reporting purposes. I am able to combine and view data SSRS but unable to replicate the process in BI.

Are there any plans to have a fix for this in the near future or is it something which will not be available as the functionality already exists in SSRS

[tannera · Accepted solution]

This is not possible at the moment through live connection and probably not for the forseeable future.

You can use the import mode, but that would flatten the cube and make it pretty unusable. For cubes you always want to stick to a live connection. 

[v-sihou-msft · Accepted solution]

@bikram_laishram

@tannera is correct. To combine to SSAS cube data, you have to use import mode, which the data is retrieved as a table only. 

Regards,

[tannera · Accepted solution]

This is not possible at the moment through live connection and probably not for the forseeable future.

You can use the import mode, but that would flatten the cube and make it pretty unusable. For cubes you always want to stick to a live connection.