属性关系介绍英国2008 -好事还是不好呢?

2008中的一个新特性分析服务的属性关系选项卡维设计师。这个工具是商业智能的一部分Development Studio(投标),实际上是伪装起来的Visual Studio。2005年介绍,我们可以定义属性关系一个接一个使用属性列表但是没有整体图形显示的关系这是视为一个隐藏的特性。现在有一个专门的标签和图形都是好的,或者是吗?一旦你得到这个选项卡工作确实显示了多属性在一个图形的关系。这是非常有用的,它允许介绍高效地存储的属性和相应的聚合。然而,我有一个主要的抱怨:这是有违直觉。在定义层次结构的维度结构选项卡上维设计师通过拖放那么低阶高阶对象对象创建水平,你会发现一个蓝色的等号层次下名称,建议您继续创建属性关系。没关系但随后创建属性关系你要做那么反过来——低阶对象高阶对象。这总是抓我,但这是真正的射手——没有撤销。 If you make that mistake you typically don’t find out until after you have attempted a Deploy of the cube for testing. This results in errors because, dummy, you have done things in the same order not in reverse order. And a Deploy does a Save, so you need to get back to where you were on your own. And that’s even more counter-intuitive. To delete a relationship, you need to click on the relationship itself, not the object. Then to re-assimilate the attribute with the key attribute you need to do that in reverse order too – you have to drag the Key onto the orphan attributes. All this just to get back to the state before the Deploy request. Then you can attempt to create the attribute relationships in the correct (reverse) order. Yikes! I remember demonstrating the Undo feature in a Database Design Tool called Bachman back in 1991. I was always surprised to see jaws drop and eyes light up. That single simple feature closed many deals in those days. Almost 20 years later, I am afraid we are still re-inventing the wheel. Later Brian