为非重复计数记录指定的排序顺序不正确

changshuzh

SSAS 错误：OLAP 存储引擎中存在错误: 为非重复计数记录指定的排序顺序不正确。

1.为非重复计数记录指定的排序顺序不正确。 把这句翻译下成:Repeat count record for non-specified sort order incorrect
2.google 里面搜索 有相关的。

"Errors in the OLAP storage engine: The sort order specified for distinct count records is incorrect"
 

解决方法：
http://stackoverflow.com/questions/320405/analysis-services-2005-olap-cubes-can-i-create-a-distinct-count-measure-on-a-nv

Google and in particular Eggheadcafe came to the rescue with a solution:

• Connect to Analysis Services from SQL Server Management Studio
• Right Click on the Analysis Services Server name (ie the top most Analysis Services link)
• Choose properties
• Check Show Advanced (All) Properties
• Find the following setting
• OLAP \ Process \ CheckDistinctRecordSortOrder
• Set this value to 0
• Click OK
• Open your OLAP in Visual Studio or BIDS.
• Process the cube.