SQLTeam.com | Weblogs | Forums

Tabular Model Relationships


#1

Hello -

I am new to SSAS in general. I'm working on creating a solution that will replace the deprecated Report Model in 2008. Right now I'm building out a CUBE and a Tabular model project to see which one works best. This question is related to the Tabular Model. The biggest advantage of the Report Model was that it allowed the user to drag and drop fields without the need to know the relationship between entities. (The relationship existed in the report model). I am trying to add the same feature in my tabular project. I created the relationships, but when I drag and drop fields in Report builder, I get duplicates. How do I create Parent Child relationships that are already available when the user creates the report? I am using sql server 2012 with SSDT 12.

Thanks