Re: [Olap4j-devel] olap4j connecting to SAP BW over XMLA

[Luc B. <luc...@gm...>]

Try upgrading to olap4j-1.1.0. Some changes were done to prevent this from
happening.

Luc


On Thu, May 30, 2013 at 1:07 PM, Karthik Narayanan <rka...@gm...>wrote:

> hi guys,
>
> Below is the code that i wrote to access a SAPBW server over XMLA and
> execure a mdx query. I am using the OLAP4j 1.0.0.455 library. The code
> compiles fine.
>
>
>  Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
> OlapWrapper wrapper =  (OlapWrapper) DriverManager.getConnection(
> "jdbc:xmla:Server=
> http://sapserver:8000/sap/bw/xml/soap/xmla?sap-client=001", "USER",
> "password");
>  OlapConnection oConnection = wrapper.unwrap(OlapConnection.class);
> OlapStatement statement = oConnection.createStatement();
> CellSet cellSet =   statement.executeOlapQuery(
>         "SELECT {[Measures].[Unit Sales]} ON COLUMNS,\n"
>         + "  {[Product].Members} ON ROWS\n"
>         + "FROM [Sales]");
>
>
> the code connects successfully to the SAPBW server and even executes the
> command. But the command fails on the server with an error. The error
> return suggests that the cause is an authorization issue. Which according
> to the SAP admin is not correct. He did a trace on the query and found that
> the query tries access providers and cubes it does not need to and breaks.
> His inputs are in the file "saptrace.rtf" . The error the client gets is in
> the file "error.rtf". Is there a setting or configuration in SAP that will
> avoid this issue. or am i missing something in my code. PLease advise. I
> can see the schema of the soap request has a lot of microsoft showing up in
> there.... may be i am not using the right driver.
>
> Your help will be appreciated.
>
>
> Karthik Narayanan
> rka...@gm...
>
>
>
>
>
> ------------------------------------------------------------------------------
> Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
> Get 100% visibility into your production application - at no cost.
> Code-level diagnostics for performance bottlenecks with <2% overhead
> Download for free and get started troubleshooting in minutes.
> http://p.sf.net/sfu/appdyn_d2d_ap1
> _______________________________________________
> olap4j-devel mailing list
> ola...@li...
> https://lists.sourceforge.net/lists/listinfo/olap4j-devel
>
>