Who should attend
- End users
Course Objectives
- Explain the multidimensional analysis and database outline hierarchy
- Connect to Essbase
- Create ad hoc queries and advanced reports
- Embed dynamic data points into Microsoft Office documents
- Import Workspace content into Microsoft Office
- Create formatted reports
Product Description
- 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 Smart View Panel
- Creating Ad Hoc Analysis Reports
- Creating Ad Hoc Grids
- Creating Member Selections
- Associating Data Sources with Worksheets
- Creating Free-form Grids
- Setting Smart View Options and Managing POVs
- Setting Smart View Options
- Displaying Aliases for Member Names
- Setting, Saving, and Sharing POVs
- 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
- Creating Customizable Reports with Interactive Components
- Embedding Dynamic Data Points
- Embedding Dynamic Data into Word and PowerPoint
- Changing the POV for Dynamic Data Points
- Importing Workspace Documents into Microsoft Office
- Integrating Workspace Documents with Microsoft Office
- Importing Financial Reporting and Web Analysis Documents
- Editing and Refreshing Documents
- Applying Advanced Formatting to Grids
- Formatting Grids as Tables
- Applying Conditional Formatting
- Grouping and Validating Data