- Parent Category: Smart View: for Essbase & Planning
Smart View: Key User for Essbase & Planning (1 day) Traditional Classroom
Audience: Key Users
Gain experience in writing functions and developing ad hoc queries that allow you to read, write data and retrieve dimension labels and descriptions to and from Essbase and Planning data sources. Learn about accessing Data Forms and task lists and how to integrate your quesries with a variety of Microsoft Office products..
Smart View provides a common Microsoft Office interface designed specifically for Oracle's Enterprise Performance Management (EPM) and Business Intelligence (BI). Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word and PowerPoint interfaces. It is a comprehensive tool for accessing and integrating EPM and BI content from Microsoft Office products.
Topics covered on this course include setting up the Smart View connection manager, member selection and using data forms for entering, calculating and processing data. You will analyse data using the ad hoc features such as pivot, drill-down, keep only and remove only. You will also find out more about using data forms and task lists from within Smart View and how to integrate queries with a variety of Microsoft Office products.
You will also gain experience in writing functions that allow you to read, write data and retrieve dimension labels and descriptions. Using functions allows you to develop structured reports utilising Smart View and Excel functionality.
Scheduled Course Dates
Register: Scheduled Course Dates - Select Course Title to Register
CPE Credits (North America)
Smart View: Key User for Essbase & Planning
Recommended CPE Credits:
7 Credits -Specialized Knowledge and Applications
Keyteach is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of
continuing professional education on the National Registry of CPE Sponsors.
Registration ID No 115820.
State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit.
Any complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors
through its website:www.learningmarket.org
Onsite Training at Your Premises
We can arrange dedicated training at your premises or at 3rd party locations on dates to fit with your project deadlines.
In addition to our published schedule of courses, we can also bring the classroom to your premises, delivering a
combination of administrator courses to meet your exact requirements or the customised delivery of end user
training to match your application and business processes. Onsite courses tend to be cost effective with four or
You will need to provide a room with a data projector, we will ship pre-configured laptops and courseware including the
manuals, pads, pens and an instructor! As an alternative to shipping laptops we can provide access to cloud-based
configured hardware over the internet if required.
Use the following link to request onsite training: