Microsoft Office 365 refers to subscription plans that include access to Office applications plus other productivity services that are enabled over the Internet (cloud services) in addition to access to desktop versions. Smart View (Mac and Browser) was developed because the existing Oracle Smart View for Office add-in infrastructure supports only Windows desktop deployments and the Smart View (Mac and Browser) deployment aligns more closely with Microsoft Office 365.

Smart View (Mac and Browser) provides an interface between Oracle’s Cloud EPM and Essbase solutions and Microsoft Office 365 deployed in a web browser on either Windows or Mac systems. Specifically the Chrome browser on Windows/Mac is supported. Other platforms and devices are planned for a future release.

Other benefits of Smart View (Mac and Browser) include:

• Multi-platform support
• Ease of deployment and maintenance
• Frequent cloud updates
• Zero client footprint; no maintenance for end users
• Highly customizable user interface and deployment

Supported Features

Smart View (Mac and Browser) supports most of the features in Excel ad hoc analysis and forms. The following high-level features are supported:

• Ad hoc analysis operations such as: Zoom, Pivot, Keep/Remove Only, Submit, Range Operations, Analyze/Free Form, and Formula Preservation
• Multiple-grid ad hoc worksheets
• Form operations such as: Form Open and Refresh, Submit from Forms, Expand/Collapse, Supporting Details, Mass Allocate, Job Console, Copy Version, Business Rules, and Analyze
• Options and Styles
• Member Selection and POV
• Drill Through
• Save ad hoc grids as forms, including save formatting
• Save ad hoc grids as Smart Forms, including save formatting
• Spreading, Grid Spread, Cell Locking, and Mass Allocation
• Functions: Includes a Function Builder interface and supports manual use of: HsGetValue, HsSetValue, HsAlias, HsGetSheetInfo
• Task lists
• Dashboards
• Flex forms
• Full 508 accessibility support
• Application building and maintenance for administrators
• Non-English environment or platform

Unsupported Features

Some Smart View for Office features are currently not supported in Smart View (Mac and Browser), such as:

• Copy and paste data points
• Double-click on member or data cells is not supported. Instead, use ribbon commands to accomplish tasks, such as zoom-in.
• Open forms and ad hoc grids from web applications (web launch)
• Native mode for ad hoc operations: Oracle Smart View for Office (Mac and Browser) does not support Native mode for ad hoc operations in supported Cloud EPM applications. Native mode is being phased out in favor of Standard mode, which offers enhanced features and is recommended for all users. To utilize Smart View (Mac and Browser) effectively, Oracle advises you to configure your Cloud EPM applications to use the Standard mode option for the Smart View Ad Hoc Behavior setting. This ensures compatibility and access to the latest functionalities.
• Query Designer
• Word and PowerPoint functionality
• Composite forms (no future plans for support)
• VBA

Videos