SQL Server Blogs

Voices from the UK SQL Server Community
Welcome to SQL Server Blogs Sign in | Help
in Search

Jorg Klein's Microsoft Business Intelligence Blog [Macaw]

SSAS - Speed up dimensions using a NULL default cube measure

Published Feb 06 2009, 01:07 PM by jorg
Filed under:

Comments

 

DaveRuijter said:

Jorg,

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;

February 9, 2009 11:09 AM
 

jorg said:

Hi Dave,

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.

Jorg

February 9, 2009 12:45 PM
 

babu said:

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 ?

March 15, 2009 5:42 PM
Powered by Community Server (Commercial Edition), by Telligent Systems