Forum Discussion

bikram_laishram's avatar
9 years ago
Solved

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...
  • tannera's avatar
    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. 

  • v-sihou-msft's avatar
    9 years ago

    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,