SQL Server 2008创建多维数据集维度的层次结构问题

Question

有三个表有层次关系，由高到低依次为：Dim Product Type、Dim Product Sub Type、Dim Product，创建多维数据集后，生成的维度Dim Product有错误提示：“在非父子维度中创建层次结构”，两个外键做为维度Dim Product的属性

问题：已经有外键关联，为什么会提示“在非父子维度中创建层次结构”？请帮忙解答，谢谢！

 

Answer 1

Can you post table schema?

Answer 2

Table Dim Product Type:

Product Type Code(PK)

Product Type Name

 

Table Dim Product Sub Type:

Product Sub Type Code(PK)

Product Sub Type Name

Product Type Code(FK)

 

Table Dim Product:

Product Code(PK)

Product Name

Product Sub Type Code(FK)

 

 

Thanks for your help!

Answer 3

No relation between [Dim Product] and [Dim Product Type]? How did you build dimension?

Answer 4

I have solved the problem.

It need to create hierarchy first,and then set all attribute's AttributeHierarchyVisible to False.

The relation of this three tables is right.

Anyway,thank you all the same!