Kaleidoscope 2009 Hands on Lab - Oracle Essbase Java API - The Basics (S655)

The goal of this lab was to introduce the to Essbase Java API and teach the basics.  It walked through the following:

• Setting up J-Developer to work with the Essbase Java API (check out my earlier blog on this topic)
• Connecting to Essbase
• Creating a grid view (grid API, similar to what the classic add-in uses)
• Filling in and querying the grid view
• Basic output of the results

The Essbase Java API objects covered in this lab:

• IEssbase - The Essbase API instance object.
• IEssOlapServer - The connection to the Essbase server.
• IEssCube - The Essbase cube object.
• IEssCubeView & IEssGridView - The Essbase grid API.

If you did not get a chance to sign up for this hands on lab or just want to try it you can get the lab here.

Please note that this lab was based on a pre-built image so some of the directories, URL's, username,etc. will vary.

Here is the complete code for the lab:

package myproject;

import com.essbase.api.base.*;

import com.essbase.api.dataquery.*;

import com.essbase.api.session.*;

import com.essbase.api.datasource.*;

public class Essbase {

    private static String username = "admin";

    private static String password = "password";

    private static String essbaseServer = "localhost"; 

    private static String provider = "http://localhost:13080/aps/JAPI"; 

    private static String application = "Sample"; 

    private static String database = "Basic";

    public Essbase() {

    }

    public static void main(String[] args) {

        IEssbase essbase = null;

        try {

            essbase = IEssbase.Home.create(IEssbase.JAPI_VERSION);

            IEssOlapServer olapServer = essbase.signOn(username,password,

                                                       false,null,provider,essbaseServer);

            IEssCube cube = olapServer.getApplication(application).getCube(database);

            IEssCubeView cubeView = cube.openCubeView("default");

            cubeView.setAliasNames(true);

            cubeView.updatePropertyValues();

            IEssGridView gridView = cubeView.getGridView();

            gridView.setSize(3,5);

            gridView.setValue(0,2,"Product");

            gridView.setValue(0,3,"Market");

            gridView.setValue(1, 2, "Jan"); 

            gridView.setValue(1, 3, "Feb"); 

            gridView.setValue(1, 4, "Mar"); 

            gridView.setValue(2, 0, "Actual"); 

            gridView.setValue(2, 1, "Sales");

            IEssOperation essOp = cubeView.createIEssOpRetrieve(); 

            cubeView.performOperation(essOp);

            int rowCount = gridView.getCountRows(); 

            int colCount = gridView.getCountColumns(); 

            for (int i = 0; i < rowCount; i++) { 

                for (int j = 0; j < colCount; j++) { 

                    System.out.print(gridView.getStringValue(i, j) + "\t"); 

                    } 

                System.out.print("\n"); 

                }

        } 

        catch(EssException e) 

        { 

            System.out.println("Error: " + e.getMessage()); 

        } 

        finally 

        { 

            try 

            { 

                if (essbase != null && essbase.isSignedOn() == true) essbase.signOff(); 

            } 

            catch (EssException e1) 

            {

                System.err.println("Error: " + e1.getMessage()); 

            } 

        }

    }

}

You can download the lab here.