This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/
This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2009/02/06/ssas-speed-up-dimensions-using-a-null-default-cube-measure.aspx
If you set 'VISIBLE' on 0, the NULL measure will not be visible. Think you forgot that.
CREATE MEMBER CURRENTCUBE.MEASURES.UseAsDefaultMeasure AS NULL,
VISIBLE = 0;
ALTER CUBE CURRENTCUBE UPDATE DIMENSION Measures,
DEFAULT_MEMBER = [Measures].UseAsDefaultMeasure;
I left it visible for testing purposes. It’s up to the cube users to say if it should be visible or not. In most cases it will be invisible like you suggest, but not per definition.
Thanks for the addition.
1. Will this not impact your other Calculated Measures or MDX queries ? If there are other queries, where you implicitely expect a different default measure, could this impact the results ?
2. Could the same result have been achieved by setting the 'IgnoreUnrelatedDimesnion' property to true for that MEasure Group in the Cube ?