Database Reference
In-Depth Information
Note
Inactive relationships can still be used through DAX. Refer to
Chapter 10
,
DAX Calculations and Queries
, to see how DAX can be used to extend
the model.
How it works…
While loading the data, SSAS evaluates the data and sets the settings (previously
discussed) based on what it can learn from the data source. For instance, if foreign
keys are discovered in the incoming data, and the related tables are also imported at
the same time, relationships will be added to the model during the initial load. (Sub-
sequent loads with new tables will not include the relationships.) The model will also
evaluate data types during this initial load and set them in the model. These features
work well with metadata-rich data sources such as relational databases. However,
some sources provide little to no information during the load process, such as text
files, and need to be reconciled as previously mentioned.
There's more…
Actually, there are many other options you can use to refine your model. The follow-
ing are just a few additional options you should consider while you are finishing your
model:
• Specifying the date table
• Setting the default columns
• Hiding the columns from client tools
• Hiding the tables from client tools
Note
You should note that the sorting and filtering of data within the design sur-
face of SSDT does not affect the data presented to the user. These fea-
Search WWH ::
Custom Search