In this recipe, we will extract data using the APIs in Excel and an MDX script. We will be using the Visual Basic editor to load the
smartviewvba.bas file, enter the code needed to connect to Essbase, and extract data specified in our MDX script. In addition, we will conduct a similar task manually using the Execute MDX option in Smart View.
To get started, click on the Start menu and navigate to Programs | Microsoft Office | Excel.