I am trying to use YTD() in mdx and am aware that I need to first define dimDate to Time type and define each dimensionAttribute to appropriate type. HOwever, I am very confused by the large amount of selections in the Type dropdown list.
For example, I have a dimenionAttribute called [S Week Of Year] and in the type, there are two sections Calendar and Fiscal under Date and each contains week type, which one should I choose? Also is there any reference where I could learn to pick the right
--Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --
The value of the Type property for an attribute determines the attribute type, and specifies the type of information contained by that attribute. Many of the available options represent types which are used by client applications to display or support an
attribute. Attribute types in Analysis Services fall in into five categorized groups. These attribute type groups include:
General: These values are available to all attributes, and exist only to enable classification of attributes for client application purposes.
Account Dimension: These values identify an attribute that belongs to an account dimension.
Currency Dimension: These values identify an attribute that belongs to a currency dimension.
Slowly Changing: These values identify an attribute that belongs to a slowly changing dimension.
Time Dimension: These values identify an attribute that belongs to a time dimension.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.