Download Smart View

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.

Smart View for Mac via Microsoft Remote Desktop

Mac Requirements:
  1. OS X version 10.7 or higher
  2. Microsoft Remote Desktop 8.0 or higher
  3. UCSF direct network connection or Duo Pulse VPN (wired or wireless)

Check if you already have Microsoft Remote Desktop installed by going to the Mac Search Finder in the upper right corner > click on the magnifying glass > Start typing "Microsoft Remote Desktop" into the seach bar.  If it is already installed the application will appear > Click on it and skip to the Microsoft Remote Desktop Configuration section.

Microsoft Remote Desktop Download:

Microsoft Remote Desktop can be downloaded from the App Store.

  1. Navigate again to the Mac Search Finder magnifying glass in the upper right corner of the Mac.
  2. Start typing "App Store".
  3. The application will appear; click on App Store application
  4. Once App Store opens, click in the App Store search bar.
  5. Search for "Microsoft Remote Desktop."
  6. The application will appear; download.

You may need admin access to your machine to download anything. See your local desktop support or create a ServiceNow ticket for the IT Service Desk if you have trouble downloading.

Mac Remote Desktop download screen from the App Store.

Microsoft Remote Desktop Configuration:

Once downloaded, you will need to launch Microsoft Remote Desktop application and configure the settings.

  1. Click on Add Workspace

    Add workspace to Remote Desktop

  2. Enter the URL: https://smview.ucsf.edu/RDWeb/Feed/webfeed.aspx 

    Add Workspace URL

  3. Click Add

  4. Microsoft Excel 2016 (with Smart View) will be made available under Remote Desktop Workspaces. Double-click on Excel 2016 under Work Resources.

    Excel 2016 available under Work Resources.

  5. The application may take up to 30 seconds to load, especially the first time.

  6. If a Certificate prompt pops up, click on the 'Show Certificate' button and check the box next to Always trust "smartview.campus.net.ucsf.edu" when connecting to "smview.ucsf.edu".  Click the 'Continue' button.

    Smart View Certificate prompt

  7. Enter your Active Directory (AD) credentials (the user name and password you use to sign in to your computer every morning).  Click the 'Continue' button.

  8. You will receive a Duo authentication push notification on your phone.  Click 'Approve' to complete your login.

    duo authentication prompt

  9. The complete instructions on how to Log On to Smart View can be found on page 10 of the Smart View: Installation and Planning Forms training manual. 
Saving Files (to preserve formulas):

Although Excel (with Smart View) is being run on a remote server, it does appear to you as if it is running locally.  Files can be saved on your local workstation, but in a very specific way.

Save to Users > Username > Documents folder

Connect to Remote Desktop Resources.