Forum Discussion
bikram_laishram
9 years agoHelper I
Combine data from two SSAS cubes
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 d...
- 9 years ago
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.
- 9 years ago
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
9 years agoAdvocate II
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.