Jump to content
We've recently updated our Privacy Statement, available here ×

abinabraham

Members
  • Posts

    25
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by abinabraham

  1. Thank you for your reply. We didnt get any errors while doing the import.But only the folders were created.None of the views,connections are available.All the types were selected. Thanks joe
  2. Hi all, We are facing an issue while importing from 3.1 to 3.5 and even to 3.7.While importing only folders and jrxml files are getting imported.The xml files are not been imported and displays as it already exists. Can anyone please help on this issue Thanks and regards joe
  3. Hi all, We are facing an issue while importing from 3.1 to 3.5 and even to 3.7.While importing only folders and jrxml files are getting imported.The xml files are not been imported and displays as it already exists. Can anyone please help on this issue Thanks and regards joe
  4. Hi all, Do jasper analysis support multiple languages.For example can the caption of a Dimension or Measures can be displayed in a French along with english.(English/French) Thanks in advance joe
  5. Hi all, We are facing an issue while importing from 3.1 to 3.5 and even to 3.7.While importing only folders and jrxml files are getting imported.The xml files are not been imported and displays as it already exists. Can anyone please help on this issue Thanks and regards joe
  6. Hi all, Any difference in the process of import in 3.7? Thanks and regards joe Post Edited by joe77 at 02/15/2010 09:08
  7. Do anybody have an idea abt this?please provide your inputs.
  8. Hi all, Do jasper analysis support multiple languages.For example can the caption of a Dimension or Measures can be displayed in a local language along with english.(English/"Local language") Thanks in advance joe
  9. i am using jasperserver-pro-3.1. The eror trace is given below. Error Trace: java.io.NotSerializableException: com.tonbeller.jpivot.table.span.PropertySpanBuilder$BookmarkStatejava.io.NotSerializableException: com.tonbeller.jpivot.table.span.PropertySpanBuilder$BookmarkState at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1081) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302) at java.util.HashMap.writeObject(HashMap.java:1039) at sun.reflect.GeneratedMethodAccessor2400.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at java.io.ObjectStreamClass.invokeWriteObject(ObjectStreamClass.java:917) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1339) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302) at java.util.HashMap.writeObject(HashMap.java:1039) at sun.reflect.GeneratedMethodAccessor2400.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at java.io.ObjectStreamClass.invokeWriteObject(ObjectStreamClass.java:917) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1339) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1375) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1347) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1375) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1347) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302) at java.util.HashMap.writeObject(HashMap.java:1039) at sun.reflect.GeneratedMethodAccessor2400.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at java.io.ObjectStreamClass.invokeWriteObject(ObjectStreamClass.java:917) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1339) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1375) at java.io.ObjectOutputStream.defaultWriteObject(ObjectOutputStream.java:391) at org.springframework.webflow.core.collection.LocalAttributeMap.writeObject(LocalAttributeMap.java:307) at sun.reflect.GeneratedMethodAccessor2399.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at java.io.ObjectStreamClass.invokeWriteObject(ObjectStreamClass.java:917) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1339) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302) at org.springframework.webflow.engine.impl.FlowSessionImpl.writeExternal(FlowSessionImpl.java:159) at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1310) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1288) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302) at java.util.LinkedList.writeObject(LinkedList.java:755) at sun.reflect.GeneratedMethodAccessor2419.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at java.io.ObjectStreamClass.invokeWriteObject(ObjectStreamClass.java:917) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1339) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302) at org.springframework.webflow.engine.impl.FlowExecutionImpl.writeExternal(FlowExecutionImpl.java:476) at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1310) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1288) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302) at org.springframework.webflow.execution.repository.continuation.SerializedFlowExecutionContinuation.serialize(SerializedFlowExecutionContinuation.java:178) at org.springframework.webflow.execution.repository.continuation.SerializedFlowExecutionContinuation.<init>(SerializedFlowExecutionContinuation.java:70) at org.springframework.webflow.execution.repository.continuation.SerializedFlowExecutionContinuationFactory.createContinuation(SerializedFlowExecutionContinuationFactory.java:55) at org.springframework.webflow.execution.repository.continuation.ContinuationFlowExecutionRepository.putFlowExecution(ContinuationFlowExecutionRepository.java:178) at org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:210) at sun.reflect.GeneratedMethodAccessor235.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy17.launch(Unknown Source) at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:131) at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:107) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)
  10. hi all, I am trying to create a ireport chart using jasperReports-Pro 3.1.2. The query populates 3 rows and 2 fields (Fields=a category expression and a value expression). i am able to create a report but the report is displaying 3 charts(or as many rows the query populates). Do i need to specify any other properties? or do i hav to write the query in any other form? i am attaching the query and code below. thanks in advance joe Code:SELECT TYPE, count(STATUS)FROM TableGROUP BY TYPE-----------------------------------<?xml version="1.0" encoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="report name" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <style name="style1" isDefault="false"/> <queryString> <![CDATA[sELECT TYPE, count(STATUS)FROM TableGROUP BY TYPE]]> </queryString> <field name="TYPE" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="COUNT(STATUS)" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <background> <band/> </background> <title> <band height="37"/> </title> <pageHeader> <band height="35"/> </pageHeader> <columnHeader> <band/> </columnHeader> <detail> <band height="311" isSplitAllowed="false"> <lineChart> <chart isShowLegend="false" hyperlinkType="None"> <reportElement isPrintRepeatedValues="false" x="200" y="10" width="345" height="149"/> <box> <pen lineColor="#FFFF00"/> <topPen lineColor="#FFFF00"/> <leftPen lineColor="#FFFF00"/> <bottomPen lineColor="#FFFF00"/> <rightPen lineColor="#FFFF00"/> </box> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <categoryDataset> <dataset resetType="None"/> <categorySeries> <seriesExpression><![CDATA["OPEN"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> <categorySeries> <seriesExpression><![CDATA["CLOSED"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> <categorySeries> <seriesExpression><![CDATA["ABANDONED"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> </categoryDataset> <linePlot> <plot/> </linePlot> </lineChart> <pieChart> <chart isShowLegend="false" hyperlinkType="None"> <reportElement x="11" y="10" width="189" height="149"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <pieDataset> <keyExpression><![CDATA[$F{TYPE}]]></keyExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <sectionHyperlink hyperlinkType="None"/> </pieDataset> <piePlot isCircular="true"> <plot/> </piePlot> </pieChart> <stackedBarChart> <chart isShowLegend="false" hyperlinkType="None"> <reportElement x="329" y="159" width="216" height="141"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <categoryDataset> <categorySeries> <seriesExpression><![CDATA["OPEN"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> <categorySeries> <seriesExpression><![CDATA["CLOSED"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> <categorySeries> <seriesExpression><![CDATA["ABANDONED"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> </categoryDataset> <barPlot isShowLabels="false" isShowTickLabels="true" isShowTickMarks="true"> <plot/> </barPlot> </stackedBarChart> <bar3DChart> <chart isShowLegend="false" hyperlinkType="None"> <reportElement x="11" y="159" width="318" height="141"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <categoryDataset> <categorySeries> <seriesExpression><![CDATA["OPEN"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> <categorySeries> <seriesExpression><![CDATA["CLOSED"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> <categorySeries> <seriesExpression><![CDATA["ABANDONED"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> </categoryDataset> <bar3DPlot isShowLabels="false"> <plot/> </bar3DPlot> </bar3DChart> </band> </detail> <columnFooter> <band height="40"/> </columnFooter> <pageFooter> <band height="41"/> </pageFooter> <summary> <band height="42"/> </summary></jasperReport>
  11. Japser is displaying 'NaN' when i have a divide by zero error.How can we display zero in place of NaN? Your help is higly appreciated. thanks in advance joe
  12. Whats the difference between XML/A Connection and Mondrian connection? Thanks in Advance joe
  13. Where can i get a document to know more on roles in jasper? Is there a way to link the roles defined in JasperServer with roles in the workbench(cubes) ? Post Edited by joe77 at 10/06/2009 13:20
  14. Can we create a Dashboard from an Analysis view? Post Edited by joe77 at 09/22/2009 09:49
  15. Hi, I created a view and it is working well.When i open it and save as in another name i am able to view it but if i right click and edit it shows the below given error. "java.io.NotSerializableException: com.tonbeller.jpivot.table.span.PropertySpanBuilder$BookmarkState" Please help me in this issue. Thanks joe Post Edited by joe77 at 09/17/2009 11:27 Post Edited by joe77 at 11/25/2009 11:54
  16. Hi, I created a view and it is working well.When i open it and save as, in another name i am able to view it but if i right click and edit it shows the below given error. "java.io.NotSerializableException: com.tonbeller.jpivot.table.span.PropertySpanBuilder$BookmarkState" Please help me in this issue. Thanks joe Post Edited by joe77 at 09/17/2009 11:28 Post Edited by joe77 at 09/18/2009 04:22 Post Edited by joe77 at 11/25/2009 11:54
  17. Hi all, Is it Possible to create more than one Degenerate dimensions in a cube from same fact table? Thanks in Advance joe.
  18. HOW TO CREATE MULTIPLE HIERARCHIES IN A CUBE? I created multiple hierarchies but i am not able to show more than one hierarchy at a time in the report. i am getting the error "jsp.jpivot.selection.selection.multipleHierarchies" Thanks in advance. joe Post Edited by joe77 at 09/01/2009 09:49
  19. i got the answer.its given below. Code:(ClosingPeriod([MONTH],[TIME].CurrentMember),[measures].[measurename])
  20. I need my measure to return the total of a quarter as the total of the last month data in the quarter and total of the year as the total of the last quarter data or total of last month of the year data. for example ther were 100 users in jan,150 in feb and 200 in march. The quarterly total must be 200 users for the quarter.NOT 100+150+200how can this be done? Is this possible to be done in a calculated measure? thanks in advance joe Post Edited by joe77 at 08/25/2009 11:54
  21. my xTD funcs are not working properly. SUM(MTD([D_TIME].currentmember), [measures].[NO_OF_CUST]) only my above MTD code is working properly.but its not showing the total for the quarter or for the year. My YTD and QTD funcs are not giving the exact count and its showing the total of all months instead of the latest months count do anyone hav any idea on this. thanks in advance
  22. I have created jasper views using jasper proffesional and now i need to create jasper reports from those views.I want to display the reports to the end users with user credentials.How can i create jasper reports from jasper view?Please provide a help. note:i created the jasper views using mondrian schema work bench. thanks in advance Post Edited by joe77 at 08/21/2009 05:28 Post Edited by joe77 at 08/21/2009 05:29
×
×
  • Create New...