Crystal Reports for Eclipse 2.0 - Sample Codes Package Ted Ueda

New bundle of sample codes for Crystal Reports for Eclipse 2.0, brought to you by SAP Business Objects Customer Assurance Deveveloper Support - Java!

This package highlights basic functionality using the Crystal Reports Java 12.0 SDK, covering:

1. Web Application Viewing and Exporting
2. Report Creation/Modification
3. Designer Extension Points

Available for download here: Crystal Reports Java 12 Sample Codes

Web Intelligence XI 3.x - Reporting off the BusinessObjects Enterprise CMS Via Data Access DDK Ted Ueda

I work for SAP Business Objects Developer Support, helping developers create custom applications using the SDKs supplied with Business Objects products. If you log a SAP Incident concerning an issue with our SDKs, I might be the one calling to help fix the problem!

A not infrequent request I receive is for a way to report off the BusinessObjects Enterprise Central Management Server (CMS) database. There's very compelling business reasons for doing so - to record details of scheduled reports, user activity and server usage and load. The Enterprise Auditing features have come a long way and been greatly expanded since version 10, but there's still some data that's not being recorded in the audit database.
Question: How to Report off the CMS Database?

You cannot connect to and report off the CMS database directly. Much of the info is blobbed in a composite column in the repository tables, and this data cannot be decrypted without having to go through the CMS service.

To access the repository data, you would use the Enterprise SDK or Enterprise Web Services to send an Enterprise query (a SQL-type query) or a path query (an XPath-type query) to the CMS, that then will return a collection of InfoObject objects. An InfoObject is a programmatic, object-oriented representation of data held in the CMS database.

The Query Builder Admin Tool (found on the Enterprise XI 3.x Java web app deployment at http://:/AdminTools/), uses the SDK to send an Enterprise query to the CMS and displays a view of the InfoObject objects and their properties. Query Builder is particularly useful if you slightly modify it to accept path queries as well as Enterprise queries, as described here. You cannot, however, schedule the Query Builder, and it's difficult to translate its HTML output to other formats.

What's required is a way to "hook up" either the Enteprise SDK or Enterprise Web Services to a data source that can be consumed by a report.

One possibility is to use Desktop Intelligence documents with VBA data providers, where the VBA invokes the Enterprise COM SDK to retrieve the InfoObject objects. The VBA then will translate the InfoObject properties to a data cube. The COM version of the SDK, however, has been deprecated with XI Release 2 and is no longer available with XI 3.x

Another possibility is to use the POJO reporting functionality of Crystal Reports. You can write Java code that uses the Enterprise SDK or Web Services to retrieve InfoObject objects and copies the desired InfoObject properties to a POJO collection. This solution, however, is restricted to Crystal Reports reports only.

What of Web Intelligence? Or Query as a Web Service (QaaWS)? Fortunately, there is a way.
POJO Reporting using the DDK

In a previous blog entry, POJO and RSS Feed Reporting with Web Intelligence Using the Data Access Driver Development Kit, I describe how you can use the new Universe Data Access Driver Development Kit (DDK) SDK and the Crystal Reports Java SDK POJO ResultSet Factory to create a Universe Connection that consumes POJO collection data sources.

This blog entry is a continuation of that blog, so that blog is worth a read if you're interested in this current subject.

What I'm going to describe here is how to connect the BusinessObjects Enterprise BIPlatform Web Services to the POJO data driver. The connection will pass a specified path query to Enterprise via Web Services, and fill a POJO collection with returned InfoObject collection properties.

The data flow in this workflow is:

CMS -> Web Services -> CRJ SDK -> DDK -> Universe

To understand this blog, you should be familiar with the following:

1. Java programming
2. BusinessObjects Enterprise Web Services programming
3. BusinessObjects Enterprise Path Queries
4. How to download Crystal Reports for Eclipse 2.0 (CRJ SDK)
5. Configuring the DDK JavaBean Driver
6. Creating Universe connections and Universes

I think the results well worth the effort. Here's a screenshot of what I was able to accomplish:
image



This is a Web Intelligence document that lists all scheduled instances that were created since last September, grouped by name. You can see that many InfoObject properties for Web Intelligence, Crystal Reports and even Program Objects are represented in the available objects.

I'll provide code samples, brief deployment instructions, and possible avenues for extending the code.
Hooking up Enterprise Web Services to the DDK JavaBeans

I'll list the sample code here. The SCN width restrictions make the code not easy to read here, so I recommend copy-and-pasting them to local file and reading them using your favorite text editor.

The POJO JavaBeans code comes in three Java source code files. First is the POJO definition, that is used to hold the InfoObject properties retrieved from the CMS. Second is the JavaBean, that defines the method the Universe calls to retrieve the data as a java.sql.ResultSet object. Third is the JavaBeanInfo, that informs the JavaBean consumer which method in the JavaBean code should be called. There is also the DDK JavaBean configuration file, javabean.sbo, used to configure the connection - location of the Java jar library files and connection parameters.

Here is the backing POJO code:

InfoObjectPOJO.java - the POJO representation of InfoObject data
package com.sap.ddk.javabean.sample; import java.sql.Timestamp; /* * POJO for InfoObject properties, designed as adapter between Universe DDK, * Crystal Reports Java POJO ResultSet Factory and BusinessObjects Enterprise * Web Services. * * Each property maps to a possible property for an InfoObject or its subclass. * * - Universes represent a boolean as Number. * - CRJ POJO does not use java.util.Calendar but java.sql.Timestamp for timestamps. * - CRJ POJO does not handle nested properties, so nested InfoObject properties * are mapped to a property with name reflecting the nesting. For example, * the property InfoObject.getSchedulingInfo().getBeginDate() will map to * InfoObjectPOJO.getSchedulingInfo_BeginDate(). */ public class InfoObjectPOJO { private Timestamp creationTime; private String cuid; private String description; private Timestamp endTime; private String errorMessage; private String fileProperties_Files_FileArray_Name; private Integer id; private Integer instance; private Integer isRecurring; private String keywords; private String kind; private Timestamp lastRunTime; private String lastSuccessfulInstanceCUID; private String name; private Timestamp nextRunTime; private String owner; private String parentCUID; private Timestamp schedulingInfo_BeginDate; private Timestamp schedulingInfo_EndDate; private String schedulingInfo_Flags; private Integer schedulingInfo_RightNow; private String schedulingInfo_ScheduleType; private String schedulingInfo_Status; private String schedulingInfo_TimeZone; private Timestamp startTime; private Timestamp updateTime; public Integer getInstance() { return instance; } public void setInstance(Integer instance) { this.instance = instance; } public Integer getIsRecurring() { return isRecurring; } public void setIsRecurring(Integer isRecurring) { this.isRecurring = isRecurring; } public String getKeywords() { return keywords; } public void setKeywords(String keywords) { this.keywords = keywords; } public String getKind() { return kind; } public void setKind(String kind) { this.kind = kind; } public Timestamp getLastRunTime() { return lastRunTime; } public void setLastRunTime(Timestamp lastRunTime) { this.lastRunTime = lastRunTime; } public String getLastSuccessfulInstanceCUID() { return lastSuccessfulInstanceCUID; } public void setLastSuccessfulInstanceCUID(String lastSuccessfulInstanceCUID) { this.lastSuccessfulInstanceCUID = lastSuccessfulInstanceCUID; } public Timestamp getNextRunTime() { return nextRunTime; } public void setNextRunTime(Timestamp nextRunTime) { this.nextRunTime = nextRunTime; } public String getOwner() { return owner; } public void setOwner(String owner) { this.owner = owner; } public String getParentCUID() { return parentCUID; } public void setParentCUID(String parentCUID) { this.parentCUID = parentCUID; } public Timestamp getSchedulingInfo_EndDate() { return schedulingInfo_EndDate; } public void setSchedulingInfo_EndDate(Timestamp schedulingInfo_EndDate) { this.schedulingInfo_EndDate = schedulingInfo_EndDate; } public String getSchedulingInfo_Flags() { return schedulingInfo_Flags; } public void setSchedulingInfo_Flags(String schedulingInfo_Flags) { this.schedulingInfo_Flags = schedulingInfo_Flags; } public Integer getSchedulingInfo_RightNow() { return schedulingInfo_RightNow; } public void setSchedulingInfo_RightNow(Integer schedulingInfo_RightNow) { this.schedulingInfo_RightNow = schedulingInfo_RightNow; } public String getSchedulingInfo_ScheduleType() { return schedulingInfo_ScheduleType; } public void setSchedulingInfo_ScheduleType(String schedulingInfo_ScheduleType) { this.schedulingInfo_ScheduleType = schedulingInfo_ScheduleType; } public String getSchedulingInfo_TimeZone() { return schedulingInfo_TimeZone; } public void setSchedulingInfo_TimeZone(String schedulingInfo_TimeZone) { this.schedulingInfo_TimeZone = schedulingInfo_TimeZone; } public Timestamp getStartTime() { return startTime; } public void setStartTime(Timestamp startTime) { this.startTime = startTime; } public Timestamp getUpdateTime() { return updateTime; } public void setUpdateTime(Timestamp updateTime) { this.updateTime = updateTime; } public String getSchedulingInfo_Status() { return schedulingInfo_Status; } public void setSchedulingInfo_Status(String schedulingInfo_Status) { this.schedulingInfo_Status = schedulingInfo_Status; } public Timestamp getSchedulingInfo_BeginDate() { return schedulingInfo_BeginDate; } public void setSchedulingInfo_BeginDate(Timestamp schedulingInfo_BeginDate) { this.schedulingInfo_BeginDate = schedulingInfo_BeginDate; } public Timestamp getCreationTime() { return creationTime; } public void setCreationTime(Timestamp creationTime) { this.creationTime = creationTime; } public String getCUID() { return cuid; } public void setCUID(String cuid) { this.cuid = cuid; } public String getName() { return name; } public void setName(String name) { this.name = name; } public Integer getID() { return id; } public void setID(Integer id) { this.id = id; } public String getDescription() { return description; } public void setDescription(String description) { this.description = description; } public Timestamp getEndTime() { return endTime; } public void setEndTime(Timestamp endTime) { this.endTime = endTime; } public String getErrorMessage() { return errorMessage; } public void setErrorMessage(String errorMessage) { this.errorMessage = errorMessage; } public String getFileProperties_Files_FileArray_Name() { return fileProperties_Files_FileArray_Name; } public void setFileProperties_Files_FileArray_Name( String fileProperties_Files_FileArray_Name) { this.fileProperties_Files_FileArray_Name = fileProperties_Files_FileArray_Name; } }

here is the JavaBean:

InfoObjectJavaBean.java - the DDK JavaBean
package com.sap.ddk.javabean.sample; import java.lang.reflect.Method; import java.net.URL; import java.sql.ResultSet; import java.sql.Timestamp; import java.util.ArrayList; import java.util.Calendar; import java.util.List; import java.util.Properties; import com.businessobjects.connectionserver.CSException; import com.businessobjects.connectionserver.datasources.ddk.Context; import com.businessobjects.connectionserver.datasources.ddk.javabean.Bean; import com.businessobjects.dsws.Connection; import com.businessobjects.dsws.biplatform.BIPlatform; import com.businessobjects.dsws.biplatform.ResponseHolder; import com.businessobjects.dsws.session.EnterpriseCredential; import com.businessobjects.dsws.session.Session; import com.businessobjects.enterprise.infoobject.InfoObject; import com.businessobjects.enterprise.infoobject.InfoObjects; import com.crystaldecisions12.sdk.occa.report.application.internal.POJOResultSetHelper; /* * BusinessObjects Enterprise Data Access Driver Development Kit JavaBean * sample for reporting off of the CMS database using the BusinessObjects Enterprise * Web Services. * * Enterprise logon credentials are read from the Universe Connection User and * Password. The Enterprise path query is read from the Connection url. * * CMS name is read from the "CMS Name" Parameter defined for the connection in the * javabean.sbo. * * CMS authentication type is read from the "CMS Authentication Type" Parameter in the * javabean.sbo. * * This sample requires the XI 3 Business Objects Web Services Java Consumer and Crystal * Report Java SDK POJO ResultSet Factory. */ public class InfoObjectJavaBean implements Bean { private String url; private String boUsername; private String boPassword; private String boCMSName; private String boAuthType; private String wsSessionURL; /* * Read and store Enterprise query and logon credentials from the context * and CMS name and authentication type from javabean.sbo parameters. */ public void initialize(Context context, String url, Properties properties) throws CSException { this.url = url; this.boUsername = (String) context.getCredentials().get("USER"); this.boPassword = (String) context.getCredentials().get("PASSWORD"); try { this.boCMSName = context.getConfiguration().getString("CMS Name"); } catch (CSException cse) { this.boCMSName = "localhost"; } try { this.boAuthType = context.getConfiguration().getString("CMS Authentication Type"); } catch (CSException cse) { this.boAuthType = "secEnterprise"; } try { this.wsSessionURL = context.getConfiguration().getString("Session Web Services URL"); } catch(CSException cse) { this.wsSessionURL = "http://localhost:8080/dswsbobje/services/Session"; } } public void close() {} /* * Retrieve InfoObject collection from Enterprise Web Services, copy properties * over to InfoObjectPOJO, and generate and return ResultSet using POJO * ResultSet Factory. */ public ResultSet getInfoObjectResultSet() throws Throwable { Method[] pojoSetters; List pojos; POJOResultSetHelper pojoResultSetHelper; /* * DSWSBobje Web Services Consumer expects a Thread context class loader. Since * DDK does not supply one, we copy over the bean creator class loader. */ Thread.currentThread().setContextClassLoader(this.getClass().getClassLoader()); /* * Retrieve all bean setters in the InfoObjectPOJO. */ pojoSetters = getPOJOSetters(InfoObjectPOJO.class); pojos = new ArrayList(); try { URL sessionURL; Connection boConnection; Session boSession; EnterpriseCredential boEnterpriseCredential; String[] biPlatformURL; BIPlatform boBIPlatform; /* * Log onto Enterprise Web Services and retrieve the BIPlatform service. */ sessionURL = new URL(this.wsSessionURL); boConnection = new Connection(sessionURL); boSession = new Session(boConnection); boEnterpriseCredential = EnterpriseCredential.Factory.newInstance(); boEnterpriseCredential.setDomain(this.boCMSName); boEnterpriseCredential.setLogin(this.boUsername); boEnterpriseCredential.setPassword(this.boPassword); boEnterpriseCredential.setAuthType(this.boAuthType); boSession.login(boEnterpriseCredential); biPlatformURL = boSession.getAssociatedServicesURL("BIPlatform"); boBIPlatform = BIPlatform.getInstance(boSession, biPlatformURL[0]); /* * Retrieve InfoObject collection. */ ResponseHolder boResponseHolder = boBIPlatform.get(this.url, null); InfoObjects boInfoObjects = boResponseHolder.getInfoObjects(); /* * For each InfoObject, create a POJO. */ for(InfoObject infoObject : boInfoObjects.getInfoObjectArray()) { InfoObjectPOJO pojo; pojo = createInfoObjectPOJO(infoObject, pojoSetters); pojos.add(pojo); } boSession.logout(); } catch(Throwable e_ignore) { // Log.error(e_ignore); throw e_ignore; } /* * Generate java.sql.ResultSet from collection of POJOs. */ pojoResultSetHelper = new POJOResultSetHelper(InfoObjectPOJO.class); return pojoResultSetHelper.createResultSet(pojos); } /* * For a specified class, return all bean setters. */ private Method[] getPOJOSetters(Class aclass) { List pojoSetterList; pojoSetterList = new ArrayList(); for(Method method : aclass.getDeclaredMethods()) { if(!method.getName().startsWith("set") || !Void.TYPE.equals(method.getReturnType()) || (method.getParameterTypes().length != 1)) { continue; } pojoSetterList.add(method); } return pojoSetterList.toArray(new Method[0]); } /* * Return a bean property with specified name from an Object * using reflection. If the entity is an Array object, return * an array containing bean property for each element of the array. */ private Object getValue(Object entity, String propertyName) throws Exception { Object retval; if(!entity.getClass().isArray()) { Method getter; getter = entity.getClass().getMethod("get" + propertyName, (Class[]) null); retval = getter.invoke(entity, (Object[]) null); } else { Object[] entityArray; Object[] retvalArray; entityArray = (Object[]) entity; if(entityArray.length == 0) { return null; } retvalArray = new Object[entityArray.length]; for(int i = 0, m = entityArray.length ; i < m ; i++) { retvalArray[i] = getValue(entityArray[i], propertyName); } retval = retvalArray; } return retval; } /* * Simple string representation of an Array, essentially * "[" + (String) element[0] + ", " + (String) element[1] + ", " ... "]" */ private String arrayToString(Object[] array) { StringBuilder stringer; stringer = new StringBuilder(); stringer.append("["); for(Object item : array) { if(!item.getClass().isArray()) { stringer.append(item); } else { stringer.append(arrayToString((Object[]) item)); } stringer.append(", "); } if(stringer.lastIndexOf(",") > 0) { stringer.delete(stringer.length() - 2, stringer.length()); } stringer .append("]"); return stringer.toString(); } /* * Create InfoObjectPOJO from InfoObject. * For each setter in InfoObjectPOJO, use reflection to retrieve the equivalent * property from the InfoObject. */ public InfoObjectPOJO createInfoObjectPOJO(InfoObject infoObject, Method[] pojoSetters) { InfoObjectPOJO infoObjectPOJO; infoObjectPOJO = new InfoObjectPOJO(); for(Method pojoSetter : pojoSetters) { Object val = null; /* * If Number type, do not pass null, since POJO ResultSet Factory does not * accept null Number or Boolean values. */ if(Integer.class.isAssignableFrom(pojoSetter.getParameterTypes()[0])) { val = new Integer(0); } try { String[] propertyNames; /* * InfoObjectPOJO with property name Parent_One_Two is mapped * to InfoObject getter getParent().getOne().getTwo() * * Note that DSWS Bobje Web Services use primitive types for * properties, so null values for those cannot be represented. */ propertyNames = pojoSetter.getName().substring(3).split("_"); val = getValue(infoObject, propertyNames[0]); for(int i = 1, m = propertyNames.length ; i < m ; i++ ) { val = getValue(val, propertyNames[i]); } /* * Fix up some types: * - POJO ResultSet Factory uses java.sql.Timestamp and not java.util.Calendar * - Universes represent boolean as Number and not java.lang.Boolean * - If DSWS class instance, transform to String. */ if(val != null) { if(val instanceof Calendar) { val = new Timestamp(((Calendar) val).getTimeInMillis()); } else if(val instanceof Boolean) { val = new Integer(Boolean.TRUE.equals(val) ? 1 : 0); } else if(val.getClass().isArray()) { try { val = arrayToString((Object[]) val); } catch(Exception eek) { } } else if(val.getClass().getPackage().getName().startsWith("com.businessobjects")) { val = val.toString(); } } } catch(Exception e_ignore) { // Log.error(e_ignore); } try { pojoSetter.invoke(infoObjectPOJO, new Object[] { val }); } catch(Exception e_ignore) { // Log.error(e_ignore); } } return infoObjectPOJO; } }

and finally the JavaBeanInfo:

InfoObjectJavaBeanInfo.java - the DDK JavaBean Info
package com.sap.ddk.javabean.sample; import java.beans.BeanDescriptor; import java.beans.MethodDescriptor; import java.beans.ParameterDescriptor; import java.beans.SimpleBeanInfo; import java.util.Properties; public class InfoObjectJavaBeanInfo extends SimpleBeanInfo { public InfoObjectJavaBeanInfo() { super(); } @Override public BeanDescriptor getBeanDescriptor() { BeanDescriptor beanDescriptor; beanDescriptor = new BeanDescriptor(InfoObjectJavaBean.class); beanDescriptor.setName("InfoObjectJavaBean"); beanDescriptor.setShortDescription("JavaBean from a InfoObject"); return beanDescriptor; } @Override public MethodDescriptor[] getMethodDescriptors() { MethodDescriptor[] methodDescriptors = null; try { methodDescriptors = new MethodDescriptor[] { new MethodDescriptor (InfoObjectJavaBean.class.getDeclaredMethod ("initialize", new Class[] {com.businessobjects.connectionserver.datasources.ddk.Context.class, String.class, Properties.class}), new ParameterDescriptor[] {new ParameterDescriptor (), new ParameterDescriptor (), new ParameterDescriptor ()}), new MethodDescriptor(InfoObjectJavaBean.class.getDeclaredMethod("close", (Class[])null)), new MethodDescriptor(InfoObjectJavaBean.class.getDeclaredMethod("getInfoObjectResultSet", (Class[])null)) }; methodDescriptors[0].setShortDescription ("initialize JavaBean"); methodDescriptors[0].getParameterDescriptors ()[0].setName ("context"); methodDescriptors[0].getParameterDescriptors ()[0].setShortDescription ("context of JavaBean"); methodDescriptors[0].getParameterDescriptors ()[1].setName ("url"); methodDescriptors[0].getParameterDescriptors ()[1].setShortDescription ("url for InfoObject feed"); methodDescriptors[0].getParameterDescriptors ()[2].setName ("properties"); methodDescriptors[0].getParameterDescriptors ()[2].setShortDescription ("properties for JavaBean"); methodDescriptors[1].setShortDescription ("finalize JavaBean"); methodDescriptors[2].setShortDescription ("Retrieve InfoObject ResultSet"); } catch(Exception e_ignore_at_your_peril){} return methodDescriptors; } }

Here's my copy of the DDK JavaBean Connection configuration file. Note that it references the CRJ SDK jars and the BusinessObjects Enterprise Web Services Consumer jars in the classpath definition, and specifies some runtime parameters. This file is found in the \win32_x86\dataAccess\connectionServer\javabean folder:

javabean.sbo - the Universe JavaBean Connectivity configuration file
com.businessobjects.connectionserver.java.drivers.javabean.JavaBeanDriver Java Beans javabean.setup javabean javabean javabean Procedures javabean False True False No No $ROOT$/beans/bean_infoobject.jar c:/eclipse/plugins/com.businessobjects.crystalreports.crsdk.libs_12.2.200.r443/lib/CrystalReportsRuntime.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/activation-1.1.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/axiom-api-1.2.5.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/axiom-impl-1.2.5.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/axis2-kernel-1.3.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/axis2-saaj-1.3.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/axis2-xmlbeans-1.3.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/backport-util-concurrent-2.2.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/commons-codec-1.3.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/commons-httpclient-3.0.1.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/commons-logging-1.1.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/dsws-bicatalog.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/dsws-biplatform.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/dsws-common.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/dsws-publish.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/dsws-queryservice.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/dsws-reportengine.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/dsws-saveservice.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/dsws-session.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/log4j-1.2.14.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/mail.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/stax-api-1.0.1.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/struts.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/wilog.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/wsdl4j-1.6.2.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/wstx-asl-3.2.1.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/xbean-2.2.0.jar c:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/web services/en/dsws_consumer/data/dswsJavaApi/XmlSchema-1.3.2.jar com.sap.ddk.javabean.sample.InfoObjectJavaBean $DATASOURCE$ localhost secEnterprise http://tueda-bexi3:8080/dswsbobje/services/Session Java Beans define java class for JavaBean driver $DATASOURCE$ Java Beans

The ClassPath Path entities include the CRJ SDK library jar file CrystalReportsRuntime.jar (at the location installed with the Crystal Reports for Eclipse 2.0 All-In-One installation) and the BusinessObjects Enterprise Web Services library jars found in the \web services\en\dsws_consumer\data\dswsJavaApi folder.

The javabean.sbo references the bean_infoobject.jar file, that contains the compiled Java program, copied to the \win32_x86\dataAccess\connectionServer\beans folder.
BusinessObjects Enterprise Web Services Connection

Connecting and logging onto the Enterprise Web Services Provider requires five items of info: the Enterprise user name, password, CMS name, authentication type, and the Enterprise Session Web Services URL. These items will be provided either in the javabean.sbo file or when configuring the connection in the Universe Designer.

The CMS Name, authentication type and Session Web Services URL are specified in the javabean.sbo file, using Parameter entities with Name attributes "CMS Name", "CMS Authentication Type" and "Session Web Services URL".

The Universe Designer presents three configuration fields when creating a JavaBean connection: the username, password and uri. In the sample, the username and password fields are used to specify the Enterprise credentials, and the uri is used to specify the path query.
Deployment

To deploy the sample, compile the Java code where you ensure you have the CRJ SDK library jars, the DDK library jar \classes\connectionServer.jar, and the BusinessObjects Enterprise Web Services Java Consumer jars in the classpath. Jar the compiled object files and place in \win32_x86\dataAccess\connectionServer\beans\bean_infoobject.jar.

Back up the javabean.sbo configuration file in your deployment, and replace it with the file above. Edit it to ensure it reflects where you have the required jar files. Also edit the file to configure your CMS name, authentication type and Session Web Services URL.

Launch the Universe Designer, then navigate to Tools -> Connections. Click "Add" then ensure the "Filter stored procedure network layer" option is selected. Give a name for your connection, then navigate the tree to find Java Beans -> POJO JavaBean datasource -> JavaBean. Click Next.

You will see the authentication panel. Enter your Enterprise credential user name and password, then enter a path query. A simple one to start off would be:

path://InfoObjects/Root Folder/@STATIC,SI_OWNER

to return all the root Public Folders.

Test the connection, then click Finish. Create an Universe off of this connection - JavaBeans are considered "stored procedure" connections, so ensure you enable that when selecting your connection, then insert the "Stored Procedure" into the Universe. Save the Universe.

You should now be able to fire up your copy of the Web Intelligence Rich Client, and create a report off of the Universe you just created.
Code Description

I've placed comments in the Java code, but I'll add a few more notes here.



* Items in a InfoObject object collection returned from Enterprise do not have uniformly the same properties - subclasses such as CrytalReport, Web Intelligence, User, UserGroup, Server, etc, all have a different set of properties. The returned collection may contain a mix of different subclasses.

Since a relational table row-column structure requires consistency, I specify the properties that are returned by the definition of the InfoObjectPOJO class.

The JavaBean code uses Java Reflection to introspect the InfoObjectPOJO class for all defined properties, then uses Reflection on each item in the InfoObject object collection to retrieve the property with the same name. If an InfoObject does not define a property, the property is set to null.

To extend the properties exposed by this driver, add new properties to the InfoObjectPOJO.



* The relational model of Universe tables prohibit automatic handling of nested properties, such as InfoObject.SchedulingInfo.BeginDate. To allow for flattening this to a 1-deep representation, nested properties are declared in the InfoObjectPOJO by separting the class/property names by underscores. For example, the InfoObjectPOJO defines the getter getSchedulingInfo_BeginDate() method to retrieve the InfoObject.SchedulingInfo.BeginDate property.

Also, since the relation model cannot automatically handle indexed properties, array values are translated into comma-delimited strings.



* The BusinessObjects Enterprise Web Services Consumer library uses a Thread-local-context ClassLoader. The DDK uses JNI with custom ClassLoader (used to load the classpath path entities specified in the javabean.sbo) and does not provide a Thread-local ClassLoader.

In the JavaBean code, I retrieve the ClassLoader for the JavaBean instance, and set it as the Thread-local ClassLoader programmatically, similar to what I did for the RSS feed library as described in the previous blog.



* The CRJ SDK POJO ResultSet Factory data type limitation causes all date, date time and timestamp types to be java.sql.Timestamp. Universes represent boolean values as Number and not java.lang.Boolean, but the ResultSet Factory prevents Booleans and Numbers from being nullable. So the default values are set to 0 (but the Web Services Consumer uses primitives for numbers and booleans anyways, so it's not the driver causing this lossage).

Reporting using Query as a Web Service

You're not restricted to just Web Intelligence documents when reporting off the CMS Universe connection. By building a QaaWS, you can expose the data to many other reporting types, including LiveOffice/Excel/Xcelsius and Crystal Reports.

As a simple test, I created the QaaWS from a CMS DDK JavaBean connection with the following query:

query://{Select STATIC, SI_OWNER From CI_INFOOBJECTS Where SI_INSTANCE=1 AND SI_RECURRING=0 AND SI_CREATION_TIME >= '2008.09.01'}

that returns info for all scheduled reports since September of last year (approximately when I installed BusinessObjects Enterprise XI 3.1).

I designed a Crystal Report off of this QaaWS, and focussed on the total processing time - the difference between the schedule run end time and begin time. Grouping by report name, I listed out the Top 6 by total of all scheduled run times, then plotted the result, along with average run time per instance.

Here's a screenshot:
image



A bit of a surprise there - almost half the total scheduled processing time was taken up by a single report! Maybe not suprising - the "World Sales Report" is the one I use most often for testing and creating sample applications.

The "Create Webi From Scratch", on the other hand, was a not-simple Web Intelligence document I created programmatically for load testing.

I find it reassuring that the Top 6 covers a spectrum of reporting types - Crystal Reports, Web Intelligence, Publications, Crystal Reports off of Universes, and even a RAS SDK app running from within a Java Program Object. Good to know I'm covering the field...

So even with a simple report that I whipped up just for this blog, I've gotten considerable insight into how I use my Enterprise installation. I'm thinking I should schedule this report monthly, so I can keep track of my usage.

If this was a production deployment, such info would be invaluable in tuning the system for better performance. Just goes to show how illuminat Business Intelligence (BI), Business Objects, Java Programminging having ready access to the CMS data can be.

As I conclude this blog entry, I'm looking at the report chart again and it brings back memories of very interesting Support Incidents I've worked on. Maybe I'll blog about one or two or three in the near future, before new Incidents pushes them out of my recollection...



Ted Ueda is a Senior Engineer with Technical Customer Assurance, SAP Business Objects.

Polestar in the cloud Web Services API - Sample Codes Ted Ueda

If you're interested in Polestar in the cloud and the recently announced Polestar in the cloud API $20K IDEAtion Challenge, then this blog entry may be of interest to you. I'm going to present here a few sample codes for that API, so you'll quickly get up to speed and have a head start on the competition!

Each of the sample codes follow the same workflow: retrieve data, upload the dataset to OnDemand, then view it in Polestar in the cloud. What differs is the programming language used and the data source. The four samples are:

1. Python script with inline dataSet.
2. C# with data retrieved from Query as a Web Service
3. Xcelsius SDK - Adobe Flex component.
4. Java with RSS Feed data.

Polestar in the cloud API

Ty Miller, a Techical Director here, sent me email about a month ago asking whether I was interested in checking out a cool new Web Services API for the BusinessObjects Labs project called Polestar in the cloud. I figured whatever Ty's involved in is high on the hot-and-interesting scale - he's sent a few pretty interesting Customer Support cases my way in the past - but at the time I was busy helping customers and working with Crystal Reports for Eclipse 2.0 and Universe Data Access Driver Development Kit SDK, so I had to flag his email for later action.

Rob Horne, who's also into pretty interesting stuff, recently blogged about Polestar in the cloud. Reading his blog certainly encouraged me to check it out (although I have to say I'm far from a Steve Nash fan), and what I found was pretty impressive.

Polestar makes the relationship between you and your data highly personal - I've gotten tremendous insight, and seen relationships I've not thought of, merely by uploading data and working with it in Polestar. Having Polestar as part of the "Cloud" computing on Whohar - the http://create.ondemand.com/ portal - makes it that much more compelling. Now you can upload and store your data on Whohar, and analyze it using different dashboards as well as Polestar.

Programmatic dataset management is accomplished via the Whohar RESTful Web Services API - you can upload, download, update and delete datasets via simple HTTP calls. You can then invoke a URL to view a dataset in Polestar.

The beauty of the API is in its simplicity - you're able to code against it using most programming languages out there, and have a very elegant means to integrate your app with Polestar in the cloud.

Rob kindly sent me a preview of the Whohar API docs - it's now available publicly here - and I've been playing with the API since. I've cleaned up some of my sample codes and present it here for your enjoyment. I do hope it helps you in quickly working out the API workflow required to integrate your stuff with Polestar in the cloud.

Python Script with Inline DataSet

Here's a short Python script that I used to get a 'feel' for the API -

Python script uploading data to Polestar in the cloud
#!/usr/bin/env python # # whohar_polestar.py # # Upload data to Whohar and view in Polestar in the cloud #=============================================================================== import base64 import os import urllib2, cookielib import webbrowser # # URL to Whohar Dataset API and Logon Credentials # url = 'https://create.ondemand.com/v1/datasets' username='<ondemand>' password='<ondemand>' # # Dataset to upload to Whohar # data = '''<?xml version="1.0" encoding="UTF-8"?> <dataset name="Test Data" visibility="private"> <source>test data</source> <description> Test data for Polestar OnDemand </description> <tags> <tag name="Test Data"> </tags> <table> <fields> <field name="Text Field" type="string"> <qualification type="dimension"> </field> <field name="Boolean Field" type="boolean"> <qualification type="dimension"> </field> <field name="Number Field" type="number"> <qualification type="measure" aggregation="average"> </field> <field name="Currency Field" type="currency"> <qualification type="measure" aggregation="sum"> </field> <field name="Date Field" type="date"> <qualification type="measure" aggregation="max"> </field> <field name="Time Field" type="time"> <qualification type="measure" aggregation="min"> </field> <field name="DateTime Field" type="dateTime"> </fields> <rows> <r> <v>Adam Ant</v> <v>false</v> <v>1</v> <v>123.45</v> <v>2007-04-25</v> <v>23:15:30</v> <v>2007-04-25T23:15:30</v> </r> <r> <v>Betty Boop</v> <v>true</v> <v>2</v> <v>246.8</v> <v>2008-10-16</v> <v>10:30:00</v> <v>2008-10-16T10:30:00</v> </r> <r> <v>Cowboy Carl</v> <v>false</v> <v>3</v> <v>369.12</v> <v>2001-11-02</v> <v>12:24:00</v> <v>2009-10-10T10:10:00</v> </r> <r> <v>Danger Dan</v> <v>false</v> <v>4</v> <v>4812.16</v> <v>1999-01-03</v> <v>12:21:00</v> <v>2010-10-10T10:10:00</v> </r> </rows> </table> </dataset>''' # # Log on and send data to Whohar # datasetURL = None # Define HTTP Basic Authentication header string base64string = base64.encodestring('%s:%s' % (username, password))[:-1] authheader = "Basic %s" % base64string # Define HTTP Cookie container - used to retrieve Session ID cookieJar = cookielib.CookieJar() opener = urllib2.build_opener(urllib2.HTTPCookieProcessor(cookieJar)) # Construct HTTP request with authentication header req = urllib2.Request(url) req.add_header("Authorization", authheader) # Send dataset to Whohar. HTTP Response to successful upload is HTTP Code 201. # Python throws an exception on 201, so we trap and retrieve content Location. try: handle = opener.open(req, data) except IOError, e: if e.code != 201: raise datasetURL = e.read() datasetURL = datasetURL[datasetURL.index("http"):-1] # Parse URL for the dataset ID id = datasetURL[datasetURL.rfind('/') + 1 :] # Retrieve Session ID from HTTP Cookie session=None for cookie in cookieJar: if cookie.name == '_whohar_session' : session = cookie.value # # Open Polestar OnDemand with dataset ID and session ID # polestar_url='https://create.ondemand.com/polestar/show_exploration/' + id + '?whohar_session_id=' + session # Open a web browser with the Polestar OnDemand URL #webbrowser.open_new(polestar_url) # I use Cygwin, for which webbrowser isn't defined, so I # open the browser manually: os.system('"/cygdrive/c/Program Files/Internet Explorer/iexplore.exe" ' + '"' + polestar_url + '"')

that shows the basics of uploading a dataSet and viewing it in Polestar: the required XML dataset format, setting up the HTTP Basic Authentication, retrieving the dataSet ID and session ID, and redirecting to Polestar in the cloud.

Edit the top of the file to insert your create.ondemand.com logon credentials, and modify the bottom to use either the webbrowser lib or explicit launching of a web browser, and run it using the Python interpreter.

You'll note how simple the API is - the advantage of using a RESTful Web Services design.

C# With Data Retrieved from Query as a Web Service

A bit more useful example, using C# - I wrote it on Visual Studio 2008 - that consumes data from Query as a Web Service (QaaWS), upload them to Whohar and view in Polestar in the cloud. Here's a screenshot of what you get, showing both the QaaWS client with the query, and the Polestar view of the data:

The query is based on the eFashion sample Universe, and Polestar is displaying the breakdown of sales revenue, quanitity of merchandise sold, and margin for stores by State. Texas is looking pretty good (more on Texas later)...

Here's the code:

C# 2008 to upload QaaWS-generated data to Polestar OnDemand
using System; using System.CodeDom; using System.CodeDom.Compiler; using System.Collections.Generic; using System.Collections.ObjectModel; using System.IO; using System.Linq; using System.Net; using System.Reflection; using System.ServiceModel.Description; using System.Text; using System.Web; namespace QaaWS2Polestar { /* Call and retrieve data from QaaWS and send to Polestar OnDemand via Whohar (https://create.ondemand.com) * * Sample Usage: * * QaaWS2Polestar.exe http://tueda-bexi3.crystald.net:8080/dswsbobje/qaawsservices/?WSDL&cuid=Af6QUpRFAexMhAuYi2onVtQ Administrator "" MyWhoharUsername MyWhoharPassword * */ class Program { static void Main(string[] args) { if (args.Length <> <cms> " + "<cms> <polestar> <polestar>"); } string qaaws_url = args[0]; string qaaws_username = args[1]; string qaaws_password = args[2]; string polestar_username = args[3]; string polestar_password = args[4]; /* * QaaWS invocation variables. */ object rows; int fetchedrows; Type rowType; PropertyInfo[] rowProperties; /* * Polestar OnDemand Web Services variables. */ string whohar_url = "https://create.ondemand.com/v1/datasets"; HttpWebResponse httpWebResponse; string polestar_data_param; string document_id; string session_id; string polestar_display_url = "https://create.ondemand.com/polestar/show_exploration/"; /* * Call QaaWS and retrieve data as Array and determine the properties of the element type. */ rows = retrieveQaaWSData(qaaws_url, qaaws_username, qaaws_password); fetchedrows = ((Array)rows).GetLength(0); rowType = rows.GetType().GetElementType(); rowProperties = rowType.GetProperties(); /* * Construct data XML from data retrieved from QaaWS */ polestar_data_param = "<?xml version=\"1.0\" encoding=\"UTF-8\"?> " + " <dataset name="\" visibility="\"> " + " <source>test data</source> " + " <description> " + " Test data for Polestar OnDemand " + " </description> " + " <tags> " + " <tag name="\"> " + " </tags> "; polestar_data_param += "<table> "; /* * For each column, specify name, type, aggregation and qualification * from type. */ polestar_data_param += "<fields> "; for (int j = 0; j < rowproperty =" rowProperties[j];" name =" rowProperty.Name;" type =" rowProperty.PropertyType.Equals(typeof(double?))" aggregation =" rowProperty.PropertyType.Equals(typeof(double?))" qualification =" rowProperty.PropertyType.Equals(typeof(double?))" name="\" type="\"> "; polestar_data_param += " <qualification type="\" aggregation="\"> "; polestar_data_param += "</field> "; } polestar_data_param += "</fields> "; /* * Copy data from QaaWS into data XML */ polestar_data_param += "<rows> "; for (int i = 0; i < row =" ((Array)rows).GetValue(i);">"; for (int j = 0; j < value =" rowProperties[j].GetValue(row," value =" ((System.DateTime?)value).Value.ToString(">" + (value == null ? "" : value.ToString()) + "</v>"; } polestar_data_param += "</r>"; } polestar_data_param += "</rows></table></dataset> "; /* * Send data to Polestar, then retrieve document ID and Session ID */ httpWebResponse = getHttpPOSTResponse(whohar_url, polestar_data_param, polestar_username, polestar_password); session_id = httpWebResponse.Cookies["_whohar_session"].Value; document_id = httpWebResponse.Headers["Location"]; document_id = document_id.Substring(document_id.LastIndexOf('/') + 1); System.Diagnostics.Process.Start("iexplore.exe", polestar_display_url + document_id + "?whohar_session_id=" + session_id); } /* * Send HTTP POST Request to URL and return the response. */ static HttpWebResponse getHttpPOSTResponse(string url, string data, string username, string password) { HttpWebRequest webRequest; CookieContainer cookieContainer; byte[] dataBytes; //Disable Expect: 100-continue header //System.Net.ServicePointManager.Expect100Continue = false; /* * Define cookie container to persist HTTP Cookies across request redirection. */ cookieContainer = new CookieContainer(); /* * Encode HTTP POST body content and POST to the url. */ dataBytes = Encoding.UTF8.GetBytes(data); webRequest = (HttpWebRequest)HttpWebRequest.Create(url); webRequest.CookieContainer = cookieContainer; webRequest.Method = "POST"; webRequest.ContentType = "text/xml"; webRequest.ContentLength = dataBytes.Length; if (username != null) { /* * HTTP Basic Authentication */ webRequest.Credentials = new NetworkCredential(username, password); } webRequest.GetRequestStream().Write(dataBytes, 0, dataBytes.Length); webRequest.GetRequestStream().Close(); try { return (HttpWebResponse) webRequest.GetResponse(); } catch (WebException webException) { WebResponse webResponse; webResponse = webException.Response; StreamReader streamReader = new StreamReader(webResponse.GetResponseStream()); String body = streamReader.ReadToEnd(); streamReader.Close(); throw webException; } } /* * Call the Query As A Web Service defined by the WSDL found at the specified URL with the * specified logon credentials, and return an array of dotNetBeans (instances of class with * properties). */ static object retrieveQaaWSData(string qaaws_url, string qaaws_username, string qaaws_password) { /* * Variables used to specify QaaWS as a Service Reference */ MetadataExchangeClient metadataExchangeClient; MetadataSet metadataSet; WsdlImporter wsdlImporter; ServiceEndpoint serviceEndpoint; System.ServiceModel.Channels.Binding binding; /* * Variables used to compile the Service Reference generated code from QaaWS */ ServiceContractGenerator generator; CodeCompileUnit codeCompileUnit; CompilerParameters compilerParameters; CodeDomProvider codeDomProvider; CompilerResults compilerResults; /* * Variables representing the generated QaaWS objects */ Assembly qaawsAssembly; Type qaawsType; Type qaawsHeaderType; Type qaawsParamType; object qaawsHeader; object qaawsParam; object qaaws; /* * Retrieve the QaaWS WSDL and generate code as a Service Reference. Note that we could * have used the simpler Web Reference, but Service Reference is programmatically nicer, * since we can use Reflection introspect the QaaWS parameters and infer meaning from the * property names. */ metadataExchangeClient = new MetadataExchangeClient(new Uri(qaaws_url), MetadataExchangeClientMode.HttpGet); metadataExchangeClient.ResolveMetadataReferences = true; metadataSet = metadataExchangeClient.GetMetadata(); wsdlImporter = new WsdlImporter(metadataSet); // Import the endpoint and binding info that's needed when instantiating the QaaWS client object. serviceEndpoint = wsdlImporter.ImportAllEndpoints()[0]; binding = wsdlImporter.ImportAllBindings()[0]; generator = new ServiceContractGenerator(); foreach (ContractDescription contract in wsdlImporter.ImportAllContracts()) { generator.GenerateServiceContractType(contract); } /* * Compile the QaaWS code. */ codeCompileUnit = generator.TargetCompileUnit; // System.ServiceModel.dll isn't found by default, so manually find and update reference. for (int i = codeCompileUnit.ReferencedAssemblies.Count - 1; i >= 0; i--) { string assemblyName = codeCompileUnit.ReferencedAssemblies[i]; switch (assemblyName) { case "System.ServiceModel.dll": codeCompileUnit.ReferencedAssemblies[i] = typeof(ServiceContractGenerator).Assembly.Location; break; default: break; } } compilerParameters = new CompilerParameters(); compilerParameters.GenerateExecutable = false; compilerParameters.GenerateInMemory = true; codeDomProvider = CodeDomProvider.CreateProvider("CSharp"); compilerResults = codeDomProvider.CompileAssemblyFromDom(compilerParameters, new CodeCompileUnit[] { codeCompileUnit }); if (compilerResults.Errors.Count > 0) { string errorMessage = "Error Compiling .NET Proxy Code Generated from the WSDL"; foreach (CompilerError error in compilerResults.Errors) { errorMessage += error.ErrorText + "\n"; } throw new Exception(errorMessage); } /* * Load the generated assembly and create the QaaWS client, QaaWS header object, and QaaWS * parameter objects. */ qaawsAssembly = compilerResults.CompiledAssembly; qaawsType = qaawsAssembly.GetType("QueryAsAServiceSoapClient", false); qaawsHeaderType = qaawsAssembly.GetType("QaaWSHeader", false); qaawsParamType = qaawsAssembly.GetType("runQueryAsAService", false); if (qaawsType == null || qaawsHeaderType == null || qaawsParamType == null) { throw new Exception("QaaWS Web Service not found."); } // Note: since we don't have a app.config file with the generated QaaWS binding and endpoint // info, we pass it into the constructor. qaaws = qaawsAssembly.CreateInstance(qaawsType.Name, false, BindingFlags.Default, null, new object[] { binding, serviceEndpoint.Address }, null, null); qaawsHeader = qaawsAssembly.CreateInstance(qaawsHeaderType.Name); qaawsParam = qaawsAssembly.CreateInstance(qaawsParamType.Name); // Set the QaaWS logon credentials. If the QaaWS has prompts, you would Reflect for // the prompt property and set them here. qaawsParamType.GetProperty("login").SetValue(qaawsParam, qaaws_username, null); qaawsParamType.GetProperty("password").SetValue(qaawsParam, qaaws_password, null); return qaawsType.GetMethod("runQueryAsAService").Invoke(qaaws, new object[] { qaawsHeader, qaawsParam, null, null, null, null, null, null, null, null, }); } } }

You'll note that much of the code is taken up by the QaaWS SOAP Web Service call - dynamically generating stub code from the WSDL, auto-compiling and loading the assembly, and using Reflection to invoke the service - and not by the OnDemand API.

It may be an unfair comparison, but this does suggest the simplicitly of a RESTful Web Service in comparison to SOAP.

Compile the code using Visual Studio 2008, and run it in the command-line:

QaaWS2Polestar.exe

and it'll launch Internet Explorer with Polestar OnDemand view of your QaaWS data.

A couple of comments about the sample code:

1. It generates the QaaWS stubs from the WSDL using .NET Service Reference rather than Web Reference. A Service-Reference-generated-code makes for easier Reflection into the stub classes, since you can infer use from the generated property names.
2. It currently doesn't set any QaaWS prompts - you can add to the Reflection routine near the end of the code to introspect any prompts.

Xcelsius SDK - Adobe Flex Component

I created this sample using Adobe Flex Builder 3 and the Xcelsius SDK. Implementation uses MXML that subclasses a mx:Button component that, when clicked, reads a bound 2D Array, constructs the Whohar dataSet XML, uploads the data and displays it in Polestar in the cloud.

You can use it within an Adobe Flash application or embedded in Xcelsius. Here's a screenshot of it embedded within Xcelsius, showing both the Polestar and Xcelsius views of the data:

When you click on the "To Polestar OnDemand" button you see on the Xcelsius view, the Polestar OnDemand view is displayed.The data is just some test data I entered into Excel in the Xcelsius designer - in actual practise, you'd be using 'real' Excel data, or a Web Service data source.

Here's the MXML code:

PolestarOnDemand.xml - uploads bound Array to Polestar in the cloud
<?xml version="1.0" encoding="utf-8"?> <mx:button mx="http://www.adobe.com/2006/mxml" label="To Polestar in the cloud" enabled="true" click="sendToPolestarOnDemand(event)" alpha="1.0" fillalphas="[1.0, 1.0]" fillcolors="[#FFFFFF, #FFFFFF]" color="#000000"> <mx:script> <![CDATA[ import flash.net.navigateToURL; import mx.controls.Alert;; import mx.managers.PopUpManager; import mx.rpc.events.FaultEvent; import mx.rpc.events.ResultEvent; import mx.utils.StringUtil; /* * Polestar OnDemand logon variables. Pass the suppress_response_codes parameter to * prohibit return of non-HTTP 200 codes (other than 5xx errors), since Flex on IE * throws exceptions on HTTP 201 Created. */ private var _psURL:String = "https://create.ondemand.com/v1/datasets?suppress_response_codes=true"; private var _psUser:String = "<user>"; private var _psPassword:String = ""; /* * Property dataArray holds the 2D Array to be sent to Polestar. */ private var _dataArray:Array = null; [Inspectable(type="Array")] public function get dataArray():Array { return _dataArray; } public function set dataArray(value:Array):void { _dataArray = value; invalidateProperties(); } /* * Begin process of sending data to Polestar OnDemand. * First query user for OnDemand Logon credentials. */ private function sendToPolestarOnDemand(event:Event):void { var logonDialog:PolestarOnDemandLogon = PopUpManager.createPopUp( this.parentApplication as DisplayObject, PolestarOnDemandLogon, true) as PolestarOnDemandLogon; logonDialog.username = _psUser; logonDialog.password = _psPassword; logonDialog.addEventListener("logonDialogOK", retrieveLogonCredentials); PopUpManager.centerPopUp(logonDialog); } /* * Retrieve the OnDemand logon credentials entered by user, and go to next step - * sending data to OnDemand. */ private function retrieveLogonCredentials(event:Event) : void { var logonDialog:PolestarOnDemandLogon = event.target as PolestarOnDemandLogon; _psUser = logonDialog.username; _psPassword = logonDialog.password; try { sendDataToPolestarOnDemand(_psURL, _psUser, _psPassword); } catch(err:Error) { Alert.show(err.message + "\n" + err.getStackTrace()); } } /* * Create the dataset XML then stream to OnDemand. */ private function sendDataToPolestarOnDemand(url:String, username:String, password:String):void { var data:String; var row:Array; var i:int, j:int; /* * Set HTTP Basic Authentication header. * Flex3 has Base64Encoder, but Flex2 does not. Since Xcelsius currently supports Flex2 only, * we use an open source Base64 library by Jason Nussbaum (http://blog.jasonnussbaum.com/?p=108). */ dataService.headers = {Authorization: "Base " + Base64.Encode(username + ":" + password)}; /* * Construct the dataSet preface info. */ data = "<?xml version=\"1.0\" encoding=\"UTF-8\"?> " + " <dataset name="\" visibility="\"> " + " <source>Xcelsius</source> " + " <description> " + " Test data for Polestar OnDemand from Xcelsius" + " </description> " + " <tags> " + " <tag name="\"> " + " </tags> "; /* * Define the dataSet. */ data += "<table>\n"; if(_dataArray.length <= 0) { throw new Error("Error: No data"); } /* * Specify column type depending on type of data. We assume column is a measure if * it's a numeric type, and dimension otherwise. Aggregation is set to 'sum' if * numeric, and 'none' otherwise. */ data += "<fields>\n"; row = _dataArray[0]; for(j = 0 ; j < string =" (row[j]" string =" (row[j]" string =" (row[j]" name="\" type="\"> "; data += " <qualification type="\" aggregation="\"> "; data += "</field> "; } data += "</fields> \n"; /* * Add the data in <r><v>ColValue1</v><v>ColValue2</v></r> format. */ data += "<rows>\n "; for(i = 0 ; i < row =" _dataArray[i]">"; for(j = 0 ; j <>" + (row[j] == null ? "" : entify(row[j].toString())) + "</v>"; } data += "</r>\n"; } data += "</rows> \n" + "</table> \n" + "</dataset>"; /* * Send data to OnDemand */ dataService.url = url; dataService.send(new XML(data)); } /* * Retrieve the dataset ID from the Polestar OnDemand data request * response, then hand off to method that opens a web browser to Polestar OnDemand. */ private function retrieveDocumentInfo(event:ResultEvent):void { try { var datasetId:String = null; var sessionId:String = null; var body:String = event.result.toString(); datasetId = body.substring(body.lastIndexOf("/")+ 1, body.length - 1); if(datasetId == null || StringUtil.trim(datasetId).length == 0) { throw new Error("Data Error: missing dataset ID."); } // Open web browser with Polestar OnDemand showing document. openBrowserWithPolestarOnDemand(datasetId); } catch(err:Error) { Alert.show("retrieveDocumentInfo: " + err.message + "\n" + err.getStackTrace()); } } /* * Open web browser to view Polestar OnDemand with specified dataset Id. * Expectation here is that previous requests would have set the HTTP Cookie * with the OnDemand logon session ID, so that no re-logon will be required for * the redirection. */ private function openBrowserWithPolestarOnDemand(datasetId:String):void { var url:String = "https://create.ondemand.com/polestar/show_exploration/" + datasetId; var urlRequest:URLRequest = new URLRequest(url); navigateToURL(urlRequest); } /* * Make the world safe for tags to live in peace and harmony. */ private function entify(s:String):String { return s == null ? null : s.replace(/&/, "&") .replace(/</, "<") .replace(/>/, ">"); } /* * Error in sending data. */ private function dataError(event:FaultEvent):void { Alert.show("Data Error: " + event.message); } ]]> </mx:Script> <!-- HTTP Service to transmit Data to Polestar OnDemand --> <mx:httpservice id="dataService" contenttype="application/xml" resultformat="text" result="retrieveDocumentInfo(event)" fault="dataError(event)"> </mx:Button>

and the MXML for the Logon dialog box it uses to collect the OnDemand logon credentials:

PolestarOnDemandLogon.xml - Logon dialog box for PolestarOnDemand.xml
<?xml version="1.0" encoding="utf-8"?> <mx:titlewindow mx="http://www.adobe.com/2006/mxml" layout="absolute" width="332" height="134" title="Logon to Polestar OnDemand" showclosebutton="true" close="onClose(event)" backgroundcolor="#FFFFFF" alpha="1.0"> <mx:metadata> [Event("logonDialogOK")] </mx:Metadata> <mx:script> <![CDATA[ import mx.events.CloseEvent; import mx.managers.PopUpManager; public function get username():String { return usernameTextInput.text; } public function set username(value:String):void { usernameTextInput.text = value; } public function get password():String { return passwordTextInput.text; } public function set password(value:String):void { passwordTextInput.text = value; } private function okButtonClicked(event:Event):void { var okEvent:Event = new Event("logonDialogOK"); dispatchEvent(okEvent); closer(); } private function onClose(event:CloseEvent):void { closer(); } private function closer():void { usernameTextInput.text = ""; passwordTextInput.text = ""; PopUpManager.removePopUp(this); } ]]> </mx:Script> <mx:label y="12" text="User:" textalign="right" left="10" width="82"> <mx:label y="38" text="Password:" textalign="right" left="10" width="82"> <mx:textinput y="10" left="100" right="20" id="usernameTextInput" displayaspassword="false" editable="true" enabled="true"> <mx:textinput y="34" left="100" right="20" id="passwordTextInput" displayaspassword="true" editable="true" enabled="true"> <mx:button y="64" label="OK" id="okButton" enabled="true" click="okButtonClicked(event)" horizontalcenter="12"> </mx:TitleWindow>

Note that the data the component uploads is bound to an 2D array. Here's a very simple Xcelsius Property Sheet MXML that will allow you to do the binding to Excel cell ranges from within Xcelsius:

PolestarOnDemandPropertySheet.mxml - Xcelsius Property Sheet for PolestarOnDemand.xml
<?xml version="1.0" encoding="utf-8"?> <mx:application mx="http://www.adobe.com/2006/mxml" layout="absolute" borderthickness="3" bordercolor="#ff0000" applicationcomplete="init()"> <mx:style source="style\PSStyle.css"> <mx:script> <![CDATA[ import xcelsius.binding.BindingDirection; import xcelsius.binding.tableMaps.input.InputBindings; import xcelsius.binding.tableMaps.output.OutputBindings; import xcelsius.propertySheets.interfaces.PropertySheetFunctionNamesSDK; import xcelsius.propertySheets.impl.PropertySheetExternalProxy; // Proxy for this Property Sheet and its Xcelsius custom component. protected var proxy:PropertySheetExternalProxy = new PropertySheetExternalProxy(); // Holds name of property currently being (re)binded. protected var propertyToBind:String; // Holds ID of property currently being (re)binded. protected var currentBindingID:String; protected function init():void { // Register callback for bind completion. proxy.addCallback(PropertySheetFunctionNamesSDK.RESPONSE_BINDING_ID, continueBind); // Notify Xcelsius that proxy initialization is complete. proxy.callContainer(PropertySheetFunctionNamesSDK.INIT_COMPLETE_FUNCTION); // Fill the controls with the current values of the component. initValues(); } /* * Initialize property values being displayed in Property Sheet */ protected function initValues():void { // Retrieve properties to initialized var propertyValues:Array = proxy.getProperties(["dataArray"]); /* * For each property, set the relevant UI component field values. */ for (var i:int=0, m:int = (propertyValues == null ? 0: propertyValues.length) ; i < object =" propertyValues[i];" string =" propertyObject.name;" bindingtext =" getPropertyBindDisplayName(propertyName);" enabled =" false;" text =" bindingText;//" text =" propertyValue;" array =" proxy.getBindings([propertyName]);" propertybindings ="="" length ="="" length ="="" string =" propertyBindings[0][0];" currentbindingid =" null;" array =" proxy.getBindings([propertyName]);"> 0)) { currentBindingID = propertyBindings[0]; // Use the 1st binding address for the property. } // Store the name of the property that we are binding, we need this when we "continueBinding". propertyToBind = propertyName; // Let the user choose where to bind to in the Excel spreadsheet. proxy.requestUserSelection(currentBindingID); } /* * Complete User request to bind property to Excel cells. */ protected function continueBind(bindingID:String):void { // Define common variables here. var propertyName:String = propertyToBind; var propertyValues:Array; var propertyObject:Object; var bindingAddresses:Array; // Clear any existing bindings - so we can re-bind. if (currentBindingID != null) { proxy.unbind(currentBindingID); currentBindingID = null; } // Process the property binding. switch (propertyName) { case "dataArray": // User explicitly cleared binding, do not create another. if ((bindingID == null) || (bindingID == "")) { valueEditor.enabled = true; // Re-enable manual entry. // Fill the control back with current value instead of range address. propertyValues = proxy.getProperties([propertyName]); propertyObject = propertyValues[0]; valueEditor.text = String(propertyObject.value); // Make sure we set the property on the component as well. proxy.setProperty(propertyName, propertyObject.value); return; } // Disable the option to manually enter a value once the component is bound. valueEditor.enabled = false; // Display the range address. valueEditor.text = proxy.getBindingDisplayName(bindingID); // Excel spreadsheet binding:- // // BindingDirection.BOTH - Update the custom component "value" property when the spreadsheet changes // and also update the spreadsheet when the custom component "value" changes. // InputBindings.ARRAY - Write to multiple cells in the spreadsheet. // OutputBindings.ARRAY - Read a multiple cells in the spreadsheet. // proxy.bind("dataArray", null, bindingID, BindingDirection.BOTH, InputBindings.ARRAY2D, OutputBindings.ARRAY2D); break; default: break; } } ]]> </mx:Script> <mx:viewstack y="45" id="viewstack1" height="100%" left="0" right="0"> <mx:canvas label="General" height="100%" width="100%" id="general"> <mx:label x="23" y="24" text="Data" width="119"> <mx:hrule y="28" height="10" left="59" right="28"> <mx:textinput id="valueEditor" y="50" right="69" left="37" enabled="false" change="proxy.setProperty('dataArray', (valueEditor.text))"> <mx:button y="50" right="37" width="24" click="initiateBind('dataArray');" icon="@Embed('resources/bind to cell.png')"> </mx:Canvas> </mx:ViewStack> <mx:tabbar y="0" width="635" x="0" dataprovider="viewstack1"> </mx:TabBar> </mx:Application>

You can also use the component outside of Xcelsius and within a Flex application. Here's a short sample of how you'd invoke PolestarOnDemand.mxml from a mx:Application:

PolestarOnDemandApp.mxml - embedding PolestarOnDemand.mxml component
<?xml version="1.0" encoding="utf-8"?> <mx:application mx="http://www.adobe.com/2006/mxml" xc="com.sap.xcelsius.sdk.sample.*" layout="absolute" creationcomplete="postInit()"> <mx:script> <![CDATA[ private function postInit():void { var atable:Array; atable = new Array(5); atable[0] = new Array(3); atable[0][0] = "Canada"; atable[0][1] = 22.222; atable[0][2] = 2242.33; atable[1] = new Array(3); atable[1][0] = "USA"; atable[1][1] = 122.222; atable[1][2] = 1242.33; atable[2] = new Array(3); atable[2][0] = "France"; atable[2][1] = 222; atable[2][2] = 222.33; atable[3] = new Array(3); atable[3][0] = "Germany"; atable[3][1] = 222.222; atable[3][2] = 22.33; atable[4] = new Array(3); atable[4][0] = "Australia"; atable[4][1] = 221.222; atable[4][2] = 2.33; polestarOnDemand.dataArray = atable; } ]]> </mx:Script> <xc:polestarondemand id="polestarOnDemand"> </xc:PolestarOnDemand> <mx:style source="com/sap/xcelsius/sdk/sample/style/MyStyle.css"> </mx:Application>

Some comments:

1. The code passes the parameter suppress_response_codes in the Whohar URL to have responses always return HTTP 200 (other than HTTP 5xx errors). This feature was added specifically for Flex running in Internet Explorer. The normal RESTful HTTP 201 (Created) return on new dataset creation throws an exception in Internet Explorer, preventing Flex from reading the returned new resource location.
2. Xcelsius SDK currently supports Flex 2 only - so in Flex Builder 3, ensure you set the compiler for your project to use version 2 rather than 3.
3. Flex 2 does not contain a library class for Base64 encoding - I used one of the many open source Base64 implementations for ActionScript available on the web.
4. Xcelsius supports MXML components via the Xcelsius SDK only starting with FixPack 1.1 (previously, you had to code using ActionScript). I tested this component using Service Pack 1 + FixPack 1.2.
5. I didn't Style the component for Xcelsius - if you want to specify fonts and colors for the component in Xcelsius, you'd need to specify styling in the code. I recommend looking at the ComboBox sample for an example on how to property style a Xcelsius SDK component.

Java With RSS Feed Data

Last example - retrieve data from Yahoo! HotJobs RSS Feed, upload and view in PoleStar OnDemand. I always wanted to be a spaceman, so I enter 'astronaut' for the HotJobs keyword, and this is the Polestar in the cloud result:

All the astronaut-related jobs are located in Texas! Most in Houston (as in "Houston, we've got a problem") and a couple in Galveston. So that means I have to be willing to relocate if I want to fulfill my childhood career aspiration. Oh, well, I think I better stick to more realistic keywords like 'programmer', 'developer', or 'cowboy'. Maybe I should learn to ride a horse first...

Anyways, here's the Java code:

JobLocationPolestar.java - Polestar in the cloud with data from Yahoo! HotJobs RSS Feed
package com.sap.ondemand.whohar.sample; import com.sun.syndication.feed.synd.SyndEntry; import com.sun.syndication.feed.synd.SyndFeed; import com.sun.syndication.io.FeedException; import com.sun.syndication.io.SyndFeedInput; import com.sun.syndication.io.XmlReader; import java.io.ByteArrayOutputStream; import java.io.IOException; import java.net.URL; import java.net.URLEncoder; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.Iterator; import java.util.List; import java.util.Map; import javax.net.ssl.HttpsURLConnection; /* * Retrieves Yahoo Job Listing RSS given keyword and uploads data to Business Objects OnDemand, * then opens view of data in Polestar in the cloud. * * Usage: * java com.sap.ondemand.whohar.sample.JobsLocationPolestar <keyword> <ondemand> <ondemand> * * For example, java com.sap.ondemand.whohar.sample.JobsLocationPolestar cowboy ondemanduser ondemandpass */ public class JobsLocationPolestar { public static void main(String[] args) throws Exception { final String YAHOO_RSS_URI = "http://hotjobs.yahoo.com/job-rss-k-"; String keyword; URL yahoo_rss; List<entry> entries; SimpleDateFormat dateFormat; StringBuilder data; final String ONDEMAND_URI = "https://create.ondemand.com/v1/datasets"; final String POLESTAR_URI = "https://create.ondemand.com/polestar/show_exploration/"; String username = args[1]; String password = args[2]; String authHeader; sun.misc.BASE64Encoder base64Encoder; HttpsURLConnection urlConnection; byte[] dataBytes; byte[] temp; ByteArrayOutputStream baos; int count; String dataSetID; Map<string,>> headers; List<string> cookies; String sessionID; String polestar_url; // DateTime string format for uploading data to OnDemand dateFormat = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss"); /* * Call Yahoo Job Listing RSS and retrieve list of entries found. */ keyword = URLEncoder.encode(args[0], "UTF-8"); yahoo_rss = new URL(YAHOO_RSS_URI + keyword); entries = getYahooRSS(yahoo_rss); /* * Create dataSet string for uploading to OnDemand */ data = new StringBuilder(); data.append(data_beginning); data.append("<rows>\n"); for(Entry entry : entries) { data.append("<r>\n"); data.append("<v>" + entry.uri + "</v>\n"); data.append("<v>" + entry.title + "</v>\n"); data.append("<v>" + entry.link + "</v>\n"); data.append("<v>" + entry.region + "</v>\n"); data.append("<v>" + entry.city + "</v>\n"); data.append("<v>" + (entry.publishedDate == null ? "" : dateFormat.format(entry.publishedDate)) + "</v>\n"); data.append("</r>\n"); } data.append("</rows>\n"); data.append(data_ending); /* * Specify the HTTP Basic Authentication header. */ base64Encoder = new sun.misc.BASE64Encoder(); authHeader = "Basic " + base64Encoder.encode((username + ":" + password).getBytes("UTF-8")); dataBytes = data.toString().getBytes("UTF-8"); /* * Send data to OnDemand */ urlConnection = (HttpsURLConnection) (new URL(ONDEMAND_URI)).openConnection(); urlConnection.setDoInput(true); urlConnection.setDoOutput(true); urlConnection.setRequestMethod("POST"); urlConnection.setRequestProperty("Authorization", authHeader); urlConnection.setRequestProperty("Content-length", "" + dataBytes.length); urlConnection.setRequestProperty("Content-Type", "text/xml"); urlConnection.getOutputStream().write(dataBytes); /* * Ensure succesful data upload by ensuring HTTP Status Code 200. */ if(urlConnection.getResponseCode() != 201) { throw new Exception("Failed dataSet upload.\n" + "HTTP " + urlConnection.getResponseCode() + ": " + urlConnection.getResponseMessage()); } /* * Parse the response for the dataSet ID */ temp = new byte[1024]; baos = new ByteArrayOutputStream(); while((count = urlConnection.getInputStream().read(temp)) > 0) { baos.write(temp, 0, count); } dataSetID = new String(baos.toByteArray(), "UTF-8"); dataSetID = dataSetID.substring(dataSetID.lastIndexOf('/') + 1, dataSetID.length() - 1); /* * Parse the returned HTTP Cookies for the session ID. */ headers = urlConnection.getHeaderFields(); cookies = headers.get("Set-Cookie"); sessionID = null; for(String cookie : cookies) { if(cookie.startsWith("_whohar_session")) { sessionID = cookie.split(";", 2)[0].split("=", 2)[1]; break; } } /* * Redirect to Polestar OnDemand with dataSet ID and session ID */ polestar_url = POLESTAR_URI + dataSetID + "?whohar_session_id=" + sessionID; Runtime.getRuntime().exec("\"c:\\Program Files\\Internet Explorer\\iexplore.exe\" " + "\"" + polestar_url+ "\""); } /* * OnDemand dataSet upload data format - the beginning part defines the column type, qualification * and aggregation. */ private static String data_beginning = "<?xml version=\"1.0\" encoding=\"UTF-8\"?> " + " <dataset name="\" visibility="\"> " + " <source>test data</source> " + " <description> " + " Test data for Polestar OnDemand " + " </description> " + " <tags> " + " <tag name="\"> " + " </tags> " + " <table> " + " <fields> " + " <field name="\" type="\"> " + " <qualification type="\"> " + " </field> " + " <field name="\" type="\"> " + " <qualification type="\"> " + " </field> " + " <field name="\" type="\"> " + " <qualification type="\"> " + " </field> " + " <field name="\" type="\"> " + " <qualification type="\"> " + " </field> " + " <field name="\" type="\"> " + " <qualification type="\"> " + " </field> " + " <field name="\" type="\"> " + " <qualification type="\"> " + " </field> " + " </fields> "; private static String data_ending = " </table>\n" + "</dataset> "; /* * Call the Yahoo Job Listing RSS, parse the results and return list of RSS entries returned. */ private static List<entry> getYahooRSS(URL yahoo_rss_url) throws FeedException, IOException { List<entry> entries; SyndFeedInput syndFeedInput; entries = new ArrayList<entry>(); syndFeedInput = new SyndFeedInput(); SyndFeed syndFeed = syndFeedInput.build(new XmlReader(yahoo_rss_url)); for(Iterator<syndentry> ientry = syndFeed.getEntries().iterator(); ientry.hasNext(); ) { SyndEntry syndEntry; String title; syndEntry = ientry.next(); title = syndEntry.getTitle(); // Parse title for location. Pattern is "— city1, region1 • city2, region2" // Note that the separator is dash (—)and not hyphen (-) for(String location : title.substring(title.lastIndexOf('—')+1).split("•")) { Entry entry; String[] cityRegion; cityRegion = location.split(","); entry = new Entry(); entry.uri = syndEntry.getUri(); entry.title = title; entry.link = syndEntry.getLink(); entry.publishedDate = syndEntry.getPublishedDate(); entry.city = cityRegion.length <= 1 ? "" : cityRegion[0].trim().toUpperCase(); entry.region = cityRegion.length <= 1 ? cityRegion[0].trim().toUpperCase() : cityRegion[1].trim().toUpperCase(); entries.add(entry); } } return entries; } static class Entry { public String uri; public String title; public String link; public String city; public String region; public Date publishedDate; } }

It's a command-line app where the first argument is the HotJobs keyword and second and third arguments are the OnDeman logon credentials.

It uses the Project ROME RSS Java library to retrieve the feed.

Whohar itself has a RSS feed reader, so you don't necessarily have to use the API to upload RSS entry data into Whohar. For this task, however, I wanted to post-process the data after retrieving it from Yahoo! and before uploading. Specifically, I wanted to parse the Job Title fields to derive the job location city and State.

Summary

The Polestar in the cloud and Whohar API has such ease-of-use that you can call it from almost any application. In this blog entry, I illustrated how you'd upload data and display it in Polestar using four different programming languages.

I'm sure you'll be able to think of much more compelling uses for it than the examples I've given above. If so, I highly recommend immediately going to the Polestar in the cloud API $20K IDEAtion Challenge site and signing yourself up for a chance to win some recognition for your idea! The cash would be a nice bonus, too...

Hope you find this entry informative, and the sample codes allow you to quickly get up-to-speed with the Polestar in the cloud API.

Ted Ueda is a Senior Engineer with Technical Customer Assurance, SAP Business Objects.

sap biw materials,sap biw certification materials,sap biw interview questions,sap biw trainings,sap biw online training,sap biw tutorials,sap biw soft

The game is officially on, and the time is short. On Thursday March 5^th we officially launched our Polestar OnDemand Ideation challenge on Innocentive. Innocentive, a partner of the SAP Community Network is hosting this SAP sponsored challenge which will reward $20,000 to the developers of the best Polestar Ondemand mashups. We had originally budgeted 10K but at the last second we decided to go big and donate an extra 10K. This challenge will only last for 30 days, so don't delay register today.

For more about the contest and Polestar OnDemand, see my two previous posts.

• The hottest product at SAP BusinessObjects
• PolestarOnDemand APIs

Now in the grand scheme of things 20K isn't really a lot of money, but in today's world it's nothing to laugh at either. I think every developer who is considering entering the challenge first wants to know what kind of effort it is going to take to create a Polestar mashup. Well, it all really depends on your level of skill, but I believe we have made it as easy as we possibly could. With the resources that we have provided even a novice developer should be able to create a proof-of-concept within an hour.

The Polestar REST API focuses on two things: adding datasets, and viewing the datasets. There are a few more calls, but most apps will be concerned with sending data to Polestar to be viewed in the Polestar interface. To make it as easy as possible Ted Ueda from our Developer support team has created four code samples: Java, .NET, Python, and Flex. These sample apps should get you up and going very quickly. The documentation is also provided as a Wiki on SDN.

You have the samples and the documentation, now all you have to do is come up with an interesting idea. Here are some questions you might want to ask while brainstorming a possible solution. How can Polestar add value to particularly interesting dataset? How can adding Polestar to a current business workflow change the way we do business? You know I would really love to see a mashup with data from http://recovery.org, or http://recovery.gov, but allas they don't have API datasets yet, I think that would be really interesting personally. The world is not lacking for interesting datasets.

Really the hardest part about this challenge will be converting the external data into the http://create.ondemand.com data XML specification. It is no small thing but it should be solvable fairly simply.

We really want your feedback. Let us know what APIs you would like to see? What are we missing? How could we make this better?

Here's a list of resources that should prove useful to anyone investigating the challenge and the Polestar APIs

• Enter the Challenge
• Documentation
• Sample Code

Helpful blog posts:

• The hottest product at SAP BusinessObjects
• PolestarOnDemand APIs

Robert Horne

How to transfer the Data from SAP-System to Non-SAP system without additional Cost/License

How to transfer the Data from SAP-System to Non-SAP system without additional Cost/License

Can we Transfer the Reports/Data from SAP-System to Non-SAP system without additional Cost/License?.

Yes, we can transfer using with simple FTP/SFTP.

Is it required any additional License or additional Cost?

No.

Is there any complex Coding or Configuration required?.

No, it is very simple.

How Can I transfer the Report/Data?.

Here I'm considering SAP-BW system running in UNIX operating system and Windows XP as Non-SAP System.

Source : SAP-BW System running on UNIX.

Destination : SQL-Server running on Windows XP.

Scenario:

I have data in SAP-BW System, e.g. InfoCube 0SD_C03. And 0SD_C03 is having some reports and want to transfer the reports data to SQL-Server running on Windows XP.

Else

You may need to transfer ECC Data to SQL-Server running on Windows XP. For this also you can use the same logic.

Here are the steps...

1. Set the Variable values using fixed restrictions or Using SAP/Customer Exits variables in BW Report. (If you have any variables.)
2. Using RSCRM_BAPI TCode schedule the report based on your requirement i.e. daily, weekly...etc. And then dump the report result into one path (Directory) in Application Server. E.g.:
   Directory: /usr/sap/BP1/DVEBMGS00/work/
   You can see this path in AL11 Tcode.
   

3. Open the port in BW Application server.

4. Create FTP/SFTP User ID in Application server level in BW System.

5. Using Windows Script you call the Report in /usr/sap/BP1/DVEBMGS00/work/ path in BW system to SQL-Server running on Windows XP. This script you can save as a batch file and schedule it based on your requirement in Windows Server.

Sample Windows script:

Note: For better understanding or Changing of the above code, please contact your Windows system Administrator. This is just sample code only.

Here I’m using RSCRM_BAPI Tcode to dump the report result into Application Server. You can use your own method also. Our intension is how to transfer the data from SAP to Non-SAP System.

Surendra Reddy Surendra Kumar Reddy Koduru, is a SAP BI consultant currently working with ITC Infotech India Ltd , Bangalore, India. He has over 4+ years of experience in various BW/BI implementation/support projects.

SAP Skills Trends and Podcast - What Are Your Thoughts? Jon Reed

Hey folks - I wrote this blog entry to hopefully get some feedback from you on a recent podcast I hosted on SAP skills trends. (If you haven't heard it yet, you can click on this link to listen). But before we get into that, a bit of context:

I've been involved in some aspect of the SAP services market since 1995, and from what I have seen so far this year, this looks like the most difficult SAP consulting market I have seen to date. The challenge for SAP professionals seems to be the combination of unprecedented economic problems and the increase in offshoring of SAP skills needs - something I plan to cover in a podcast soon.

Of course, some would say that the benefit of such a downturn is that it provokes reform and innovation. I think most of us would agree that the classic SAP consulting model could use a hearty helping of both. But I do feel for the predicaments of folks who have been emailing me these days. I've been hearing from some senior consultants with pretty compelling skill sets, such as a senior FI/CO person, a senior SAP Logistics person, and a senior CRM Mobile specialist - just some quick snapshots of people who have never had as much difficulty finding new projects.

The good side, if there is one, is that the SAP market has not stopped in its tracks; there is still work to be found. There are two areas that always deserve exploration: one is skills expansion, and the second is marketing those skills. Though I would say that self-marketing is rapidly shifting into something much more useful and important: SAP community involvement. I wrote a piece on the keys to marketing yourself as an SAP consultant last summer that goes into self-marketing in more detail.

On the skills side, we can probably throw most of what we historically understood about SAP skills needs out the window and start afresh. We need new insights and practical tips on what skills are actually in use now. And we need feedback from those in the field on what they are seeing. That's a major reason why I agreed to participate in a recent SAP skills podcast that was coordinated by SAP's Ecosystem Workforce Group. This podcast was a joint venture with my site, JonERP.com, PAC, and K2 Partnering Solutions. We had folks on the podcast from different parts of the globe drawing on global research, so it really was an attempt to provide a big picture view of SAP skills demand now.

If you haven't checked out the podcast yet, or want to see a podcast timeline, check that out on Audrey Stevenson's blog. It's also on the University Alliance home page on SCN. I'm hoping that you'll check it out and share some comments with me on what you took from the podcast and if it resonates or conflicts with what you are seeing. One of the big themes of the podcast is the key to remaining marketable as an onsite consultant in the era of global outsourcing.

The skills needed to be a marketable onsite consultant and the so-called "SAP BPX skill set" seem to be more and more connected. For example, in the podcast, Peter Russo, who leads PAC's SAP Research Practice, talked about some shifts in SAP skills needs he is seeing and some new roles that are emerging. Peter talked about how this ties back into the topic of consultant quality, and bringing genuine value to customer sites. In that context, he noted the emergence of the "Business Solutions Architect"" a combination of technical and business skills, which is the result of the broadening of the SAP suite and the possibilities that SOA brings. As Peter defined it, the Business Solution Architect brings both business process know-how and technical expertise to the table. These folks are not necessarily doing hard core coding, but they are doing process orchestration and bringing management skills to the table as well.

Peter noted that this is a difficult skills profile for customers to develop - thus the need for an onsite consulting presence in this area. The Business Solutions Architect has an onsite relevance due to the importance of local experience, understanding the needs of the company in question, and having the industry know-how to properly advise such a customer. I don't know about you, but to me, this sounds a lot like the BPX skills profile we talk about frequently on this site. Another theme that Peter cited was the importance of Business Intelligence skills and the need for data transparency, competitive analysis, and KPI measurement. These skills also tie into the onsite consultant profile, and I'll be exploring this in further detail in future podcasts.

So with that said, I'm interested in hearing your feedback on these comments and/or on the themes of the podcast.

Jon Reed is the President of JonERP.com - he blogs and podcasts on SAP skills trends.