jonnyfrastovner Posted March 20, 2007 Share Posted March 20, 2007 I have successfully managed to create reports in iReport using XMLA and MDX against mondrian cubes. Now I want to deploy the report to a web page, optionally also create a report with subreports using different data sources/cubes. How do i specify data sources for xmla? I guess i must reference the WS URI (eg. http://localhost:8080/xmla) but how do i specify other parameters (catalog/cube, username/password etc)? How do i pass this to subreports? regards,- Bjug Boyum Link to comment Share on other sites More sharing options...
jonnyfrastovner Posted March 21, 2007 Author Share Posted March 21, 2007 I should probably mention that i run my apps on jboss (normally with a jndi data source). Link to comment Share on other sites More sharing options...
m.khiali Posted June 25, 2007 Share Posted June 25, 2007 hie, I want to know if you can help me to realize a report with an XMLA connexion because I have some difficulties. I ask you that because you have manage. Thank you in advance Link to comment Share on other sites More sharing options...
jonnyfrastovner Posted June 27, 2007 Author Share Posted June 27, 2007 I guess you have an xmla provider running? I do it by defining three variables in the JR report itself:XMLA_URI the ws adress, eg. "http://www.cubedata.com/xmla"XMLA_CATALOG name of the catalog, eg "myCubes"XMLA_DATASOURCE eg. "Provider=Mondrian;DataSource=myCubes;" The last two parameters are configured in datasources.xml on the xmla server (in MSAS and mondrian at least) In iReport you need to configure an xmla datasource to design and run the reports. Link to comment Share on other sites More sharing options...
Yuna Posted August 30, 2007 Share Posted August 30, 2007 Hi!I can't find the file datasource.xml. A have to get connection to MS SQL Server AS. And there isn't such file on my server. this file is important? And I don't understand how to write connection string? I must define variables in .jrxml - file? but what to write in connetion string when I run my report? Link to comment Share on other sites More sharing options...
ammy.5790 Posted May 3, 2013 Share Posted May 3, 2013 Hi I have managed to create a report with XMLA connection successfully. My main report uses a jdbc connection to my oracle db I want a subreport to use XMLA connection ( not jdbc ) .. Is it possible ?? if yes , plzz help .... ?? Link to comment Share on other sites More sharing options...
ammy.5790 Posted May 3, 2013 Share Posted May 3, 2013 Hi I have managed to create a report with XMLA connection successfully.My main report uses a jdbc connection to my oracle db I want a subreport to use XMLA connection ( not jdbc ) .. Is it possible ??if yes , plzz help .... ?? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now