Table of Contents
- Title and Copyright Information
 - Documentation Accessibility
 - Documentation Feedback
 - 1 Creating and Running an EPM Center of Excellence
 - 2 Welcome to the Smart View User's Guide
 - 3 Introduction to Smart View
 - 4 Data Source Connections
 - 5 Smart View Options
 - 
               
               
                  
                  6
                      Smart View Extensions
               
                  
               
               
               
- About Smart View Extensions
 - Working with Extension Alerts
 - Initially Checking for Available Extensions
 - Installing Extensions
 - Updating Extensions
 - Enabling Logging for Extension Installations
 - Overriding the Default URL for the Extension Download
 - Enabling and Disabling Extensions
 - Adjusting Display when Working with Extensions
 - Uninstalling Extensions
 
 - 
               
               
                  
                  7
                      Dimensions and Members
               
                  
               
               
               
- About Dimensions and Members
 - Dimension and Member Naming Limitation
 - Best Practices for Numeric Member Names
 - Selecting Members from the Member Selector
 - Selecting Members from the POV Toolbar
 - Selecting Members Using the Cell-Based POV
 - Entering Members in Free-Form Mode
 - Displaying the POV Toolbar
 - POV Manager
 - Filtering by Attribute
 - Filtering by Subsets
 - Selecting Period-to-Date Members
 - Specifying Member Perspective
 - Viewing Member Information
 - Working with Aliases and Alias Tables
 - Defining Member Name Display in the Member Selector
 - Displaying Qualified Names of Duplicate Members
 - Qualified Name Display in Alternate Hierarchies
 - Viewing Dimension Properties
 
 - 
               
               
                  
                  8
                      Data and Data Cells
               
                  
               
               
               
- Refreshing Data
 - Using the Submit Data Options
 - Calculating Data
 - Working with Currencies
 - Adjusting Values in Data Cells
 - Resolving Data Validation Errors
 - Specifying Data Perspective
 - Working with Smart Lists
 - Working with Drill-Through Reports
 - Working with Linked Reporting Objects
 - Adding Cell Comments in EPM Cloud
 - Adding Attachments
 - Viewing Cell History
 
 - 
               
               
                  
                  9
                      Data Forms
               
                  
               
               
               
- Working with Forms in Excel
 - Opening Forms in Excel
 - Using Excel Formulas in Forms
 - Working with User Variables
 - EPM Cloud Form Behavior in Smart View
 - Displaying the Floating Toolbar in Planning Forms
 - Saving Ad Hoc Grids
 - Performing Ad Hoc Analysis in EPM Cloud Forms
 - Using the Drop-down Member Selector on Row Dimensions in Forms
 - Inserting Charts
 - Cell-Level Security in Smart View
 - Working with Valid Intersections
 - 
                     
                     Flex Forms
                        
                     
                     
                     
- About Flex Forms
 - 
                           
                           Best Practices for Working with Flex Forms
                              
                           
                           
                           
- General Guidelines for Flex Forms
 - Selecting Members in Flex Forms
 - Using Suppression Options in Flex Forms
 - Filtering and Sorting in Flex Forms
 - Flexing Beyond the Form Definition
 - Retaining Invalid Members on Flex Forms
 - Retaining Formula, Label, and Comment Rows and Columns on Flex Forms
 - Retaining Modified Members on Flex Forms After POV or User Variable Change
 - Smart Push with Flex Forms
 - Unsupported Features on Flex Forms
 
 - Working with Flex Forms in Smart View
 - Opening a Flex Form in Ad Hoc Mode and Submitting Data
 
 
 - 
               
               
                  
                  10
                      Ad Hoc Analysis
               
                  
               
               
               
- About Ad Hoc Analysis
 - Starting Ad Hoc Analysis
 - Inserting Attribute Dimensions on the Sheet
 - Preserving Excel Formulas in Ad Hoc Grids
 - Formatting Ad Hoc Grids
 - Enabling Attribute Association Processing in Ad Hoc Grids
 - Zooming In and Out
 - Specifying Ancestor Position in Ad Hoc Grids
 - Working with Excel Filters on Ad Hoc Sheets
 - Pivoting
 - Removing Selected Members From the Grid
 - Inserting Rows and Columns
 - Displaying and Suppressing Repeated Members
 - Working with Multiple Grids on a Worksheet
 - Cascading Reports and Ad Hoc Grids
 - Using Substitution Variables
 - Detecting Comments and Unknown Members on Essbase Sheets
 
 - 11 Books
 - 12 Reports
 - 13 Smart Forms
 - 14 Task Manager
 - 15 Task Lists
 - 
               
               
                  
                  16
                      Free-Form Mode
               
                  
               
               
               
- About Free-Form Mode
 - Guidelines and Best Practices for Free-Form
 - Free-Form Grid Examples
 - Comments in Free-Form Grids
 - Formulas in Free-Form Grids
 - Duplicate Aliases in Free-Form Mode
 - Attribute Dimensions in Free-Form Grids
 - Submitting from Free-Form Grid with Scaling Options Enabled
 - Creating Free-Form Reports
 - Retrieving Attribute Dimensions in Free-Form Mode
 - Creating Asymmetric Reports
 - Actions That May Cause Unexpected Behavior
 
 - 
               
               
                  
                  17
                      General Operations
               
                  
               
               
               
- Smart View Operations
 - Searching for Forms and Other Artifacts
 - Using the Document Contents pane
 - Using Undo and Redo
 - Copying and Pasting
 - 
                     
                     Saving Office Documents to EPM Cloud
                        
                     
                     
                     
- About Saving Office Documents to EPM Cloud from Smart View
 - Creating Folders in the EPM Cloud Platform Library Using the Web Interface
 - Creating Folders in the Narrative Reporting Library Using Smart View
 - Saving Office Documents to EPM Cloud Library Using Smart View
 - Managing Access to Office Documents in EPM Cloud Library
 
 - Importing Metadata in Office Applications
 - Viewing Sheet Information
 - Opening Forms and Ad Hoc Grids from Web Applications (Web Launch)
 - Opening Large Workbooks in Smart View
 - Working Compatibly on Forms and Ad Hoc Grids Between Smart View and Smart View (Mac and Browser)
 - Entering Percentage Values in Forms and Ad Hoc Grids
 - Enabling Automatic Cell Width and Height Adjustment
 - Working with Shared Workbooks
 - Working with Protected Worksheets
 - Printing POV Members in the Header and Footer
 - Enabling and Disabling Smart View
 
 - 18 Functions
 - 19 Smart Query
 - 20 Smart Slices
 - 21 Query Designer and MDX Queries
 - 
               
               
                  
                  22
                      Smart View and EPM Cloud
               
                  
               
               
               
- About Smart View and EPM Cloud
 - Viewing Member Formula
 - Working with Business Rules
 - Working with Supporting Details
 - Spreading Data
 - Performing Calculations Without Having to Submit Your Changes (Calc on the Fly)
 - Accessing Ancestor Members in Ad Hoc Grids
 - Managing Planning Approvals
 - Monitoring Job Status
 - Dashboards
 - Opening Composite Forms
 - Copying Versions
 - Searching for a Page in EPM Cloud Forms
 - Saving Native Excel Formatting to EPM Cloud
 - 
                     
                     Working with Multiple-Grid Worksheets in EPM Cloud
                        
                     
                     
                     
- About Multiple Grids on a Worksheet
 - Creating Multiple-Grid Worksheets with EPM Cloud Sources
 - Converting EPM Cloud Single-Grid Worksheets to Multiple-Grid Worksheets
 - Renaming Ranges on EPM Cloud Multiple-Grid Worksheets
 - Changing Connections in EPM Cloud Multiple-Grid Worksheets
 - POV Behavior on EPM Cloud Multiple-Grid Worksheets
 
 - Setting User Preferences
 - Smart View Behavior Options in EPM Cloud
 
 - 
               
               
                  
                  23
                      Smart View and Narrative Reporting
               
                  
               
               
               
- About Narrative Reporting
 - Setting Up Narrative Reporting in Smart View
 - Connecting to Narrative Reporting in Smart View
 - Using Narrative Reporting Home
 - Administering Report Packages in Smart View
 - 
                     
                     Authoring Doclets
                        
                     
                     
                     
- About the Author Phase Process
 - Authoring Doclets in Smart View
 - Working with Linked Regular Doclets
 - 
                           
                           Working with Embedded Content from Reference Doclets
                              
                           
                           
                           
- About Embedded Content From Reference Doclets
 - Adding Reference Doclets to a Report Package
 - Creating Available Content Using the Available Content Button in Reference Doclets
 - Creating Available Content from Excel Named Ranges in Reference Doclets
 - Validating Fonts in Reference Doclets
 - Embedding Content in a Doclet
 - Updating Excel-based Reference Doclet Content and Properties
 - Deleting Available Content from Excel-based Reference Doclets
 - Previewing Available Content
 - Refreshing Embedded Content in a Doclet
 - Viewing Available Content Name in Doclets
 - Removing Embedded Content from a Doclet
 
 - 
                           
                           Working with Embedded Content from Reference Files
                              
                           
                           
                           
- About Embedding Content from Reference Files
 - Creating Available Content Using the Available Content Button in Reference Files
 - Creating and Embedding Available Content from Excel Named Ranges in Reference Files
 - Managing Named Ranges for Reference Files
 - Updating Available Content in a Reference File
 - Remapping Content within Reference Files
 
 - 
                           
                           Working with Variables
                              
                           
                           
                           
- About Variables
 - Creating Static Variables
 - Creating Reference Variables
 - Inserting Variables in a Doclet
 - Working with Variables in Smart View for PowerPoint
 - Searching for Variables
 - Locating the Source of Reference Variable Values
 - Editing Variables
 - Filtering Variables
 - Highlighting Variables in Doclets
 - Inspecting Variables
 - Unlinking Reference Variables
 - Deleting Variables
 
 - Working with Excel Doclets in PDF-based Report Packages
 - Working with Server-Initiated Refresh
 - Inserting Links and Cross-References to Pages in Doclets
 - Working with an Automatic Table of Contents
 - Approving or Rejecting Doclets
 - Recalling Doclets
 - Inspecting Doclets
 - Reverting to a Prior Version of a Doclet
 
 - Performing Reviews
 - Working with Distributions
 - Performing Sign Offs
 - Refreshing Report Packages
 - Publishing Report Packages, Sections, and Doclets
 - Saving Office Documents to EPM Cloud in Narrative Reporting in Smart View
 - Working with Reports in Smart View
 - Working with Narrative Reporting Data in Smart View
 
 - 24 Smart View and Account Reconciliation
 - 25 Smart View and Profitability and Cost Management
 - 
               
               
                  
                  26
                      Smart View and Reporting and Analysis
               
                  
               
               
               
- About Importing Reporting and Analysis Documents
 - Editing and Refreshing Documents
 - Refreshing Reporting and Analysis Documents
 - Financial Reporting Import Formats
 - Importing Financial Reporting Documents
 - Exporting Financial Reporting Reports
 
 - 
               
               
                  
                  27
                      Smart View and Oracle Analytics Cloud
               
                  
               
               
               
- About Oracle Analytics Cloud and Smart View
 - Features and Components of Oracle Analytics Cloud in Smart View
 - Installing the Oracle Analytics Cloud Extension
 - Working with Windows System Locales in Oracle Analytics Cloud
 - Connecting to Multiple Oracle Analytics Cloud Data Sources
 - Oracle BI Presentation Catalog
 - 
                     
                     Working with Oracle Analytics Cloud Analyses, Views, and Dashboards
                        
                     
                     
                     
- Supported Oracle Analytics Cloud View and Object Types
 - Inserting Tables and Pivot Tables
 - Inserting Graphs
 - Inserting Compound Views
 - Inserting Dashboards
 - Working with Prompts
 - Working with Page Prompts
 - Specifying Preferences for Refreshing Views
 - Refreshing Views
 - Masking Data in Views
 - Viewing Properties of an Oracle Analytics Cloud Object
 - Copying and Pasting Oracle Analytics Cloud Objects Between Office Applications
 - Editing an Analysis in Oracle Analytics Cloud
 - Copying and Pasting Views From Oracle Analytics Cloud to Office
 - Editing Views Created in Oracle Analytics Cloud
 
 - Working with Views Using the View Designer
 
 - 28 Smart View and Essbase Cloud
 - 
               
               
                  
                  29
                      Smart View Diagnostics and Health Check
               
                  
               
               
               
- About Smart View Diagnostics and Health Check
 - Displaying the Diagnostics Group in the Smart View Ribbon
 - Customizing Diagnostics Features
 - Using the Smart View Diagnostics Tools
 - Cleaning Up the Diagnostics Folder
 - Performing a Health Check On Your System
 - Performing a Health Check on Microsoft Office Documents
 
 - A Finding Information