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.
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
Who Should Attend?
Developer
End User
- Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
- Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
- Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
- Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
- Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
- Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.
Agenda
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