About this Course

Code TPD69830GC20
Duration 1 Day
Special Notices

Please note: In order to provision you with your courseware and lab access for this course QA must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our QA Partner data sharing page. If you have any questions or concerns please contact your QA account manager.

This Oracle Hyperion Smart View 11.1.2 for Planning (11.1.2.3) training teaches you how to use Smart View to enter, adjust and analyze Planning data. You learn how to annotate and predict data and use ad hoc tools to analyze data.Learn to:Navigate the Smart View interface Connect to data sources Enter, calculate, and analyze Planning data Manage the approval process and task lists Embed dynamic data points in Microsoft Office documents Run and view predictions in Predictive Planning A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Prerequisites

  • Basic knowledge of Planning data sourcesModerate experience with the Microsoft Office suiteBasic understanding of financial planning and budgeting conceptsBasic Microsoft Windows skills

Please note: In order to provision you with your courseware and lab access for this course QA must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our QA Partner data sharing page. If you have any questions or concerns please contact your QA account manager.

Delegates will learn how to

  • Navigate the Smart View interface
  • Set Smart View options
  • Connect to shared and private data sources
  • Enter, spread, and calculate data in forms
  • Run and view predictions
  • Use adhoc analysis to analyze data
  • Embed dynamic data points in Microsoft Word and PowerPoint
  • Perform approval process tasks
  • Complete task lists in Microsoft Excel and Outlook
  • Describe the key features and benefits of Smart View for Planning

Outline

Introduction to Smart View

  • Oracle Hyperion Planning
  • Smart View Overview
  • Smart View Architecture
  • Integration with Source Systems
  • Smart View Business Process

Navigating Smart View and Setting Options

  • Smart View Excel Interface
  • Connection Types
  • Connecting to Data Sources
  • View Planning data in Excel
  • Setting Smart View Options

Managing Data in Forms

  • Working with Forms in Excel
  • Entering and Adjusting Data
  • Annotating Data Cells
  • Calculating Data Values
  • Monitoring Planning Jobs in Job Console
  • Submitting Data

Introduction to Predictive Planning

  • Predictive Planning Overview
  • Setting General Options
  • Running Predictions
  • Viewing Prediction Results
  • Pasting Results in Forms
  • Creating Comparison and Custom Views

Analyzing Data with Ad Hoc Analysis Tools

  • Starting Ad Hoc Analysis
  • Selecting Members
  • Formatting Ad Hoc Grids
  • Zooming In and Out on Members
  • Pivoting, Keeping, and Removing Members
  • Saving Ad Hoc Grids
  • Cascading Reports
  • Embedding Data in Word and PowerPoint

Managing the Approval Process

  • Planning Approval Process Overview
  • Validating Planning Units
  • Resolving Validation Errors
  • Changing Planning Unit Statuses
  • Annotating Planning Units

Managing Task Lists

  • Task List Management Overview
  • Importing Task Lists into Microsoft Outlook
  • Opening Task Lists
  • Viewing Task Details
  • Executing and Completing Tasks
  • Creating Task List Reports

1 Day

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0113 220 7150 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.