techs_massage

Thank you. I will try that. Thanks for the information!!

I am using a mondrian connection. Does that require the same http basic authentication? I have http enabled from any source to the server that the cube exists on on our internal firewall. Do I specifically have to configure something in Analysis Manager? I guess I have not seen where that setting exists.

I have created a report using iReport and can run the report fine within that app. I use the jrxml file in JapserIntelligence and a jdbc connection to my datasource, but then I receive the following error when running the report in JasperIntelligence: Error Message: org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@847c91 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@e5167, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Only a type can be imported. it.businesslogic.ireport.IReportScriptlet resolves to a package import it.businesslogic.ireport.IReportScriptlet; <---------------------------------------> 1 errors Error Trace: org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@847c91 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@e5167, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Only a type can be imported. it.businesslogic.ireport.IReportScriptlet resolves to a package import it.businesslogic.ireport.IReportScriptlet; <---------------------------------------> 1 errors org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@847c91 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@e5167, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Only a type can be imported. it.businesslogic.ireport.IReportScriptlet resolves to a package import it.businesslogic.ireport.IReportScriptlet; <---------------------------------------> 1 errors com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Only a type can be imported. it.businesslogic.ireport.IReportScriptlet resolves to a package import it.businesslogic.ireport.IReportScriptlet; <---------------------------------------> 1 errors at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:193) Where should I look first?

size=234]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/AM_Database.JPG

size=400]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/olap_datasource.JPG Post edited by: techs_massage, at: 2006/12/01 20:17

I have gotten past the jpivot error. Now I am down to only a login failure. I believe once I get past the login failure, my view will work. I know it must be something simple that I am missing. Here is what I have for datasource connection info: Through Analysis Manager on a database server, I have created a database called ProcureITCubeDB. The datasource for the database is a db on the same server. For the datasource connection in Analysis Manager I am using Microsoft OLE DB Provider for SQL Server. I am using Windows NT integrated Security. My test connection works fine from within AM. My cube in AM is called VendorPO. Like I said in an earlier post it is just a simple cube with a pototal measure in a fact table and a vendor dimension that looks for the vendorname. The key that links the tables is vendor_id. Within Jasper, I have created an olap datasource to the ProcureITCubeDB: My username and password are what I use on our domain. I went to the cube and right clicked and did manage roles and added myself as a user that is unrestricted to the cube. In Jasper I have an olap connection that uses the olap datasource I mentioned earlier. Then when I try and execute the MDX query, I get the following message:That is not a valid MDX Query: [Microsoft][sqlServer 2000 Driver for JDBC][sqlServer]Login failed for user 'nmeister'. Is my setup wrong anywhere that you can see? I can access the cube from an excel spreadsheet with no problem.

Loading the jpivot file did not work for me. Is there maybe something in my setup you can see that I am missing? I have created a simple cube using MS Analysis Services using SQL tables. The fact table is a purchaseorder table and the two dimensions are Vendor (just looking for vendorname) and PurchaseOrderDateC (just a basic time dimension). My datasource in Jasper validates to the db on the server fine. I created a simple schema that looks like the following: <Schema name="ProcureITVendorSchema"> <Cube name="VendorPOs"> <Table name="purchaseorders"/> <Dimension name="Vendor" foreignKey="vendor_id"> <Hierarchy hasAll="true" allMemberName="All Vendors" primaryKey="vendor_id"> <Table name="vendors"/> <Level name="VendorName" column="VendorName" uniqueMembers="true"/> </Hierarchy> </Dimension> <Dimension name="PurchaseOrderDateC" foreignKey="vendor_id"> <Hierarchy hasAll="false" primaryKey="vendor_id"> <Table name="purchaseorders"/> <Level name="Year" column="Datec" type="Numeric" uniqueMembers="true"/> </Hierarchy> </Dimension> <Measure name="Pototal" column="Pototal" aggregator="sum" formatString="#,###.##"/> </Cube> </Schema> I loaded that schema into Jasper. I then created a simple MDX query in my olap view that looks like the following and also validates and saves in Jasper: SELECT {[Measures].[pototal]} ON COLUMNS, NON EMPTY{[Vendor].[All Vendors].[Dell]} ON ROWS FROM [VendorPOs] However, when I try to run the olap view itself, I get the: JPivot had an error ... org.apache.jasper.JasperException: javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy org.apache.jasper.JasperException: javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy Anything glaring that anyone can see in my setup that I may have missed? Or some other piece that needs to be added? Your help is greatly appreciated!

Absolutely. Thank you! A zip file should work. Thanks Again! Post edited by: techs_massage, at: 2006/11/29 12:58

ddaly - can you provide me with the jpivot.jar file you built? I don't have the tools to build jpivot, but I am having the same issue you were having with the same exact error message. Thanks!

I was receiving a jpivot error with my olap cube but discovered I was using the wrong datasource connection. That was giving me the error. It was connecting to the db, but couldn't do anything because it was the wrong db. Post edited by: techs_massage, at: 2006/12/02 13:52

I have found a great site that explains schemas step by step and have created what I know is a good schema now. The site is here: http://mondrian.pentaho.org/documentation/schema.php#What_is_a_schema I am still wondering if there is a tool that can create a good schema automatically from an existing cube. Post edited by: techs_massage, at: 2006/12/02 13:55

Hi - I have JasperIntelligence running and have created a cube to access through an olap view. I have manually built the schema file that Jasper asks for, but was wondering if there is a way to have the schema file generated automatically somewhere to avoid any typos. I am currently using Microsoft Analysis Services to create my cubes and I am getting an error when I try to create my MDX query for the olap view. The error reads that it cannot find [Measures].[Pototal] in my cube. It does however exist in the cube so I'm thinking maybe my schema file is typed wrong somewhere. Thank you!

turns out the username password to access the db had changed - after I changed that in my datasource connection in JasperIntelligence the report worked - sorry for such a long error message to an easy fix :whistle:

Thank you!! That is exactly what the problem was. I appreciate your help. I have another problem now on another report. I created a datasource connection just like I did in the last report and created the report with the same connection in iReport with no problem, but when I try to run the report in JasperIntelligence it gives me the following error: Error Message: org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@6ebdba targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@9e6e1a, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSException: Error creating connection. Post edited by: techs_massage, at: 2006/12/02 14:01

Just to further clarify... the report data does not show in the html page - if you export the report into word or pdf - the data does show up. Any help would be appreciated. I can send screen shots if necessary.