As you know, Smart View is an Excel add-in. For years, it is only available for Windows OS. Starting from this month, June 2019, it finally supports Excel 365 for Mac OS and a browser-based version of Excel 365.

The new Smart View add-in provides for a thin and customizable deployment across the enterprise in support of Oracle EPM Cloud applications. In this initial release, it supports the following major features:

Download Smart View. Smart View is an excel interface that connects with Hyperion Planning and Essbase to allow users to perform ad hoc analysis and reporting, input data instead of the web-based forms, and view Financial Reporting (FR) reports. Here you will find a variety of downloads that can be used to enhance or extend Smart View. Power Pack Extensions For release 11.1.2.5.210, if the Power Pack Extension does not appear in the Smart View Options dialog, it may be due to the download installer file being flagged as blocked. This powerful software provides a suite of tools that views, optimizes, annotates, and analyzes IR thermal images and videos. It also generates fully customizable and professional-looking reports with the push of a button or in a few easy steps. SmartView by Samsung is a free application that will help you watch online TV stations on your computer and even use it as a remote controller for your TV set or Blu-Ray player. Sadly, you won't be able to find SmartView for Mac, so, you might want to use one of the alternative Mac tools.

Ad hoc analysis operations such as Zoom, Pivot, Keep/Remove only, as well as Submit, Range Operations, Analyze/Free Form, and Formula Preservation
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

In order to make this version work for you, you have to make sure:

Use either Excel 365 on a Mac or Excel 365 on Chrome
Have admin access on the EPM environment
Update the environment to at least 19.02

Now, let’s configure this Smart View on a Mac OS. Firstly, we would need to create a Manifest file. The manifest file is used for Office 365 users to present with a Smart View ribbon containing buttons and menu commands. Go to the manifest page to create a manifest file. The URS is:

Select a Provider to create manifest. For example, select EPBCS.

By selecting EPBCS, it will give you available ribbon commands for the Planning provider.

Click Create Manifest to create the manifest file. Remember, do not include spaces in the manifest file name.

Samsung Smart View 2 For Mac

Load the manifest file to Mac Excel 365. Copy the manifest file to the following location:

/Users/<user>/Library/Containers/com.microsoft.Excel/Data/Documents/wef

If the wef folder does not exist in this location, then create the folder.

Launch Excel and select the Insert tab. Then in the My Add-ins drop-down menu, select Smart View.

The Smart View tab should appear in Excel. It provides the basis Smart View functionalities as of the Windows OS version.

Now, we are able to log in to the planning environment.

Smart View 2.0 Download For Mac

After login, the Library folder for the application will appear in the home panel. I have 3 play types (cubes), so I would see 3 sub-folders.

Smart View 2.0 For Mac

We can also click on the Job Console to check the job logs.

Smart View 2 For Pc

This Smart View version is becoming really handy if you are running a Mac OS. Hope you enjoy this post and see you next time.