Oracle Hyperion Smart View 11.1.1 for Essbase

Total time

Oracle Hyperion Smart View 11.1.1 for Essbase

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.
  • View related products with starting dates: Oracle.

Description

In this course, you learn how to use Smart View, a common Microsoft Office add-in (Excel, Word and PowerPoint), to query, analyze, and share data stored in Essbase databases. You use Data Source Manager to create and connect to common and independent provider connections. You leverage Smart Slices and Report Designer to create customizable reports and dashboards. You also integrate Workspace documents with Microsoft Office.

Learn To:
  • Query and analyze data stored in Essbase
  • Create ad hoc queries, free-form grids, and advanced reports
  • Work with Smart Slices and Report Designer
  • Embed dynamic data points into Microsoft Office documents
  • Import Workspace content into Excel, Word, and PowerPoint

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle, CompTIA A+ / Network+ / Security+, IT Security, Retail (Management), and Security.

In this course, you learn how to use Smart View, a common Microsoft Office add-in (Excel, Word and PowerPoint), to query, analyze, and share data stored in Essbase databases. You use Data Source Manager to create and connect to common and independent provider connections. You leverage Smart Slices and Report Designer to create customizable reports and dashboards. You also integrate Workspace documents with Microsoft Office.

Learn To:
  • Query and analyze data stored in Essbase
  • Create ad hoc queries, free-form grids, and advanced reports
  • Work with Smart Slices and Report Designer
  • Embed dynamic data points into Microsoft Office documents
  • Import Workspace content into Excel, Word, and PowerPoint
  • Explore data graphically by using Oracle® Essbase Visual Explorer

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.


Audience
  • Reports Developer
  • End Users

Course Topics Introduction to Smart View
  • Oracle's Enterprise Performance Management System
  • Essbase Overview
  • Smart View Overview
  • Smart View High-level Architecture
  • Installing Smart View Client
  • Smart View Excel Interface
  • Data Source Providers
  • Working with Data Source Manager
Creating Ad Hoc Analysis Reports
  • Connecting to Data Sources
  • Creating Ad Hoc Grids
  • Creating Free-form Grids
Setting Smart View Options and Managing POVs
  • Setting Smart View Ad Hoc Options
  • Setting Smart View Display Options
  • Displaying Aliases for Member Names
  • Setting, Saving and Sharing Points of View
Creating Advanced Reports
  • Working with Query Designer
  • Executing MDX Queries
  • Retrieving Data for DTS Members
  • Retrieving Data for Attribute Dimensions
  • Working with Excel Formulas
  • Creating Formatted Reports
  • Creating Asymmetric Reports
Working with Smart Slices and Report Designer
  • Creating Smart Slices
  • Setting Smart Slice Preferences
  • Adding Queries and Subqueries to Report Designer
Embedding Dynamic Data Points
  • Embedding Dynamic Data in Word and PowerPoint
  • Changing the POV for Dynamic Data Points
  • Managing the POVs for Multiple Data Points
  • Cascading Reports and Ad Hoc Grids
Importing Workspace Documents into Microsoft Office
  • Integrating Workspace Documents with Microsoft Office
  • Import Formats
  • Editing and Refreshing Documents
Analyzing Data Graphically in Visual Explorer
  • Visual Explorer Overview
  • Exploring Data Graphically
  • Working with Visual Explorer in Stand-alone Mode

Course Objectives
  • Describe Smart View
  • Install Smart View Client
  • Connect to Essbase
  • Create ad hoc queries and advanced reports
  • Embed dynamic data points into Microsoft Office documents
  • Import Workspace content into Microsoft Office
  • Explore data graphically in Oracle® Essbase Visual Explorer
  • Explain the multidimensional analysis and database outline hierarchy

There are no reviews yet.
  • View related products with reviews: Oracle.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.