Oracle Hyperion Smart View 11.1.1 for Essbase
Starting dates and places
Description
In this course, you learn how to use Smart View, a common Microsoft Office add-in (Excel, Word and PowerPoint), to query, analyze, and share data stored in Essbase databases. You use Data Source Manager to create and connect to common and independent provider connections. You leverage Smart Slices and Report Designer to create customizable reports and dashboards. You also integrate Workspace documents with Microsoft Office.
Learn To:- Query and analyze data stored in Essbase
- Create ad hoc queries, free-form grids, and advanced reports
- Work with Smart Slices and Report Designer
- Embed dynamic data points into Microsoft Office documents
- Import Workspace content into Excel, Word, and PowerPoint
- …
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, a common Microsoft Office add-in (Excel, Word and PowerPoint), to query, analyze, and share data stored in Essbase databases. You use Data Source Manager to create and connect to common and independent provider connections. You leverage Smart Slices and Report Designer to create customizable reports and dashboards. You also integrate Workspace documents with Microsoft Office.
Learn To:- Query and analyze data stored in Essbase
- Create ad hoc queries, free-form grids, and advanced reports
- Work with Smart Slices and Report Designer
- Embed dynamic data points into Microsoft Office documents
- Import Workspace content into Excel, Word, and PowerPoint
- Explore data graphically by using Oracle® Essbase Visual Explorer
A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.
Audience
- Reports Developer
- End Users
Course Topics 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 Data Source Manager
- Connecting to Data Sources
- Creating Ad Hoc Grids
- Creating Free-form Grids
- Setting Smart View Ad Hoc Options
- Setting Smart View Display Options
- Displaying Aliases for 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
- Creating Smart Slices
- Setting Smart Slice Preferences
- Adding Queries and Subqueries to Report Designer
- Embedding Dynamic Data in Word and PowerPoint
- Changing the POV for Dynamic Data Points
- Managing the POVs for Multiple Data Points
- Cascading Reports and Ad Hoc Grids
- Integrating Workspace Documents with Microsoft Office
- Import Formats
- Editing and Refreshing Documents
- Visual Explorer Overview
- Exploring Data Graphically
- Working with Visual Explorer in Stand-alone Mode
Course Objectives
- 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 Workspace content into Microsoft Office
- Explore data graphically in Oracle® Essbase Visual Explorer
- Explain the multidimensional analysis and database outline hierarchy
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.