4644 - Oracle Smart View for Office 11.1.2 for Essbase Ed 1

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

Duration: 3.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

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

Content

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 Pane

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

  • Creating Reports with Smart Slices

Audience

  • Developer
  • End User

Prerequisites

N/A

Certification

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses

d90871

This training is the first step in mastering MySQL, the world’s most popular open source database.

p10380

P10380 - Oracle Database 18c: Administration Workshop

d79995

Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.

d83527

D83527 - Java SE 8 Fundamentals
Enquire Now
 
 
 
 
qR6MBm
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy