为AS 2005的Cube指定默认度量值

In some cases, it is not obvious or easy to create a default measure in AS2005 cubes. In fact, there is no default measure by default, which can lead to long query times for queries that specify no measures. We have seen slow behavior with several query tools that display an initial default query or heavily browse the hierarchies, especially Proclarity.

默认情况下，AS 2005的Cube并没有指定一个默认的度量值，这样的情况下，它会随便选择一个度量值作为默认度量值。如果用户在MDX中没有指定度量值的话。这可能会导致一些用户的困惑，以及可能降低速度

为了解决这个问题，可以参考下面的两个步骤

To add a default measure, you can follow the code below:

1. Generate a new calculated member with NULL value: --创建一个计算成员，设置为空值

CREATE MEMBER [CubeA].[MEASURES].NullMember AS null, VISIBLE = 0 ;

2. Include the new member in the cube as default measure: --把该计算成员指定为多维数据集默认的度量值

ALTER CUBE [CubeA]

UPDATE DIMENSION Measures,

Default_Member = [MEASURES].NullMember;

也可以通过图形化界面去做这个事情（在Cube设计器里面）