Oracle Smart View for Office 11.1.2 for Essbase Ed 1

Oracle Smart View for Office 11.1.2 for Essbase Ed 1 Certification Training Course Overview

Oracle Smart View for Office 11.1.2 for Essbase training course is designed to learn how to use Oracle Smart View 11.1.2.5, a common Microsoft Office (Excel, Word and PowerPoint) add-in to query, analyze, and share data stored in Essbase databases. In this training class, you will be taught how to connect to data sources and create ad-hoc queries and free-form grids.

Course Objective:

  • Query and analyze data stored in Essbase.
  • Create advanced reports.
  • Set Smart View options.
  • Create reports using Smart Query, Query Designer, and functions.
  • Embed dynamic data points into Microsoft Office documents.
  • Create reports with smart slices.

Target Audience:

  • Developer
  • End User

Oracle Smart View for Office 11.1.2 for Essbase Ed 1 (8 Hours) Download Course Contents

Live Virtual Classroom

Fee : 500 (Includes Taxes) 
9 AM - 5 PM (Flexible Time Slots for 4 hours option)




August
8 Hours/Day
4 Hours/Day
09
16
09-10
16-17
September
8 Hours/Day
4 Hours/Day
20
20-21
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Customers who bought this course also bought

• Oracle BPM 12c: Essentials Ed 1
• Oracle Database 12c: Admin, Install and Upgrade Accelerated
• Oracle Database 12c: Advanced PL/SQL
• Oracle Database: Managing Multitenant Architecture Ed 1
• Oracle Database 12c R2: SQL Tuning for Developers Ed 2
• Oracle Database 19C:Administration Workshop
• Oracle Database: Backup and Recovery Workshop
• Oracle Database: Introduction to SQL
• Oracle HCM Cloud: US Payroll
• Oracle WebLogic Server 12c: Administration I Ed 3

Course Modules

Module 1: Introduction to Smart View
  • Multi-Dimensional Analysis Overview
  • Smart View Architecture
  • Smart View Excel User Interface
  • Connecting to Data Sources
Module 2: Creating Ad Hoc Analysis Reports
  • Creating Ad Hoc Grids
  • Performing Ad Hoc Operations in Multiple Cells
  • Creating Member Selections
  • Associating Data Sources with Worksheets
  • Creating Multiple Grids on One Worksheet
  • Creating Free-form Grids
  • Working with the Essbase Ribbon
  • Working with Document Contents Pane
Module 3: Setting Smart View Options
  • Setting Global and Sheet-Level Options
  • Setting Data Navigation and Retrieval Options
  • Setting Number and Cell Formatting Options
  • Setting Administrative Options
  • Displaying Aliases for Member Names
Module 4: Creating Advanced Reports
  • Creating Queries using Query Designer
  • Creating a Smart Query
  • Creating Reports using Functions
  • Executing MDX Queries
  • Retrieving Data for DTS Members
  • Retrieving Data for Attribute Dimensions
  • Working with Excel Formulas
  • Replacing Data with Numeric Zeroes or Text
Module 5: Working with Smart Slices
  • Creating Reports with Smart Slices
Download Course Contents

Request More Information

Course Prerequisites
  • Basic Computer Knowledge.
  • Explain the multidimensional analysis and database outline hierarchy
  • Create ad hoc queries and advanced reports in Smart View
  • Set Smart View Options
  • Use Smart Query and Query Designer
  • Embed dynamic data points into Microsoft Office documents
  • Create reports with smart slices

FAQ's