尝试处理多维数据集，但在模拟信息中出现错误 [英] Trying to process the cube but getting the error at impersonation information

问题描述

我在Business Development Intelligent Studio(BIDS)中使用一些名为"Test_cube"的数据库构建了一个多维数据集，该数据库由产品"维表，客户"维表和订单事实"表组成. 产品表属性:prodID-主键，prodname，prodtype，prodcost
客户表属性:custID主键，custname，custloc
订单表属性:orderID，prodID，custID，数量，单价，总价格计算的查询列，其中主键设置为orderID，prodID，custID

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

但是在尝试像这样部署多维数据集时遇到了一些错误

But I got some errors while trying to deploy the cube like

内部错误:操作未成功终止.
数据源"Test_cube"包含处理操作不支持的ImpersonationMode.
高级关系引擎中的错误.无法建立数据源ID为'Test_cube'，名称为'Test_cube'的数据源的连接.
OLAP存储引擎中的错误:正在处理ID为'products'的维度，'products'的名称.
OLAP存储引擎中的错误:处理'Test_cube'数据库中'产品'维度的'prodID'属性时发生错误.
服务器:由于事务中的另一项操作失败，因此取消了当前操作.

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.

推荐答案

尝试一下

在解决方案资源管理器下双击您的数据源->导航到Impersonation Information选项卡->选择inherit

Double Click on your data source under solution explorer -> Navigate to Impersonation Information tab -> Choose inherit

现在尝试再次处理.

这篇关于尝试处理多维数据集，但在模拟信息中出现错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！