Oracle Smart View for Office 11.1.2 for Essbase Ed 1

Cost $2000

Course Code
D87763GC10

Duration
1 day

Format
Live Virtual Class

What you will learn

In this course, you 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 course you learn how to connect to data sources and create ad-hoc queries and free-form grids.

Learn To:

  • 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.

Benefits to You

By enrolling in this course, you'll develop the skills to use Smart Query and Query Designer to create customizable reports with interactive components. You'll get a chance to work with expert Oracle University instructors who can show you how to format reports by using functions.

Audience

  • Developer
  • End User

Objectives

  • 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

Topics

  • Introduction to Smart View
    • Multi-Dimensional Analysis Overview
    • Smart View Architecture
    • Smart View Excel User Interface
    • Connecting to Data Sources
  • 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 Panel
  • 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
  • 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
  • Working with Smart Slices

Enroll for Oracle Smart View for Office 11.1.2 for Essbase Ed 1

Oracle Smart View for Office 11.1.2 for Essbase Ed 1

$2,000.00

Clear
SKU: D87763GC10 Categories: ,

Additional information

Schedules

Sep 27 2021 (1 day) 9:00 AM – 5:00 PM US-Pacific, Mar 29 2022 (1 day) 9:00 AM – 5:00 PM US-Eastern

Format

Live Virtual Class

Reviews

There are no reviews yet.

Be the first to review “Oracle Smart View for Office 11.1.2 for Essbase Ed 1”

Your email address will not be published. Required fields are marked *

No products were found matching your selection.

Follow-on Courses

Browse the suggested follow-on courses below and continue your training journey. We offer training in various learning formats, from instructor-led to virtual, so you can choose what works best for you. Get started by selecting a course to learn more.

No products were found matching your selection.

TOP
0