Forum Discussion

Solution Sage

9 years ago

Connecting to Cube - model tables and unique values

Hi all, I'm connecting to a cube, and I'm running into a couple issues. 1. When I'm importing data from the cube in the navigator, I get to the 26 tables in the model. If I select multiple ta...

Need Help

v-qiuyu-msft

Community Support

9 years ago

Are the no possibility to keep the relationships when importing from a multidimensional cube? Any tips here to make the process as smooth as possible? Or is the solution as simple as doing a server upgrade to an enterprise version to support live connection?

Hi Rvn86,

It's not supported, all defined relationships in cube will lose after you import SSAS data. You need to create it again. Or upgrade SQL Server to SQL Server 2012 SP1 CU4 or later version.

Best Regards,
Qiuyun Yu