Oracle Fusion Smart View

Learn to…

This course will teach you the steps to install, configure and build ad-hoc reports quickly. Once you have an understanding of the basic reporting capabilities we will build more complex reports. By building reports in Excel, you have the benefit of a familiar application complemented by the security of the database to enable you to quickly build reports.

Benefits to you…

After this course you will have the skills and knowledge to utilise Smart Query and Query Designer to build personalised reports with interactive components. Consultants with implementation and report design experience will teach you how best practice.

Introduction to Smart View

  • Connecting to Data Sources
  • Smart View Excel User Interface
  • Smart View Architecture

Creating Ad Hoc Analysis Reports

  • Associating Data Sources with Worksheets
  • Creating Member Selections
  • Working with the Essbase Ribbon

Setting Smart View Options

  • Setting Number and Cell Formatting Options
  • Setting Administrative Options
  • Setting Data Navigation and Retrieval Options

Creating Advanced Reports

  • Retrieving Data for Attribute Dimensions
  • Working with Excel Formulas
  • Creating Queries using Query Designer
  • Creating a Smart Query

Smart Slices

  • Creating Reports with Smart Slices
    Using Query Designer and Smart Query
  • Define the database outline hierarchy and multidimensional analysis
  • 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
  • Analyst
  • End User
  • Implementer
Instructor-led class

Booking enquiry

Share this Course

Get in touch

If you would like to find out how we can help you, please get in touch.
+44 (0)20 3900 1186

Book a meeting

We offer free consultation if you’re keen to find out what course fits the best for you. Use the link below to schedule a meeting with us.
Book a meeting

Booking enquiry

Hear it first hand

What do our customers think of our training?