1 目录
1
ORACLE BIEE基础 ..................................................................................................................... 4 1.1 OBIEE 概述 ................................................................................................................... 4
1.1.1 BIEE 历史 .......................................................................................................... 4 1.1.2 数据模型 ........................................................................................................... 4 1.2 BIEE 安装...................................................................................................................... 5
1.2.1 JDK要求 ............................................................................................................ 5 1.2.2 下载BIEE ........................................................................................................... 6 1.2.3 安装BIEE ........................................................................................................... 6 1.2.4 Logs ................................................................................................................... 8 1.3 配置 ............................................................................................................................... 9
1.3.1 安装后的目录 ................................................................................................... 9 1.3.2 几个重要的配置文件 ....................................................................................... 9 1.4 预览Demo效果 ........................................................................................................... 9
1.4.1 启动BI服务和OC4J ......................................................................................... 9 1.4.2 打开BIEE仪表盘 ............................................................................................ 10 BIEE 开发步骤........................................................................................................................ 12 2.1 数据库 ......................................................................................................................... 12
2.1.1 安装数据库 ..................................................................................................... 12 2.2 创建资料库 ................................................................................................................. 12
2.2.1 资料库 ............................................................................................................. 12 2.3 创建物理模型 ............................................................................................................. 13
2.3.1 导入物理表 ..................................................................................................... 13 2.3.2 选择维度表和事实表 ..................................................................................... 14 2.3.3 完成物理模型 ................................................................................................. 15 2.3.4 新建主键和外键 ............................................................................................. 16 2.4 创建逻辑模型 ............................................................................................................. 18
2.4.1 创建逻辑层 ..................................................................................................... 18 2.4.2 查看逻辑层 ..................................................................................................... 19 2.4.3 修改逻辑层 ..................................................................................................... 19 2.5 创建展现模型 ............................................................................................................. 20
2.5.1 创建展现层 ..................................................................................................... 20 2.6 保存资料库 ................................................................................................................. 21
2.6.1 保存资料库 ..................................................................................................... 21 2.6.2 修改密码 ......................................................................................................... 22 2.7 发布资料库 ................................................................................................................. 22
2.7.1 修改NQSConfig.INI ......................................................................................... 22 2.7.2 重启Oracle BI Server ...................................................................................... 22 2.8 Answers – 答复 .......................................................................................................... 23
2.8.1 登陆BI Dashboards ......................................................................................... 23 2.8.2 选择主题 ......................................................................................................... 23
2
3
4
5
2.8.3 预览报表 ......................................................................................................... 25 2.8.4 新建文件夹 ..................................................................................................... 25 2.8.5 保存报表 ......................................................................................................... 26 2.9 Dashboards – 仪表盘 ................................................................................................. 27
2.9.1 创建仪表盘 ..................................................................................................... 27 2.9.2 编辑仪表盘 ..................................................................................................... 27 2.9.3 查看仪表盘 ..................................................................................................... 28 Answer详细介绍 ................................................................................................................... 29 3.1 列................................................................................................................................. 29
3.1.1 新建报表 ......................................................................................................... 29 3.1.2 列属性 ............................................................................................................. 30 3.1.3 fx-编辑属性 ..................................................................................................... 30 3.1.4 添加筛选器 ..................................................................................................... 31 3.1.5 最终效果 ......................................................................................................... 32 3.2 答复 ............................................................................................................................. 33
3.2.1 Prompts-报表提示 .......................................................................................... 33 3.2.2 Title-标题 ........................................................................................................ 33 3.2.3 Legend-图例 .................................................................................................... 34 3.2.4 Narrative-叙述内容 ........................................................................................ 35 3.2.5 Ticker-标记视图 .............................................................................................. 36 3.2.6 合计 ................................................................................................................. 37 3.2.7 Chart-图表 ....................................................................................................... 38 3.2.8 Pivot Table-数据透视图 .................................................................................. 39 3.2.9 Gauge-计量表 ................................................................................................. 39 3.2.10 Column Selector-列选择器 ............................................................................. 41 3.2.11 View Selector-视图选择器 ............................................................................. 41 Dashboard详细介绍 .............................................................................................................. 43 4.1 仪表盘设置 ................................................................................................................. 43
4.1.1 管理 ................................................................................................................. 43 4.1.2 我的账户 ......................................................................................................... 43 4.2 仪表盘功能 ................................................................................................................. 43
4.2.1 Dashboard Prompt-仪表盘提示 ..................................................................... 44 4.2.2 Link or Image-链接或图像 .............................................................................. 44 4.2.3 Embedded Content-嵌入式内容 .................................................................... 45 4.2.4 Text-文本 ......................................................................................................... 46 4.2.5 Briefing Book-简要簿 ...................................................................................... 47 4.2.6 Folder-文件夹 ................................................................................................. 49 4.2.7 Guided Nav. Link-引导导航 链接 ................................................................... 49 4.2.8 Briefing Book Nav. Link-工作簿导航 链接 ..................................................... 50 4.2.9 BI Publisher 报表............................................................................................ 51 4.2.10 条件显示内容 ................................................................................................. 51 Delivers介绍 ........................................................................................................................... 53 5.1 Scheduler 配置 ........................................................................................................... 53
5.1.1 安装计划表 ..................................................................................................... 53
6
5.1.2 配置Job Manager ........................................................................................... 53 5.1.3 添加用户认证 ................................................................................................. 55 5.1.4 查看Scheduler ................................................................................................ 56 5.2 Delivers应用 ............................................................................................................... 57
5.2.1 编辑我的客户 ................................................................................................. 57 5.2.2 创建iBot ......................................................................................................... 58 5.2.3 查看Alerts ...................................................................................................... 60 5.2.4 发送Mail ........................................................................................................ 60 其他功能介绍 ......................................................................................... 错误！未定义书签。 6.1 钻探 ............................................................................................................................. 63
6.1.1 修改维度表 ..................................................................................................... 63 6.1.2 创建维度 ......................................................................................................... 65 6.1.3 修改层次结构 ................................................................................................. 66 6.2 导航 ............................................................................................................................. 70
6.2.1 列导航 ............................................................................................................. 70 6.3 Writeback .................................................................................................................... 73 6.3.1 修改物理层 ..................................................................................................... 73
6.3.2 修改连接池 ..................................................................................................... 74 6.3.3 创建回写模板 ................................................................................................. 74 6.3.4 回写授权 ......................................................................................................... 75 6.3.5 配置回写报表 ................................................................................................. 75 6.3.6 查看效果 ......................................................................................................... 77 6.3.7 回写限制 ......................................................................................................... 77 6.4 权限 ............................................................................................................................. 78
6.4.1 Administration Tool ......................................................................................... 78 6.4.2 新建Group ...................................................................................................... 78 6.4.3 新建User ........................................................................................................ 80 6.4.4 登陆Answer .................................................................................................... 81 6.5 数据迁移 ..................................................................................................................... 82
6.5.1 资料库迁移 ..................................................................................................... 82 6.5.2 Catalog迁移 .................................................................................................... 82 6.5.3 报表迁移 ......................................................................................................... 83 6.5.4 其他内容迁移 ................................................................................................. 83 6.6 附录 ............................................................................................................................. 83
6.6.1 系统变量 ......................................................................................................... 83 常见问题 ................................................................................................. 错误！未定义书签。 7.1 问题记录 ..................................................................................................................... 85
7.1.1 Oracle BI Scheduler Error: nQSError: 68019 Authentication Failed. ............... 85 7.1.2 [nQSError: 75006] Failed to send MAIL command. Authentication required . 85 Open and Closed Issues for this Deliverable ........................................................................... 86
7
8