Audience :

  • Application Developers
  • Report Developers
  • Power Users
  • Business Users

Topics :

  • Introduction to Smart View
    • Oracle’s Enterprise Performance Management System
    • Essbase Overview
    • Smart View Architecture
    • Smart View Excel User Interface
    • Connect to Data Sources
  • Create Ad Hoc Analysis Reports
    • Create Ad Hoc Grids
    • Perform Ad Hoc Operations in Multiple Cells
    • Create Member Selections
    • Associate Data Sources with Worksheets
    • Create Multiple Grids on One Worksheet
    • Create Free-form Grids
    • Work with the Essbase Ribbon
  • Set Smart View Options
    • Set Global and Sheet-Level Options
    • Set Data Navigation and Retrieval Options
    • Set Number and Cell Formatting Options
    • Set Administrative Options
    • Display Aliases for Member Names
  • Create Advanced Reports
    • Work with Query Designer
    • Execute MDX Queries
    • Retrieve Data for DTS Members
    • Retrieve Data for Attribute Dimensions
    • Work with Excel Formulas
    • Replace Data with Numeric Zeroes or Text
  • Embed Dynamic Data Points and Import Workspace Documents
    • Embed Data into Word and PowerPoint
    • Change the POV for Dynamic Data Points
    • Integration of Workspace Documents with Microsoft Office: Overview
  • Work with Smart Slices and POV Manager
    • Work with Smart Slices
    • Work with Report Designer
    • Cascading Reports and Ad Hoc Grids
    • Work with POV Manager
  • Apply Advanced Formatting to Grids and Add VBA Buttons
    • Advanced Formatting Overview
    • Format Grids as Tables
    • Apply Conditional Formatting
    • Group Data
    • Validate Data
    • Add VBA Functionality to Grids