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
Description:
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.
