Just started to do a Tablur Mode project in SSAS 2012. When I try to add a new Dim Table using the Existing Connection (Model > Existing Connections) it works fine and imports data and also I can see the table in Grid (Data View) Mode, but cannot see the table in Diagram View.
What am i missing here?
Is there an actual relationship between the rows in the two tables, i.e. PK -> FK? Do the referenced columns have the following: 1) the same name in both tables 2) the same data type in both tables 3) data integrity between both tables