Analysis Services中具有许多维度属性的层次结构级别

I would like to define a Company - Product - Edition hierarchy similar to:

我想定义一个公司 - 产品 - 版本层次结构类似于：

All
 |--Microsoft / Redmond / MSFT
 |   |--Windows
 |   |   |--Windows 7
 |   |   |--Windows Vista
 |   |   
 |   |--Office
 |   |   |--Office 2010
 |   |   
 |--Oracle / Santa Clara / ORCL
     |--Java
     |   |--Java 7
     |   
     |--MySQL
         |--MySQL Standard Edition

I would like the Company level to consist of many attributes, for example: name (let's call it primary attribute) as well as headquarters and NYSE code (secondary attributes). I don't want to concatenate them into a single value; the users should be able to place the secondary attributes in the report when they need them.

我希望公司级别包含许多属性，例如：name（让我们称之为主要属性）以及总部和NYSE代码（次要属性）。我不想将它们连接成单个值;用户应该能够在需要时将辅助属性放在报表中。

Is it possible in SSAS?

SSAS有可能吗？

1 个解决方案

#1

Maybe not in the way you're thinking. You can't add additional attributes to the levels of a hierarchy, but you can add those attributes to the dimension and relate them to the attributes that are in a hierarchy, using the "Attribute Relationships" tab. You won't be able to refer to the "secondary attributes" through the hierarchy, though. You'll refer to them directly in the dimension.

也许不是你想的那样。您无法将其他属性添加到层次结构的级别，但可以使用“属性关系”选项卡将这些属性添加到维度并将它们与层次结构中的属性相关联。但是，您将无法通过层次结构引用“辅助属性”。您将直接在维度中引用它们。