BO 4.1 Universe Metadata extraction using Java SL SDK

[Former Member]

We are building an application using the SL SDK and are trying to extract the metadata from the Universe (like list of classes, dimensions, measures etc). We are able to connect to the server, retrieve the universe to the local machine; however, when we try to load the retreived local universe, we are facing an excception and not sure on how to proceed on the same.
   

     Below is the code snippet and the exception.
 
//Java code that caused the exception

RelationalBusinessLayer businessLayer = (RelationalBusinessLayer) local.load("E:\\Universe\\retrieval-2014-03-10-17-29-22\\eFashion_bl.blx");
System.out.println("Description-->"+businessLayer.getDescription());

//After setting the path and the required class path in the Command Prompt while executing the java file as below

java -cp "E:\Program Files (x86)\SAP BusinessObjects Enterprise XI 4.0\SL SDK\java\sl_sdk.jar;E:\Program Files (x86)\SAP BusinessObjects Enterprise XI 4.0\java\lib;E:\Program Files (x86)\SAP BusinessObjects Enterprise XI 4.0\java\lib\*;E:\Program Files (x86)\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\java;E:\Program Files (x86)\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\java\*;" UniverseBo -Dbusinessobjects.connectivity.directory="E:\Program Files (x86)\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer"

     The following Exception occurred.

//Exception

Exception in thread "main" java.lang.UnsupportedOperationException
        at com.businessobjects.connectionserver.ConnectionServer.getInstance(ConnectionServer.java:165)

Any pointers to the problem and suggestions are appreciated.

Thanks,

Prasanna R

[Former Member · Accepted solution]

Hi Prasanna,

Additionally, I was able to run my SL java codes using the attached compile.bat file.

I am attaching it in .txt format. Modify it according to your Directory structure and place the file in the same falder as your .java file and run the comiple.bat file and check if you are able to execute the same.

Thanks,

Prithvi

compile.txt.zip

[Former Member · Accepted solution]

Hi Prithivi,

   Thanks for the help and also the batch file; it was very helpful - we are now able to connect to the server without any exceptions. Might reach out again if we need any further help

Regards,

Prasanna R

[Former Member · Accepted solution]

Hi Prithvi,

     We are trying to extract metadata through java sdk from BO 4.1,we had been able to extract the data upto class level but can not proceed further to extract data related to the objects such as "measures,"dimensions","filters",etc from a class as we can't find suitable methods to do so.Please have a look to the following code snippet:-

RelationalBusinessLayer businessLayer = (RelationalBusinessLayer) local.load("D:\\Universe\\retrieval-2014-03-17-15-47-46\\eFashion4.blx");    //loading local blx file

RootFolder rf =businessLayer.getRootFolder();

List<BlItem> getchildren=rf.getChildren();   //would return list of classes

Now we intend to extract objects(filters,dimensions,measures) from each of these BlItems.

Please help.

Regards,
Ashwani.

[Former Member · Accepted solution]

Hi Ashwini,

Please start a new thread for your problem. It seems to me that you want to retrieve the detailed level information(i.e. Classes/Objects/Filters from the Data Foundation Layer). The thing that you want to know can be achievable through SL SDKs. Can you please specify your full BI product version that you are using?

Thanks,

Shailendra

[former_member308992]

Hello all,

For me eclipse dont reconize

...local.load( ... 

Do you know why?

Thank you

[Former Member]

Hi,

If this error message appears, verify that you have added the
following argument to the Java Virtual Machine:

Dbusinessobjects.connectivity.directory="D:\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer"

Also what happens when you build your project through ecllipse?

Thanks,

Prithvi