Is there an easy way to find out the column dependencies between tables in the DSV of a cube? The reason I am asking this question is: When there are lots of tables (fact and dim tables) in the dsv, it is hard to follow the lines.
有没有一种简单的方法可以找出多维数据集的DSV中表之间的列依赖关系?我问这个问题的原因是:当dsv中有很多表(事实和暗表)时,很难遵循这些行。
Help appreciated!
3 个解决方案
#1
You can right click on the arrows and hit Edit Properties, which tells you the columns of the tables that match up, and what those tables are. It's a bit tedious, but it'll get you there.
您可以右键单击箭头并单击编辑属性,它会告诉您匹配的表的列以及这些表是什么。这有点乏味,但它会让你到那里。
#2
The easiest way to do this would be to create a new diagram with just the tables you were interested in.
最简单的方法是使用您感兴趣的表创建一个新图表。
Whe you are editing the DSV, in the top left corner is a "Diagram Organizer" right click and choose the option to add a new diagram. This allows you to setup a sort of "view" of a sub-set of the tables in your DSV. Then you can right click on this empty diagram, add one or more of the tables that you are interested in and then you can right click on these tables and choose the "Add related tables" option until you have drilled as deep as you need to into the relationships.
当您编辑DSV时,在左上角右键单击“图表管理器”并选择添加新图表的选项。这允许您设置DSV中表格子集的“视图”。然后,您可以右键单击此空图,添加一个或多个您感兴趣的表,然后您可以右键单击这些表并选择“添加相关表”选项,直到您根据需要深入钻取进入关系。
#3
Open the DSV file in a text editor and scroll down to the bottom. There you will find a section called <xs:appinfo>. The relationships are all defined there, like this (for example):
在文本编辑器中打开DSV文件,然后向下滚动到底部。在那里你会找到一个名为
<msdata:Relationship name="Data-TimeDimension"
msdata:parent="dbo_TimeDimension" msdata:child="Data"
msdata:parentkey="Date" msdata:childkey="ClickDateHour"
msprop:Description=""
msprop:IsLogical="True" />
Depending on what you wanted you could apply an XSL transform and generate an html page, or write a program that parses that and dumps it out in some other format.
根据您的需要,您可以应用XSL转换并生成html页面,或者编写一个程序来解析并以其他格式转储它。
#1
You can right click on the arrows and hit Edit Properties, which tells you the columns of the tables that match up, and what those tables are. It's a bit tedious, but it'll get you there.
您可以右键单击箭头并单击编辑属性,它会告诉您匹配的表的列以及这些表是什么。这有点乏味,但它会让你到那里。
#2
The easiest way to do this would be to create a new diagram with just the tables you were interested in.
最简单的方法是使用您感兴趣的表创建一个新图表。
Whe you are editing the DSV, in the top left corner is a "Diagram Organizer" right click and choose the option to add a new diagram. This allows you to setup a sort of "view" of a sub-set of the tables in your DSV. Then you can right click on this empty diagram, add one or more of the tables that you are interested in and then you can right click on these tables and choose the "Add related tables" option until you have drilled as deep as you need to into the relationships.
当您编辑DSV时,在左上角右键单击“图表管理器”并选择添加新图表的选项。这允许您设置DSV中表格子集的“视图”。然后,您可以右键单击此空图,添加一个或多个您感兴趣的表,然后您可以右键单击这些表并选择“添加相关表”选项,直到您根据需要深入钻取进入关系。
#3
Open the DSV file in a text editor and scroll down to the bottom. There you will find a section called <xs:appinfo>. The relationships are all defined there, like this (for example):
在文本编辑器中打开DSV文件,然后向下滚动到底部。在那里你会找到一个名为
<msdata:Relationship name="Data-TimeDimension"
msdata:parent="dbo_TimeDimension" msdata:child="Data"
msdata:parentkey="Date" msdata:childkey="ClickDateHour"
msprop:Description=""
msprop:IsLogical="True" />
Depending on what you wanted you could apply an XSL transform and generate an html page, or write a program that parses that and dumps it out in some other format.
根据您的需要,您可以应用XSL转换并生成html页面,或者编写一个程序来解析并以其他格式转储它。