Oracle Hyperion Smart View培训
Oracle Hyperion Planning 产品说明书
Oracle Hyperion PlanningOracle Hyperion Planning is an agile planning solution that supports enterprise wide planning, budgeting, and forecasting using desktop, mobile and Microsoft Office interfaces. It provides a robust modeling framework that helps develop reliable financial forecasts based on sales and operational assumptions to produce cost effective enterprise alignment. With Oracle Hyperion Planning, you have a solution that is best in class and proven in the market place to provide timely, actionable plans to help make informed business decisions. Oracle Hyperion Planning can be deployed on-site or in the Cloud.K E Y B U S I N E S S B E N E F I T S• Reduce budgeting and planning cycles by weeks or months• Improve forecast reliability• Appeal to a wider user community through an intuitive Web user interface• Provide familiar user interface for users with full Microsoft Office integration• Reduce planning cycles with anywhere, anytime mobile• Eliminate time lag between when plans are updated and reports are refreshed• Reduce cost of ownership through superior application deployment, management tools and packaged data integration• Lay the foundation for making the transition to Enterprise Business Planning Streamline Enterprise-wide Planning and Budgeting ProcessEnterprise alignment is challenging to achieve in financial plans due to disconnect between the office of finance and sales and operational business units. Financial planning and forecasting often ends up being a resource and time consuming process of gathering information spread across a multitude of disconnected spreadsheets or point solutions used by the office of finance and various sales and operational business units.Oracle Hyperion Planning provides the required agility to the enterprise planning process by quickly aligning financial plans, models and forecasts across cost centers and lines of business thus enabling decisions to be made at a speed which business demands. The impact of changes to key plan drivers and assumptions can be evaluated instantaneously, and revisions made available immediately to all stakeholders without the reliability risks from manual interventions. Oracle Hyperion Planning has built in time intelligence and allocation logic and comes with a powerful calculation engine that can be used to express a range of business requirements, from simple arithmetic formulae to complex allocations. Oracle Hyperion Planning offers guided task flows and supports both bottom-up and top-down agile planning processes. Its robust workflow capabilities support efficient review and approval processes.Ensure Reliability with Predictive Planning and Rolling ForecastsCompanies today are faced with a rapidly changing business environment. Constantly changing market dynamics can bring in demand, supply and price fluctuations that require decisions based on alternate outcomes. A key need to make informed decisions in such a market is to be able to understand the financial impact of key business driversand revise forecasts reliably and quickly.K E Y F E A T U R E S• Hybrid data model facilitates planning, analysis and commentary • Flexible workflow capabilities• Reliability with predictive planning capabilities• Seamless Microsoft Office integration • Collaboration and alignment with easy to use mobile friendly web interface• Built in reporting and dashboards • Proven and scalable architecture • Robust integration with ERP sources with drill back• Enterprise grade deployment and backups• Agility with full mobile planning and workflow capabilities• Instant calculations and fast aggregations Oracle Hyperion Planning provides sophisticated predictive planning capabilities that can generate reliable statistical predictions based on time series data over long periods of history while capturing seasonality impacts along the way thus enabling forecasts to be more reliable. Oracle Hyperion Planning also provides on the fly what if modeling capabilities for planners to assess the impact of various combinations of business assumptions on key financial outcomes. To facilitate planners’ ability to revise business and market impacts on forecasts quickly, Oracle Hyperion Planning comes out of the box with rolling forecast capabilities that makes the whole planning process even more agile from the get go.Collaborative Planning within an Intuitive Scalable Web InterfaceOracle Hyperion Planning enables business users to concurrently collaborate on their plans and report in an easy to use mobile friendly web interface with instant calculation and dynamic fast aggregation for large volumes of data making it perfectly suited for enterprise grade deployments. It is built with device form factor in mind with intuitive navigation enabling users manipulate and adjust plans drivers, or perform allocation and spread actions across multiple data intersections. For sophisticated users, Oracle Hyperion Planning supports advanced yet intuitive ad-hoc modeling capabilities to quickly zoom in to relevant data intersections using pivot and drill capabilities. It provides guided task flows for less-frequent users’ intuitive guidance. This ensures that everyone can participate in the planning process.Figure 1: The intuitive mobile friendly web interface of Oracle Hyperion Planningcombines task flows, templates and ad-hoc models, dashboards and reportsEnhance Productivity with Full Microsoft Office Suite IntegrationOracle Hyperion Planning leverages Oracle Hyperion Smart View for Office as the Microsoft Office interface allowing for planning actions within Outlook, Excel, Word and PowerPoint with built in prediction capabilities. Users can take all actions and engage in a collaborative planning process while working within the comfort of Microsoft Excel.Modeling in Excel during the planning phase is facilitated with sophisticated ad hoccapabilities where rows, columns and other axis can be pivoted on the fly to view the information from different points of view for quick analysis and forecasting. Common planning actions, such as spreading and allocation, are provided as context sensitive menus within input templates rendered within Microsoft Excel.Creating customized input templates in Oracle Hyperion Planning is very simple. Users can create input grids and format them using familiar Excel font and number formats and on the click of a button generate input templates targeted at specific business units. Additionally, users can seamlessly move planning data across Excel, PowerPoint and Microsoft Word. This allows the creation of customized dynamic reports and presentations with accurate information and users can refresh the document to automatically consume the collaborative changes in the underlying database. The end result is intuitive usability, reduced manual intervention, improved reliability, and increased agility.Figure 2: The built-in Microsoft Office integration in Oracle Hyperion Planning allows users to update, format and perform on the fly predictive modeling in Microsoft Office.Enable Agility with Mobile AccessBusiness users can perform common planning, budgeting and forecasting tasks with a fully functional browser based experience from their iOS, Android or Windows tablets. The commonly used features available via a tablet-optimized user experience include accessing task lists, viewing dashboards and reports, entering data and performing ad-hoc modeling. In addition workflow review and approvals processes can be executed on-the-go via the Oracle EPM Mobile App on iOS and Android phones. These mobilecapabilities help improve user productivity and reduce planning cycle times.Figure 3: A fully mobile optimized browser experience for tablets and desktops facilitates planning when you need and where you want.Integrate Planning and Management Reporting SeamlesslyReports and dashboards that display planning information can be created in minutes, and any changes made to the plans in Oracle Hyperion Planning are instantaneously reflected in the content of the reports and dashboards. Using the web interface, users can access user-friendly dashboards, interactive analytics, and richly formatted financial reports while interacting with the planning system. Users can create book reports for management reporting and these can be accessed on demand on a desktop or on mobile.Figure 4: Fully formatted reporting capabilities facilitate enterprise wide distributedreporting and quick generation of management book reports.Oracle Hyperion Planning’s powerful workflow functionality, including e-mail notifications, alerts, and dashboards, empowers users to track and communicate the progress of plans and budgets. Ownership of plans can be designated based on a specified intersection of key plan dimensions. Approval paths can be altered based on data changes to provide true matrix approval. When a planner “promotes” a plan for approval, the system can automatically identify the next approver. All of the above processes can also be performed in conjunction with what-if analysis and scenario testing that allows users to compare and contrast multiple scenarios prior to promoting the selected scenario for approval up the management chain.Figure 5: Flexible and powerful planning workflow capability allows sophisticated yet snappy review and approval processes with a new mobile application.Large Deployments with Scalable Architecture at Low Cost of OwnershipOracle Hyperion Planning is built to scale with the organization’s growth. It is based on hybrid architecture, which makes optimal use of relational and MOLAP technologies to facilitate a variety of planning needs including annotations and commentary which are essential for variance analysis. The scalable architecture enables organizations to start with an initially small deployment before extending it out to hundreds or thousands of concurrent users. The architecture allows for flexible data entry, analysis, and frequent real-time updates from anywhere, in a safe and secure environment.Moreover, Oracle Hyperion Planning provides collaborative planning processes and dependable, centralized user and data management, significantly reducing maintenance and distribution costs. Oracle Hyperion Planning interoperates with accepted user management systems to help ensure maintenance and security consistency.Robust Data Integration and DeploymentsOracle Hyperion Planning facilitates bidirectional data integration with ERP systems, legacy applications, data warehouses, and other enterprise data sources. The solutionO R A C L E E N T E R P R I S E P E R F O R M A N C E M A N A G E M E N T A P P L I C A T I O N SOracle enterprise performance management applications are an integrated, modular suite that supports a broad range of strategic and financial performance management processes and helps unlock business potential.R E L A T E D P R O D U C T SOracle enterprise performance management applications provide the following capabilities:• Strategy Management• Financial Close and Reporting• Planning, Budgeting and Forecasting • Profitability and Cost Management • Enterprise Data Governance is built to be flexible to the organization’s needs. All system artifacts and data can be imported and exported or for backups using flat files or using out of box mapping features. Users can drill back from their planning data into the details in their source systems. Deployments can be easily categorized as development, test and production environments with easy movement of data models across these environments for quick and fast deployments.Lay the Foundation for Enterprise Business PlanningOracle Hyperion Planning is the center piece of Oracle’s broader solution for Enterprise Business Planning. The Enterprise Business Planning process spans strategic planning, budgeting and forecasting, workforce planning, capital asset planning, project financial planning and other elements of operational planning that have a significant impact on financial performance. It also involves an ongoing evaluation of business costs and profitability analysis and uses those insights to drive change in business plans. In addition, Enterprise Business Planning can leverage predictive analysis and simulation techniques to constantly evaluate and quantify risk and uncertainty, inherent to all of these plans, and takes actions to mitigate those risks as appropriate.CO N TAC TU SFor more information about [insert product name], visit or call +1.800.ORACLE1 to speak to an Oracle representative.C O N N E C T W I T H U S/oracle/oracle/oracleCopyright © 2015, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. 0115。
oracle数据库培训课程大纲
oracle数据库培训课程大纲oracle数据库培训课程大纲Oracle 9i/10g课程大纲UNIT 1. 数据库基础及 SQL基础课程综述本课程适用于Oracle9i/10g 用户，将向学员提供数据服务器的扩展介绍。
课程涉及的概念包括面向关系和面向对象数据库，以及强大的SQL编程语言。
课程将向学员教授创建和维护数据库对象，以及存储、获取和操作数据。
同时学员将学会使用像ROLLUP、CUBE、Set运算符和分级获取等高级技术获取数据。
学员将学会使用iSQL*Plus工具编写SQL 和SQL*Plus脚本文件产生类似报表的示例和动手实践以增强基础概念。
内容纲要※ 数据库概述※ 编写基本的SQL语句※ 限制和排序数据※ 单记录函数※ 从多表中显示数据※ 使用Group函数聚合数据※ 编写子查询※ 使用iSQL*Plus产生只读输出※ 操作数据※ 创建和管理表※ 包含约束※ 创建视图※ 其它数据库对象※ 控制用户访问※ 使用Set运算符※ Oracle Datetime函数※ 对GROUP BY子句的增强※ 高级子查询※ 分级获取数据※ Oracle对DML 和DDL语句的扩展※ 使用PL/SQL developer,TOAD等专业软件查询管理数据库学员受益从事Oracle数据库服务器的数据操作和管理。
目标学员数据库管理人员、开发人员、测试人员、数据库最终用户。
学员条件有基本的操作系统使用经验，熟悉数据处理概念和技术。
课程天数3天UNIT 2. Oracle9i/10g 数据库管理基础 I课程综述Oracle 产品数据库管理员管理工业界最先进的信息系统和拥有业界最高薪水。
本课程是迈向成为一名Oracle专家的第一步，设计用于巩固熟悉基本的数据库任务。
学员将学会设计、创建和维护Oracle数据库。
学员将会了解Oracle数据库架构的基本概念，以及这些组件如何工作和相互交互。
学员将学会如何创建关系数据库和以一种有效和高效率的方式管理各种架构。
oracle培训教材
Installing your Oracle Software
Planning Your Installation
– What Oracle software are you installing? – Does the hardware involved meet the
• As a DBA, you must plan:
– The logical storage structure of the database and its physical implementation:
• How many disk drives do you have? What type of storage is being used?
– Memory requirements:
. 1 GB for the database instance with Oracle
Enterprise Manager Database Control
– Disk space requirements:
. 3 GB of swap space (based on 2 GB RAM) . 3.8 GB for the Oracle Database software . 1.7 GB for the preconfigured database (optional) . 3.4 GB for the fast recovery area (optional)
end-to-end backup solution for Oracle environments:
. Centralized tape backup management for file system data
2024年Oracle数据库培训
Oracle数据库培训Oracle数据库培训：全面提升您的数据库管理技能一、引言Oracle数据库作为全球领先的数据库管理系统，以其卓越的性能、可靠性和安全性，在各个行业中得到了广泛的应用。
为了帮助广大数据库管理员和开发人员更好地掌握Oracle数据库技术，我们特推出Oracle数据库培训课程。
本文将详细介绍本课程的目标、内容、培训方式及预期效果，帮助您全面了解Oracle数据库培训的相关信息。
二、培训目标1.理论与实践相结合：使学员掌握Oracle数据库的基本概念、体系结构、核心功能及高级特性，能够熟练运用Oracle数据库进行数据管理和维护。
2.提升技能水平：通过培训，使学员具备独立进行Oracle数据库安装、配置、优化、备份与恢复的能力。
3.适应企业需求：针对企业实际应用场景，培养学员具备解决实际问题的能力，提高企业数据库管理水平和业务运行效率。
4.考取Oracle认证：帮助学员顺利通过Oracle认证考试，获得Oracle认证数据库管理员（OCP）证书，提升个人职业竞争力。
三、培训内容1.Oracle数据库基础（1）Oracle数据库概述（2）Oracle数据库体系结构（3）SQL语言基础（4）PL/SQL编程2.Oracle数据库管理（1）数据库安装与配置（2）表空间与数据文件管理（3）用户、权限与角色管理（4）备份与恢复策略3.Oracle数据库性能优化（1）SQL优化（2）索引优化（3）分区技术（4）数据库监控与分析4.Oracle数据库高级特性（1）RAC集群技术（2）DataGuard物理备用数据库（3）GoldenGate实时数据复制（4）Oracle数据库安全策略四、培训方式1.面授课程：小班授课，面对面教学，方便学员与讲师互动交流，及时解答疑问。
2.实践操作：课程中安排大量实验环节，确保学员在实际操作中掌握Oracle数据库技术。
3.在线辅导：提供在线学习平台，学员可随时提问，讲师将在第一时间给予解答。
Oracle Hyperion Smart View for Office, Fusion Edit
Release 11.1.1.4.00Readme[Skip Navigation Links]About This Patch (1)Patch Type (1)Supported Paths to This Patch (1)Supported Platforms (2)Supported Languages (2)Release Compatibility (2)Defects Fixed in this Patch (3)Known Issues in this Patch (4)Documentation Updates (5)Accessing Hyperion Product Documentation (5)Connecting to Planning with an Ad Hoc Query (5)Installing this Patch (5)New Features (8)Accessibility Considerations (8)More Information (8)About This PatchThis Readme file describes the defects fixed in this patch and the requirements and instructions for applying this patch.Caution: You are urged to carefully read and understand the following requirements. Failure to comply may result in applying a patch that can cause your application to malfunction, includinginterruption of service and/or loss of data. Before installing or applying this patch:Verify that your system configuration (product version, patch level, and platform) exactly matches what is specified in the Readme.Patch TypeThis patch is a Patch Set Update (PSU) and it is a full installation of the product. It includes the Smart View PSU 11.1.1.3.500. Release 11.1.1.4.00 also provides a complete installation if you are not already starting from Release 11.1.1.x.”Supported Paths to this PatchYou can apply this patch to the following releases:9.3.311.1.1.311.1.1.3.500Supported PlatformsInformation about system requirements for EPM System products is now available in a spreadsheet format in the Oracle Hyperion Enterprise Performance Management System Certification Matrix.This matrix is posted at /technology/products/bi/hyperion-supported-platforms.html. System requirements are no longer part of the Oracle Hyperion EnterprisePerformance Management System Installation Start Here.Supported Client SoftwareMicrosoft Office 2003Microsoft Office 2007Microsoft Office 2010 (32 bit versions only)Supported Operating SystemsWindows 7Windows VistaWindows XP Professional SP 2Windows 2003 SP 1Windows 2008Supported LanguagesThis patch is localized. It includes the following languages: English, French, German, Spanish, Italian, Brazilian Portuguese, Japanese, Korean, Simplified Chinese, Traditional Chinese, Russian, Turkish, Danish, and Swedish.This release supports non-English languages. The list of supported languages for all EPM System products is included in the Oracle Hyperion Enterprise Performance Management SystemCertification Matrix, posted at /technology/products/bi/hyperion-supported-platforms.htmlRelease CompatibilityCompatibility MatrixThe two tables in this section provide the data source release numbers supported by Smart View11.1.1.4.00 Table 1 displays release number compatibility between Smart View 11.1.1.4.00 and datasources connected through Provider Services 11.1.1.x. Table 2 displays release compatibility between Smart View 11.1.1.x and data sources that are connected directly.See the Enterprise Performance Management System Installation Start Here for Provider Services installation information.Table 1: Smart View 11.1.1.4.00 Compatibility with Data Sources Connected through ProviderServices 11.1.1.xTable 2: Smart View 11.1.1.x Compatibility with Independent Data SourcesTop of Document Defects Fixed in this PatchIf you are coming from Release 11.1.1.0, 11.1.1.1, or 11.1.1.2, use the Defects Fixed Finder tool to review the list of defects fixed between those releases and Release 11.1.1.4. This tool is available here:https:///oip/faces/secure/km/DocumentDisplay.jspx?id=1292603.1Only administrators are able to create Smart Slices. Thesesecurity restrictions on Smart Slices have been removed:Create (or Add)ModifyRenameDeleteTop of Document Known Issues in this PatchThe following issues are the noteworthy known issues of this patch.Top of Document Documentation UpdatesAccessing Hyperion Product DocumentationThe most recent version of each Hyperion product guide is available for download from theDocumentation area of the Oracle Technology Network (OTN) Web site(/technology/index.html). Deployment-related documentation is also available from the Oracle E-Delivery Web site (/EPD/WelcomePage/get_form).Individual product guides are available for download on the Oracle Technology Network (OTN) Web site only.Note: Not all of the documentation for this product has been updated from Release 11.1.1.1, 11.1.1.2, or 11.1.1.3. Similarly, the product UI may not have been updated since these releases.Connecting to Planning with an Ad Hoc QueryIf you are upgrading from 9.3.x to 11.1.1.3 or 11.1.1.4, you may not be able to connect to Planning with an ad hoc query in Smart View. Workaround:Open the data form in 11.1.1.x Smart View. (11934262).1.Select Hyperion, and then Activate.2.Select Reset.3.Select Activate.4.Refresh.5.Save the connection in Favorites.Top of Document Installing this PatchThe section includes important information about installing this patch of Smart View.If you are upgrading from a Smart View version older than 11.1.1.4.00, you must perform thedeployment steps for data providers as described below.Financial ManagementOn the Financial Management provider machine, copy both smartview.exe and version.xml to the HFM\Web\HFMOfficeProvider\ folder and replace the corresponding files from your previousinstallation.If Always force client to upgrade (even when client and server are compatible) is enabled in the Financial Management Web Server Configuration Utility for Smart View, users can install on their client machine as follows:unch Excel and select Hyperion, then Connection Manager to connect to the FinancialManagement provider.2.On the Upgrade Smart View for Office dialog box, click Install Now.3.On File Download, click Run or Save.4.On Microsoft Office Excel, click Run.5.When prompted, close Excel and all other Microsoft Office applications, then click OK in theInstallation Warning to proceed.6.Close Excel and all other Microsoft Office applications.When the installation is complete, you may be prompted to restart your computer, after which you see a new version of Smart View in the Hyperion > About screen.Planning1.Rename the existing SmartView.exe (to create a backup) and copy the new SmartView.exe to thePlanning directory:Hyperion\products\Planning\bin\SmartView\SmartView.exe2.In Planning, select Administration, then Manage Properties, then System Properties andenter the following setting:For example:Restart the Planning server.Users are prompted to install Smart View 11.1.1.4.00:unch Excel and select Hyperion, then Connection Manager to connect to the Planningprovider.2.On the Upgrade Smart View for Office dialog box, click Install Now.3.On File Download, click Run or Save.4.On Microsoft Office Excel, click Run.5.Close Excel and all other Microsoft Office applications.When the installation is complete, you may be prompted to restart your computer, after which you see a new version of Smart View in the Hyperion > About screen.NOTE: New Smart View client version available may appear even after you upgrade. The workaround is to remove the entries from the Planning system database that were added inSystem Properties of the Planning system database and restart the Planning server.Provider ServicesOn the Provider Services machine, copy both smartview.exe and version.xml to the<SVP_HOME>\redist\ folder and replace the corresponding files from your previous installation.1.Open version.xml in the <APS_HOME>\redist\folder and replace the line, “” with:is the name of the computer on which Provider Services is installed, andis the port number on which Provider Services listens.For example:For Provider Services deployed on WebSphere 6.0.2 only, use the following example (note the = at the end of the line).=Note: To distribute Hyperion Visual Explorer, replace smartview.exe with smartviewHVE.exe in the<APS_HOME>\redist\ folder. Then rename smartviewHVE.exe to smartview.exe.Users perform the following steps on their client machines:unch Excel and select Hyperion, then Connection Manager and connect to Provider Services.2.From New Smart View Client version available, select Click here to install link.3.From File Download, click Run to start the installation.4.If a Microsoft Excel Security Warning dialog box is displayed, click Run.When prompted, close Excel and all other Microsoft Office applications, then click OK in the Installation Warning to proceed.6. In the Smart View installer, click Next to begin the installation, then follow the prompts.When the installation is complete, you may be prompted to restart your computer, after which you see a new version of Smart View in the Hyperion > About screen.Reporting and Analysis1.On the Reporting and Analysis Workspace web application server machine, copy bothSmartView.exe and version.xml to the BIPlus\AppServer\InstalledApps\workspace_static\SmartView folder and replace the corresponding files from your previousinstallation.2.Rename version.xml to SmartViewVersion.xml.Users perform the following steps on their client machines:unch Excel and select Hyperion, then Connection Manager to connect to Reporting andAnalysis.2.From Upgrade Smart View for Office, click Apply Now.3.From File Download, click Open to start the installation.4.Close Excel and all other Microsoft Office applications.When the installation is complete, you may be prompted to restart your computer, after which you seea new version of Smart View in the Hyperion About screen.Top of DocumentNew FeaturesInformation about system requirements for EPM System products is now available in a spreadsheet format in the Oracle Hyperion Enterprise Performance Management System Certification Matrix.This matrix is posted at /technology/products/bi/hyperion-supported-platforms.html. System requirements are no longer part of the Oracle Hyperion EnterprisePerformance Management System Installation Start Here.Top of DocumentAccessibility ConsiderationsAccess to Oracle SupportOracle customers have access to electronic support through My Oracle Support. For information, visit /pls/topic/lookup?ctx=acc&id=info or visit/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.Documentation AccessibilityFor information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at /pls/topic/lookup?ctx=acc&id=docacc.Top of DocumentMore InformationFor more information about Oracle Essbase; Oracle Hyperion Planning, Fusion Edition; Oracle Business Intelligence, Enterprise Edition; Hyperion Enterprise; Hyperion Shared Services; Oracle Hyperion Financial Management, Fusion Edition; Hyperion Reporting and Analysis; Oracle Crystal Ball, Fusion Edition, Oracle Essbase Visual Explorer, and Oracle Enterprise Performance Management Workspace, Fusion Edition, please see the relevant product documentation.Top of DocumentCopyright © 2011, Oracle and/or its affiliates. All rights reserved.。
2024版oracle系列培训ppt课件
Oracle PaaS服务为企业提供数据库、应用开发和集成、大数据分析等云平台，加速企业数字 化转型。
Oracle Cloud软件即服务（SaaS）
Oracle提供丰富的SaaS应用，如ERP、CRM、HCM等，满足企业不同业务需求，降低企业 运营成本。
Oracle在大数据处理中的应用实践
数据库安全管理
安全管理策略Leabharlann 阐述Oracle数据库的安全管理策略，包括用户权限管理、 角色管理、数据加密和安全审计等方面的内容。
数据加密与传输安全
讲解Oracle数据库的数据加密技术和传输安全机制，包括 透明数据加密（TDE）、SSL/TLS加密通信等，保障数据的 机密性和完整性。
用户与权限管理
详细介绍如何管理Oracle数据库的用户和权限，包括用户 的创建、授权和撤销等操作，确保只有授权用户才能访问数 据库资源。
TKPROF等，帮助管理员及时发 现和定位性能问题。
SQL优化
详细讲解SQL优化的方法和技巧， 包括SQL语句的编写规范、索引 设计原则、执行计划分析和优化 等，提高SQL语句的执行效率。
系统优化
提供系统层面的优化建议，包括 内存分配、磁盘I/O优化、网络 配置调整等，提升整个数据库系
统的性能表现。
的集合，是数据管理的高级阶段。
数据库的发展历程
02
从文件系统到层次、网状数据库，再到关系数据库和非关系数
据库。
Oracle数据库的特点与优势
03
高性能、高可用性、可扩展性、安全性等。
Oracle数据库体系结构
01
02
03
04
物理存储结构
数据文件、控制文件、重做日 志文件等。
O R A C L E Smart View用户手册说明书
F U S I O N E D I T I O NR E L E A S E11.1.2C ONTENTS I N B RIEFOverview (2)Smart View Panel (2)Context-Sensitive Ribbons (2)Integration with Outlook (3)Redesigned Options Dialog Box (3)Planning Features (4)Financial Management Features (5)Smart View and Disclosure Management Integration (5)New VBA Functions (5)EPM System New Features (6)OverviewThis document describes the new features introduced in Oracle Hyperion Smart View for Office, Fusion Edition Release 11.1.2.It is our goal to make Oracle products, services, and supporting documentation accessible to the disabled community. Smart View Release 11.1.2 supports accessibility features, which are described in Appendix A of the Smart View for Office User's Guide.Smart View PanelFrom the Smart View Panel, you can manage data source connections, access data and task lists, create reports, and open Oracle Crystal Ball Enterprise Performance Management, Fusion Edition workbooks if you are licensed for Crystal Ball EPM.The Smart View Panel, opened from the Smart View ribbon, is displayed by default on the right side of the Microsoft Office application. You can move, re-size, or close the Smart View Panel from the down arrow in the title bar.The Smart View Panel contains the following panes:l Home: A panel that displays links to shared connections and private connections as well asa list of recently used items - ad hoc grids, data forms, and tasks - which you can click toestablish a connection.l Shared Connections: A drop-down menu of available connections from Oracle's Hyperion®Shared Services and a tree view of the contents of the currently selected connection.l Private Connections: A drop-down menu of available connections saved on the local computer and a tree view of the contents of the currently selected connection. You can also enter a URL to connect directly to a data source here.l Task Lists: A tree list of tasks from which you can manage your tasks. This pane opens only when you select a task list from shared connections or private connections.l Simulation Workbook: (only if you are licensed for Crystal Ball EPM) A tree list of available Oracle Crystal Ball Enterprise Performance Management, Fusion Edition workbooks that you can open in Smart View.l Action Panel: A list of operations available based on the selection in the shared connection.private connection, or task list tree list.Context-Sensitive RibbonsSmart View operations in Microsoft Office applications are available through ribbon commands. The Smart View ribbon, which contains commands for common Smart View operations, is always present. When you connect to a data source (other than Oracle's Hyperion Reporting and Analysis), the corresponding data source ribbon is also displayed. For Oracle Hyperion Planning, Fusion Edition, Oracle Hyperion Financial Management, Fusion Edition, and Oracle's Hyperion® Enterprise®, when you enter ad hoc analysis, the data source ribbon is automatically 2New Featuresreplaced by its ad hoc version. Each ribbon displays only the commands permitted for that datasource, mode, and Office application.These are the new ribbons:l Smart Viewl Essbasel Planningl Planning Ad Hocl HFM (Financial Management )l HFM Ad Hocl Enterprise (Oracle's Hyperion® Enterprise®)l Enterprise Ad Hocl OBIEE (Oracle Business Intelligence Enterprise Edition)Note:Microsoft Office 2003 users can still access Smart View operations via menus.Integration with OutlookPlanning and Financial Management task lists are now integrated into Outlook, so users canintegrate their tasks into Outlook tasks and perform these tasks from within Outlook. Data formtasks are seamlessly launched from Outlook into the familiar Excel interface.Redesigned Options Dialog BoxThe Smart View Options dialog box has been redesigned to make options more easily accessible.Options are organized into categories to provide better user experience and accommodateprovider-specific options. Like other components of Smart View in this release, options areavailable to users only if they are supported by the currently connected data source.The following new options are available from the Options dialog box:l Change the language in which Smart View is displayed without having to re-install Smart Viewl In shortcut menus, choose whether to display Smart View and Microsoft items or only Smart View itemsl Reset all options to default setting with a click of the Reset buttonNew Features3Figure 1 Options Dialog BoxPlanning FeaturesThis release of Smart View supports a greatly expanded set of Planning functionality.l Planning task lists are now integrated into Outlook, so planners can integrate their tasks into Outlook tasks, and can perform these tasks from within Outlook. Planning data form tasks are seamlessly launched from Outlook into the familiar Excel interfacel Planning task lists are available in Office, including task status and task reports; users can perform tasks in Excel, and have them automatically synchronized with the Webl All process management end-user functionality can be accessed from Outlook and Excel l Data validation, including validation indicators and messagesl The ability to monitor the status of Planning jobs in the Job Consolel Composite data forms in Microsoft Office with shared dimensions that are automatically synchronized across multiple data formsl Mass Allocate and Grid Spread for spreading valuesl Copy data across versions for scenario-entity combinationsl Dynamic user variables that allow end users to select and change user variable values directly in data formsl Custom right-click menus for data and metadatal Member formula display4New Featuresl Setting Planning user preferences within Smart Viewl Data forms enabled for ad hoc allow users to slice data and save a slice to create reports or share with other usersFor information about Planning, see the Oracle Hyperion Planning New Features and OracleHyperion Planning User's Guide.Financial Management FeaturesIn this release, Smart Slices are available toFinancial Management users who connect to SmartView. Using Smart Slices, Financial Management users can create and save reports from theReport Designer and cascade reports across a selected dimension.Smart View and Disclosure Management IntegrationCustomers who use Smart View in Excel or Word to assemble financial reports can also useOracle Hyperion Disclosure Management, which allows you to assemble a reporting packagefor submission to a regulatory agency that includes financial statements, as well as supportingschedules and commentary which may exist in Excel, Word, or an Oracle Hyperion FinancialReporting, Fusion Edition report.The first release of Oracle Hyperion Disclosure Management offers a complete XBRL creationand management solution with Enterprise level XBRL mapping; XBRL Taxonomy management,editing and viewing; and Instance document creation, validation and viewing. While viewingSmart View queries in Word or Excel, users can perform data source level mapping with theXBRL Taxonomy Mapping Tool, that allows for re-usable taxonomy element mapping withinOracle Hyperion Financial Management, Fusion Edition, Oracle Hyperion Planning, FusionEdition, and Oracle Essbase.New VBA FunctionsThis release features the following new VBA functions.l HypFindMemberEx retrieves member information like dimension, alias, generation and level names.l HypSetAsDefault creates a connection default.l HypOpenForm opens a data form.l HypSetPages sets page members for the selected sheet.l HypGetPagePOVChoices returns the available member names and member description fora given dimension.l HypDeleteMetaData deletes Oracle Hyperion Smart View for Office, Fusion Edition metadata from the workbook.New Features5l HypGetSharedConnectionsURL returns the Shared Connections URL to be used (also shown in the Options dialog box).l HypSetSharedConnectionsURL sets the Shared Connections URL in the config file and Options dialog box.l HypIsConnectedToSharedConnections checks whether SmartView is connected to Shared Connections.EPM System New Featuresl Most Oracle Hyperion Enterprise Performance Management System products have adopted Oracle Diagnostic Logging (ODL) as the logging mechanism. The ODL framework provides uniform support for managing log files, including log file rotation, maximum log file size, and the maximum log directory size. For more information, see the “Using EPM System Logs” chapter of the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Troubleshooting Guide.l Oracle Configuration Manager (OCM) integrates with My Oracle Support and provides configuration information for Oracle software. It assists in the troubleshooting,maintenance, and diagnostics of your EPM System deployment. For more information about Oracle Configuration Manager see the Oracle Hyperion Enterprise PerformanceManagement System Installation and Configuration Guide.l With this release, many EPM System products support hostnames that resolve to IPv6 addresses. See the Oracle Hyperion Enterprise Performance Management System Certification Matrix. IPv4 support (both hostname and IP address) remains unchanged from earlier releases.l Oracle Hyperion Enterprise Performance Management System supports the following types of SSL configurations:m Full SSL Deployment (including data access)m SSL Terminating at the Web Serverm SSL Accelerators (Off-loading)m Two-way SSLFor more information on the SSL configurations, see the Oracle Hyperion EnterprisePerformance Management System Security Administration Guide.6New FeaturesNew Features7COPYRIGHT NOTICESmart View New Features, 11.1.2Copyright © 2004, 2010, Oracle and/or its affiliates. All rights reserved.Authors: EPM Information Development TeamThis software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:U.S. GOVERNMENT RIGHTS:Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.。
Smartview-11版本操作使用说明-V2011.1
Smartview-11版本操作说明大唐联通项目组2010年10月一、海波龙Smartview介绍Smartview是海波龙公司开发的合并报表系统与OFFICE连接的软件。
安装Smartview后，可通过Smartview程序直接连接合并报表系统的数据库，根据使用者的用户权限将系统数据传出至EXCEL。
Smart View 面板通过 Smart View 面板，您可以管理数据源连接、访问数据和任务列表以及创建报表。
Smart View 面板从 Smart View 功能区打开，默认情况下显示在 Microsoft Office 应用程序的右侧。
您可以通过标题栏上的向下箭头对 Smart View 面板的位置和大小进行调整，或者关闭面板。
Smart View 面板包含下列窗格：•主页：包含一个面板，其中显示指向“共享连接”和“专用连接”的链接，以及最近使用项目的列表（如即席网格、数据表单和任务）。
您可以单击它们建立连接。
•共享连接：包含一个显示Oracle Hyperion® Shared Services 提供的可用连接的下拉菜单和一个显示当前选定连接的内容的树形视图。
•专用连接：包含一个显示本地计算机上保存的可用连接的下拉菜单和一个显示当前选定连接的内容的树形视图。
您还可以在此处输入 URL 直接连接到数据源。
•任务列表：任务的树列表，您可通过该列表管理任务。
只有当您从“共享连接”或“专用连接”中选择某个任务列表时，此窗格才会打开。
二、下载安装说明2.1、在IE浏览器中输入：http:// 10.192.137.19:19000/workspace/index.jsp打开登录页面。
2.2、输入用户名、密码。
登录进入以下页面。
2.3、点击“工具”按钮出现下拉框，找到“安装”再点击，出现下拉框，选择Smart view(s)点击。
2.4、点击Smart view(s)后，出现下载保存页面。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
© 2010 Oracle Corporation – Proprietary and Confidential
8
Smart View Panel: Benefits (3/3)
© 2010 Oracle Corporation – Proprietary and Confidential
Smart View Panel: Benefits (2/3)
Shared Connections: • Are defined by an administrator • Are accessible through the following shared connections URL: http://servername:19000/workspace/SmartViewProviders • Have a list of context-sensitive action items
© 2010 Oracle Corporation – Proprietary and Confidential
Smart View Panel: Benefits (1/3)
• Shared Connections—Are accessible through a shared connections URL. • Private Connections—Are locally stored connections or URL-based connections that can be entered for quick connectivity. • Actions—Are context-sensitive options that can be performed on any connection. • Recently Used—Is a list of items that enables you to access most recently used actions and connections.
Disclaimer:
This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Software License and Service Agreement or other applicable contract with Oracle, with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced or distributed to anyone outside Oracle without Oracle’s prior written consent. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates. This document is for informational purposes only and is intended solely to assist you in planning for the implementation and upgrade of the product features described. This is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality is always at Oracle’s sole discretion. This document is not considered part of the applicable program documentation. Due to the nature of the product architecture, it may not be possible to safely include all features described in this document without risking significant destabilization of the code.
© 2010 Oracle Corporation – Proprietary and Confidential
Oracle Online Training Materials – Usage Agreement
Use of this Site (―Site‖) or Materials constitutes agreement with the following terms and conditions: 1. Oracle Corporation (―Oracle‖) is pleased to allow its business partner (―Partner‖) to download and copy the information, documents, and the online training courses (collectively, ―Materials") found on this Site. The use of the Materials is restricted to the non-commercial, internal training of the Partner’s employees only. The Materials may not be used for training, promotion, or sales to customers or other partners or third parties. 2. All the Materials are trademarks of Oracle and are proprietary information of Oracle. Partner or other third party at no time has any right to resell, redistribute or create derivative works from the Materials. 3. Oracle disclaims any warranties or representations as to the accuracy or completeness of any Materials. Materials are provided "as is" without warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement. 4. Under no circumstances shall Oracle be liable for any loss, damage, liability or expense incurred or suffered which is claimed to have resulted from use of this Site of Materials. As a condition of use of the Materials, Partner agrees to indemnify Oracle from and against any and all actions, claims, losses, damages, liabilities and expenses (including reasonable attorneys' fees) arising out of Partner’s use of the Materials.
© 2010 Oracle Corporation – Proprietary and Confidential
Oracle® Hyperion Smart View For Office, Fusion Edition Release 11.1.2 New Features Training
Shubhomoy Bhattacharya Principal Product Manager
© 2010 Oracle Corporation – Proprietary and Confidential
Smart View 11.1.2 Feature Summary
• • • • Smart View panel Context-specific ribbons Revised Options dialog box Microsoft Outlook support for Planning and Financial Management • New Planning features • New Financial Management features