[Step By Step]SAP HANA创建层次结构的属性视图(Hierarchy Attribute View)
在产品表中,数据是具有一定层次结构的
1. 在Content相应的package下面右键点击Attribute View,新建Attribute View
![](https://images0.cnblogs.com/blog/18408/201304/30170912-d7786bd0765e481a9ed7c0f31b6d6255.png)
填写相关信息,注意:我们所建的依然是标准视图:
![](https://images0.cnblogs.com/blog/18408/201304/30170914-f9876c423bc14a178d92f15fb11d7b03.png)
点击Finish后得到如下设计界面:
![](https://images0.cnblogs.com/blog/18408/201304/30170918-7318921421d14355b9df729e622258ce.png)
2. 添加数据对象
点击Data Foundatio
![](https://images0.cnblogs.com/blog/18408/201304/30170920-8945d0b592464000b5fcb9daf5c10dce.png)
点击绿色+号,进入数据对象查询窗体
![](https://images0.cnblogs.com/blog/18408/201304/30170921-b4993e5cc22c41f6943558576cf18302.png)
输入数据对象关键字,找到相应的数据对象,点击OK,则数据对象添加到Data Foundation中:
![](https://images0.cnblogs.com/blog/18408/201304/30170924-7e5eb1adbf3a456b9d274e64c5bdd340.png)
3. 选择输出列
点中Data Foundation, 选择相应的列作为输出列
![](https://images0.cnblogs.com/blog/18408/201304/30170928-9b475135cf5042f4811e502a40050fde.png)
4. 设置Key Attribute
点中Semantics,设置ProductID为Key Attribute
![](https://images0.cnblogs.com/blog/18408/201304/30170932-b5c11431d60e43de8446ef3ab5c25ecc.png)
5. 设置Hierarchie
点中Semantics,点击Hierarchies中的添加按钮
![](https://images0.cnblogs.com/blog/18408/201304/30170935-f6ef2609dfbc40a488dda61ebf4c6d0d.png)
设置Hierarchy相关属性,指定层结构相关的字段
![](https://images0.cnblogs.com/blog/18408/201304/30170937-5a46206efc1943aa8c5d7a5e0bd9e598.png)
点击OK后,得到如下结果:
![](https://images0.cnblogs.com/blog/18408/201304/30170940-944dfe6e566f4d0198412538dd72a91a.png)
6. 激活并预览数据
![](https://images0.cnblogs.com/blog/18408/201304/30170943-a791477167084094b8d1c1cbe6b9c99f.png)
原文地址: https://www.cnblogs.com/omygod/archive/2013/04/30/3052082.html