Skip to Scheduled Dates
Course Overview
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.
Who Should Attend
Developer
End User
Course 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
Course Outline
1 - Introduction to Smart View
- Multi-Dimensional Analysis Overview
- Smart View Architecture
- Smart View Excel User Interface
- Connecting to Data Sources
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 Panel
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
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
5 - Working with Smart Slices