1

Closed

SSAS Tabular: DefaultMember

description

Out-of-the-box Tabular doesn't let you set the DefaultMember on dimensions or measures. This limitation is probably purposeful since DAX queries (i.e. Power View) would ignore this default member. However you can edit the XMLA and set the default member by adding the following to the .bim file at the end of the Commands tag:
 
<Command>
<Text>
Alter Cube
CurrentCube
Update Dimension [Date].[Calendar],
Default_Member = [Date].[Calendar].[Year].&amp;[2002] ;
</Text>
</Command>
 
However, we should carefully consider before implementing this feature since there's no parity with Power View.
Closed Jul 18, 2012 at 8:50 PM by furmangg
decided not to implement this

comments

dgosbell wrote Mar 16, 2012 at 4:08 AM

Although it works - it's also unsupported (see http://blogs.msdn.com/b/cathyk/archive/2011/10/17/the-bi-semantic-model-mdx-dax-and-you.aspx) So even if it works now it may not work in the future and I also don't like the idea of people not being able to get support because they used BIDS Helper.

Sign in to add a comment