如何找出要加入的列
有没有一种简单的方法可以找出多维数据集 DSV 中表之间的列依赖关系？ 我问这个问题的原因是：当 dsv 中有很多表（事实表和暗淡表）时，很难遵循这些规则。
帮助表示赞赏！
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.
Help appreciated!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
您可以右键单击箭头并单击“编辑属性”，它会告诉您匹配的表的列以及这些表是什么。 这有点乏味，但它会让你到达目的地。
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.
最简单的方法是创建一个仅包含您感兴趣的表格的新图表。
当您编辑 DSV 时，左上角有一个“图表组织器”，右键单击并选择添加新图表的选项图表。 这允许您在 DSV 中设置表子集的某种“视图”。 然后，您可以右键单击此空图表，添加一个或多个您感兴趣的表，然后您可以右键单击这些表并选择“添加相关表”选项，直到您钻取到所需的深度到关系中。
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 文件并向下滚动到底部。 在那里您将找到一个名为
根据您的需要，您可以应用 XSL 转换并生成 html 页面，或者编写一个程序来解析该页面并以其他格式转储它。
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):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.