allenmvt.edu

I've created a cube for a table that has an order_number, building_name and operational_date. Operational_date can be null. I'm running JasperServer 5.5. The mdx and the cube definition are below. When I click on the "Order Count" measure (hover hint says this interaction is "Show Source Data") in the JasperSever OLAP result I dont see any rows for orders that have a null operation date even though they are correclty counted by the Order Count measure. I.e JasperSErver may correctly indicate that the order count value is 2, but when i mouse click on the 2, there are no rows displayed. When i remove the operational_date from the cube, things work correctly. Is there something i need to add to the operational_date dimension to correct this? Thanks for any help! <Cube name="orders" cache="true" enabled="true"> <Table name="MAC_ORDER_STATS_OPEN_V" schema="ATLAS" /> <Dimension type="StandardDimension" name="Building"> <Hierarchy hasAll="true"> <Level name="Queue" table="MAC_ORDER_STATS_OPEN_V" column="BUILDING_NAME" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" /> </Hierarchy> </Dimension> <Dimension type="StandardDimension" foreignKey="OPERATIONAL_DATE" name="Operational Date"> <Hierarchy hasAll="true" primaryKey="DAY_DATE"> <Table name="DAY_VIEW" schema="ATLAS" /> <Level name="Fiscal Year" column="FISCAL_YEAR" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" /> <Level name="Month" column="MONTH" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" ordinalColumn="DAY_DATE" /> <Level name="Day" column="DAY" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" ordinalColumn="DAY_DATE" /> </Hierarchy> </Dimension> <Measure name="Order Count" column="ORDER_NUMBER" aggregator="count" formatString="#,###" visible="true" /> </Cube> select {[measures].[order count]} on columns, NON EMPTY {([building].[all buildings])} on rows from [orders]

I'm getting the following on when i try to expand a parent-child hierachy. Error Messagejava.lang.ClassCastException: mondrian.rolap.SqlMemberSource$RolapParentChildMemberNoClosure cannot be cast to mondrian.rolap.RolapCalculatedMember Error Tracejava.lang.ClassCastException: mondrian.rolap.SqlMemberSource$RolapParentChildMemberNoClosure cannot be cast to mondrian.rolap.RolapCalculatedMember at mondrian.rolap.RolapCell.replaceTrivialCalcMember(RolapCell.java:231) at mondrian.rolap.RolapCell.getMembersForDrillThrough(RolapCell.java:214) at mondrian.rolap.RolapCell.canDrillThrough(RolapCell.java:146) at com.tonbeller.jpivot.mondrian.MondrianDrillThrough.canDrillThrough(MondrianDrillThrough.java:61) at com.tonbeller.jpivot.table.navi.DrillThroughUI.canDrillThrough(DrillThroughUI.java:275) at com.tonbeller.jpivot.table.navi.DrillThroughUI$DomDecorator.build(DrillThroughUI.java:156) at com.tonbeller.jpivot.table.CellBuilderDecorator.build(CellBuilderDecorator.java:31) at com.tonbeller.jpivot.excel.ExcelCellBuilderDecorator.build(ExcelCellBuilderDecorator.java:43) at com.tonbeller.jpivot.table.TableComponent.buildCells(TableComponent.java:685) at com.tonbeller.jpivot.table.TableComponent.buildRows2Dim(TableComponent.java:670) at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:359) at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:310) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:141) at org.apache.jsp.WEB_002dINF.jsp.modules.olap.viewOlap_jsp._jspx_meth_wcf_005frender_005f4(viewOlap_jsp.java:3802) at org.apache.jsp.WEB_002dINF.jsp.modules.olap.viewOlap_jsp._jspx_meth_c_005fif_005f12(viewOlap_jsp.java:3758) at org.apache.jsp.WEB_002dINF.jsp.modules.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:543) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) 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.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:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:236) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:257) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1183) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:902) 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.doPost(FrameworkServlet.java:511) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) 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.IPadSupportFilter.doFilter(IPadSupportFilter.java:77) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) 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 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 org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) 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:563) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:662) My cube is defined as <?xml version="1.0" encoding="UTF-8"?> <Schema name="t2"> <Cube name="t2" cache="true" enabled="true"> <Table name="EMP2" schema="ALLENM" /> <Dimension name="Employee" foreignKey="EMPLOYEE_ID"> <Hierarchy hasAll="true" primaryKey="EMPLOYEE_ID"> <Table name="EMP2" schema="ALLENM" /> <Level name="employee name" column="EMPLOYEE_ID" parentColumn="SUPERVISOR_ID" nullParentValue="0" uniqueMembers="true" nameColumn="EMPLOYEE_ID" type="String"/> </Hierarchy> </Dimension> <Measure name="Count" column="EMPLOYEE_ID" aggregator="count" visible="true" /> </Cube> </Schema> Table looks like this desc emp2 Name Null Type ------------- ---- ------------ SUPERVISOR_ID VARCHAR2(10) EMPLOYEE_ID VARCHAR2(10) FULL_NAME VARCHAR2(20) I originally had the id columns as numbers, but change them hoping to fix the cast errors. Thanks for any help!

I'm trying to write a parent child MDX query. I've created the employee and employee_closure table described in the Mondrian Technical guide. Then i create the following schema <?xml version="1.0" encoding="UTF-8"?> <Schema name="t2"> <Cube name="t2" cache="true" enabled="true"> <Table name="EMPLOYEE" schema="ALLENM" /> <Dimension name="Employee"> <Hierarchy hasAll="true"> <Table name="EMPLOYEE" schema="ALLENM" /> <Level name="employee" column="EMPLOYEE_ID" parentColumn="SUPERVISOR_ID" nullParentValue="0" type="Numeric" uniqueMembers="true" nameColumn="FULL_NAME" /> <Closure parentColumn="SUPERVISOR_ID" childColumn="EMPLOYEE_ID"> <Table name="EMPLOYEE_CLOSURE" /> </Closure> </Hierarchy> </Dimension> <Measure name="Count" column="EMPLOYEE_ID" aggregator="count" visible="true" /> </Cube> </Schema> Next i deployed the following MDX/OLAP view to a 4.2 JasperServer select {[MEASURES].[count]} ON COLUMNS, non empty {([employee].[all employees])} ON ROWS from [t2] When i run the query, i get the high level All Employees dimension and the correct count, but when i click on the + to expand the dimension nothing happens. I would think that it would expand to the next level of employee supervisor relationship. What am i missiing? Thanks for any help you can provide.

Hi, I'm trying to select dimension properties in an MDX query. I can get the level to display, but never the properties. Following is my example cube <Schema name="atlas"> <Cube name="test" cache="true" enabled="true"> <Table name="SVC" schema="ALLENM" /> <Dimension name="Service" foreignKey="SERVICE_CODE"> <Hierarchy hasAll="true" primaryKey="SERVICE_CODE"> <Table name="SERVICE_CODET" schema="ALLENM" /> <Level name="Description" uniqueMembers="TRUE" column="DESCRIPTION"> <Property name="rate" column="RATE" /> </Level> </Hierarchy> </Dimension> <Measure name="Service Count" column="SERVICE_CODE" aggregator="count" visible="true" /> </Cube> </Schema> And this is the mdx query I'm using. select {[measures].[sERVICE COUNT]} on columns, non empty {[service]} DIMENSION PROPERTIES [service].[rate] on rows from [test] When I deploy/run this in JasperServer, I correctly get the Description and the Measures, but no Rate column. Thanks for any help you can provide.

Hi ... I have a similiar problem to the one described at http://jasperforge.org/plugins/espforum/view.php?group_id=99&forumid=108&topicid=84324. My analysis views become stale unless I manually flush the cache via the UI. I've tried implementing the script described in the linked issue, but it doesnt really seem to flush the cache. Is there a step thats missing in the Java provided within the linked issue? I', running version 3.7. Thanks for any help.

Actually i think the onePagePerSheet is the relevant config in this situation per http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=46967, but it is correctly set to false and i still get pagination.

Hi, I've got a crosstab report that i want to export to excel from JasperReports. When i do this, the crosstab column headers repeat for each page. I'd like to prevent that from happening. I'm familiar with http://jasperreports.sourceforge.net/config.reference.html configuration to prevent headers and titles from repeating on an excel export, but i cant figure out how specicfically to prevent crostab column headers from exporting after the first page. Thanks for any help.

Hi, I have several crosstab reports that i have deployed to JasperServer 3.7.1 instance. When i export them to excel using the normal Excel export icons, i get pagebreaks and repeated crosstab headers. I'd like to avoid this. We configured the normal xls exclude parameters and config defined at http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=46967 a long time ago and that works great for everything except the crosstabs. Is there another step/config i need to take specifically for crosstabs? Thanks for your help.

Thanks

I deployed a schema file to JasperServer and lost the local copy. How can i get the schema file back from Jasperserver so that i can make changes to it using the workbench? Thanks for any help!

Thanks ... i'll give it a shot.

Is there a way to dynamically print headers for PDF but not for Excel? I'm assuming i would use a "pint when" expression, but i dont know what to evaluate to determine if it PDF or Excel. Thanks

Nevermind. I was using iReport 3.5.0 and its got a bug i guess. Right click on crosstab doesnt give you access to the crosstab data/runset. I upgraded iReport and it works now

I'm trying to pass a report parameter (pDate) to a dataset parameter (pDate2) in a crosstab, but i cant seem to figure out how to do it. I''m trying to use the following expression in the "Parameters Map Expression" of the crosstab $P{REPORT_PARAMETERS_MAP}.put("pDate2",$P{pDate}) Then i reference $P{pDate2} in the dataset query, but no luck. No errors, just no results. Am I on the right path? Is there somehting I'm missing? Thanks for any help!

Thanks ... Thats a good idea. Right now i changed focus and i'm approaching it as a crosstab. I think that may work well, but if not i'll fall back to your suggestion.