Before seeing the instructions please make sure that you connected your iPhone/iPad or Android smartphone with your mac through USB cable. Launch Quick Time Player in your Mac. Does Smart View 11.1.2.5 Support the MAC Operating System (Doc ID 1646148.1) Last updated on JUNE 30, 2020. Applies to: Hyperion Essbase - Version 11.1.2.3.003 and later. Smartview 2.22.0010.0 for Mac I'm running OSZ Tiger, version 10.4.11 I think. Last night I updated to version 2.22.0010.0 and now the program won't open. When I try to open the program, the splash pops up for a few seconds and I can see the title in the menu bar. Then everything goes away.
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:
- 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.
Load the manifest file to Mac Excel 365. Copy the manifest file to the following location:
/Users//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.
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.
We can also click on the Job Console to check the job logs.
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.
Click Create Manifest to create the manifest file. Remember, do not include spaces in the manifest file name.
Load the manifest file to Mac Excel 365. Copy the manifest file to the following location:
/Users//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.
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.
We can also click on the Job Console to check the job logs.
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.
Oracle Smart View for Office provides a common Microsoft Office interface designed specifically for Oracle's Enterprise Performance Management (EPM) and Business Intelligence (BI) solutions.
Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word and PowerPoint interfaces. It is a comprehensive tool for accessing and integrating EPM and BI content from Microsoft Office products.
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) provides an interface between Oracle's EPM Cloud 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.
Smart View (Mac and Browser) was developed because the existing Smart View add-in infrastructure supports only Windows desktop deployments and the Smart View (Mac and Browser) deployment aligns more closely with Microsoft Office 365. Other benefits 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
Smart View (Mac and Browser) supports most of the features in Excel ad hoc analysis and forms. The following high-level features are included:
Smart View 2 For Pc
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
Saving ad hoc grids as forms, including saving formatting
Saving ad hoc grids as Smart Forms, including saving formatting
Spreading, Grid Spread, Cell Locking, and Mass Allocation
Functions - manual use of HsGetValue and HsSetValue
Application building and maintenance for administrators
Some Smart View for Office features are currently not available in Smart View (Mac and Browser), such as:
Copy and paste data points
Task lists
Double-click on member or data cells is not supported. Instead, use ribbon commands to accomplish tasks, such as zoom-in.
Word and PowerPoint functionality
Samsung Smart View 2 For Mac
Download microsoft word 2011 for mac. Videos
Smart View 2.0 For Mac
| Your Goal | Watch This Video |
|---|---|
Learn about using basic features in Smart View (Mac and Browser) | Introducing Smart View for Office Mac and Browser |
