Report Portal

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?

Read more...

Tags: design, tabular

 

2007-2015 VidasSoft Systems Inc.