abinabraham
-
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
Posts posted by abinabraham
-
-
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
-
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
-
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
-
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
-
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 -
Do anybody have an idea abt this?please provide your inputs.
-
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
-
i am using jasperserver-pro-3.1.
The eror trace is given below.
Error Trace:
java.io.NotSerializableException: com.tonbeller.jpivot.table.span.PropertySpanBuilder$BookmarkState
java.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)
-
anyone have any idea abt this issue?
Please help.
-
anyone have any idea abt this issue?
Please help.
-
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>
-
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
-
Whats the difference between XML/A Connection and Mondrian connection?
Thanks in Advance
joe
-
Post Edited by joe77 at 10/13/2009 06:49
-
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 -
Can we create a Dashboard from an Analysis view?
Post Edited by joe77 at 09/22/2009 09:49 -
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 -
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 -
Hi all,
Is it Possible to create more than one Degenerate dimensions in a cube from same fact table?
Thanks in Advance
joe.
-
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 -
i got the answer.its given below.
Code: (ClosingPeriod([MONTH],[TIME].CurrentMember),[measures].[measurename])
-
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+200
how 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 -
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
-
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
Any difference in the process of import in 3.7
in Products
Posted
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