farhad

Thank you very much mauleous It helped me /tools/fckeditor/editor/images/smiley/msn/regular_smile.gif

HiHow to edit reports after adding them to the JasperServer Repository?It is possible to add reports to JasperServer after designing them in the iReport. As I know it is not possible to edit a report in the iReport after adding it to the JasperServer Repository. I mean changes would not be apply. I should edit the original report in the iReport and then add a new version of the report to the JasperServer Repository.Is there any way to edit reports uploaded to the repository?Regards

Hi,I want to run a report to retrieve records except of last ‘n’ minutes. To do it I defined an integer parameter to get user input as ‘n’ minutes. My database is db2 and am using the following query:SELECT minute2 , count(CASE WHEN channel_id = 210 THEN channel_id END) AS IB, count(CASE WHEN channel_id = 863 THEN channel_id END) AS ATM, count(CASE WHEN channel_id = 1 THEN channel_id END) AS INTERNALFROM ref.transaction_log_monitoring where transaction_type=1 and log_time < (select max(log_time) from ref.transaction_log_monitoring)- $P{Parameter1} MINUTES group by minute2this query faces an error that I attached it to the post while the parameter is ok, for example the following query runs successfully SELECT minute2 , count(CASE WHEN channel_id = 210 THEN channel_id END) AS IB, count(CASE WHEN channel_id = 863 THEN channel_id END) AS ATM, count(CASE WHEN channel_id = 1 THEN channel_id END) AS INTERNALFROM ref.transaction_log_monitoring where transaction_type=$P{Parameter1} and log_time < (select max(log_time) from ref.transaction_log_monitoring)- 1 MINUTES group by minute2Thanks and regards

Hi, How to create a domain based on a derived table? I have a DB2 database with tens of tables. There is table called Transaction_log with millions of records. I want to create a domain over it, but the problem is that the huge number of records caused reports to be very slow and ineffective. So I tried to create a derived table to filter the main table based on a smaller time interval to retrieve fewer records: select * from ref.transaction_log where log_time between timestamp('2011-08-01 12:00:00.000000') and timestamp('2011-08-01 12:30:00.000000') Everything was OK, derived table created successfully and added to the display options. But after choosing so-called domain to create ad hoc report I faced the following error: Error Message java.lang.IllegalArgumentException: getObjectType for javaType: null returned null Thanks Post Edited by farhad at 09/03/2011 14:44

hi, thank you , here is my schema: <?xml version="1.0"?> <Schema name="dphi"> <Cube name="cubeTest" cache="true" enabled="true"> <Table name="REF.USER_ACTION_LOG"> </Table> <Dimension foreignKey="USER_ACTION_ID" name="action"> <Hierarchy hasAll="true" allMemberName="all" primaryKey="USER_ACTION_ID"> <Table name="REF.USER_ACTION"> </Table> <Level name="ActionNAME" column="NAME" type="String" uniqueMembers="true" > </Level> </Hierarchy> </Dimension> <Measure name="actionCount" column="USER_ACTION_LOG_ID" formatString="#,###.00" aggregator="count"> </Measure> </Cube> </Schema> USER_ACTION has a one to many relationship with USER_ACTION_LOG , I thhink it can be considered as a simple star schema. I tested this schema over same tables in MySQL and MS SQL SERVER 2008 successfully with no error. I faced this error when I tried to create an Ad Hoc report over the cubeTest cube. I also made successfully an OLAP view using the following MDX query: select {[measures].[ actionCount]} on columns, {[action].[All] } on rows from [cubetest] but running the OLAP View generates an error with error trace as follows: ------------ The server has encountered an error. Please excuse the inconvenience. Error Message com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: MDX cube 'cubetest' not found or not processed Error Trace com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: MDX cube 'cubetest' not found or not processed at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.initializeOlapModel(OlapConnectionServiceImpl.java:396) at com.jaspersoft.jasperserver.war.control.OlapModelController.getOlapSession(OlapModelController.java:530) at com.jaspersoft.jasperserver.war.control.OlapModelController.viewOlap(OlapModelController.java:267) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:473) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:410) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:158) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:129) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:394) at com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:110) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:96) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:180) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:185) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.security.CrossScriptingFilter.doFilter(CrossScriptingFilter.java:49) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) at java.lang.Thread.run(Thread.java:619) Caused by: com.tonbeller.jpivot.olap.model.OlapException: MDX cube 'cubetest' not found or not processed at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:616) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:138) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:79) at com.tonbeller.jpivot.tags.PageStateManager.initializeAndShow(PageStateManager.java:44) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:190) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.initializeAndShow(OlapConnectionServiceImpl.java:358) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.initializeOlapModel(OlapConnectionServiceImpl.java:394) ... 85 more Error Message com.tonbeller.jpivot.olap.model.OlapException: MDX cube 'cubetest' not found or not processed Error Trace com.tonbeller.jpivot.olap.model.OlapException: MDX cube 'cubetest' not found or not processed at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:616) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:138) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:79) at com.tonbeller.jpivot.tags.PageStateManager.initializeAndShow(PageStateManager.java:44) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:190) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.initializeAndShow(OlapConnectionServiceImpl.java:358) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.initializeOlapModel(OlapConnectionServiceImpl.java:394) at com.jaspersoft.jasperserver.war.control.OlapModelController.getOlapSession(OlapModelController.java:530) at com.jaspersoft.jasperserver.war.control.OlapModelController.viewOlap(OlapModelController.java:267) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:473) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:410) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:158) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:129) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:394) at com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:110) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:96) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:180) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:185) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.security.CrossScriptingFilter.doFilter(CrossScriptingFilter.java:49) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) at java.lang.Thread.run(Thread.java:619)

Hi, I have been developed a simple schema over a DB2 data source. Everything seems to be OK and there is no problem or error while creating an OLAP View. But trying to run the OLAP View makes the folloewing error: Internal error: Error while executing query [with set [selectedMeasures] as '{[Measures].[m1]}' select {Hierarchize({[action].[all]})} ON COLUMNS, {[selectedMeasures]} ON ROWS from [cubeTest] ] Thanks for attentions

Hi, Exception getting dataset from cache! I created a Domain over a large dataset containing more than 16,000,000 records. When I am trying to drag the amount field (its value is from 1 to 2,100,000,000) and drop it as a measure am facing the error” exception getting dataset from cache”. I think that this is because of the very large sum of the Amount field. It also seems that JasperServer only supports 2,000,000 records in ad hoc reporting. Is there any where in the JaperServer to increase this value? So my question is that how can we deal with large data in JasperServer? I mean measuring, paging, and printing. Thank you for attention

Hi all, I imported some resources from previous 3.7 version of jasperserver into 4.1 versions. Everything imported successfully but starting the jasperser-pro causes the following error: 2011-07-19 18:38:12,468 ERROR ContextLoader,main:215 - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'proOnStartPropagator' defined in ServletContext resource [/WEB-INF/applicationContext-multiTenancy-web.xml]: Invocation of init method failed; nested exception is com.jaspersoft.jasperserver.api.metadata.common.service.JSResourceNotFoundException: jsexception.folder.not.found.at Here is my entire work in the last 3 month: 1. I made some reports and dashboards in the 3.7 version 2. I exported everything to BackUp3_7.zip 3. I downloaded and installed the 4.01 version 4. I imported the BackUp3_7.zip to the new version 5. I exported everything of 4.01 version and newly added resources of the 3.7 version to BackUp3_7_And_4_0_1.zip 6. I downloaded the the 4.1 version and installed it 7. I imported BackUp3_7_And_4_0_1.zip to the 4.1 version a. All resources of 4.01 version imported successfully b. Resources of 3.7 version imported incompletely 8. I tried to import the BackUp3_7.zip to the 4.1 version independently 9. Everything was okay with no error 10. But when I tried to start the jasperserver-pro I faced the above-mentioned error I Attached the TomCat.txt for details How can I fix the jasperserver to start It? I am very thankfull for helps. Post Edited by farhad at 07/19/2011 14:27

Hi, Don’t bother yourself to solve my problem! I think this bug is eliminated somewhat from the jasperReport server 4.1, but it still has the following problems: Ad hoc reports are CrossTab only; it is not possible to see the corresponding charts of OLAP Ad hoc reports I can't see any possibility of drilling trough the reports in the OLAP Ad hoc reports while it is possible in the OLAP view mechanism After saving the OLAP ad hoc report, I tried to import it in a Dashboard and I faced with a wonderful thing. It seems that the so-called report saved like a print screen image. Because all parts of the web page along with the report appears in the dashboard. I mean JasperLogo, Logout link, Username Label, the blue template and so on. Besides the save link is disabled and the little pop up window "Please wait, Loading…" is working forever until the page refreshed. regards Post Edited by farhad at 06/26/2011 07:16

I have been designed a simple snow flake data warehouse. I created a domain using domain creation wizard in the jasperReports server. The wizard joined all possible tables automatically. I have been face with two problems: Firstly: what is the difference between this wizard and the OLAP creation wizard while the numerical result seems to be the same? I mean in the both methods we can get reports to show some facts along with some dimensions apart from the report kind of OLAP or ad hoc. Secondly: how can I deal with Many-to-Many relationships in the domain creation wizard? The problem is that it ignores the weighting factor of the bridge table and the result is not true. I have been reported the same problem in How to make a Schema for a Snow Flake model . Please help me to overcome this problems

I have been designed a simple snow flake data warehouse. I am trying to make a schema and define required dimensions and facts. How can I define a schema for a snow flake model while there are some bridge tables as fact tables? Each bridge table has a Weighting factor as illustrated bellow: Suppose that DimContractor is in the Many-to-Many relationship with the DimContract via FactContractorContract and finally DimContract connected to the fact sales. Each contractor has a weight in the FactContractorContract to show the percent of the contribution in the relating contracts. I want to calculate the income of each contractor using the weight and the FactSales. FactContractorContract: Contractor_ID Contract_ID Weight 1 1 .5 1 2 .2 2 3 .6 FactSales Contract_ID Income 1 1000 2 2000 3 3000 I want to get the following: Contractor_Name Income X 500+400=900 Y 1800 I am very Thankful for helps.

Hi, I have been created a simple OLAP view using a simple schema. I can run it and see the result. I am looking for a way to make analytical Ad hoc reports. I want to enable the user to see Dimensions and measures and then create reports by dragging and dropping. Is it possible? How can I create analytical ad hoc reports? Thank you very much. Please help me. I will very thankful for kindly helps.

Hi, I have been created a simple OLAP view using a simple schema. I can run it and see the result. I am looking for a way to make analytical Ad hoc reports. I want to enable the user to see Dimensions and measures and then create reports by dragging and dropping. Is it possible? How can I create analytical ad hoc reports? Thank you very much. Please help me. I will very thankful for kindly helps Post Edited by farhad at 05/24/2011 08:24

Hi, Thank you very much for your kindly and good reply. I am working with JasperServer OLAP view, it seems to be attractive.

Hi ernestoo Thank you very much for your kindly reply, I installed JasperAnalysis_workbench-1.0 and successfully execute some MDX quires against FoodMart.xml. I tried to do the same in the jasperReport Server, but I faced the same previous error. I really confused that what is the matter. I think I am doing right steps to make an OLAP view with the aid of the JasperSoft-OLAP-User-Guide, But in the last step the following error prevents me to make the OLAP view: The following is not a valid MDX query: Internal error: while parsing catalog repoint:/test/MyFoodMart_2_Schema4