BW--About Hierarchy
来源:互联网 发布:mac自带五笔输入法 编辑:程序博客网 时间:2024/06/06 17:39
Hierarchy Type | Description |
Hierarchy definition for characteristics | |
Characteristic hierarchy | Characteristic values of a characteristic in a tree structure. Characteristic hierarchies are stored in their own data tables. Like master data, they can be used in all InfoProviders. Example: Hierarchy of cost centers that are assembled in cost center groups. |
Determining hierarchical structures in InfoCube modeling | |
In the dimensions of an InfoCube
| Example: Time dimension. The definitions of InfoObjects 0CALDAY, 0CALMONTH, and 0CALYEAR form a hierarchy. Example: 04.09.2003 ® 04.2003 ® 2003 |
Specification of hierarchical structures in InfoCube maintenance | |
In the attributes of a characteristic | Example: The definitions of InfoObjects 0MATERIAL, 0MATL_GROUP, 0MATL_TYPE, and 0IND_SECTOR form a hierarchy. To use attributes in the query as hierarchy levels, they have to be defined as navigation attributes. |
2)Comparison of modeling in different hierarchical structures
Characteristic Hierarchy | Hierarchical Structures in InfoCube Dimensions or DataStore Objects | Hierarchical Structures in Attributes Characteristics |
As Posted view is not possible. Different views (such as version, key date) of the data are possible. | As Posted view is possible. | As Posted view is not possible. Different data views are not possible. Exception: The view for the key date is possible if the characteristic or respective attributes are time dependent. |
Cross-InfoProvider | Only valid for an InfoProvider | Cross-InfoProvider, because it is modeled in the master data. |
Changeable | Not changeable, unless you reload the InfoProvider. | Changeable (with master data changes or with the addition of attributes). |
Drill-down path is defined by the structure. | Drill-down path is not defined by the structure. Levels can therefore be skipped. | Drill-down path is not defined by the structure. Levels can therefore be skipped. |
Duplicate leaves are always displayed. | Duplicate leaves are only possible in As Posted view. | Duplicate leaves are not possible. |
Balanced and unbalanced hierarchies are possible. | Hierarchy structures have to be balanced. | Hierarchy structures have to be balanced. |
注意点:
A hierarchy can contain 50,000-100,000 leaves at most. If your hierarchy is larger, you should insert a level that is used as a navigation attribute or preferably as a separate characteristic in the dimension table.
- BW--About Hierarchy
- sap bw hierarchy table 介绍
- 如何从EXCEL文件加载Hierarchy到BW (How to Load Hierarchy From Flat File)
- BW
- BW
- BW
- BW
- BW的层次结构(hierarchy)在Webi报表中展现
- Hierarchy
- hierarchy
- (极力推荐)BW:How to load and generate a custom hierarchy in SAP Business Warehouse (SAP BW) without using flat files
- BW:浅谈BW Authorization
- BW:小结:BW系统升级
- about:
- about
- About
- About
- About
- PowerDesigner 中将Comment(注释)及Name(名称)内容互相COPY的VBS代码
- JavaScript常用字符串处理函数
- 利用vs.net快速开发windows服务(c#)
- php code test
- SQL Redist content: Command line option syntax error. Type Command /? for Help. 错误!!!
- BW--About Hierarchy
- 对于GC回收优化转贴文章的一点补充
- 利用Visual C#实现任务栏通知窗口
- 需求为什么会失真?如何解决?
- Selenium的介绍及使用
- 从今天开始..................
- 视频转换
- 直接控制GPIO引脚读取磁卡数据
- 编写软件架构文档说明