Database Reference
In-Depth Information
When the dimensional attribute includes date data, the attribute type should always be configured to reflect
the content. The date data determines how SSAS performs aggregations and how MDX functions are processed.
In our current example date, month, quarter, and year attributes must be configured accordingly.
oddly enough, the treeview has redundant type settings. in Figure 9-43 the Date dimension attribute is
available in two places. Although this is confusing, it does not matter which is used to set the attribute.
Tip
Figure 9-43. Setting the attribute type on a date column
After you have completed setting the attribute types, the Select Dimensional Attributes wizard page will look
similar to Figure 9-44 . Click Next at the bottom of this page to advance to the final page of the wizard.
 
Search WWH ::




Custom Search