Download PDF
of this course

Oracle Smart View for Office 11.1.2 for Financial Management (11.1.2.5) (SVOFM)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration: 1 Day

Price: SGD 1,055.00

This Oracle Smart View for Office (11.1.2.3) training helps business users access and analyze data from various Oracle Hyperion data sources. Get interactive, hands-on instruction from expert Oracle University instructors.

Learn To:

  • Create ad-hoc queries, free-form grids and advanced reports.
  • Create smart slices and create smart slice reports.
  • Embed dynamic data points into Microsoft Office documents.
  • Perform data submission using data forms.
  • Import Reporting and Analysis content into Excel, Word, and PowerPoint.

Benefits to You

By taking this course, you'll learn how to use Smart View to query, consolidate and analyze data from Financial Management applications. You'll walk away with more knowledge than you had before about leveraging this solution to help your business.

 

Who Should Attend

  • End Users
  • Application Developers

Course Certifications

This course is part of the following Certifications:

Prerequisites

Suggested Prerequisites:

  • Familiarity with Financial Management concepts and terms
  • Familiarity with Microsoft Excel, Word, and PowerPoint

Course Objectives

  • Connect to Financial Management
  • Create ad hoc queries and free form reports
  • Create smart slices and smart slice reports
  • Import Reporting and Analysis documents into Microsoft Office
  • Enter and submit data in data forms
  • Embed dynamic data points in Microsoft Office documents

Course Content

Introduction to Smart View

  • Smart View Overview
  • Smart View Product Architecture
  • Installing Smart View
  • Smart View Excel Interface
  • Managing Data Source Connections

Entering Data in Data Forms and Data Grids

  • Opening Financial Managment Documents in Smart View
  • Enter and Submitting Data
  • Entering Cell Text
  • Adjusting Data Values
  • Setting the Point of View
  • Calculating and Consolidating Data

Analyzing Data with Ad Hoc Analysis Tools

  • Creating Ad Hoc Grids
  • Pivoting Dimensinos
  • Selecting Members for Rows and Columns
  • Setting Member and Data Displays Options
  • Applying Cell Formatting and Formulas
  • Cascading Grids

Creating Free Form and Query Designer Reports

  • Creating Free Form Grids
  • Creating Smart View Function Worksheets
  • Working with Query Designer

Creating Reports Using Smart Slices

  • Smart Slice Overview
  • Creating Smart Slices
  • Inserting Reporting Objects in Smart Slice Reports
  • Inserting Point of View Objects in Smart Slice Reports

Integrating Smart View Data With Other Products

  • Copying and Pasting Data Points Across Microsoft Office
  • Importing Financial Reporting Reports into Excel
  • Importing Financial Reporting Reports into Word and PowerPoint
  • Changing the Point of View for Imported Financial Reporting Reports

 

Course ID: SVOFM


Show Schedule for 1 Month  3 Months  All 
Date Country Location Register