JasperServer and MS Analysis Services?

[oswalxy]

I'm trying to configure JasperServer to navigate some cubes made in MS Analysis Services.

 

Everything should be fine from the MS side.

Then I go to JasperServer and:

 

 

1) from within repository.olap.connections I add a new "OLAP Client connection" of type "XML/A Connection" where I specify:

 

-DataSource=Provider=MSOLAP.2;DataSource=localhost;Catalog=Foodmart 2000

-URI=http://localhost/xmla/msxisapi.dll

 

 

2) from within olap.views I add a new "Analysis view" where I specify:

 

-OLAP Client Connection from Content Repository=the formerly defined connection

- MDX Query=select

{[Measures].[unit Sales]} on columns,

order(except([Promotion Media].[Media Type].members,{[Promotion Media].[Media Type].[No Media]}),[Measures].[unit Sales],DESC) on rows

from Sales

 

3) Then I try to navigate the cube clicking on the defined view but I've got an "error" saying

 

"Error Message:

com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=HTTP fault string=(401)Unauthorized fault actor=null

Error Trace:

com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=HTTP fault string=(401)Unauthorized fault actor=null...."

 

 

By the way I tried exacly the same configuration both with "JasperServer 1.2.1 OpenSource" and "JasperServer Professional 1.2 Evaluation": same results and same error.

 

Any idea or any suggestion on how to connect to Microsoft Analysis Services?

 

A.

[oswalxy]

I realize now that there is a much more appropriate group "JasperIntelligence Discussion/Help" to discuss about this so I'm moving there.

 

A.