#jdeveloper

[shugahanii]

Find correct version of JDeveloper to use with EBS R12.x - Oraask

Find correct version of JDeveloper to use with EBS R12.x

Find correct version of JDeveloper to use with EBS R12.x - Oraask

[palash90world-blog]

Connecting MySQL database through Oracle ADF/JDeveloper

Database connection is an important task in any application development. Due to this fact, each and every language has provided useful API ...

[catgovind]

How to delete and recreate Integrated WebLogic Server Default Domain in JDeveloper?

How to delete and recreate Integrated WebLogic Server Default Domain in JDeveloper?

How to delete and recreate Integrated WebLogic Server Default Domain in JDeveloper?

Some times we may have a situation where the Integrated WebLogic server has problems to start, or it takes too long time to respond back. It is simple to recreate it than to troubleshoot. In this section, we explained on how to delete the Default Domain and recreate it.

Delete IntegratedWebLogic DefaultDomain

1.…

View On WordPress

[soacommunity]

Create a SOA Application in JDeveloper 12c Using Maven SOA Plug-In by Daniel Rodriguez

Create a SOA Application in JDeveloper 12c Using Maven SOA Plug-In by Daniel Rodriguez

  Maven is a commonly used build system for java projects. It provide benefits ranging from standardizing project layouts, to automated dependency fetching, to automated builds and Maven.  Oracle provides a pretty comprehensive document outlining how to build and create Oracle SOA and BPM projects using Maven. See this articlethat documents some simple steps to get up and running using Maven.…

View On WordPress

[essbaselabs]

Kaleidoscope 2009 Hands on Lab - Oracle Essbase Java API - Building Your First Application (S656)

I know it has been while since the show but I wanted to make sure this got posted.  The plan for this lab was to build on S655 and S654 and for the end result to be a useable Essbase utility written with the Java API in JDeveloper. 

The lab was focused on the Outline API and was centered around the idea of creating an Outline Extractor.  The lab can be downloaded here.  This lab will get you started but here is a more complete code sample with XML output.

package com.oracle.essbase.japi;

  import com.essbase.api.base.EssException;

import com.essbase.api.base.IEssIterator;

import com.essbase.api.datasource.IEssCube;

import com.essbase.api.datasource.IEssOlapServer;

import com.essbase.api.domain.IEssDomain;

import com.essbase.api.metadata.IEssCubeOutline;

import com.essbase.api.metadata.IEssDimension;

import com.essbase.api.metadata.IEssGeneration;

import com.essbase.api.metadata.IEssLevel;

import com.essbase.api.metadata.IEssMember;

import com.essbase.api.session.IEssbase;

 import java.util.ResourceBundle;

 import javax.xml.parsers.DocumentBuilder;

import javax.xml.parsers.DocumentBuilderFactory;

 import javax.xml.parsers.ParserConfigurationException;

 import javax.xml.transform.OutputKeys;

import javax.xml.transform.Transformer;

import javax.xml.transform.TransformerException;

import javax.xml.transform.TransformerFactory;

import javax.xml.transform.dom.DOMSource;

 import javax.xml.transform.stream.StreamResult;

 import org.w3c.dom.DOMImplementation;

import org.w3c.dom.Document;

import org.w3c.dom.Element;

import org.w3c.dom.Node;

 public class OutlineExtractor {

private static String s_userName = "";

private static String s_password = "";

private static String s_olapSvrName = "";

private static String s_provider = "";

private IEssOlapServer olapSvr = null;

private IEssbase ess = null;

private Document doc;

public OutlineExtractor() {

olapSvr = Connect();

}

  public static void main(String[] args) {

OutlineExtractor outlineExtractor = new OutlineExtractor();

outlineExtractor.ReadOutline("Sample","Basic", true);

outlineExtractor.Disconnect();

}

private IEssOlapServer Connect() {

readProperties();

try {

// Create JAPI instance.

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

// Sign On to the Provider

IEssDomain dom = ess.signOn(s_userName, s_password, false, null, s_provider);

IEssOlapServer olapSvr = dom.getOlapServer(s_olapSvrName);

olapSvr.connect();

return olapSvr;

}

catch (EssException e) {

System.out.println(e.getMessage());

e.printStackTrace(System.out);

Disconnect();

return null;

}

}

private void Disconnect(){

//Try to sign off

try {

if (olapSvr != null && olapSvr.isConnected() == true){

olapSvr.disconnect();

}

} catch (EssException e) {

System.out.println(e.getMessage());

e.printStackTrace(System.out);

}

try {

if (ess != null && ess.isSignedOn() == true){

ess.signOff();

}

} catch (EssException e) {

System.out.println(e.getMessage());

e.printStackTrace(System.out);

}

}

private static void readProperties() {

ResourceBundle settings = ResourceBundle.getBundle("Essbase");

  s_userName=settings.getString("Common.UserName");

s_password=settings.getString("Common.Password");

s_olapSvrName = settings.getString("Common.ServerName");

s_provider = settings.getString("Common.Provider");

}

public void ReadOutline(String ApplicationName, String DatabaseName, Boolean IncludeAttributes){

IEssCube cube;

try {

cube = olapSvr.getApplication(ApplicationName).getCube(DatabaseName);

readOutline(cube,DatabaseName,IncludeAttributes);

} catch (EssException e) {

System.out.println(e.getMessage());

e.printStackTrace(System.out);

}

}

private void readOutline(IEssCube cube, String DatabaseName, Boolean IncludeAttributes) throws EssException {

IEssCubeOutline otl = null;

try {

otl = cube.openOutline();

IEssIterator dims = otl.getDimensions();

DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();

DocumentBuilder builder = factory.newDocumentBuilder();

DOMImplementation impl = builder.getDOMImplementation();

  doc = impl.createDocument(null,null,null);

Element elementCube = doc.createElement("Cube");

elementCube.setAttribute("ApplicationName", cube.getApplicationName());

elementCube.setAttribute("DatabaseName", DatabaseName);

elementCube.setAttribute("CubeType", cube.getCubeType().stringValue());

doc.appendChild(elementCube);

for (int i = 0; i < dims.getCount(); i++) {

IEssDimension dim = (IEssDimension)dims.getAt(i);

if (IncludeAttributes) {

Element elementDim = doc.createElement("Dimension");

elementDim.setAttribute("DimensionName", dim.getName());

elementDim.setAttribute("Category", dim.getCategory().stringValue());

elementDim.setAttribute("StorageType", dim.getStorageType().stringValue());

elementCube.appendChild(elementDim);

getMembersIterator(dim.getDimensionRootMember(),elementDim);

}

else{

if(dim.getCategory() != IEssDimension.EEssDimensionCategory.ATTRIBUTE && dim.getCategory() != IEssDimension.EEssDimensionCategory.ATTRIBUTE_CALC){

Element elementDim = doc.createElement("Dimension");

elementDim.setAttribute("DimensionName", dim.getName());

elementDim.setAttribute("Category", dim.getCategory().stringValue());

elementDim.setAttribute("StorageType", dim.getStorageType().stringValue());

elementCube.appendChild(elementDim);

getMembersIterator(dim.getDimensionRootMember(),elementDim);

}

}

}

otl.close();

otl = null;

// transform the Document into a String

DOMSource domSource = new DOMSource(doc);

TransformerFactory tf = TransformerFactory.newInstance();

Transformer transformer = tf.newTransformer();

//transformer.setOutputProperty(OutputKeys.OMIT_XML_DECLARATION, "yes");

transformer.setOutputProperty(OutputKeys.METHOD, "xml");

transformer.setOutputProperty(OutputKeys.ENCODING,"ISO-8859-1");

transformer.setOutputProperty("{http://xml.apache.org/xslt}indent-amount", "4");

transformer.setOutputProperty(OutputKeys.INDENT, "yes");

java.io.StringWriter sw = new java.io.StringWriter();

StreamResult sr = new StreamResult(sw);

transformer.transform(domSource, sr);

String xml = sw.toString();

System.out.println(xml);

} catch (EssException e) {

System.out.println(e.getMessage());

e.printStackTrace(System.out);

}

catch (ParserConfigurationException e) {

System.out.println(e.getMessage());

e.printStackTrace(System.out);

}

catch (TransformerException e) {

System.out.println(e.getMessage());

e.printStackTrace(System.out);

}

finally {

if (otl != null) {

try {

otl.close();

} catch (EssException e) {

System.out.println(e.getMessage());

e.printStackTrace(System.out);

}

}

}

}

  private void getMembersIterator(IEssMember mbr,Element ParentElement) throws EssException{

Element elementMember = doc.createElement("Member");

elementMember.setAttribute("MemberName", mbr.getName());

elementMember.setAttribute("UniqueName", mbr.getUniqueName());

elementMember.setAttribute("MemberFormula", mbr.getFormula());

elementMember.setAttribute("LevelNumber", String.valueOf(mbr.getLevelNumber()));

elementMember.setAttribute("GenerationNumber", String.valueOf(mbr.getGenerationNumber()));

elementMember.setAttribute("ChildCount", String.valueOf(mbr.getChildCount()));

ParentElement.appendChild(elementMember);

IEssIterator mbrs = mbr.getChildMembers();

for (int i = 0; i < mbrs.getCount(); i++) {

getMembersIterator((IEssMember)mbrs.getAt(i),elementMember);

}

}

 }

Here is what my properties file looks like.

Common.UserName=admin Common.Password=password Common.ServerName=localhost Common.Provider=Embedded

If you complete this lab you may run into a bug with connections.  Tim Tow has documented this fix very well… http://timtows-hyperion-blog.blogspot.com/2007/12/essbase-api-error-fix-geeky.html

[essbaselabs]

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.

[essbaselabs]

Kaleidoscope 2009 Hands on Lab - Introducing J-Developer (S654)

If you did not get a chance to sign up for the hands on lab I wanted to give you a chance to get some of the content.  This lab is intended to be a intro to J-Developer so that you can begin using J-Developer. If you follow this online tutorial you will get all the same content and more.  If you are interested in using J-Developer with the Essbase Java API check out my earlier blog on this topic.

[essbaselabs]

Kaleidoscope 2009

Check out my sessions at Kaleidoscope 2009:

http://www.odtugkaleidoscope.com/abstracts.html#Milella

Top Five Essbase CDF's In this session we will demonstrate how to install and use a CDF (Custom Defined Function) in Essbase. We will also walk through some of the most popular CDF categories including an overview of J-Export. CDF categories include; exporting data (J-Export), importing data, accessing Web content (stock quotes, other Web services), outline changes with the Essbase JAPI, and general utility functions for tuning and debugging Essbase calculations.

Bonus CDF - Integrate Essbase with Twitter http://essbaselabs.blogspot.com/2009/05/ashton-kutcher-can-now-get-my-essbase.html

  Hands on Labs

I will also be joining Tim Tow in some hands on labs:

Introducing JDeveloper In this session, you will learn how to download, install and perform the basic configuration, with a focus on the Essbase Java API, of the Oracle JDeveloper Java Integrated Development Environment.   You will also learn basic Java concepts including how to create a new Java application and project and how to create a new Java class by creating the classic Java ‘Hello World’ application.

Java API: The Basics In this session, you will learn the basic structure of the Essbase Java API, how to use it to connect to a given Essbase server, application and database, how to layout a data retrieval grid and how to retrieve data into the grid.

Java API: Building Your First App In this session, you will learn how to use the Essbase Java API to write an application, we will focus our efforts on building an outline extractor.