Database Reference
In-Depth Information
9. As you can see, SSAS was able to identify the relationships in our model
when we imported the data. You will also notice that we are missing the rela-
tionship between the Product Category table and the Product table.
10. The easiest way to create this relationship is to drag ProductSubCat-
egoryKey from one table to the other; the direction does not matter as SSAS
will evaluate the data to determine the correct direction for the relationship.
11. You can also create the relationship by right-clicking on the column name in
either view and by selecting Create Relationship… . This will open up a dia-
log that allows you to select the tables and fields in the relationship.
12. You need to be aware of a couple of restrictions around relationship building.
The Tabular Model does not support a multifield relationship. Tabular Models
also do not support role-playing dimensions. If you look at the preceding
screenshot, you can see that the relationships between the Date table and
the Internet Sales tables include dotted lines. These represent nonact-
ive relationships in the model. Only active relationships can be used in major
parts of the data analysis natively.
Search WWH ::




Custom Search