Oracle Smart View for Office 11.1.2 for Essbase (OR-SVO)

About this course:

This course is designed to enable the candidate to use Oracle Smart View (11.1.2.5), a usual Microsoft Office (PowerPoint, Word, and Excel) add-in to query, share and analyze information kept in Essbase databases. This course helps you to learn and understand how to create ad-hoc queries, methods to connect free-form grids.

Understand how to:

• Build reports using Query Designer, functions, and Smart Query.
• Build reports with smart slices.
• Analyze and query data stored in Essbase.
• Set Smart View options.
• Build advanced reports.
• Insert dynamic data points within Microsoft Office documents.

Pros to You:

By registering at this course, you will enhance the skills and expertise to utilize Query Designer and Smart Query to build personalized reports with interactive components. You will obtain an opportunity to collaborate with professional Oracle University trainers who can tell you the best way to arrange reports by utilizing functions.

Course Objective:

• Using Query Designer and Smart Query
• Build advanced reports and ad hoc queries in Smart View
• Insert dynamic data points within Microsoft Office documents
• Set Smart View Options
• Build reports with smart slices
• Define the database outline hierarchy and multidimensional analysis

Audience:

• End Users
• Reports Developer

Prerequisite:

• Understanding of Microsoft PowerPoint, Word, and Excel
• Understanding of Essbase
• Understanding of multidimensional data terms and storage