Essbase开发笔记
正在加载中...
资料简介:
目 录
1. EssBase简介...............................................4
1.1. Essbase组成...........................................4
1.2. Essbase 请求方式....................................6
1.3. Essbase Support Matrix........................6
2. Essbase安装............................................7
3. Essbase启动........................................7
3.1. 命令行方式(Windows环境)...................7
3.2. 通过控制面板=>服务................................8
4. EssBase基础..........................................9
4.1. 基本概念..............................................9
4.2. Dense维与Sparse维...........................10
4.3. 维度成员间关系....................................10
4.4. OutLine中的维度................................11
4.5. 存储相关概念.......................................11
4.6. 两种存储模式........................................11
5. Essbase数据库开发..................................12
5.1. 基本步骤...........................................12
5.2. 创建Essbase应用................................13
5.2.1 启动Administration Console................13
5.2.2 创建应用及数据库................................13
5.2.3 建立数据模型(Outline).....................14
5.2.4 创建Rule文件...................................14
6. Essbase安全控制...................................19
6.1. 权限控制...........................................19
6.2. 权限信息的存储和变更........................19
7. Essbase调度.....................................20
8. ESSBASE优化方法...............................20
8.1. 完善数据源........................................20
8.2. 调整轮廓(Outline)..............................20
8.2.1 深入理解Dense和Sparse维...............20
8.2.2 合理选择DENSE维............................21
8.2.3 调整维度次序....................................21
8.2.4 调整Flat Dimension..........................21
8.3. 数据加载优化.......................................22
8.4. 使用动态计算(dynamic calc).................22
8.5. 调整内存分配........................................23
8.5.1 配置索引、数据和物理(文件系统)高速缓存...........23
8.5.2 选择合适的数据压缩算法..........................23
8.6. 系统参数设置(ARBORPATH/BIN/essbase.cfg)......24
8.6.1 NETDELAY..........................................24
8.6.2 NETRETRYCOUNT...............................24
8.6.3 DYNCALCCACHECOMPRBLKBUFSIZE.......24
8.6.4 DYNCALCCACHEMAXSIZE...................24
8.6.5 DYNCALCCACHEBLKRELEASE...................25
8.6.6 DYNCALCCACHEWAITFORBLK.................25
8.6.7 DYNCALCCACHEBLKTIMEOUT................25
8.6.8 DYNCALCCACHEONLY...........................25
8.6.9 CALCCACHEHIGH..............................26
8.6.10 CALCCACHEDEFAULT.......................26
8.6.11 CALCCACHELOW..............................26
8.6.12 CALCLOCKBLOCKHIGH......................26
8.6.13 CALCLOCKBLOCKDEFAULT..............26
8.6.14 CALCLOCKBLOCKLOW...................26
8.6.15 CALCHASHTBLMEMORY..................27
8.6.16 CALCOPTCALCHASHTBL.................27
9. ESSBASE数据备份与恢复.....................27
9.1. 数据备份..........................................27
9.2. 数据恢复......................................29
10. Essbase 开发Cube建议...................29
11. EIS应用开发...................................30
11.1. EIS 安装说明.............................30
11.2. EIS 操作说明.................................30
12. 前台展现.........................................30
12.1. Hyperion Intelligence Designer(Brio).....30
12.2. Hyperion Analyzer..............................30
1. EssBase简介...............................................4
1.1. Essbase组成...........................................4
1.2. Essbase 请求方式....................................6
1.3. Essbase Support Matrix........................6
2. Essbase安装............................................7
3. Essbase启动........................................7
3.1. 命令行方式(Windows环境)...................7
3.2. 通过控制面板=>服务................................8
4. EssBase基础..........................................9
4.1. 基本概念..............................................9
4.2. Dense维与Sparse维...........................10
4.3. 维度成员间关系....................................10
4.4. OutLine中的维度................................11
4.5. 存储相关概念.......................................11
4.6. 两种存储模式........................................11
5. Essbase数据库开发..................................12
5.1. 基本步骤...........................................12
5.2. 创建Essbase应用................................13
5.2.1 启动Administration Console................13
5.2.2 创建应用及数据库................................13
5.2.3 建立数据模型(Outline).....................14
5.2.4 创建Rule文件...................................14
6. Essbase安全控制...................................19
6.1. 权限控制...........................................19
6.2. 权限信息的存储和变更........................19
7. Essbase调度.....................................20
8. ESSBASE优化方法...............................20
8.1. 完善数据源........................................20
8.2. 调整轮廓(Outline)..............................20
8.2.1 深入理解Dense和Sparse维...............20
8.2.2 合理选择DENSE维............................21
8.2.3 调整维度次序....................................21
8.2.4 调整Flat Dimension..........................21
8.3. 数据加载优化.......................................22
8.4. 使用动态计算(dynamic calc).................22
8.5. 调整内存分配........................................23
8.5.1 配置索引、数据和物理(文件系统)高速缓存...........23
8.5.2 选择合适的数据压缩算法..........................23
8.6. 系统参数设置(ARBORPATH/BIN/essbase.cfg)......24
8.6.1 NETDELAY..........................................24
8.6.2 NETRETRYCOUNT...............................24
8.6.3 DYNCALCCACHECOMPRBLKBUFSIZE.......24
8.6.4 DYNCALCCACHEMAXSIZE...................24
8.6.5 DYNCALCCACHEBLKRELEASE...................25
8.6.6 DYNCALCCACHEWAITFORBLK.................25
8.6.7 DYNCALCCACHEBLKTIMEOUT................25
8.6.8 DYNCALCCACHEONLY...........................25
8.6.9 CALCCACHEHIGH..............................26
8.6.10 CALCCACHEDEFAULT.......................26
8.6.11 CALCCACHELOW..............................26
8.6.12 CALCLOCKBLOCKHIGH......................26
8.6.13 CALCLOCKBLOCKDEFAULT..............26
8.6.14 CALCLOCKBLOCKLOW...................26
8.6.15 CALCHASHTBLMEMORY..................27
8.6.16 CALCOPTCALCHASHTBL.................27
9. ESSBASE数据备份与恢复.....................27
9.1. 数据备份..........................................27
9.2. 数据恢复......................................29
10. Essbase 开发Cube建议...................29
11. EIS应用开发...................................30
11.1. EIS 安装说明.............................30
11.2. EIS 操作说明.................................30
12. 前台展现.........................................30
12.1. Hyperion Intelligence Designer(Brio).....30
12.2. Hyperion Analyzer..............................30
2010-03-18
页数30
浏览8314
下载231