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.

I have a report that has about 30 columns that are date related statistics. I'd like to design a report that puts the first 15 columns on the first page and the next 15 on the second page and keeps the same date column (column 1) for reference. Is there a way to do this? Thanks

I've got a report that accepts a date parameter. if the parameter value is not provided, then the date should default to yesterday. I have set the default expression to the following new Date(System.currentTimeMillis() - 24 * 60 * 60 * 1000) This works well when i run in iReport, but when I deploy to Jasper server (3.5) and schedule the report to run it doesnt seem to work. At the parameter tab of the schedule process i put in no value. When the report runs, it runs with a null value for the parameter instead of firing the default expression. Am I missing something? Thanks

Nevermind ... right click cell and adjust padding and broders.

I'd like to have a gridline look for a report, but can't figure out how to accomplish it. I found this sample http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/samples/DataSourceReport.html that accomplished the look i'd like to get, but i can't figure out how to make it happen. When I open http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/samples/DataSourceReport.jrxml in iReport, i can see visually that the $F(name) field has what looks like a border on the left and bottom, but i don't see how to set this in iReport. Can someone provide direction/explain this to me? Thanks!

I’m building a report that has 5 parameters. Each of these parameters may or may not be used in a particular run of the report. The values of each parameter are a list of values separated by a comma. I’d like to build my report query based on whether or not the parameter values are non-empty. For example, I’d like to execute code (similar to below example) that checks the values of each of the parameters and then builds the relevant where clause (stored in a parameter call queryText). If accountListParamater is not empty then queryText = “account in (accountListParamater)” End … for all 5 parameters. How do I execute code like this to build the query text inside the jxmrl /jasper file and have it execute before the query is run? I’m not asking for the specific code, just where to put the code/how to execute it. I know I can use the default expression property on the queryText parameter to execute a single Java expression, but how do I execute a series of Java expressions that build the queryText. Thanks.

I'm very new to this and probably just missing some key concepts. I've built some cubes and some related aggregate tables. Performance is good and i've confirmed that i'm using the aggregrate table my monitoring database activity. However, when I togger to NON EMPTY on the rows, the performance is terrible and i can see that i'm hitting my fact tables. Is this behaviour expected? Is there something i can do to improve the performacne? thanks

Thanks for your help. Having that as on option on a future release would be valuable i think. Thanks for considering it.

I put a subreport in the summary band. I want the subreport to print on a new page, so I inserted a page break just before the subreport object. The subreport correctly prints on the next page, but that page doesn't have any page footers. My page footer does a Page x of y. All other pages have a page footer and they correctly count the number of pages in the report, including the summary page. I'm running version 3.5.0. Thanks for any help!