49 thoughts on “Java code to list the objects used in a Webi 4.0 document”

1. Boris December 3, 2012 at 9:59 pm

   Dmitry,

   your example shows how to get a list of objects in a webi report. For documentation and traceablity purposes it would be nice to get an expression which corresponds to any particular object used in the report. Is there any way to do this? For instance, if the object name was “Full Name” and its expression in teh universe was ” LAST_NAME||’, ‘||FIRST_NAME “, how can I get this information from the webi report itself. I assume there has to be a better solution than parsing the entire SQL.

   Boris

   LikeLike

   Reply ↓
   1. dmytro Post authorFebruary 15, 2013 at 12:17 pm

      Boris,
      I wish I knew how to pull this information out of BO 4.0 🙂

      LikeLike

      Reply ↓
      1. RAGHU June 21, 2013 at 11:02 am

         Hi Dmytro,

         The following code with unvDoc will do the magic for Boris.

         The code will list only objects along with IDs as per his req. more to do is just have a vlookup of objectID of code output vs objectID from unvdoc tool excel to get sql part of the object…

         All the credit goes to Dmytro… I am learning SDK on following your Website..

         ………………………………………………………..

         import java.util.Collection;
         import java.util.List;
         import java.util.ArrayList;
         import java.util.Locale;
         import com.businessobjects.adv_ivcdzview.Utils;
         import com.businessobjects.rebean.wi.DataProviders;
         import com.businessobjects.rebean.wi.model.engine.IDocumentInstance;
         import com.businessobjects.rebean.wi.services.IDocumentInstanceManagementService;
         import com.businessobjects.sdk.core.Core;
         import com.businessobjects.sdk.core.context.IContext;
         import com.crystaldecisions.sdk.exception.SDKException;
         import com.crystaldecisions.sdk.framework.CrystalEnterprise;
         import com.crystaldecisions.sdk.framework.IEnterpriseSession;
         import com.crystaldecisions.sdk.framework.ISessionMgr;
         import com.crystaldecisions.sdk.occa.infostore.IInfoObject;
         import com.crystaldecisions.sdk.occa.infostore.IInfoObjects;
         import com.crystaldecisions.sdk.occa.infostore.IInfoStore;
         import com.sap.sl.dataprovider.DataProvider;
         import com.sap.sl.dictionary.*;
         import com.sap.webi.client.toolkit.Deployment;
         import com.sap.webi.client.toolkit.LoginKey;
         import com.sap.webi.client.toolkit.SessionContext;
         import com.sap.webi.client.toolkit.reporting.ReportDictionaryHelper;
         import com.sap.webi.client.toolkit.internal.repository.RepositoryAccessCommonImpl;
         import com.sap.webi.client.toolkit.repository.IRepositoryAccess;
         import com.sap.webi.client.toolkit.reporting.ObjectsDictionary;

         import edu.emory.mathcs.backport.java.util.Arrays;
         import edu.emory.mathcs.backport.java.util.Collections;

         public class ObjectsWithID {
         public static void main(String[] args) throws Exception {

         IEnterpriseSession enterpriseSession = null;
         try {
         ISessionMgr sessionMgr = CrystalEnterprise.getSessionMgr();
         enterpriseSession = sessionMgr.logon(
         “”, “”, “”, “secEnterprise”); // secEnterprise can be secLDAP …
         System.out.println(“REPORT NAME”+”###”+”Data Provider Name”+”###”+”Object Name”+”###”+”Qualification”+”###”+”ObjectID”);
         // Do some magic
         String serializedSession = enterpriseSession.getSerializedSession();
         SessionContext sessionContext = Utils.getSessionContextManager()
         .matchSessionContext(Deployment.DHTML, serializedSession, true);
         Locale localLocale = Locale.getDefault();
         sessionContext.getLoginInfo().set(LoginKey.LOCALE, localLocale);
         sessionContext.logonWithSerializedSession();
         IContext context = sessionContext.getCoreContext();
         IDocumentInstanceManagementService documentInstanceManagementService =
         Core.getService(IDocumentInstanceManagementService.class);
         // Get the list of webi documents
         IInfoStore infoStore = (IInfoStore) enterpriseSession.getService(“InfoStore”);
         String query = “select SI_NAME, SI_ID from CI_INFOOBJECTS ”
         + “where SI_KIND = ‘Webi’ and SI_INSTANCE=0 “; // optional and SI_PARENT_FOLDER in () and SI_ID=
         IInfoObjects infoObjects = (IInfoObjects) infoStore.query(query);
         for (Object object : infoObjects) {
         IInfoObject infoObject = (IInfoObject) object;
         if (getInfoObjectPathAndTitle(infoObject).startsWith(“/”)) {

         IDocumentInstance doc = documentInstanceManagementService
         .openDocument(context, infoObject.getID());

         List dataprovs = ReportDictionaryHelper.getDataProviders(context, doc);

         if (dataprovs.size() > 0) {
         for (DataProvider dataprov:dataprovs) {

         Collection list1 = ReportDictionaryHelper.getDictionaryObjectsFlatList(context, doc);

         for (DictionaryExpression dp :list1) {

         int position1;
         String hexobjectID;
         if(dp.getID().length()>3){
         if ((dp.getID().contains(“.”))) {
         position1 = dp.getID().indexOf(“.”);
         if(dp.getID().substring(0,position1).equals(dataprov.getID())){
         System.out.println(dp);
         hexobjectID =dp.getID().substring(dp.getID().indexOf(“.”)+3,dp.getID().length());
         System.out.println(hexobjectID);
         int objectid = Integer.parseInt(hexobjectID,16);
         System.out.println(“Hex value “+objectid);
         System.out.println(infoObject.getTitle()+”###”+dataprov.getName()+”###”+dp.getName()+”###”+objectid);
         }

         }
         }
         }

         }
         }

         documentInstanceManagementService.closeDocument(context, doc);

         }
         }
         } catch (SDKException ex) {
         ex.printStackTrace();
         } finally {
         if (enterpriseSession != null)
         enterpriseSession.logoff();
         }
         System.out.println(“Finished!”);
         }

         public static String getInfoObjectPath(IInfoObject infoObject)
         throws SDKException
         {
         String path = “”;
         while (infoObject.getParentID() != 0) {
         infoObject = infoObject.getParent();
         path = “/” + infoObject.getTitle() + path;
         }
         return path;
         }

         public static String getInfoObjectPathAndTitle(IInfoObject infoObject)
         throws SDKException
         {
         return getInfoObjectPath(infoObject) + “/” + infoObject.getTitle();
         }
         }

         Regards,
         Raghu

         LikeLike
      2. RAGHU June 21, 2013 at 11:20 am

         Please modify reqd lines following code. I am sorry i forgot to comment some lines

         //System.out.println(dp);
         hexobjectID =dp.getID().substring(dp.getID().indexOf(“.”)+3,dp.getID().length());
         //System.out.println(hexobjectID);
         int objectid = Integer.parseInt(hexobjectID,16);
         //System.out.println(“Hex value “+objectid);
         System.out.println(infoObject.getTitle()+”###”+dataprov.getName()+”###”+dp.getName()+”###”+objectid);

         Regards,
         Raghu

         LikeLike
      3. dmytro Post authorAugust 22, 2013 at 7:31 pm

         Belated thanks to you, Raghu

         LikeLike
      4. Aditya August 5, 2014 at 5:06 am

         Hi Dmytro,

         I am looking for a code where I can change the logo of one/bunch of reports with another logo that is saved on my local machine or the server.
         I’m working around withe following piece of code regarding the same:

         package org.bukhantsov;

         import java.util.ArrayList;

         import com.businessobjects.rebean.wi.DocumentInstance;
         import com.businessobjects.rebean.wi.FormulaExpression;
         import com.businessobjects.rebean.wi.ReportCell;
         import com.businessobjects.rebean.wi.ReportDictionary;
         import com.businessobjects.rebean.wi.ReportEngine;
         import com.businessobjects.rebean.wi.ReportEngines;
         import com.businessobjects.rebean.wi.ReportExpression;
         import com.businessobjects.rebean.wi.TreeNode;
         import com.crystaldecisions.sdk.exception.SDKException;
         import com.crystaldecisions.sdk.framework.CrystalEnterprise;
         import com.crystaldecisions.sdk.framework.IEnterpriseSession;
         import com.crystaldecisions.sdk.framework.ISessionMgr;
         import com.crystaldecisions.sdk.occa.infostore.IInfoObject;
         import com.crystaldecisions.sdk.occa.infostore.IInfoObjects;
         import com.crystaldecisions.sdk.occa.infostore.IInfoStore;

         public class Program {

         public static void main(String[] args) throws Exception {

         String userName = “Administrator”;
         String password = “”;
         String cms = “ukr-client01”;
         String auth = “secEnterprise”;

         IEnterpriseSession enterpriseSession = null;
         ReportEngines reportEngines = null;
         try {

         System.out.println(“Connecting…”);
         ISessionMgr sessionMgr = CrystalEnterprise.getSessionMgr();
         enterpriseSession = sessionMgr.logon(userName, password,
         cms, auth);
         reportEngines =
         (ReportEngines) enterpriseSession.getService(“ReportEngines”);
         ReportEngine wiRepEngine =
         (ReportEngine) reportEngines.getService(ReportEngines.ReportEngineType.WI_REPORT_ENGINE);
         IInfoStore infoStore = (IInfoStore) enterpriseSession.getService(“InfoStore”);

         String query = “select SI_NAME, SI_ID from CI_INFOOBJECTS ”
         + “where SI_KIND = ‘Webi’ and SI_INSTANCE=0”;
         IInfoObjects infoObjects = (IInfoObjects) infoStore.query(query);
         for (Object object : infoObjects) {
         IInfoObject infoObject = (IInfoObject) object;
         String path = getInfoObjectPathAndTitle(infoObject);
         if (path.startsWith(“/Business Performance Management/Reporting/AR Aging”)) {
         DocumentInstance widoc = wiRepEngine.openDocument(infoObject.getID());
         String doc = infoObject.getTitle();
         int cnt = replaceExpression(widoc, “=\”boimg://logo.bmp\””, “=\”boimg://logo.jpg\””);
         System.out.println(cnt + ” occurences were replaced in ” + path + “/” + doc);
         widoc.save();
         widoc.closeDocument();
         }
         }

         } catch (SDKException ex) {
         ex.printStackTrace();
         } finally {
         if (reportEngines != null)
         reportEngines.close();
         if (enterpriseSession != null)
         enterpriseSession.logoff();
         }
         System.out.println(“Finished!”);
         }

         private static int replaceExpression(DocumentInstance widoc, String from, String to) {
         ReportDictionary reportDictionary = widoc.getDictionary();
         ArrayList nodes = getListOfTreeNodes(widoc.getStructure(), false);
         int n = 0;
         for (TreeNode node : nodes) {
         if (node instanceof ReportCell) {
         ReportCell reportCell = (ReportCell)node;
         ReportExpression reportExpression = reportCell.getExpr();
         if (reportExpression instanceof FormulaExpression) {
         FormulaExpression formulaExpression = (FormulaExpression)reportExpression;
         if (formulaExpression.getValue().compareTo(from) == 0){
         FormulaExpression newFormulaExpression = reportDictionary.createFormula(to);
         reportCell.setExpr(newFormulaExpression);
         n += 1;
         }
         }
         }
         }
         widoc.applyFormat();
         return n;
         }

         public static ArrayList getListOfTreeNodes(TreeNode root, boolean onlyLeaves) {
         ArrayList nodes = new ArrayList();
         treeNodeTraversal(root, nodes, onlyLeaves);
         return nodes;
         }

         private static void treeNodeTraversal(TreeNode node, ArrayList nodes, boolean onlyLeaves) {
         if (!onlyLeaves || node.isLeaf()) {
         nodes.add(node);
         }
         for (int i = 0; i < node.getChildCount(); ++i) {
         treeNodeTraversal(node.getChildAt(i), nodes, onlyLeaves);
         }
         }

         public static String getInfoObjectPath(IInfoObject infoObject)
         throws SDKException {
         String path = "";
         while (infoObject.getParentID() != 0) {
         infoObject = infoObject.getParent();
         path = "/" + infoObject.getTitle() + path;
         }
         return path;
         }

         public static String getInfoObjectPathAndTitle(IInfoObject infoObject)
         throws SDKException {
         return getInfoObjectPath(infoObject) + "/" + infoObject.getTitle();
         }

         public static String getUniversesRoot(IInfoStore infoStore)
         throws SDKException {
         String query = "select * from CI_APPOBJECTS where SI_KIND = 'Folder' "
         +"and SI_OWNER='System Account' AND SI_NAME='Universes'";
         IInfoObjects objects = (IInfoObjects) infoStore.query(query);
         IInfoObject obj = (IInfoObject) objects.get(0);
         return getInfoObjectPathAndTitle(obj);
         }

         }

         LikeLike
2. Aaron February 14, 2013 at 8:58 pm

   Hi, Is it possible to capture the values selected in a global filter in a WebI document in BI4.0?
   We have a requirement to capture the filter values and pass on to SDK utility that will store these values in a db table for further processing.

   Also after the SDK utility has run, we need to pass the control back to the Launchpad so that users can continue in the same IE Infoview window that they had used to login.

   Is it possible to achieve using BI 4 SDK?
   Appreciate your response.

   LikeLike

   Reply ↓
   1. dmytro Post authorFebruary 15, 2013 at 12:14 pm

      Isn’t BO auditing sufficient for this? It is possible to track user prompt selection. I assume you can get the values from auditing database “for further processing”.

      LikeLike

      Reply ↓
3. RAGHU June 6, 2013 at 5:44 am

   Hi Dmytro,

   I am tryong to get variable formula and i am not getting it exactly what i want. It’s giving in some other language+english. i beilive its object cuid and function ids are coming into picture in this. If its plain english variable like a variable having raghu in it. then we are able to get it. But when there is objecrs or functions used in variables definition. then i am facing issue.

   Code addition done is

   System.out.println(var.getDefinition());

   Output is as follows

   VARIABLES:
   Var_Activity
   DIMENSION
   qDl$f301$f282$s$oL4$f301$lDelay$s$f524$s$f553$f456$lDelay$f457$s$f525$s$oLD$

   Please let me know if we can achieve the variable formulas using SDK.

   Regards,
   Raghu

   LikeLike

   Reply ↓
   1. RAGHU June 11, 2013 at 7:40 am

      Hi Dmytro,
      I have modified the code to list the formula in varaiable and its working very fine.

      List vars = ReportDictionaryHelper.getDocumentVariables(context,doc);
      if (vars.size() > 0) {
      System.out.println(“\n VARIABLES:”);
      for (Variable var:vars) {
      System.out.println(var.getName());
      System.out.println(var.getQualification());
      //System.out.println(var.getDefinition());
      String objectvarformula = ReportDictionaryHelper.getVariableFormulaText(context, doc, var);
      System.out.println(objectvarformula);
      }
      }

      Regards,
      Raghu

      LikeLike

      Reply ↓
      1. dmytro Post authorJune 11, 2013 at 10:02 pm

         Thanks for the followup

         LikeLike
      2. Phani February 12, 2014 at 9:25 pm

         Hello Raghu,
         We are looking to get the list of objects used in a webI report in BI 4.0, the above code is what we are looking for, but I am not a java guy, can you please help me to implement this in our system, I would apppreciate if you could let me know the steps via email, my mail id is pphani119@yahoo.com

         Thanks in Advance
         – Phani

         LikeLike
   2. Phani February 12, 2014 at 9:24 pm

      Hello Raghu,
      We are looking to get the list of objects used in a webI report in BI 4.0, the above code is what we are looking for, but I am not a java guy, can you please help me to implement this in our system, I would apppreciate if you could let me know the steps via email, my mail id is pphani119@yahoo.com

      Thanks in Advance
      – Phani

      LikeLike

      Reply ↓
4. Deblin June 6, 2013 at 6:54 am

   Is there any way i can do this in netbeans? I am very new to java and we have a requirement to get the list of columns of a report through JAVA SDK. For example if a report A has Column A and Column B then the output will give us :
   Column A
   Column B

   is there a java code that does this?

   LikeLike

   Reply ↓
5. NewToBO June 26, 2013 at 9:16 am

   Is there any code available for creating webi document in BI4.0.
   I tried to create with following code snippet, But dataProvider is not getting value from the document instance. So I am not able to create the document.Please help to resolve this issue

   IDocumentInstance doc = dimService.newDocument(context);
   Workspace workspace = diService.getWorkspace(context, doc);
   List listDataProvider = wsService.getDataProviders(workspace);
   for (DataProvider provider : listDataProvider) {
   dataSource = (DataSource) provider.getDataSourceHeader().getDataSourceInfo();
   System.out.println(“datasource::”+dataSource.getName());
   }
   dimService.closeDocument(context, doc);

   LikeLike

   Reply ↓
6. wasy August 2, 2013 at 7:47 pm

   Is it possible to convert this code into an individual app (web or stand-alone) or in an application form and export the results in excel, just like universe documentor.

   would be wonderful and very very convenient for non-java guys.

   LikeLike

   Reply ↓
   1. dmytro Post authorAugust 4, 2013 at 9:24 am

      Well this code is primarily a hack. Soon SAP will release 4.1 with a public report sdk and it will be much easier to create the application.

      LikeLike

      Reply ↓
7. Balaji August 21, 2013 at 1:30 pm

   Hi Dmytro,
   Thanks for this thread. It is helpful for a novice like me.

   Thanks
   Balaji

   LikeLike

   Reply ↓
   1. dmytro Post authorAugust 22, 2013 at 7:28 pm

      Thanks Balaji, but this one is not for novice. It is about some not documented stuff so I would probably recommend it only for hackers 🙂
      This one for novices
      https://bukhantsov.org/2011/08/getting-started-with-businessobjects-java-sdk/
      and all posts regarding 3.1 as well
      https://bukhantsov.org/bo/

      LikeLike

      Reply ↓
8. Dhana August 22, 2013 at 1:52 pm

   Hi Dmytro,

   Is there anyway to list SQL expression behind the objects used in data providers in the report?

   Thanks,
   Dhana

   LikeLike

   Reply ↓
   1. dmytro Post authorAugust 22, 2013 at 7:29 pm

      See the answer to the first comments by RAGHU. Hopefully it can help. (I have not tried it)

      LikeLike

      Reply ↓
      1. Dhana August 27, 2013 at 5:10 pm

         Thanks Dmytro…And can we pull the list of reports based on a filter used in the report???

         LikeLike
9. Chai August 29, 2013 at 6:00 pm

   Hi..where can I find ReportDictionaryHelper and SessionContext classes?

   thanks

   LikeLike

   Reply ↓
   1. Rocky September 12, 2013 at 12:19 pm

      Hi Dmytro,

      Is there a possibility to retrieve all the objects and classes from a universe BO 4.0

      LikeLike

      Reply ↓
10. Rocky September 12, 2013 at 12:26 pm

    Hi Dmytro,

    Is there a possibility to retrieve all the objects and classes from a universe BO 4.0 using java code

    LikeLike

    Reply ↓
11. Sandeep Chandran September 27, 2013 at 7:30 am

    HI Dmytro,

    Is there any way to list which objects from universe are used in reports , without opening each and every report from BI laaunchpad. My question is specifc to BI 4.0 WEBI.

    Also, anyway to list the reports, where in a specific universe object is used.

    Thanks and Regards
    Sandeep Chandran

    LikeLike

    Reply ↓
12. rajiv November 14, 2013 at 4:41 am

    hi Dmytro,

    wondering, how you know which jar files to pick….

    thanks, regards,
    rajiv n

    LikeLike

    Reply ↓
    1. dmytro Post authorNovember 14, 2013 at 12:28 pm

       pick all from …\java\lib

       If you are asking about adv_ivcdzview.jar, webi_client_toolkit.jar. I found reference to them in some jsp files.

       LikeLike

       Reply ↓
13. jessica November 14, 2013 at 12:20 pm

    Is there any way to get the structure of Webidocument in Bi 4

    LikeLike

    Reply ↓
    1. dmytro Post authorNovember 14, 2013 at 12:33 pm

       I assume yes, in 4.1

       Check this document:
       scn.sap.com/docs/DOC-27465
       -> RESTful Web Services SDK Developer Guides and API References
       -> SAP Business Objects BI Platform 4.1 Web Intelligence Developer Guide

       LikeLike

       Reply ↓
14. SS November 28, 2013 at 5:57 pm

    Hi Dmtyro,

    Could you please tell me how I can change the universe of webi report using Java 4.1 SDK.

    I am able to set the data source of data provider using below code.
    IWebiDocDataProviders loObj = infoObject.getDocumentDataProviders();
    IWebiDocDataProvider loDP = loObj.item(i);
    loDP.setDataSourceID(lsNewCUID);

    but some how these changes are not reflecting in Webi Report.

    Do I need to save the data provider after changing the universe?

    Please let me know the correct code for it

    LikeLike

    Reply ↓
15. Mark December 5, 2013 at 8:46 pm

    Hi Dmytro,

    Fantastic information- helping a lot.

    One question- is there any documentation on ReportDictionaryHelper? I think it is going to help me solve some things, but I can’t find anything (Javadocs, etc) on it- when I search, its basically only your blog that comes up.

    Thanks,

    LikeLike

    Reply ↓
    1. dmytro Post authorDecember 5, 2013 at 8:57 pm

       Hi Mark
       This post is about some internal sdk, so I do not think there is any documentation online.
       In 4.1 there is RESTful API for Webi, it will probably be much more convenient.

       LikeLike

       Reply ↓
       1. Mark December 11, 2013 at 5:40 pm

          Hmm, alright. Have you done any examples of using RESTful API for WEBI? I’ve looked through your stuff, and haven’t seen any so far.

          Thanks,

          Mark

          LikeLike
16. brian January 17, 2014 at 4:33 am

    thanks for the example! I have this working, but am seeing that the following line isn’t closing my webi session as expected:

    documentInstanceManagementService.closeDocument(context, doc);

    my webi sessions steadily increase as I iterate through webi documents, and ultimately I consume all available causing errors to be thrown.

    Any ideas as to why this isn’t closing the webi session that is invoked?

    LikeLike

    Reply ↓
17. Saradhi April 1, 2014 at 4:03 pm

    Hi dmytro,

    Your blog is very helpful.
    I have a requirement to add a new function (e.g: A financial function like IRR available in Excel) in Webi so that users can use this new function as all other functions like sum,Year,ToDate etc in Webi while developing reports. can we achieve this using the JAVA sdk by simply deploying the JAR files into server. Your response is very much appreciated as we have users seriously looking for this feature in Webi.
    Thank you very much.

    LikeLike

    Reply ↓
    1. dmytro Post authorApril 5, 2014 at 4:41 pm

       Click to access xi31_sp2_webi_calc_ext_en.pdf

       LikeLike

       Reply ↓
18. Dave April 3, 2014 at 3:16 pm

    Hi, I’m getting the following error with your code after invoking openDocument

    [2014-04-02 15:23:08,268] [ERROR] [com.crystaldecisions.enterprise.ocaframework.FailoverLogonService] logonWithToken(): Failed to relogon, aps=boe4cms01:6400,token=395039JDcRslb56VEd26ES3RQ07Fq395038JL5IiWD3ccgQ9UVABvK41zL, errorCode=10521
com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
at com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuseHelper.read(oca_abuseHelper.java:106)
at com.crystaldecisions.enterprise.ocaframework.idl.OCA.OCAs._LogonEx6Stub.LogonWithTokenEx5(_LogonEx6Stub.java:488)
at com.crystaldecisions.enterprise.ocaframework.FailoverLogonService.logonWithToken(FailoverLogonService.java:232)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.reconnectCMS(ManagedSession.java:771)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.validateServer(ManagedSession.java:756)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.validateStatelessService(ManagedSession.java:574)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.newService(ManagedSession.java:983)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.get(ManagedSession.java:278)
at com.crystaldecisions.enterprise.ocaframework.ManagedSessions.get(ManagedSessions.java:299)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService_aroundBody4(ServiceMgr.java:520)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService(ServiceMgr.java:1)
at com.businessobjects.corba.generic.container.proxy.internal.remote.WorkSessionProxyBuilder$WorkSessionStubHelper.getService(Unknown Source)
at com.crystaldecisions.enterprise.ocaframework.ManagedService.validate(ManagedService.java:771)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.validateStatelessService(ManagedSession.java:611)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.newService(ManagedSession.java:983)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.get(ManagedSession.java:256)
at com.crystaldecisions.enterprise.ocaframework.ManagedSessions.get(ManagedSessions.java:299)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService_aroundBody4(ServiceMgr.java:520)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService_aroundBody5$advice(ServiceMgr.java:512)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService(ServiceMgr.java:1)
at com.businessobjects.corba.generic.container.proxy.internal.remote.WorkSessionProxyBuilder.findManagedService(Unknown Source)
at com.businessobjects.corba.generic.container.proxy.internal.remote.WorkSessionProxyBuilder.connect(Unknown Source)
at com.businessobjects.corba.generic.container.proxy.internal.remote.WorkEntityFactory.getWorkSessionProxy(Unknown Source)
at com.businessobjects.corba.generic.container.proxy.internal.remote.RemoteGenericContainerProxy.getSessionProxy(Unknown Source)
at com.businessobjects.corba.generic.container.proxy.internal.remote.RemoteGenericContainerProxy.getSessionProxy(Unknown Source)
at com.businessobjects.corba.generic.container.proxy.internal.remote.RemoteGenericContainerProxy.getSessionProxy(Unknown Source)
at com.businessobjects.corba.generic.container.proxy.internal.remote.RemoteGenericContainerProxy.getEntityProxy(Unknown Source)
at com.businessobjects.sdk.core.server.internal.corba.AbstractServerConnector.init(AbstractServerConnector.java:86)
at com.businessobjects.rebean.wi.newserver.WebiServerConnector.init(WebiServerConnector.java:79)
at com.businessobjects.sdk.core.server.internal.corba.CorbaServerContext.init(CorbaServerContext.java:65)
at com.businessobjects.sdk.core.server.internal.corba.CorbaServerImpl.createServerContext(CorbaServerImpl.java:53)
at com.businessobjects.sdk.core.server.internal.AbstractServer.init(AbstractServer.java:69)
at com.businessobjects.sdk.core.server.internal.InstanceServer.init(InstanceServer.java:73)
at com.businessobjects.sdk.core.server.internal.InstanceServerServiceImpl.createServer(InstanceServerServiceImpl.java:90)
at com.businessobjects.rebean.wi.impl.services.DocumentInstanceManagementServiceImpl.createServerCallerReader(DocumentInstanceManagementServiceImpl.java:764)
at com.businessobjects.rebean.wi.impl.services.DocumentInstanceManagementServiceImpl.openDocument(DocumentInstanceManagementServiceImpl.java:157)
at com.businessobjects.rebean.wi.impl.services.DocumentInstanceManagementServiceImpl.openDocument(DocumentInstanceManagementServiceImpl.java:80)
at com.businessobjects.rebean.wi.internal.WIReportEngine.openDocument(WIReportEngine.java:429)
at com.businessobjects.rebean.wi.internal.WIReportEngine.openDocument(WIReportEngine.java:438)
at com.weishu.platform.datasource.bo4.services.impl.BOE4AccessServiceImpl.toMetadata(BOE4AccessServiceImpl.java:132)
at com.weishu.platform.datasource.bo4.services.impl.BOE4AccessServiceImpl.toMetadatas(BOE4AccessServiceImpl.java:78)
at com.weishu.platform.datasource.bo4.services.impl.BOE4AccessServiceImpl.listMetadata(BOE4AccessServiceImpl.java:70)
at com.weishu.platform.datasource.bo4.BOE4Accesser.listMetadatas(BOE4Accesser.java:101)
at com.weishu.platform.datasource.bo4.BOE4Accesser.doTestListDocument(BOE4Accesser.java:180)
at com.weishu.platform.datasource.bo4.BOE4Accesser.main(BOE4Accesser.java:212)
[2014-04-02 15:23:12,771] [ERROR] [com.crystaldecisions.enterprise.ocaframework.FailoverLogonService] logonWithToken(): Failed to relogon, aps=boe4cms01:6400,token=395039JDcRslb56VEd26ES3RQ07Fq395038JL5IiWD3ccgQ9UVABvK41zL, errorCode=10521
com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
at com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuseHelper.read(oca_abuseHelper.java:106)
at com.crystaldecisions.enterprise.ocaframework.idl.OCA.OCAs._LogonEx6Stub.LogonWithTokenEx5(_LogonEx6Stub.java:488)
at com.crystaldecisions.enterprise.ocaframework.FailoverLogonService.logonWithToken(FailoverLogonService.java:232)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.reconnectCMS(ManagedSession.java:771)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.validateServer(ManagedSession.java:756)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.validateStatelessService(ManagedSession.java:574)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.newService(ManagedSession.java:983)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.get(ManagedSession.java:278)
at com.crystaldecisions.enterprise.ocaframework.ManagedSessions.get(ManagedSessions.java:299)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService_aroundBody4(ServiceMgr.java:520)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService(ServiceMgr.java:1)
at com.businessobjects.corba.generic.container.proxy.internal.remote.WorkSessionProxyBuilder$WorkSessionStubHelper.getService(Unknown Source)
at com.crystaldecisions.enterprise.ocaframework.ManagedService.validate(ManagedService.java:771)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.validateStatelessService(ManagedSession.java:611)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.newService(ManagedSession.java:983)
at com.crystaldecisions.enterprise.ocaframework.ManagedSession.get(ManagedSession.java:256)
at com.crystaldecisions.enterprise.ocaframework.ManagedSessions.get(ManagedSessions.java:299)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService_aroundBody4(ServiceMgr.java:520)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService_aroundBody5$advice(ServiceMgr.java:512)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService(ServiceMgr.java:1)
at com.businessobjects.corba.generic.container.proxy.internal.remote.WorkSessionProxyBuilder.findManagedService(Unknown Source)
at com.businessobjects.corba.generic.container.proxy.internal.remote.WorkSessionProxyBuilder.connect(Unknown Source)
at com.businessobjects.corba.generic.container.proxy.internal.remote.WorkEntityFactory.getWorkSessionProxy(Unknown Source)
at com.businessobjects.corba.generic.container.proxy.internal.remote.RemoteGenericContainerProxy.getSessionProxy(Unknown Source)
at com.businessobjects.corba.generic.container.proxy.internal.remote.RemoteGenericContainerProxy.getSessionProxy(Unknown Source)
at com.businessobjects.corba.generic.container.proxy.internal.remote.RemoteGenericContainerProxy.getSessionProxy(Unknown Source)
at com.businessobjects.corba.generic.container.proxy.internal.remote.RemoteGenericContainerProxy.getEntityProxy(Unknown Source)
at com.businessobjects.sdk.core.server.internal.corba.AbstractServerConnector.init(AbstractServerConnector.java:86)
at com.businessobjects.rebean.wi.newserver.WebiServerConnector.init(WebiServerConnector.java:79)
at com.businessobjects.sdk.core.server.internal.corba.CorbaServerContext.init(CorbaServerContext.java:65)
at com.businessobjects.sdk.core.server.internal.corba.CorbaServerImpl.createServerContext(CorbaServerImpl.java:53)
at com.businessobjects.sdk.core.server.internal.AbstractServer.init(AbstractServer.java:69)
at com.businessobjects.sdk.core.server.internal.InstanceServer.init(InstanceServer.java:73)
at com.businessobjects.sdk.core.server.internal.InstanceServerServiceImpl.createServer(InstanceServerServiceImpl.java:90)
at com.businessobjects.rebean.wi.impl.services.DocumentInstanceManagementServiceImpl.createServerCallerReader(DocumentInstanceManagementServiceImpl.java:764)
at com.businessobjects.rebean.wi.impl.services.DocumentInstanceManagementServiceImpl.openDocument(DocumentInstanceManagementServiceImpl.java:157)
at com.businessobjects.rebean.wi.impl.services.DocumentInstanceManagementServiceImpl.openDocument(DocumentInstanceManagementServiceImpl.java:80)
at com.businessobjects.rebean.wi.internal.WIReportEngine.openDocument(WIReportEngine.java:429)
at com.businessobjects.rebean.wi.internal.WIReportEngine.openDocument(WIReportEngine.java:438)
at com.weishu.platform.datasource.bo4.services.impl.BOE4AccessServiceImpl.toMetadata(BOE4AccessServiceImpl.java:132)
at com.weishu.platform.datasource.bo4.services.impl.BOE4AccessServiceImpl.toMetadatas(BOE4AccessServiceImpl.java:78)
at com.weishu.platform.datasource.bo4.services.impl.BOE4AccessServiceImpl.listMetadata(BOE4AccessServiceImpl.java:70)
at com.weishu.platform.datasource.bo4.BOE4Accesser.listMetadatas(BOE4Accesser.java:101)
at com.weishu.platform.datasource.bo4.BOE4Accesser.doTestListDocument(BOE4Accesser.java:180)
at com.weishu.platform.datasource.bo4.BOE4Accesser.main(BOE4Accesser.java:212)


    LikeLike

    Reply ↓
19. Prathima May 23, 2014 at 4:32 am

    Hi dmytro,

    Is it possible to extract the metadata of a webi report from the BOBJ server 4.1 like header and footer details ,query, data providers, table and chart details using SDK. I have another doubt that is it possible to extract or save crystal report .rpt files from BOBJ server 3.1 to local as .rpt file itself.

    LikeLike

    Reply ↓
20. Maciej May 30, 2014 at 7:47 am

    Hi,

    Where did you found adv_ivcdzview.jar? I have BO Client Tools 4.0 but I cannot find that one 😦

    Many thanks

    LikeLike

    Reply ↓
    1. dmytro Post authorMay 30, 2014 at 8:02 am

       It is on the server in the folder C:\Program Files (x86)\SAP BusinessObjects\Tomcat6\webapps\BOE\WEB-INF\eclipse\plugins\webpath.AnalyticalReporting\web\WEB-INF\lib\

       LikeLike

       Reply ↓
21. Pavan June 2, 2014 at 7:15 am

    Out of many sites I visited, your site is very helpful dmytro. Thanks for helping us.
    I have a quick doubt, Im trying to reschedule a report using BO SDK
    I have written code in many ways but nothing worked 😦
    Below is the sample code:

    What is happening here is, report is getting scheduled but it is not sending mail/attachment unlike the original schedule instance.
    Below are the details of the rescheduled instance

    Title: SDK_TEST
    Document Type: Web Intelligence Report
    Status Success
    Destination: Default
    Owner: ****
    Creation Time: 5/15/2014 1:53 AM
    Start Time: 5/15/2014 1:53 AM
    End Time: 5/15/2014 1:53 AM
    Duration: 3 sec
    Server Used: mdwnew.AdaptiveJobServer
    PID: 27131966
    Parent Object Path: **********
    Remote Instance in Federated Cluster: No
    Expiry: 5/15/2024 1:53 AM
    Formats: Web Intelligence

    Now my doubt is can we reschedule the report directly or we need to get all the scheduling info like from/to/events etc and then apply them for the new schedule? I think it will be a tedious job as it could be SMTP or FTP or inbox or anything.

    LikeLike

    Reply ↓
22. Pavan June 2, 2014 at 7:18 am

    I think the snippet got removed

    Can you please tell me where am going wrong, or if you have code alredy that would be very much helpful Dmytro

    LikeLike

    Reply ↓
23. Mohit June 4, 2014 at 10:17 am

    Subject : Need to fetch Universe Name
    Hi Dmytro,

    I have migrated my BO reporting code from XR2 to XI4 and now using RestFul SDK 4 APIs to fetch the reports.

    Problem in below Code:

    ReportEngine repEng;
    DocumentInstance wiDoc = repEng.openDocument (si_id);
    Properties p = checkProperties
    (wiDoc.getProperties());
    queryList = new ArrayList();

    int providerCount =
    wiDoc.getDataProviders().getCount();

    DataProvider oDataProvider = null;
    for (int m = 0; m < providerCount; m++) {
    oDataProvider =
    wiDoc.getDataProviders().getItem(m);
    queryName = oDataProvider.getName ();
    logger.debug("queryName=" +
    queryName);
    logger.debug("dataprovider:" +
    oDataProvider.toString());
    logger.debug("datasource:" +
    oDataProvider.getDataSource().toString());
    universeName =
    oDataProvider.getDataSource().getLongName();
    queryData = new QueryData
    (queryName, universeName);
    queryList.add(queryData);
    }
    On SDK 2 above code works fine but If I use the above code with RestFul SDK 4 then I get below error.

    com.businessobjects.sdk.core.exception.common.NotImplementedException: This feature is not implemented. (Error: RWI 00013)
    at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(
    ExceptionBuilder.java:152)
    at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(
    ExceptionBuilder.java:123)
    at com.businessobjects.rebean.wi.internal.ds.WIDataSource.getLongName
    (WIDataSource.java:82)
    at com.newedgeusa.rboh.tool.BOBroker.getBoObjectReportsXI4(
    BOBroker.java:481)
    at com.newedgeusa.rboh.tool.BoObjectReportsXI4.doWork(
    BoObjectReportsXI4.java:18)
    at com.newedgeusa.rboh.tool.Main.start(Main.java:67)
    at com.newedgeusa.rboh.tool.Main.main(Main.java:29)

    Question: How can I fetch universe name using RestFul API, when I make request and get the XML result it does not return me UNIVERSE NAME.

    Please help me out, really urgent.

    Thanks,
    Mohit

    LikeLike

    Reply ↓
    1. Rakhy July 1, 2014 at 8:03 pm

       Hi Mohit,

       Any luck in fetching the universe name? I am trying to read data from a webi report, even I am getting This feature is not implemented. (Error: RWI 00013) exception. Looks like it is not implemented in XI 4.1 version! Please do let me know if you have any suggestions.

       Regards,
       Rakhy.

       LikeLike

       Reply ↓
24. Michael Madhukar K June 13, 2014 at 12:45 pm

    Could you please provide some BO4.x sdk sample code to Schedule and export the Webi document.

    LikeLike

    Reply ↓
    1. Prathima June 20, 2014 at 12:24 pm

       HI,

       Could any one tell me how to use RESTful API to get the list of reports from the BO server 4.1.

       LikeLike

       Reply ↓
25. ILAN July 16, 2014 at 8:46 am

    Hello !
    can you please help to get a list of object used in each Report BO with java SDK.

    Thank you

    LikeLike

    Reply ↓
26. arun August 7, 2014 at 8:05 pm

    Hello, Your SDK are very useful, currently am working with Java SDK BI 4.1. I have Authendication problem though secWnAD for the below code.
    ISessionMgr sessionMgr = CrystalEnterprise.getSessionMgr();
    enterpriseSession = sessionMgr.logon(“arajan”,”July2014″, “pidwbob001”, “secWinAD”);
    Error:

    Caused by: java.io.IOException: Unable to locate a login configuration
    at com.sun.security.auth.login.ConfigFile.init(Unknown Source)

    when i tried the same through VBA I am not getting any error for authendication.

    Kindly help me.

    LikeLike

    Reply ↓

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out /  Change )

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

Notify me of new comments via email.

Notify me of new posts via email.

Δ