Setting a Default Member using Tabular mode SSAS and Excel 2013
Using the multi-dimensional mode of SQL Server Analysis Services (SSAS), setting the default member for a dimension attribute hierarchy can be as simple as selecting the dimension attribute hierarchy and then setting the default member in the properties window. Setting a default member can be useful if it is desired to set the default date for a Date/Time dimension to today's date thereby relieving users of the necessity of making the selection themselves. In the tabular mode version of SSAS, setting a default member is problematic partly because the option does not exist. So, how can this issue be addressed?