OracleDiscoverer培训.ppt

Create EUL Create Business area 在Business area下存放的是flod 通常做法是安照ERP模块的结构去建Business area 在建立Business area时可以把此模块的table一起 建立,这就是基于DB的flod,则这些flod在建立时里 面的字段和DB的字段是一样的. r Create calculated items Create joins Create conditions Create complex folders 常用 SQL 函数 例:计算员工的薪水范围 Registering PL/SQL Functions Registering PL/SQL Functions by Using Import Creating a New Join Creating a Multi-Item Join Creating a Complex Folder Assigning Items to Complex Folders Custom Folders Editing a Custom Folder Describe drill facilities Create an item hierarchy Create a drill-to-detail item class Create a hyperdrill plug-in Create a date hierarchy Create a nonstandard calendar Drilling Down for Detailed Data Creating an Item Hierarchyby Using the Hierarchy Wizard Creating an Item Hierarchyby Using the Hierarchy Wizard Maintaining Item Hierarchies Create a new hierarchy Edit a hierarchy Delete a hierarchy Setting the Repository User Property Setting Up Scheduled Workbook Privileges and Limits Editing a Scheduled Workbook Unscheduling a Workbook 把一些不再使用的文件删除 当复合文件的源文件被删除后,把那些复合文件也删除 当TABLE或VIEW的ITEM不存在时把这些ITEM从文件 中删除 当TABLE有新的ITEM时在文件中添加上 如果有新的连接条件添加新的连接 Managing Folders  Deleting a Business Area Refine relational structure 1 2 3 4 Administration Edition Creating Drills Administration Edition Expand Replace Administration Edition 1 2 Administration Edition Discoverer Plus Edition 3 Administration Edition Administration Edition Administration Edition Administration Edition Administration Edition Administration Edition Maintaining the End User Layer Administration Edition Administration Edition Administration Edition * 广州赛意企业管理咨询有限公司 http://www.chinaSIE.com SIE Consulting Co., Ltd Oracle Discoverer 该资料来源于互联网，更多erp资料请关注　 陈海浬 2006年3月 赛意咨询 http://www.chinaSIE.com 内容 Discoverer 介绍 概念介绍 安装事项 Administration Edition 内容 赛意咨询 http://www.chinaSIE.com Discoverer 介绍 Discoverer是直接基于数据仓库关系型数据库进行分析的ROLAP工具 什么是Discoverer? 赛意咨询 http://www.chinaSIE.com Discoverer 介绍 它是一个直观的随意