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 2000
Group Training Date On Request
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
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

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

Top Trending Technologies

 Cloud Computing Certification Training Courses
 IT Security and Cybersecurity Certification Courses
 Fundamentals Training and Certification Courses
 System Administration Training and Certification Courses
 Cloud Architect Certification Training Courses
 CRM Training and Certification Courses
 Big Data Analytics Courses & Certification Training
 Data Analytics Certification and Training Courses
 Security Testing Training & Certification Courses
 Programming Courses Training and Certification

FAQ's