shivareddyk

hi guys, my source data look like this field1 field2 field3 measure a f null 423 b g null 645 c d qwe 678 when i am displaying data by usng crosstab,i am getting only c d qwe 678 Question? how we can display the remaining 2 rows also in crosstab?(only the problem i-reports crosstab),i hope the problem with crosstab grouping,am i rite? (note: when i am use same mdx query in mondrian schem i am getting all rows) I hope some one help on this issue Thanking u in advance....

4 both questions answer is "yes"

hi prof's, how we can set order by exp in crosstab? note:my report data displaying alphabetical order,i want to custmize that order,help us any one? Regards

hi, i created cross tab with 2 row level groups and 2 column level groups...i saw expected result, but, when i am trying to add 3rd level group in row wise manuly i am getting empty report... Question: - how we can apply 3rd level row group in crosstab? Required ur help.... Regards

1.build cube by using workbench. 2.create connection between workbench and jasperserv when ur deploying cube or creating analysisview. 3.follow screen shot to creat view Regards

hi prof's? can possible to keyin parameters on top of jasperviews(by using some parameter window or ..) ? to view the data accordingly filter conditions instued of choose filter conditions from change data cube. pls....,let me any one... Regards

some thing like this.. *u can choose those things from (change data cube), from [your cube name] where [Property_code].[H2] gudluck

hi guys, i am viewing one jasperview from jasperserver(view generated based on cube),when ever i click particular value(drilldown),i am getting new report with out source records of that value. how i can get sourcerecords?wht is the cause i am unable to view those source records.........? pls let me know any one.. Regards

hi valbumbu, pls replay,i am getting same error...but i am passing parameters through query.. Regards shv

hi .. any one know aboun this bug " com.jaspersoft.jasperserver.api.JSException: jsexception.unknown.parameter.type.for.multiple.value.inputcom.jaspersoft.jasperserver.api.JSException: jsexception.unknown.parameter.type.for.multiple.value.input at com.jaspersoft.jasperserver.war.action.ReportParametersAction.getParameterMultiValue(ReportParametersAction.java:1223) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.bindParameterValues(ReportParametersAction.java:1088) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.getParameterValues(ReportParametersAction.java:216) at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:368) at com.jaspersoft.jasperserver.war.action.ViewReportAction.runReport(ViewReportAction.java:255) at sun.reflect.GeneratedMethodAccessor505.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:79) " pls.......respondeeeeeeeeee.... Regards

hi guys, how we can resolve this issue "com.jaspersoft.jasperserver.api.JSException: jsexception.unknown.parameter.type.for.multiple.value.input"? additional infor.. Note:- i created parameters by using query,and add same parameter name in jasperserver input data types folder of list of values and i chose multi select list of values at the time of creating addcontrol on .jrxml file. Thanking u.....

hi guys,how u resolve this issue,now i am getting same issue"com.jaspersoft.jasperserver.api.JSException: jsexception.unknown.parameter.type.for.multiple.value.input" pleaseeeeeee let me know,my personal id -- shiva.reddy@hotmail.com

hi guys, currently my pc having Jasperserver 3.7pro version,i am able to export test report with FLASH FORMAT and I am able to export dashboard with PDF format also........... BUT,i am unable to export dashboard with FLASH FORMAT,can i know how we can export dashbord's with flashformat's? Thanks

HI 1. I wrote query like this [this query displaying data of one dimension with two measures) "select NON EMPTY {[Measures].[balance],[Measures].[Peso Equiv]} ON COLUMNS, NON EMPTY {[depositesize].members} ON ROWS from [demo_p]" 2. I wrote query like this [this query displaying data of one dimension with two measures) "select NON EMPTY {[Measures].[balance],[Measures].[Peso Equiv]} ON COLUMNS, NON EMPTY {[PRODUCT].members} ON ROWS from [demo_p]" Note: The 2nd query also same as 1st one(but i use different dimension), if i executed separatly both mdx are dispalying corresponding data in pivote view. Q:-When i am trying to mix both queries i got a problem(tree structure not displaying in right side) ? i mixed like this (1 way) select NON EMPTY {[Measures].[balance],[Measures].[Peso Equiv]} ON COLUMNS, NON EMPTY Hierarchize(Union({[depositesize].members,[depositesize].members})) ON ROWS from [demo_p] 2nd way(with out Union) Pls...Could u let me know what are the causes. Regards Code:CUBE XML CODE:<Schema name="Deposit_pra"> <Cube name="demo_p" cache="true" enabled="true"> <Table name="f_deposit"> </Table> <Dimension type="TimeDimension" foreignKey="RUNNING_DATE" name="REPORT DATE"> <Hierarchy name="REPORT DATE" hasAll="true" allMemberName="All REPORT DATE" primaryKey="EXTRACTION_DATE" primaryKeyTable="extraction_date"> <Join leftKey="extraction_date" rightKey="date"> <Table name="extraction_date"> </Table> <Table name="d_time"> </Table> </Join> <Level name="year" table="d_time" column="YEAR" type="Integer" uniqueMembers="false" levelType="TimeYears" hideMemberIf="Never"> </Level> <Level name="quarter" table="d_time" column="QUARTER" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> <Dimension type="StandardDimension" foreignKey="" name="depositesize" caption=""> <Hierarchy name="" hasAll="true" allMemberName="All depositesize" caption=""> <Table name="f_deposit"> </Table> <Level approxRowCount="" name="dep_size" table="f_deposit" column="AMOUNT_EXRATE_DESCR" nameColumn="" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="IfBlankName" formatter=""> </Level> </Hierarchy> </Dimension> <Dimension type="StandardDimension" foreignKey="PRODUCT_ID" name="PRODUCT" caption=""> <Hierarchy name="New Hierarchy 0" hasAll="true" primaryKey="PRODUCT_ID" primaryKeyTable="d_product" caption=""> <Table name="d_product" schema="" alias=""> </Table> <Level name="New Level 0" table="d_product" column="CRLINE_DESCR" nameColumn="" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="IfBlankName" formatter="" caption=""> </Level> </Hierarchy> </Dimension> <Measure name="Balance" column="AMOUNT" datatype="Numeric" formatString="#,##0.00" aggregator="sum" visible="true"> </Measure> <Measure name="pesoequiv" column="ACTUAL_AMOUNT" datatype="Numeric" formatString="#,##0.00" aggregator="sum" formatter="" caption="" visible="true"> </Measure> </Cube></Schema>

Hi, i created one cube with one dimension and measure.i deployed that cube successfully in jasper server PROFESSIONAL version.i got this error(when ever i try to EXPAND DIMENSION or example i click "+ ") "javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy " please let me what is the cause...... Note:-(the same cube and mdx query working well in community version),the problem only in PRO version? Regards Code:cube code:" <Schema name="New Schema1"> <Cube name="frp_dep_tsting" cache="true" enabled="true"> <Table name="f_deposit" schema="" alias=""> </Table> <Dimension type="StandardDimension" foreignKey="PRODUCT_ID" name="DEPOSIT TYPE" caption=""> <Hierarchy name="DEPOSIT TYPE" hasAll="true" allMemberName="All DEPOSIT TYPE" allMemberCaption="" primaryKey="PRODUCT_ID" primaryKeyTable="d_product" caption=""> <Table name="d_product" schema="" alias=""> </Table> <Level name="Level 1" table="d_product" column="CRLINE_DESCR" nameColumn="" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> <KeyExpression> <SQL dialect="mysql"> (case when `d_product`.`CRLINE_DESCR` ='DEMAND DEPOSIT' then '1.DEMAND DEPOSIT' when `d_product`.`CRLINE_DESCR`= 'SAVINGS DEPOSIT' then '2.SAVINGS DEPOSIT' when `d_product`.`CRLINE_DESCR`='TIME CERTIFICATES OF DEPOSIT' then '3.TIME CERTIFICATES OF DEPOSIT' else 0 end) </SQL> </KeyExpression> </Level> </Hierarchy> </Dimension> <Measure name="Balance" column="AMOUNT" datatype="Numeric" formatString="#,##0.00" aggregator="sum" visible="true"> </Measure> </Cube></Schema>"MDX Query:-"select NON EMPTY {[Measures].[balance]} ON COLUMNS, NON EMPTY {[DEPOSIT TYPE.DEPOSIT TYPE].[All DEPOSIT TYPE]} ON ROWSfrom [frp_dep_tsting]"ERROR IS:-"javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxyjavax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy at org.apache.commons.el.Logger.logError(Logger.java:484) at org.apache.commons.el.Logger.logError(Logger.java:588) at org.apache.commons.el.ArraySuffix.evaluate(ArraySuffix.java:318) at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145) at org.apache.commons.el.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:263) at org.apache.commons.el.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:190) at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:917) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_if_5(viewOlap_jsp.java:2556) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:408) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) 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.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:127) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:56) 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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:142) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:247) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1105) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:841) 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.doPost(FrameworkServlet.java:360) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) 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.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:141) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:281) 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.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:142) 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 com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilter(MTBasicProcessingFilter.java:182) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:178) 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:178) 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)"

Could u give,Any one replay to this post....... hi ,my mdx is like this " select NON EMPTY {[Measures].[balance]} ON COLUMNS, NON EMPTY {[depositesize].members} ON ROWS from [demo_p]" at compilation time i did't get any errors,but at run time i am getting these as errors,could u pls tell me cause......... Code: Post Edited by shivareddyk at 10/26/2009 03:58

Dear prof......., 1. can possible to calculate statistical functions like (Mean, Variance, Co-Variance, SD...Etc) through Jasper server community/Professional versions? 2. If possible, how we can calculate? Can u give to me any information regarding those things...... Thanks& Regards Shiva

hi Madhavi, could you tell me what is the cause of this error? "javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy" i am loaded cube into jasperserver with out any errors,i am trying to view i got that above error? let me know pls...... Regards shiva

Hi ........., could u send me that "jpivot.jar" file, i also got same issue...send ur file to this id shiva.reddy@hotmail.com " javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxyjavax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy at org.apache.commons.el.Logger.logError(Logger.java:484) at org.apache.commons.el.Logger.logError(Logger.java:588) at org.apache.commons.el.ArraySuffix.evaluate(ArraySuffix.java:318) at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145)"Regards

ANY ONE FIND OUT SOLUTION FOR THIS PROBLEM? pls let me know ur solutionshiva.reddy@hotmail.com Regards

hi i am trying to login jasperserver through this url"http://localhost:8080/jasperserver-pro/login.html but i got login credentials errors? some times url changes like this http://localhost:8080/jasperserver-pro/j_acegi_security_check could u let me know any onw cause of this problem...... Regards

how to solve this type of errors? i deploye a cube in jasperserver-pro3.5v,i tring to view that view ......i got this problem. " javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxyjavax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy at org.apache.commons.el.Logger.logError(Logger.java:484) at org.apache.commons.el.Logger.logError(Logger.java:588) at org.apache.commons.el.ArraySuffix.evaluate(ArraySuffix.java:318) at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145) at org.apache.commons.el.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:263) at org.apache.commons.el.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:190) at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:917) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_if_5(viewOlap_jsp.java:2556) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:408) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) 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"Could u let me know any one abt this issue!!!!!!!Regards Post Edited by shivareddyk at 08/27/2009 01:51

Dear.......,extremely sorry to u.... i need small informstion from u(carminez and jasper admin),how can i migrate my community to jasperprofessional 3.5v(Eval version),please let me no,i need ur help........ i think u,bcz ur working with j s pro3.5v Regards shiva

Dear professionals........, Q:- how to migrate from community version to professional 3.5v migration(Eval version)? i installed jasper professional version 3.5 ,with default server as Tomcat and MYSQL as existing mysql db from my pc(not bundel mysql db). note:my pc having all mysql backup data(schema database and jasperserver db form community version) Now i need to run same type of things(analysisviews and reports) in jasperprofessional version,how i can make it? please respond,if u have any document process please send me shiva.reddy@hotmail.com. ur help is appriciated.......

hi how to migrate community version to Jasperprofessional 3.5v, what are things need to takecare,could u explain bit.....? Regards