jens_noering Posted February 26, 2007 Share Posted February 26, 2007 Hello community, i'm trying to connect ireport to jasperserver via xml/ a so i'm able to use the new warehouse explorer. I`ve created a Mondrian xml/ a datasource on jasperserver named olapxmladefintion. I've named the catalog like my schema is named 'olapschema'.When I'm trying to connect to jasperserver from ireport with xml/ a connection a Datasource is shown named:Provider=Mondrian;DataSource=OLAP; That is the right connection i think, but no catalog is shown. I've tried several descriptions for the catalog like Foodmart or simply olap. Which description is the right one?I'm not using foodmart database! The name of my Schema is OLAP. Hope someone can help me?! Link to comment Share on other sites More sharing options...
jdcryans Posted February 28, 2007 Share Posted February 28, 2007 Exactly the same problem here AND the costly documentation is of no help at all. Please help. Link to comment Share on other sites More sharing options...
sbirney Posted February 28, 2007 Share Posted February 28, 2007 Hello, this is a relatively new feature, so it hasn't been well documented yet. The datasource in the XML/A connection must match the name of the catalog, so try Provider=Mondrian;DataSource=olapschema; if your catalog is named 'olapschema'. hope this helps. Link to comment Share on other sites More sharing options...
jdcryans Posted February 28, 2007 Share Posted February 28, 2007 In my case, everything from client connections to schemas is named 'Test'. And it doesn't work tho I have know way to know what's wrong (printing the catched exception into the console would have been cool). Thanks Link to comment Share on other sites More sharing options...
jens_noering Posted February 28, 2007 Author Share Posted February 28, 2007 I've also tried the same things. uploaded schema with name OLAP.created a mondrian connection with name OLAP.But nothing happend. The DataSource is given automaticaly by ireport, I'm not able to define this. Any other ideas on this topic.Maybe I have to change the xml.jsp ? Link to comment Share on other sites More sharing options...
sure919 Posted February 28, 2007 Share Posted February 28, 2007 Hi Everyone!!May be XMLA connection definitions is different from the way in JI. I tried defining connection to mondrian using xmla it worked. here is the screen shot attached... Here is what i did:- Deployed mondrian.war on Tomcat application server. XMLA Server url is required so i passedhttp://locahost:8080/mondrian/xmla.and clicked "Get metadata" button. It discovers all the datasources that are present on the XMLA Server, based on the datasource selected it displays the catalog and based on the catalog it displays the cubes. i select the cube and save the connection information after verification (Test).Now, from IR Wizard or Report query dialog When i click the design query it opens up the Rex Wizard to design my mdx query.Hope this info helpsPost edited by: sure919, at: 2007/02/28 07:53 Link to comment Share on other sites More sharing options...
sure919 Posted February 28, 2007 Share Posted February 28, 2007 Oops i am unable to upload the image(SCreenshot)..here are the steps pass the url info.. and click the get metadata button.Hope it works for you too.. Cheers!!!sure Link to comment Share on other sites More sharing options...
jens_noering Posted February 28, 2007 Author Share Posted February 28, 2007 Hi sure919, I already connected to JI trough ireport on a blank version(Samples installed) of JI (JR 1.2) with the foodmart and sugarcrm datasource, so the steps i've to make to connect are well known to me. But no I've to connect to our own olap database.And there is the problem that ireport shows me the correct provider and datasource, but no catalog appears in the drilldown box. So I'm able to connect to the databse through xml/a, but now catalog is found. But thanxx that you have taken a look at my problem. Did you connect to foodmart or to an own olap database? greetz jens noeringPost edited by: jens_noering, at: 2007/02/28 09:24 Link to comment Share on other sites More sharing options...
sure919 Posted February 28, 2007 Share Posted February 28, 2007 Hi Jens Noering, I need to look into your datasources.xml file. This file contains the 1. datasource information,2. Catalog information (xml format). along with the DB info.later the Catalog contains the cube information.Could you please upload your "datasources.xml" file (you could find this in WEB-INF folder like "C:apache-tomcat-5.5.12webappsmondrianWEB-INF").I am attaching my datasources.xml file, hope this helps Cheers!!Sure [file name=datasources.xml size=1155]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/datasources.xml[/file] Link to comment Share on other sites More sharing options...
jens_noering Posted February 28, 2007 Author Share Posted February 28, 2007 Thanxx Sure, dont know why, but there was no Datasources.xml in the C:Programmejasperintelligence-1.1.0apache-tomcatwebappsjasperserverWEB-INFFolder. After I noticed that, I made my one one. Please take a look at it. As you can see in my folderdescription, i'm running the olap server on JI 1.1. Database is MySQL. MySQl Database is named olap.Olap Schema File Path = C:Programmejasperintelligence-1.1.0apache-tomcatwebappsjasperserverWEB-INFolappivot.xml Hope you can help me [file name=datasources-070fd19117e73a26dc22b6f58d2d77fc.xml size=554]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/datasources-070fd19117e73a26dc22b6f58d2d77fc.xml[/file] Link to comment Share on other sites More sharing options...
jens_noering Posted February 28, 2007 Author Share Posted February 28, 2007 Update: I noticed the port for the jdbc connection to mysql was wrong. Updated it but nothing happend. greetz Jens Noering Link to comment Share on other sites More sharing options...
jdcryans Posted February 28, 2007 Share Posted February 28, 2007 I fixed my problem finally. Simply, I thought I had jasper server 1.2 but it was 1.1 Now that I have updated, I do see my catalog and my cube but when I go in the query designer (with the XMLA connection and query language set to "XMLA-MDX") I have the following message : "defaultCloseOperation must be one of : DO_NOTHING_ON_CLOSE, HIDE_ON_CLOSE, or DISPOSE_ON_CLOSE". Funny enough! Anyone else has this message? This bug should be easy to fix. Thx Link to comment Share on other sites More sharing options...
sbirney Posted March 1, 2007 Share Posted March 1, 2007 datasources.xml is not used by JI. All the configuration for XML/A datasources is done by creating a XMLA Definition in the repository on the server. Then you can connect to this from iReport, or from an XMLA Connection on the same or another JI server. I'm not too knowledgeable about connecting with iReport, but I have tested this for the XMLA Connection method. Link to comment Share on other sites More sharing options...
jens_noering Posted March 2, 2007 Author Share Posted March 2, 2007 ok installed Jasperserver 1.2 and tried to connect to my olap database. That is working well, but now the problem is, that the same error appears:defaultCloseOperation must be one of: DO_NOTHING_ON_CLOSE, HIDE_ON_CLOSE, or DISPOSE_ON_CLOSE Maybe a java version problem? Installed JRE 1.6 Anybody got the same problem? Link to comment Share on other sites More sharing options...
jdcryans Posted March 2, 2007 Share Posted March 2, 2007 jdcryans wrote:Now that I have updated, I do see my catalog and my cube but when I go in the query designer (with the XMLA connection and query language set to "XMLA-MDX") I have the following message : "defaultCloseOperation must be one of : DO_NOTHING_ON_CLOSE, HIDE_ON_CLOSE, or DISPOSE_ON_CLOSE".Funny enough! Anyone else has this message? This bug should be easy to fix.Thx Yes I do Link to comment Share on other sites More sharing options...
jonnyfrastovner Posted March 4, 2007 Share Posted March 4, 2007 Me too. Tried running Ireport with JRE1.5_11, without success. jdcryans wrote:jdcryans wrote:Now that I have updated, I do see my catalog and my cube but when I go in the query designer (with the XMLA connection and query language set to "XMLA-MDX") I have the following message : "defaultCloseOperation must be one of : DO_NOTHING_ON_CLOSE, HIDE_ON_CLOSE, or DISPOSE_ON_CLOSE".Funny enough! Anyone else has this message? This bug should be easy to fix.Thx Yes I do 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