1. 如果attribute view 通过Excel 表示的时候，只显示那些主键属性，以及hierarchy active设置为true的非主键属性。

  如果希望非主键的属性显示，必须将其hierarchy active设置为true.

Each attribute in the list of output fields has among its properties a setting "Hierarchy Active“.

This setting defaults to "false“. If set to “false” the attribute will only show up in Excel (via MDX) if it is a key field of the attribute view

2. 层次属性只有通过mdx在excel中显示时才有效。

Hierarchies are only accessible via MDX.

Attribute View