为dimcustomer表部署维度时出错 [英] error while deploying dimension for dimcustomer table

问题描述

这是我的第一个ssas项目。



我创建了3个维度对于adventureworksDW数据库。



dimproduct，dimdate& dimcustomer使用各自的表。



但是前两个维度已经部署并且成功处理。



但是在部署dimcustomer尺寸时，我面临很多错误。我无法弄明白为什么？



请帮忙。



错误：



1.服务器：操作已取消。

2.内部错误：操作终止失败。

3. oledb或者olebc错误，操作取消了hy008。

4. olap存储引擎中的错误：当id为dim customer的维度，dimcustomer的名称正在处理时发生错误。

this is my first ssas project.

i've created 3 dimensions for adventureworksDW database.

dimproduct, dimdate & dimcustomer by using respective tables.

But first two dimensions are deployed & processed successfully.

but while deploying dimcustomer dimension, i'm facing lot of errors. i couldn't figure out why?

please help.

Errors:

1. server: the operations has been cancelled.
2. internal error: the operation terminated unsuccessfully.
3. oledb or olebc error , operation cancelled hy008.
4. errors in olap storage engine: an error occured while the dimension with the id of 'dim customer', name of dimcustomer was being processed.

推荐答案

嗨朋友们，



不知怎的，我设法解决了我的问题。



问题是我在创建维度时为dimcustomer表选择了coloumns，它具有重复值。



为了解决这个问题，我选择维度/属性的关键色度和值coloumn。当然，我选择了keycoloumn是多维的。



谢谢，

Subbu。

Hi Friends,

Somehow I managed to solve my issue.

The issue exists with the coloumns i've selected for dimcustomer table while creating dimension, which is having duplicate values.

To solve this, I've choosen key coloumn & value coloumn of the dimension/attributes. Ofcourse, I've choosen the keycoloumn to be multidimensional one.

Thanks,
Subbu.

这篇关于为dimcustomer表部署维度时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！