sql-server - 为什么我收到此错误 `Error (Data mining): Either the user, TEMP-USER\Administrator, does not have permission` ？

Question

我使用 SQL Server 2008 r2 和 SSAS，我使用 AdventureWorks2008 数据库。

我在 Sql 服务器分析器的 MDX 查询中编写此查询。

SELECT [Measures].[Internet Sales Amount]
FROM [Adventure Works] 

我得到这个错误

Executing the query ...

Error (Data mining): Either the user, TEMP-USER\Administrator, does not have permission to access the referenced mining model, Adventure Works, or the object does not exist.

Error (Data mining): Either the user, TEMP-USER\Administrator, does not have permission to access the referenced mining model, Adventure Works, or the object does not exist.

Execution complete

为什么会出现这个错误？

Answer 1

你最常使用这个查询

SELECT 
[Measures].[Internet Sales Amount]  ON COLUMNS
FROM [Adventure Works] 

必须在 MDX 查询中定义 COLUMNS。