Connecting BIRT to Microsoft Analysis (ssas 2005)

Hello,

Is there a specific driver to connect to SSAS 2005 like the "XMLAServer" connector of Jasperreport ?

I have encounter error when trying to add the XmlaOlap4jDriver to BIRT (JDK 1.6).
Driver used : OLAP4J

Below is the error i received when i made a connection test:

ould not connect to OLAP4J.
Error creating SQL Model Connection connection to OLAP4J. (Error: Class org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection can not access a member of class org.olap4j.driver.xmla.XmlaOlap4jDriver with modifiers "protected")
Class org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection can not access a member of class org.olap4j.driver.xmla.XmlaOlap4jDriver with modifiers "protected"
Error creating JDBC Connection connection to OLAP4J. (Error: Class org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection can not access a member of class org.olap4j.driver.xmla.XmlaOlap4jDriver with modifiers "protected")
Class org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection can not access a member of class org.olap4j.driver.xmla.XmlaOlap4jDriver with modifiers "protected"

Any help to resolve this problem ?

Find more posts tagged with

Comments

JRiglar

Hi, try the following :

Install an XML/A ODA (attached is just an example)
Configure this XML/A interface and follow the steps shown in the link (this is for MSAS 2008), "How to set up XMLA HTTP Access for SQL Server Analysis Service" http://blogs.infragistics.com/blogs/atanas_dyulgerov/archive/2010/01/27/how-to-set-up-xmla-http-access-for-sql-server-analysis-service-2008-and-access-the-adventure-works-2008-from-an-infragistics-pivotgrid-application.aspx
Create a BIRT report using the ODA with URL : http://localhost/olap/msmdpump.dll
Pick a Cube and do any MDX query to get data from the Cube.

zadmichr

<blockquote class='ipsBlockquote' data-author="'JRiglar'" data-cid="81318" data-time="1312881251" data-date="09 August 2011 - 02:14 AM">
Hi, try the following : 
 
Install an XML/A ODA (attached is just an example) 
Configure this XML/A interface and follow the steps shown in the link (this is for MSAS 2008), "How to set up XMLA HTTP Access for SQL Server Analysis Service" <a class='bbc_url' href='http://blogs.infragistics.com/blogs/atanas_dyulgerov/archive/2010/01/27/how-to-set-up-xmla-http-access-for-sql-server-analysis-service-2008-and-access-the-adventure-works-2008-from-an-infragistics-pivotgrid-application.aspx'>http://blogs.infragistics.com/blogs/atanas_dyulgerov/archive/2010/01/27/how-to-set-up-xmla-http-access-for-sql-server-analysis-service-2008-and-access-the-adventure-works-2008-from-an-infragistics-pivotgrid-application.aspx</a> 
Create a BIRT report using the ODA with URL : <a class='bbc_url' href='http://localhost/olap/msmdpump.dll'>http://localhost/olap/msmdpump.dll</a> 
Pick a Cube and do any MDX query to get data from the Cube. </blockquote>
 
Thank you for your response JRIGLAR. 
For the SSAS http access, it's already done. 
I never used the ODA Datasource, i put the .Jars files under the plugins folder (Eclipse-BIRT), i go into the ODA Datasource node (on Eclipse Data Explorer) but nothing declared... 
Usually i use JDBC, it's the first time i use ODA datasource so can you send me some instructions to install your package. 
 
You will find a screenhot showing the step where my fingers freezed

Thank you in advance.

Migrateduser

Hi JRiglar, I know time has passed since this post. Im new to Birt and iHub and trying to make a connection to MSSQL Server Analysis Service. The XMLA HTTP Access is all ready setup. The XMLA.zip file that you are attaching how should I install it? On the Eclipse > Preference > Data Management ?
 
Is there any documentation you can recommend? Tips or guidance will be appreciated... Please Helppp!! :S

Juan Carlos

any progress on this post?

Azharmrd

@zadmichr said:
Hi, try the following :

Install an XML/A ODA (attached is just an example)

Configure this XML/A interface and follow the steps shown in the link (this is for MSAS 2008), "How to set up XMLA HTTP Access for SQL Server Analysis Service" http://blogs.infragistics.com/blogs/atanas_dyulgerov/archive/2010/01/27/how-to-set-up-xmla-http-access-for-sql-server-analysis-service-2008-and-access-the-adventure-works-2008-from-an-infragistics-pivotgrid-application.aspx

Create a BIRT report using the ODA with URL : http://localhost/olap/msmdpump.dll

Pick a Cube and do any MDX query to get data from the Cube.

Thank you for your response JRIGLAR.

For the SSAS http access, it's already done.

I never used the ODA Datasource, i put the .Jars files under the plugins folder (Eclipse-BIRT), i go into the ODA Datasource node (on Eclipse Data Explorer) but nothing declared...

Usually i use JDBC, it's the first time i use ODA datasource so can you send me some instructions to install your package.

You will find a screenhot showing the step where my fingers freezed

Thank you in advance.

Thanks. Visit here to get more information.