Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link: http://hub-nl.insight.com/i/692679

Contents of this Issue

Navigation

Page 120 of 212

108 C H A P T E R 6 | More analytics By default, a relationship between two tables is one-directional unless you change this behavior at the model or environment level. At the model level, open the model properties, and then choose Both Directions in the Default Filter Direction drop-down list. This change applies only to your current model; any new models you create will default to single direction. If you prefer to change the default for all new models, select Options from the Tools menu, expand Analysis Services Tabular Designers in the navigation pane on the left, select New Project Settings, and then select Both Directions in the Default Filter Direction drop-down list, as shown in Figure 6-14. Figure 6-14: Setting the default filter direction for new projects. Writing formulas The user interface for the formula bar in the model designer has been improved by the addition of the following changes, which help you write and review DAX formulas more easily: Syntax coloring Functions are now displayed in a blue font, variables in a cyan font, and string constants in a red font to distinguish these expression elements more easily from fields and other elements. IntelliSense Errors are now identified by a wavy red underscore, and typing a few characters displays a function, table, or column name that begins with matching characters. Formatting You can persist tabs and multiple lines by pressing Alt+Enter in your expression to improve legibility. You can also include a comment line by typing // as a prefix to your comment. Formula fixup In a model set to compatibility level 1200, the model designer automatically updates measures that reference a renamed column or table. Incomplete formula preservation In a model set to compatibility level 1200, you can enter an incomplete formula, save and close the model, and then return to your work at a later time. Introducing new DAX functions The current release of SQL Server 2016 includes many new functions, which are described in the following table:

Articles in this issue

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016