Hyperion Smart View 9.3.1 for Essbase
- Total time
Hyperion Smart View 9.3.1 for Essbase
Provider rating:
Starting dates and places
This product does not have fixed starting dates and/or places.
Description
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
Audience
- Reports Developer
- End Users
Course Topics Introduction to Smart View
- Introduction to Essbase
- Smart View Overview
- Installing Smart View Cli…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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
Audience
- Reports Developer
- End Users
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
- Connecting to Data Sources
- Associating Data Sources with Worksheets
- Creating Ad Hoc Grids
- Creating Free-form Grids
- 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
- 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 in Word and PowerPoint
- Changing the POV for Dynamic Data Points
- Managing the POVs for Multiple Data Points
- Integrating BI+ Documents with Microsoft Office
- Importing Formats
- Editing and Refreshing Documents
- Visual Explorer Overview
- Exploring Data Graphically
- Working with Visual Explorer in Stand-alone mode
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
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.