This document explains how to connect to the Essbase Cube using the SmartView add-in in Excel.

Open the attachment and follow the steps in the document.