SAP HANA中创建层次分析视图(Hierarchy Analytic View)
1. 创建层次Attribute View: ATTR_PRODUCT_HIERACHY
ref: http://www.cnblogs.com/omygod/archive/2013/04/30/3052082.html
2. 在Content中,选中相应的package,右键新建Analytic View:
![](https://images0.cnblogs.com/blog/18408/201304/30174919-9013361c698f42edb289188e5b72aec5.png)
填写相应的参数:
![](https://images0.cnblogs.com/blog/18408/201304/30174921-7768a75aac5f4e26b71b6e5f9ee854d3.png)
点击Finish之后进入相应的主设计界面:
![](https://images0.cnblogs.com/blog/18408/201304/30174924-56a202adcb28494c8a2b50968bb61a44.png)
3. 添加数据对象
点击Data Foundation, 添加数据表FCTCustomerOrder
![](https://images0.cnblogs.com/blog/18408/201304/30174927-b189ff08926f4be48464f10ad0c3488d.png)
4. 选择Data Foundation的输出列
![](https://images0.cnblogs.com/blog/18408/201304/30174930-ccb901f51d364195af26018d5e5e541d.png)
5. 设置Data Foundation中列的属性(Attribute or Measure)
点击Semantics, 更改ProductID_1为attribute
![](https://images0.cnblogs.com/blog/18408/201304/30174934-f12290d7097343369371c7da3d40b0ac.png)
6. 添加属性视图
点击Logical Joi
![](https://images0.cnblogs.com/blog/18408/201304/30174935-61963b2232e34a2a8ba14e048a958c61.png)
点击绿色的添加按钮,进入查询属性视图的界面,输入相应的关键字,找到相应的属性视图
![](https://images0.cnblogs.com/blog/18408/201304/30174936-a1c0772707dc43908bda90dacb42c717.png)
点击OK,得到如下设计界面:
![](https://images0.cnblogs.com/blog/18408/201304/30174939-9b11e225ad4e48eaba8c1bcdf6d74684.png)
7. 在Attribute View和Data Foundation之间建立连接关系
从Data Foundation中的ProductID_1 拖动线条到Attribute View中的ProductID
![](https://images0.cnblogs.com/blog/18408/201304/30174944-5283e0a4328f4931844fc9e34ccab50f.png)
8. 激活并预览数据
![](https://images0.cnblogs.com/blog/18408/201304/30174948-91229411943744d58e751c0e00531b20.png)
该数据可以在Excel中更加直观的展示,可参见另外的文章。
http://www.cnblogs.com/omygod/archive/2013/04/30/3052344.html
原文地址: https://www.cnblogs.com/lan-meng/p/5549875.html