Hyperion Smart View 9.3.1 for Essbase
Oracle University provides a downloadable eKit containing the training materials for this course.What you will learn:
In this course, you learn how to use Smart View to query and analyze data stored in Essbase databases. You learn how to create reports and integrate documents created using Hyperion Reporting and Analysis tools with Word, Excel, and PowerPoint.
Learn To:- Query and analyze data stored in Analytic Services databases
- Create ad hoc queries, free-form grids, and advanced reports
- Embed dynamic data points into Microsoft Office documents
- Explore data graphically using Hyperion Visual Explorer
- Import BI+ content into Excel, Word, and PowerPoint
| Schedule/Purchase | Training Formats | Price | Duration | Course Materials | Instruction Language |
|---|---|---|---|---|---|
| View Schedule | Instructor-Led Training | US$ 750 | 1 Day | English | |
| View Schedule | Live Virtual Class | US$ 750 | 1 Day | English |
Note: To have a more personalized experience, we invite you to: Log In!
Audience:
- End Users
- Reports Developer
Prerequisites:
Suggested Prerequisites:
- Familiarity with Microsoft Excel, Word, and PowerPoint
- Familiarity with multidimensional data storage and terms
Course Objectives:
- Explain the multidimensional analysis and database outline hierarchy
- 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 BI+ content into Microsoft Office
- Explore data graphically in Hyperion Visual Explorer
Course Topics:
Introduction to Smart View
- Introduction to Essbase
- Smart View Overview
- Installing Smart View Client
- Smart View in Spreadsheets
- Data Source Providers
- Working with Connection Manager
Creating Ad Hoc Analysis Reports
- Connecting to Data Sources
- Associating Data Sources with Worksheets
- 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
- Viewing Qualified Names for Members
- Displaying Duplicate 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
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
Importing BI+ Documents into Microsoft Office
- Integrating BI+ Documents with Microsoft Office
- Importing 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