O'Reilly logo

Oracle Essbase 11 Development Cookbook by Jose R. Ruiz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using MDX for extracting data using API

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.

Getting ready

To get started, click on the Start menu and navigate to Programs | Microsoft Office | Excel.

How to do it...

  1. In Excel, click on Sheet1 and press Alt+F11. You will launch Microsoft Visual Basic editor, which should look like the following screenshot:
    How to do it...
  2. Right-click ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required