SQL 尝试处理多维数据集，但在模拟信息中出现错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/25598926/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Trying to process the cube but getting the error at impersonation information
提问by Manu'sa Bora
I have built a cube in Business Development Intelligent Studio(BIDS) using some database with the name 'Test_cube' which consists of Products dimension table, customers dimension table and orders fact table.
The products table attributes :prodID-primary key,prodname,prodtype,prodcost
The customers table attributes :custID-primary key,custname,custloc
The orders table attributes :orderID,prodID,custID,quantity,unitprice,totalprice-calculated query column where primary key was set to orderID,prodID,custID
我在 Business Development Intelligent Studio (BIDS) 中使用一些名为“Test_cube”的数据库构建了一个多维数据集，该数据库由产品维度表、客户维度表和订单事实表组成。
products 表属性：prodID-primary key,prodname,prodtype,prodcost
customers 表属性：custID-primary key,custname,custloc
orders 表属性：orderID,prodID,custID,quantity,unitprice,totalprice-calculated 查询列 whereprimary键被设置为 orderID、prodID、custID
But I got some errors while trying to deploy the cube like
但是我在尝试部署多维数据集时遇到了一些错误，例如
Internal error : The operation terminated unsuccessfully.
The datasource,'Test_cube', contains an ImpersonationMode that is not supported for processing operations.
Errors in the high-level relational engine.A connection could not be made to the datasource with the DataSourceID of 'Test_cube',Name of 'Test_cube'.
Errors in the OLAP Storage engine: An error occurred while the dimension, with the ID of 'products',Name of the 'products' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'prodID' attribute of the 'products' dimension from the 'Test_cube' database was being processed.
Server : The Current operation was cancelled because another operation in the transaction failed.
内部错误：操作未成功终止。
数据源“Test_cube”包含处理操作不支持的 ImpersonationMode。
高级关系引擎中的错误。无法连接到 DataSourceID 为“Test_cube”、名称为“Test_cube”的数据源。
OLAP 存储引擎中的错误：处理 ID 为“产品”、“产品”名称的维度时发生错误。
OLAP 存储引擎中的错误：处理“Test_cube”数据库中“products”维度的“prodID”属性时出错。
服务器：当前操作被取消，因为事务中的另一个操作失败。
回答by Anand Verma
Try this
尝试这个
Double Click on your data source under solution explorer -> Navigate to Impersonation Informationtab -> Choose inherit
在解决方案资源管理器下双击您的数据源 -> 导航到Impersonation Information选项卡 -> 选择inherit
Now try processing it again.
现在尝试再次处理它。
回答by Akila Weeratunga
I used 'Use a specific username and password' and typed in the username and password I use to log into my PC and it worked
我使用了“使用特定的用户名和密码”并输入了我用来登录我的 PC 的用户名和密码，它工作正常
回答by mahdi moghimi
Answers are not fully complete , After you want to process cube or dimension , SSAS see Logon account in sql server analysis services service, if match, Process continue else Error.
回答不完全，要处理多维数据集或维度后，SSAS见sql server analysis services服务中的登录帐户，如果匹配，处理继续否则错误。
You should use impersonation level to handle this issue.
您应该使用模拟级别来处理此问题。
First add your user to SSAS Server administrator Right Click on Microsoft analysis service Instance and point Properties --> Security --> Server administrators --> add your account.
首先将您的用户添加到 SSAS 服务器管理员 右键单击 Microsoft 分析服务实例并点属性 --> 安全性 --> 服务器管理员 --> 添加您的帐户。
Then Go to Data Source properties --> Security settings --> Impersonation Info --> Use a specific windows user name and password --> and set your Username and password Server Admin.
然后转到数据源属性 --> 安全设置 --> 模拟信息 --> 使用特定的 Windows 用户名和密码 --> 并设置您的用户名和密码服务器管理员。
Processing will be continue as well.
处理也将继续。
回答by Sql Surfer
I had to set this to an explicit account and use my personal credentials to get around this problem.
我必须将其设置为显式帐户并使用我的个人凭据来解决此问题。
Particularly on a first deploy which I think could be relevant.
特别是在我认为可能相关的第一次部署时。
Also: This problem went away after I started VS2012 in administrator mode.
另外：在我以管理员模式启动 VS2012 后，这个问题就消失了。
And Finally: I suspect that the version of SSAS on your target could affect this behavior. Think developer,enterprise vs standard edition.
最后：我怀疑目标上的 SSAS 版本可能会影响这种行为。想想开发者、企业与标准版。
