One of the task while building a PowerPivot Model is to create/Edit/Delete Relationships between tables. With SQL Server 2012 release of PowerPivot for Excel, we now have a Diagram view and this makes our task of defining relationships easier! Great addition. Any-who when you view your model in Diagram Model, This is how it looks:
To Edit a Relationship, You can click on the Relationship represented by the arrow and it would pop up an “Edit Relationship” Dialog Box.
But what if you wanted to Manage ALL relationships of this Model? You can do this!
GO TO Design Tab > Click On Manage Relationships.
Now here you can manage (create/edit/delete) relationships among tables. Very easy!
That’s about it for this post. Your feedback is welcome!