利用 Oracle BI Apps 扩大实施-减少风险

Click to edit Master text styles,Second level,Third level,Fourth level,Fifth level,Click to edit Master title style and Second Line Like This,利用,Oracle BI Apps,扩大实施，减少风险,钟振华,Aaron Zhong,Oracle BI Sales Consultant,议程,客户到底需要什么？,Oracle BI Apps,概述,跨系统的，预置方式,BI Apps,的机会在哪里？,议程,客户到底需要什么？,Oracle BI Apps,概述,跨系统的，预置方式,BI Apps,的机会在哪里？,客户需要的：,1,） 完整的产品之外，还需要完整的内容,客户的反馈：,DW/BI,系统产品架构,那数据仓库的模型怎么建立呢？,ETL,过程好像设计很复杂，有什么最佳实践吗？,前端展现的报表内容和,KPI,有没有什么好的建议呢？,客户需要的：,1,）完整的产品之外，还需要完整的内容,2,）需要能跨不同系统的预置分析模型,客户的反馈：,现有的包含内容的方案（举例）,SAP BW,独立系统之上的报表系统,EBS + Discoverery,我们公司除了,EBS/SAP,，之外还有其他系统怎么办？,我们很多报告的数据要从不同系统里面才能取到的，怎么办？,客户,发票,、,订单,服务客户,把握机会,寻找机会,生成线索,生成订单,创建分类,举办活动,管理列表,收款,登记订单,发货,企业赖以生存和发展的价值流程,以客户为中心的联系到创造收益流程,客户,订单管理,联系中心,销售,销售,销售,订单收集,市场营销,市场营销,市场营销,财务,订单管理,订单管理,以客户为中心的联系到现金流程,Oracle BI,应用是一个跨企业业务系统的分析应用,客户需要的：,1,）完整的产品之外，还需要完整的内容,2,）需要能跨不同系统的预置分析模型,3,）和业务流程的配合是新的亮点,客户的反馈：,销售分析,市场营销分析,服务和联系中心分析,通过增强的交叉销售将服务呼叫转换成销售,提高商机可见度和预测准确性,实时了解活动执行情况、结果和,ROI,财务分析,HR/,劳动力分析,供应链分析,优化供应商来源、供应商绩效和库存级别,财务状况的实时视图以及成本和盈利能力的动因,了解促进员工效率和机构绩效的动因,我们的系统还能有什么亮点吗？,企业绩效优化的下一级别,“,商务智能,(BI),正在进入业务流程领域,，它不仅使用户的信息体验更加有效，还允许进行业务流程优化。,”,软件宏观趋势：重整企业软件, 2005,年,9,月,Verify Supplier Payable Status,PCS Computing: Analytics in Action,Identify Problem w/ Revenue,1,Locate Substitute Product,Source Additional Parts,4,3,Execute Multichannel Sales Campaign,Problem with Invoice & Backlog,2,10,Sales,Finance,Marketing,Contact,Center,Supply,Chain,5,Identify Overstocked Laptops,6,Create Campaign for Overstock,7,Ensure Campaign Readiness,8,Monitor Contact Center Performance,11,Address Agent Retention issue,9,Workforce,Oracle,企业绩效管理系统,商务智能基础平台,OLTP,和,ODS,系统,数据仓库,数据中心,SAP,、,Oracle,、,Siebel,、,PeopleSoft,、自定义,Excel,XML,业务,流程,Essbase,财务绩效管理应用程序,BI,应用程序,融合中间件,Web,办公室,桌面,移动设备,议程,客户到底需要什么？,Oracle BI Apps,概述,跨系统的，预置方式,BI Apps,的机会在哪里？,Oracle,的产品策略,集成的商务智能数据库,在数据库中集成了商务智能和数据挖掘功能,集成的商务智能工具,同类最佳的下一代商务智能技术平台,集成的分析应用程序,特定于行业的企业级分析和公司绩效管理应用程序,可利用任何信息技术环境,Oracle BI,应用产品,基于,OBIEE,构建的单源或多源分析应用程序,在,Oracle BI EE Suite,上建立的,Oracle BI Apps,Prepackaged Hierarchies, Drill Paths, Security,Prebuilt,dashboards, reports, guided navigations,Common Enterprise Information Model,Multidimensional Calculation and Integration Engine,Intelligent Caching Services,Intelligent Request Generation and Optimized Data Access Services,Based on industry and analytic best practices,销售,服务和联系中心,市场营销,订单管理和执行,供应链,财务,人力资源,Oracle BI,应用产品,即席分析,预先,检测,和警报,MS Office,插件,报告并,发布,交互式,信息板,离线,分析,Web,服务,打包的,ETL,映射,通用适配器,IVR,、,ACD,、,CTI,Hyperion,MS Excel,其它数据源,数据仓库模式,Oracle,的预建,BI,应用程序降低了复杂性,为客户的多应用程序环境提供更好的洞察力,信息板,“,可见”,“,管线”,“,隐藏在内部”,多个应用程序和数据转换,的映射都需要专业知识和时间,构建,BI,解决方案所需的步骤,需要大量的投资、技能和时间,许可一个,ETL,工具，将数据从操作系统移到该数据仓库,许可交互式用户访问工具,许可,/,创建信息传递工具,研究,/,了解每个用户社区的分析需求,设置用户安全性和可见性规则,执行,QA,和性能测试,管理进行中的更改,/,升级,详细了解操作数据源,为每个数据源构建,ETL,计划,为每个受众构建分析,按主题领域设计数据仓库,构建,BI,解决方案所需的步骤,需要大量的投资、技能和时间,许可一个,ETL,工具，将数据从操作系统移到该数据仓库,许可交互式用户访问工具,许可,/,创建信息传递工具,研究,/,了解每个用户社区的分析需求,设置用户安全性和可见性规则,执行,QA,和性能测试,管理进行中的更改,/,升级,详细了解操作数据源,为每个数据源构建,ETL,计划,为每个受众构建分析,按主题领域设计数据仓库,这些步骤需要多种不同的,BI,和,DW,技术,投资,构建,BI,解决方案所需的步骤,需要大量的投资、技能和时间,许可一个,ETL,工具，将数据从操作系统移到该数据仓库,许可交互式用户访问工具,许可,/,创建信息传递工具,研究,/,了解每个用户社区的分析需求,设置用户安全性和可见性规则,执行,QA,和性能测试,管理进行中的更改,/,升级,详细了解操作数据源,为每个数据源构建,ETL,计划,为每个受众构建分析,按主题领域设计数据仓库,这些步骤需要多种不同的,BI,和,DW,技术,投资,这些步骤需要具有专业,技能,的,IT,或,BI,员工资源,构建,BI,解决方案所需的步骤,需要大量的投资、技能和时间,这些步骤需要多种不同的,BI,和,DW,技术,投资,许可一个,ETL,工具，将数据从操作系统移到该数据仓库,许可交互式用户访问工具,许可,/,创建信息传递工具,这些步骤需要花费,时间,来了解并完善学到的最佳实践知识,研究,/,了解每个用户社区的分析需求,设置用户安全性和可见性规则,执行,QA,和性能测试,管理进行中的更改,/,升级,这些步骤需要具有专业,技能,的,IT,或,BI,员工资源,详细了解操作数据源,为每个数据源构建,ETL,计划,为每个受众构建分析,按主题领域设计数据仓库,BI Approaches: Tools vs Applications,Federated Data Sources,Siebel,Oracle,SAP R/3,PSFT,EDW,Other,ETL,DW,Oracle BI Platform,& Metadata,BI content,Comparison Points,Prebuilt BI Applications Approach,Tools & Build Approach,BI Content,Metadata,Data Warehouse,ETL,Oracle BI,应用产品,完整、预建的最佳实践,BI,解决方案,旅游和运输,汽车,通信和媒体,复杂的,制造业,消费部门,能源,金融服务,高科技行业,保险,和医疗,生命科学,公共部门,其它运营和分析来源,Oracle BI,套件企业版,预置适配器：,销售,服务和联系中心,市场营销,订单管理和执行,供应链,财务,人力资源,流水线分析,三角预测,销售团队有效性,追加销售,/,交叉销售,周期分析,线索转换,员工生产效率,薪酬分析,HR,税务报表,劳动力配备,人员流动趋势,人力资本回报,A/R,与,A/P,分析,GL/,资产负债表分析,客户与产品的收益率,P&L,分析,支出管理,现金流分析,供货商绩效,支出分析,采购周期,库存可用性,员工花费,BOM,分析,订单流水线,订单,vs.,可用库存,周期分析,积压分析,执行状态,客户应收款,活动记分卡,响应率,产品倾向,忠诚度和流失率,市场篮子分析,活动,ROI,客户流失倾向,客户满意度,解决率,服务代表有效性,服务成本分析,服务趋势,Sales Analytics Product Components,Pre-mapped metadata, including embedded best practice calculations and metrics for the sales organization.,Presentation Layer,Logical Business Model,Physical Sources,3,Pre-built ETL to extract data from over 3,000 operational tables and load it into the DW, sourced from Oracle BI EE CRM, back office ERP systems and other sources.,2,Pre-built warehouse with 12 star-schemas designed for analysis and reporting on sales data.,1,A “best practice” library of over 250 pre-built intelligence dashboards, reports and alerts for sales representatives, analysts, managers and executives,4,To:,技术用户,Prebuilt ETL to extract data from over 3,000 operational tables and load it into the DW, sourced from CRM systems, call center telephony middleware and other sources,1,Service Analytics utilizes ETL routines that extract data from 2,000+ operational tables and load it into 15 star-schemas available for immediate analysis,2,Pre-mapped metadata, defining real-time access to analytical and operational sources, embedded best practice calculations and metrics for the contact center,3,A “best practice” library of over 150 prebuilt role-based intelligence dashboards, reports and alerts for service and contact center agents, managers and executives,4,Business Analytics,Warehouse,Presentation Layer,Logical Business Model,Physical Sources,Service and Contact Center Analytics,Prebuilt ETL to extract data from over 3,000 operational tables and load it into the DW, sourced from HCM systems, and other sources,1,HR Analytics utilizes ETL routines that extract data from 2,000+ operational tables and load it into 3 star-schemas available for immediate analysis,2,Pre-mapped metadata, defining real-time access to analytical and operational sources, embedded best practice calculations and metrics for the HCM practitioner,3,A “best practice” library of over 150 prebuilt role-based intelligence dashboards, reports and alerts for HR Managers. Analysts and Business Unit Executives,4,Business Analytics,Warehouse,Presentation Layer,Logical Business Model,Physical Sources,Oracle Human Resources Analytics,Pre-mapped metadata, including embedded best practice calculations and metrics for the sales organization.,Presentation Layer,Logical Business Model,Physical Sources,3,Pre-built ETL to extract data from over 3,000 operational tables and load it into the DW, sourced from ERP systems and other legacy sources.,2,A “best practice” library of over 250 pre-built intelligence dashboards, reports and alerts for sales representatives, analysts, managers and executives,4,Pre-built warehouse with over 20 star-schemas designed for analysis and reporting on sales, fulfillment and receivables data.,1,Oracle Order Management and Fulfillment Analytics,ETL & Business Adapters,CRM,Legacy,OM,OM,Financial,HR,POS,Legacy,Inventory,Other Supply Chain Systems,Operational Systems,Business Analytics,Warehouse,Pre-mapped metadata, including embedded best practice calculations and metrics for Supply Chain, Supplier, and other Business Users.,Presentation Layer,Logical Business Model,Physical Sources,3,Pre-built ETL to extract data from over 3,000 operational tables and load it into the DW, sourced from SAP, PSFT, Oracle Applications and other sources.,1,A “best practice” library of over 125 pre-built metrics, Intelligent Dashboards, Reports and alerts for Buyers, Cost center Managers, Suppliers, Supplier AP Managers and Supply Chain Executives,4,Pre-built warehouse with more than 15 star-schemas designed for analysis and reporting on Supply Chain Analytics,2,Oracle Supply Chain Analytics Product Components,ETL & Business Adapters,CRM,VMI,Supply Chain,Financial,HR,POS,Demand,Planning,Other Supply Chain Systems,Operational Systems,Business Analytics,Warehouse,Pre-mapped metadata, including embedded best practice calculations and metrics for Financial, Executives and other Business Users.,Presentation Layer,Logical Business Model,Physical Sources,3,Pre-built ETL to extract data from over 3,000 operational tables and load it into the DW, sourced from SAP, PSFT, and other sources.,2,A “best practice” library of over 350 pre-built metrics, Intelligent Dashboards, Reports and alerts for CFO, Finance Controller, Financial Analyst, AR/AP Managers and Executives,4,Pre-built warehouse with more than 15 star-schemas designed for analysis and reporting on Financial Analytics,1,Oracle Financial Analytics Product Components,Oracle BI,应用产品,完整、预建的最佳实践,BI,解决方案,旅游和运输,汽车,通信和媒体,复杂的,制造业,消费部门,能源,金融服务,高科技行业,保险,和医疗,生命科学,公共部门,其它运营和分析来源,Oracle BI,套件企业版,预置适配器：,销售,服务和联系中心,市场营销,订单管理和执行,供应链,人力资源,流水线分析,三角预测,销售团队有效性,追加销售,/,交叉销售,周期分析,线索转换,员工生产效率,薪酬分析,HR,税务报表,劳动力配备,人员流动趋势,人力资本回报,供货商绩效,支出分析,采购周期,库存可用性,员工花费,BOM,分析,订单流水线,订单,vs.,可用库存,周期分析,积压分析,执行状态,客户应收款,活动记分卡,响应率,产品倾向,忠诚度和流失率,市场篮子分析,活动,ROI,客户流失倾向,客户满意度,解决率,服务代表有效性,服务成本分析,服务趋势,财务,A/R,与,A/P,分析,GL/,资产负债表分析,客户与产品的收益率,P&L,分析,支出管理,现金流分析,所有销售职责都能从“指导性”的洞察力中获益,销售经理,销售高管,管理市场机会和销售覆盖度,管理全面销售的绩效以及和目标直接的距离,基于实际绩效层级在关键技术领域指导销售团队,管理销售额预期，通过丰富的对销售管道机会和历史销售绩效的洞察力,确认和管理销售通道中的关键机会,确认基于过去采购记录，此客户最可能购买的情况,销售代表,销售代表需要的洞察力,目标,探测,交叉销售和扩大销售,管理自己的销售地域和预期的准确性,客户关怀,用户采集和联盟,Oracle,商务智能应用 “最佳实践” 分析,My Top Leads (by quality, revenue opportunity, etc.),My Competition by Product Line and Account,My Cross-Sell Candidates,My Next Product Most Likely to be Sold,My Products Most Likely to be sold Together,My Discounting Recommendations,My Pipeline Health,My Forecast and Actual versus Quota,My Overdue Activities by Type, Account, Opportunity,My Personal Report Card,My Customers Order and Discount History,My Customers Recency and Frequency,My Customers Service Request History and Open SRs,My Customer Satisfaction Scores,My Accounts that need Coverage,My Outdated Information (Opportunities that need updated),My Information Completeness (Accounts and Contacts missing key information),Sales Representatives can quickly gain insight into who they should be selling to; what they should be selling; and what opportunities they should focus on.,目标,员工效率,市场，产品和销售活动的效率,销售预期,用户采集和联盟,销售经理需要的洞察力,Oracle,商务智能应用 “最佳实践” 分析,Activities by Employee and Activity Type,Subordinate Report Card,Discounting by Subordinate,Change in Forecast by Subordinate,Health of the Pipeline,Opportunity Revenue by Lead Qualify,Win/Loss Rate by Competitor, Product and Subordinate,Customer Satisfaction,Forecast and Actual versus Quota,Expected Revenue Analysis,Opportunity Revenue by Sales Stage,Detail Forecast by Product and Vertical,System Adoption by Employee,Employee Alignment with Sales Process (Account Coverage, Opportunity Updates, etc.),Sales managers can quickly determine the overall health of their teams pipeline; retrieve accurate forecasts; and identify problem areas in their team that need their attention.,目标,员工效率,市场，产品和销售活动的效率,销售预期,用户采集和联盟,销售高管需要的洞察力,Oracle,商务智能应用 “最佳实践” 分析,Subordinate Report Card,Discounting Trends and Impact on Revenue,Bottom n% of Sales Representatives,Forecast Accuracy,Health of the Pipeline,Opportunity Revenue by Marketing Campaign,Win/Loss Rate by Competitor, Product and Vertical,Opportunity Cost,Customer Satisfaction,Forecast and Actual versus Quota,Worst-Expected-Best Analysis,Expected Revenue Analysis,Detail Forecast by Product and Vertical,Order Revenue versus Compensation,System Adoption by Team and Individual Employees,Team Alignment with Sales Process (Account Coverage, Opportunity Updates, etc.),Understanding key user adoption trends and comparisons,Sales Executives can quickly assess the overall health of the pipeline; the health of different market segments; top and bottom performers; etc. and can rapidly adjust the sales process while its occurring, not after the fact.,Whats in Sales Analytics 7.9,7 Role-based Dashboard Pages,Sales Executive & Managers,Competitor - Team,Customer - Team,Demand Generation - Team,Sales Effectiveness - Team,Sales Representatives,My Accounts,My Pipeline,My Forecast,5 Functional Dashboards,Competitor,Overview,Details,Product,Heat Map,Demand Generation,Overview,Results,Lead Management,Pipeline,Overview,Forecasting,Details,Sales Effectiveness,Overview,Forecast Accuracy,Product,Customer,Overview,Account Summary,Products,No. of dashboards5,No. of dashboard pages23,No. of reports134,No. of metrics560,Overview,Forecasting,Details,My Pipeline,My Forecast,Pipeline Dashboards,The Pipeline Dashboards have been designed to provide a full and detailed insight into the organizations sales pipeline and forecast. The pre-built analysis helps Sales Executives, Managers and Representatives quickly identify pipeline and forecasting shortfalls and proactively address these issues.,Analysis of historical pipeline characteristics to support concrete coaching & performance management,Provides sales representatives with insights into their personal forecast. This enables them to identify issues on their own without the need for managements involvement,Provides sales representatives with insights into their personal pipeline. This enables them to identify issues on their own without the need for managements involvement,Deeper insight into the current quarter forecast and modifications that require immediate attention,Insight into the overall health of the organizations pipeline and forecast.,Pipeline,Purpose:,Shows the user his current pipeline,Shows real-time opportunity revenue versus quota by sales stage for the user,User Focus:,Sales Executives, Managers and Representatives,Location:,Dashboard Pipeline,Page Overview / My Pipeline,Source:,Sales CRM Forecasting Subject Area,Purpose:,Shows the user how his subordinates are doing in report card format,Shows the number of open opportunities, average days open, average deal size and revenue by subordinate,User Focus:,Sales Managers,Location:,Dashboard Pipeline,Page Overview,Source:,Sales CRM Pipeline Subject Area,Pipeline Scorecard,Forecast and Actual versus Quota,Purpose:,Shows the user where he stands with respect to quota based on his forecast and the actual revenue he has produced so far in the quarter,Shows forecast and order revenue versus quota over time for the user,User Focus:,Sales Executives, Managers & Representatives,Location:,Dashboard Pipeline,Page Overview / My Pipeline,Source:,Sales CRM Forecasting Subject Area,基于角色的仪表板,分析流程,指导导航链接,安全,/,可视化,警告和主动发送,从逻辑到物理的抽象层,计算和度量定义,可视化和个性化,动态,SQL,生成,高并行度,多级架构和灵活的定制,模块化部署,抽象数据模型,一致性维度,异构数据源支持,数据库针对性索引,Oracle,商务智能应用架构,Administration,Metadata,Oracle BI Presentation Services,Dashboards by Role,Reports, Analysis / Analytic Workflows,Metrics / KPIs,Logical Model / Subject Areas,Physical Map,Oracle BI Server,Direct Access to Source Data,Data Warehouse /,Data Model,ETL,Load Process,Staging Area,Extraction Process,DAC,Federated Data Sources,Siebel,Oracle,SAP R/3,PSFT,EDW,Other,ETL,概述,Administration,Metadata,Oracle BI Presentation Services,Dashboards by Role,Reports, Analysis / Analytic Workflows,Metrics / KPIs,Logical Model / Subject Areas,Physical Map,Oracle BI Server,Direct Access to Source Data,Data Warehouse /,Data Model,DAC,Federated Data Sources,Siebel,Oracle,SAP R/3,PSFT,EDW,Other,获取,/,加载数据的三种方式,批量,ETL,低延迟,ETL,从数据源直接到,Oracle BI,服务器,对于提取，统一的过渡层和加载分层设计的,ETL,提供隔离，模块化和可扩展性,能支持源系统版本快速变化,能通过补充适配器进行扩展,支持缓慢变化维度,高性能的架构,所有的数据映射都是增量抽取的,高度优化和并行的加载,支持所有数据库的批量加载,Datawarehouse Application Console (DAC),应用管理，执行和监控,ETL,Load Process,Staging Area,Extraction Process,DAC,Administration,Metadata,Oracle BI Presentation Services,Dashboards by Role,Reports, Analysis / Analytic Workflows,Metrics / KPIs,Logical Model / Subject Areas,Physical Map,Oracle BI Server,Direct Access to Source Data,Data Warehouse /,Data Model,DAC,Federated Data Sources,Siebel,Oracle,SAP R/3,PSFT,EDW,Other,ETL,Load Process,Staging Area,Extraction Process,DAC,ETL,概述,Load,Extract,SAP,PeopleSoft,Source Independent Layer,Staging Tables,Extract,Other,Siebel,OLTP,Oracle,Power,Connect,Power,Connect,SQL,SQL,SQL,SQL,App Layer,ABAP,App Layer,Oracle Data,Warehouse,物理数据模型概述,包含一致性维度的模块化企业范围的数据仓库的数据模型,销售，服务，市场推广，分销，财务，劳动力，经营和采购,从多个数据源整合数据,代码的标准化,实时性,交易数据能存储在受欢迎的层度,能跟踪历史变迁,支持多货币，多语言,对,Oracle,，,SQL Server,，,IBM UDB/390,，,Teradata,进行优化,Administration,Metadata,Oracle BI Presentation Services,Dashboards by Role,Reports, Analysis / Analytic Workflows,Metrics / KPIs,Logical Model / Subject Areas,Physical Map,Oracle BI Server,Direct Access to Source Data,ETL,Load Process,Staging Area,Extraction Process,DAC,Federated Data Sources,Siebel,Oracle,SAP R/3,PSFT,EDW,Other,Data Warehouse /,Data Model,特点,:,一致性维度,颗粒度交易数据,跟踪所有的历史信息,预置和可快速扩展,集成的企业分析数据模型,优点,:,企业范围内的业务分析,(,跨整个价值链,),能总汇总的信息一直分析到详细信息,准确的历史分析,Service,Customers,Sales,Marketing,Distribution,Finance,HR / Workforce,Operations,Procurement,Customers,Customers,Suppliers,Suppliers,Suppliers,选定的业务分析仓库的主要实体,一致的维度,客户,产品,供应商,内部组织,客户地点,客户联系人,GL,帐户,员工,销售代表,服务代表,合作伙伴,宣传活动,提供的内容,成本中心,利润中心,销售,商机,报价,渠道,订单管理,销售订单行,销售计划行,登记,提货行,帐单,积压,市场营销,宣传活动,响应,营销成本,供应链,采购订单行,采购申请行,采购订单收据,库存余量,库存处理,财务,应收款,应付款,总帐,COGS,呼叫中心,ACD,事件,代表活动,联系人-代表快照,目标和基准,IVR,导航历史,服务,服务请求,活动,协议,劳动力,报酬,员工档案,员工事件,制药,处方,联合的市场数据,财务,财务资产,保险索赔,公共部门,利益,案例,事件,线索,模块化,DW,数据仓库数据模型包括：,350,个事实表,550,个维表,5,200,个预建量度,（,2,500+,个是派生量度）,15,000,个数据元素,销售订单行,销售订单详细信息,EAI,ETL,客户地点,采购方,/,收货方,/,收款方,日期,付款条件,销售渠道,产品,制造,/,销售,/,供应商,员工,客户,地点,工厂,/,制造,发货,/,存放,销售组织,示例量度,取消的订单行数量,客户数量,新客户数量,订单行数量,订单数量,产品数量,退回的订单行数量,订单折扣百分比,每个订单的产品平均数量,平均订单大小,取消的金额,/,数量,订单到登记成交率,未结的登记金额,/,数量,订单合计金额,/,数量,合计退回金额,/,数量,特性,包含,27,个逻辑维和,33,个现成量度,提供了详细分析销售订单行的功能,在事务级别和行级别存储数据,示例：销售订单行事实表,业务流程一致性,应收账款进程,标准仓库代码,Oracle,PSFT,SAP,Invoice,Invoice and Payment Schedules,Invoice items,AR documents with DR document type,CR Memo/DR Memo,CR Memo and DR Memo,CR Memo and DR Memo items,AR documents with DA document type,Payments,Cash Receipts etc.,Payments/ Deposits,AR documents with DA document type and A as special indicator,Payment Applications,Cash/CR Memo applications/Adjustments,Payment Item Activities,AR documents with DZ document type,Other,All other types of transactions,BI/AR: All other types of items,All other types of AR documents,业务流程一致性,标准化的仓库代码,所有源交易类型码值被储存并附与标准化仓库码,所有更高层次的体系结构中都使用相同的标准化仓库码,存放源交易类型码价值观，使分析能集成到每个交易系统,TYPE,CODE,TYPE_DESC,WAREHOUSE CODE,O,Credit memo,Credit Memo,4,Credit memo list,Credit Memo,S,Credit memo cancellation,Credit Memo Cancellation,P,Debit memo,Debit Memo,6,Intercompany credit memo,Intercompany Credit Memo,5,Intercompany invoice,Intercompany Invoice,N,Invoice cancellation,Invoice Cancellation,U,Pro forma invoice,Pro forma Invoice,3,Invoice list,Standard Invoice,M,Invoice,Standard Invoice,TYPE CODE,TYPE_DESC,WAREHOUSE CODE,Credit Memo,Credit Memo,Credit Memo,On-Account Credit,On-Account Credit,Credit Memo,Debit Memo,Debit Memo,Debit Memo,Debit note,Debit note,Debit Memo,Invoice,Invoice,Standard Invoice,Contra,Contra,Standard Invoice,BI,服务器档案库概述,Administration,Metadata,Oracle BI Presentation Services,Dashboards by Role,Reports, Analysis / Analytic Workflows,Direct Access to Source Data,Data Warehouse /,Data Model,ETL,Load Process,Staging Area,Extraction Process,DAC,Federated Data Sources,Siebel,Oracle,SAP R/3,PSFT,EDW,Other,多层抽象,分离的物理，逻辑和展现层,逻辑建模是建立在一个复杂的物理数据结构之上,逻辑模型独立于物理数据源，即同样的逻辑模型可以,remapped,很快到另一个数据源,度量,/ KPIs,多道复杂的计算度量（跨越多个事实表）,一个合乎逻辑的事实，可以跨几个表的来源包括碎石和实时分割,基于层次的度量,