SQL Server 2008 Analysis Services(OLAP) - unknown member

设置UnknownMember 为 NONE

 

- Dim xxx   ->   属性：UnknownMember=NONE

- [Dim xxx].[xxx]    ->   属性：KeyColumns.Null...=automatic ； NameColumns.Null...=automatic 

- 双击“ xxx.cube”   ->    Dimension Usage：  Dim xxx     ->     advanced：null processing = automatic

 

 

常见错误：

Error1MeasureGroupAttribute [Dim xxx].[xxx] : The 'KeyColumns' #0 has NullProcessing set to 'UnknownMember', but the dimension doesn't have UnknownMember set to 'Visible' or 'Hidden'.00