suppachartt

Wow, Thank you Sherman, That will help me a lot

Thank you, will try that.

Hi All, Is there any SQL log file? All I see is the one in ----> \Tomcat 6.0\webapps\jasperserver\WEB-INF\logs And it doesn't tell me what SQL mondrian generated during runtime. Thank you, Suppachart

Hi Sherman, Thank you for your reply, Sherman. Yes, our data is pre-aggregated straight out of Oracle OLAP engine. In the fact table has the summary top level for each dimension along with all the child level data, we have several dimensions. The fact table size is massive. In the fact table has PRODUCT column which contains product_id. We use this column to join with dimension PRODUCT_DIMVIEW table using PRODUCT as a key. The problem is when I used the schema like the one you suggested, the mondrian will roll-up all the data from P01 to P86 including PT in the fact table which is not right as PT is the summarize level of P01 to P86, in other word, the figure I end-up with is double counting. Cheers, Suppachart Post Edited by suppachartt at 08/05/2009 00:41

Hi all, I have data in PRODUCT_DIMVIEW table that look like this, PRODUCT PRODUCT_LEVEL PRODUCT_LV1_DESC PRODUCT_LV2_DESC PT 1 Total Products (null) P01 2 Total Products Product 1 P02 2 Total Products Product 2 Here is my dimension schema, <Dimension type="StandardDimension" foreignKey="PRODUCT" name="Product"> <Hierarchy hasAll="true" primaryKey="PRODUCT"> <Table name="PRODUCT_DIMVIEW" schema="ESADMIN"></Table> <Level name="lv1" column="PRODUCT" type="String" uniqueMembers="true"></Level> <Level name="lv2" column="PRODUCT" type="String" uniqueMembers="false"></Level> </Hierarchy> </Dimension> How can I tell mondrian that in lv1 Level, I want just only product_id = PT to show up and lv2 Level has only 'P01' and 'P02' data? I can write SQL to select data by level. How can I do this in this schema file? Cheers, Suppachart Post Edited by suppachartt at 08/03/2009 08:21

Hi Kristen, Thanks for your reply. Here is my environment: OS: Windows Server 2003 Web Server: Tomcat 6.0 RDBMS: Oracle 10g BI: Jasper BI 3.5.1 Regards, Suppachartt

Hi All, I tried to drill-through my data. But I got this error. Cheers, Suppachartt Code:java.lang.NegativeArraySizeException at com.tonbeller.jpivot.mondrian.MondrianDrillThroughTableModel.getRow(MondrianDrillThroughTableModel.java:243) at com.tonbeller.wcf.table.TableModelDecorator.getRow(TableModelDecorator.java:59) at com.tonbeller.wcf.table.SortedTableModel.getRow(SortedTableModel.java:50) at com.tonbeller.wcf.table.TableModelDecorator.getRow(TableModelDecorator.java:59) at com.tonbeller.wcf.table.PagedTableModel.getRow(PagedTableModel.java:47) at com.tonbeller.wcf.table.TableComponent.renderBody(TableComponent.java:468) at com.tonbeller.wcf.table.TableComponent.render(TableComponent.java:332) at com.tonbeller.wcf.component.NestableComponentSupport.render(NestableComponentSupport.java:39) at com.tonbeller.wcf.table.EditableTableComponent.render(EditableTableComponent.java:135) at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:141) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_wcf_005frender_005f7(viewOlap_jsp.java:3574) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_005fif_005f14(viewOlap_jsp.java:3529) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_005fotherwise_005f0(viewOlap_jsp.java:3497) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_005fchoose_005f0(viewOlap_jsp.java:3377) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_005fif_005f13(viewOlap_jsp.java:3343) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:482) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 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:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) 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.doGet(FrameworkServlet.java:350) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 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: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:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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: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:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:619)

Hi All, My company uses Oracle 10g and they store data using MOLAP engine. Now in order to use JasperAnalysis, they created a view to their data and I assume that this is not the best way to do it. They claimed that this view is their fact table and aggregate table. What should I do as I can't tell Mondrian that this view is aggregate table due to the fact that this view doesn't have a fact count column. How can I get around this problem?

Hi All, I have a VIEW that was generated from OLAP dimensional database. Generally speaking, I don't have fact table. How can I work with mondrian then? Can I treat this VIEW as a fact table. In this case I need to generate Aggregate table out of this VIEW? Cheers, Suppachart Code:CREATE OR REPLACE FORCE VIEW "ESADMIN"."FR_CUBEVIEW" ("TIME", "PRODUCT", "GL_ACCOUNT", "CENTRE", "ENTITY", "CUSTOMER", "PROJECT", "SPARE", "CURRENCY", "SCENARIO", "ACTYTD_VS_LYR_FY", "ACT_FULLYR", "ACT_LY_VS_ACT2", "ACT_LY_VS_ACT2_FULLYR", "ACT_LY_VS_ACT2_YTD", "ACT_VS_ACT2", "ACT_VS_ACT2_FULLYR", "ACT_VS_ACT2_YTD", "ACT_VS_LASTYR", "ACT_VS_LASTYR_PCT", "ACT_VS_LASTYR_YTD_PCT", "ACT_VS_LYR_YTD", "ACT_VS_PREV_MTH", "ACT_VS_PREV_QTR_QTD", "ACT_VS_PREV_QTR_QTD_PCT", "ACT_VS_PRMTH_YTD", "BUD_FULLYR", "BUD_VS_ACT2", "BUD_VS_ACT2_FULLYR", "BUD_VS_ACT2_YTD", "BUD_VS_ACT_CURR", "BUD_VS_ACT_CURR_PCT", "BUD_VS_ACT_FULLYR", "BUD_VS_ACT_QTD", "BUD_VS_ACT_QTD_PCT", "BUD_VS_ACT_YTD", "BUD_VS_ACT_YTD_PCT", "BUD_VS_LASTYR", "BUD_VS_LYR_YTD", "BUD_VS_PREV_MTH", "BUD_VS_PREV_QTR_QTD", "BUD_VS_PREV_QTR_QTD_PCT", "BUD_VS_PRMTH_YTD", "CURR_ACT", "CURR_ACT_QTD", "CURR_ACT_YTD", "CURR_BUD", "CURR_BUD_QTD", "CURR_BUD_YTD", "CURR_FCAST", "CURR_FCAST2", "CURR_FCAST2_QTD", "CURR_FCAST2_YTD", "CURR_FCAST_QTD", "CURR_FCAST_YTD", "EXTRAPOLATION", "FCAST2_FULLYR", "FCAST2_VS_ACT2", "FCAST2_VS_ACT2_YTD", "FCAST2_VS_ACT_CURR", "FCAST2_VS_ACT_CURR_PCT", "FCAST2_VS_ACT_FULLYR", "FCAST2_VS_ACT_QTD", "FCAST2_VS_ACT_QTD_PCT", "FCAST2_VS_ACT_YTD", "FCAST2_VS_ACT_YTD_PCT", "FCAST2_VS_BUD_CURR", "FCAST2_VS_BUD_FULLYR", "FCAST2_VS_BUD_YTD", "FCAST2_VS_FCAST_CURR", "FCAST2_VS_FCAST_FULLYR", "FCAST2_VS_FCAST_YTD", "FCAST2_VS_LASTYR", "FCAST2_VS_LYR_YTD", "FCAST2_VS_LY_ACT2_FULLYR", "FCAST2_VS_LY_ACT_FULLYR", "FCAST2_VS_LY_ACT_FULLYR_PCT", "FCAST2_VS_LY_BUD", "FCAST2_VS_LY_BUD_FULLYR", "FCAST2_VS_LY_BUD_YTD", "FCAST2_VS_LY_FCAST_FULLYR", "FCAST2_VS_PREV_MTH", "FCAST2_VS_PREV_QTR_QTD", "FCAST2_VS_PREV_QTR_QTD_PCT", "FCAST2_VS_PRMTH_YTD", "FCAST_FULLYR", "FCAST_VS_ACT2", "FCAST_VS_ACT2_FULLYR", "FCAST_VS_ACT2_YTD", "FCAST_VS_ACT_CURR", "FCAST_VS_ACT_CURR_PCT", "FCAST_VS_ACT_FULLYR", "FCAST_VS_ACT_QTD", "FCAST_VS_ACT_QTD_PCT", "FCAST_VS_ACT_YTD", "FCAST_VS_ACT_YTD_PCT", "FCAST_VS_BUD_CURR", "FCAST_VS_BUD_FULLYR", "FCAST_VS_BUD_YTD", "FCAST_VS_FCAST2_FULLYR", "FCAST_VS_LASTYR", "FCAST_VS_LYR_YTD", "FCAST_VS_LY_ACT_FULLYR", "FCAST_VS_LY_ACT_FULLYR_PCT", "FCAST_VS_PREV_MTH", "FCAST_VS_PREV_QTR_QTD", "FCAST_VS_PREV_QTR_QTD_PCT", "FCAST_VS_PRMTH_YTD", "LASTYR_ACT", "LASTYR_ACT2", "LASTYR_ACT2_FULLYR", "LASTYR_ACT2_YTD", "LASTYR_ACT_FULLYR", "LASTYR_ACT_QTD", "LASTYR_ACT_YTD", "LASTYR_BUD", "LASTYR_BUD_FULLYR", "LASTYR_BUD_QTD", "LASTYR_BUD_YTD", "LASTYR_FCAST", "LASTYR_FCAST2", "LASTYR_FCAST2_QTD", "LASTYR_FCAST2_YTD", "LASTYR_FCAST_FULLYR", "LASTYR_FCAST_QTD", "LASTYR_FCAST_YTD", "PREV_MTH_ACT", "PREV_MTH_ACT2", "PREV_MTH_ACT_YTD", "PREV_MTH_BUD", "PREV_MTH_BUD_YTD", "PREV_MTH_FCAST", "PREV_MTH_FCAST2", "PREV_MTH_FCAST2_YTD", "PREV_MTH_FCAST_YTD", "PREV_QTR_ACT", "PREV_QTR_BUD", "PREV_QTR_FCAST", "PREV_QTR_FCAST2", "OLAP_CALC") AS SELECT "TIME","PRODUCT","GL_ACCOUNT","CENTRE","ENTITY","CUSTOMER","PROJECT","SPARE","CURRENCY","SCENARIO","ACTYTD_VS_LYR_FY","ACT_FULLYR","ACT_LY_VS_ACT2","ACT_LY_VS_ACT2_FULLYR","ACT_LY_VS_ACT2_YTD","ACT_VS_ACT2","ACT_VS_ACT2_FULLYR","ACT_VS_ACT2_YTD","ACT_VS_LASTYR","ACT_VS_LASTYR_PCT","ACT_VS_LASTYR_YTD_PCT","ACT_VS_LYR_YTD","ACT_VS_PREV_MTH","ACT_VS_PREV_QTR_QTD","ACT_VS_PREV_QTR_QTD_PCT","ACT_VS_PRMTH_YTD","BUD_FULLYR","BUD_VS_ACT2","BUD_VS_ACT2_FULLYR","BUD_VS_ACT2_YTD","BUD_VS_ACT_CURR","BUD_VS_ACT_CURR_PCT","BUD_VS_ACT_FULLYR","BUD_VS_ACT_QTD","BUD_VS_ACT_QTD_PCT","BUD_VS_ACT_YTD","BUD_VS_ACT_YTD_PCT","BUD_VS_LASTYR","BUD_VS_LYR_YTD","BUD_VS_PREV_MTH","BUD_VS_PREV_QTR_QTD","BUD_VS_PREV_QTR_QTD_PCT","BUD_VS_PRMTH_YTD","CURR_ACT","CURR_ACT_QTD","CURR_ACT_YTD","CURR_BUD","CURR_BUD_QTD","CURR_BUD_YTD","CURR_FCAST","CURR_FCAST2","CURR_FCAST2_QTD","CURR_FCAST2_YTD","CURR_FCAST_QTD","CURR_FCAST_YTD","EXTRAPOLATION","FCAST2_FULLYR","FCAST2_VS_ACT2","FCAST2_VS_ACT2_YTD","FCAST2_VS_ACT_CURR","FCAST2_VS_ACT_CURR_PCT","FCAST2_VS_ACT_FULLYR","FCAST2_VS_ACT_QTD","FCAST2_VS_ACT_QTD_PCT","FCAST2_VS_ACT_YTD","FCAST2_VS_ACT_YTD_PCT","FCAST2_VS_BUD_CURR","FCAST2_VS_BUD_FULLYR","FCAST2_VS_BUD_YTD","FCAST2_VS_FCAST_CURR","FCAST2_VS_FCAST_FULLYR","FCAST2_VS_FCAST_YTD","FCAST2_VS_LASTYR","FCAST2_VS_LYR_YTD","FCAST2_VS_LY_ACT2_FULLYR","FCAST2_VS_LY_ACT_FULLYR","FCAST2_VS_LY_ACT_FULLYR_PCT","FCAST2_VS_LY_BUD","FCAST2_VS_LY_BUD_FULLYR","FCAST2_VS_LY_BUD_YTD","FCAST2_VS_LY_FCAST_FULLYR","FCAST2_VS_PREV_MTH","FCAST2_VS_PREV_QTR_QTD","FCAST2_VS_PREV_QTR_QTD_PCT","FCAST2_VS_PRMTH_YTD","FCAST_FULLYR","FCAST_VS_ACT2","FCAST_VS_ACT2_FULLYR","FCAST_VS_ACT2_YTD","FCAST_VS_ACT_CURR","FCAST_VS_ACT_CURR_PCT","FCAST_VS_ACT_FULLYR","FCAST_VS_ACT_QTD","FCAST_VS_ACT_QTD_PCT","FCAST_VS_ACT_YTD","FCAST_VS_ACT_YTD_PCT","FCAST_VS_BUD_CURR","FCAST_VS_BUD_FULLYR","FCAST_VS_BUD_YTD","FCAST_VS_FCAST2_FULLYR","FCAST_VS_LASTYR","FCAST_VS_LYR_YTD","FCAST_VS_LY_ACT_FULLYR","FCAST_VS_LY_ACT_FULLYR_PCT","FCAST_VS_PREV_MTH","FCAST_VS_PREV_QTR_QTD","FCAST_VS_PREV_QTR_QTD_PCT","FCAST_VS_PRMTH_YTD","LASTYR_ACT","LASTYR_ACT2","LASTYR_ACT2_FULLYR","LASTYR_ACT2_YTD","LASTYR_ACT_FULLYR","LASTYR_ACT_QTD","LASTYR_ACT_YTD","LASTYR_BUD","LASTYR_BUD_FULLYR","LASTYR_BUD_QTD","LASTYR_BUD_YTD","LASTYR_FCAST","LASTYR_FCAST2","LASTYR_FCAST2_QTD","LASTYR_FCAST2_YTD","LASTYR_FCAST_FULLYR","LASTYR_FCAST_QTD","LASTYR_FCAST_YTD","PREV_MTH_ACT","PREV_MTH_ACT2","PREV_MTH_ACT_YTD","PREV_MTH_BUD","PREV_MTH_BUD_YTD","PREV_MTH_FCAST","PREV_MTH_FCAST2","PREV_MTH_FCAST2_YTD","PREV_MTH_FCAST_YTD","PREV_QTR_ACT","PREV_QTR_BUD","PREV_QTR_FCAST","PREV_QTR_FCAST2","OLAP_CALC" FROM table(OLAP_TABLE ('ESADMIN.DATA_ESSATTO duration query','','','&(FR_CUBE_LIMITMAP)'))MODEL DIMENSION BY ( TIME, PRODUCT, GL_ACCOUNT, CENTRE, ENTITY, CUSTOMER, PROJECT, SPARE, CURRENCY, SCENARIO)MEASURES ( ACTYTD_VS_LYR_FY, ACT_FULLYR, ACT_LY_VS_ACT2, ACT_LY_VS_ACT2_FULLYR, ACT_LY_VS_ACT2_YTD, ACT_VS_ACT2, ACT_VS_ACT2_FULLYR, ACT_VS_ACT2_YTD, ACT_VS_LASTYR, ACT_VS_LASTYR_PCT, ACT_VS_LASTYR_YTD_PCT, ACT_VS_LYR_YTD, ACT_VS_PREV_MTH, ACT_VS_PREV_QTR_QTD, ACT_VS_PREV_QTR_QTD_PCT, ACT_VS_PRMTH_YTD, BUD_FULLYR, BUD_VS_ACT2, BUD_VS_ACT2_FULLYR, BUD_VS_ACT2_YTD, BUD_VS_ACT_CURR, BUD_VS_ACT_CURR_PCT, BUD_VS_ACT_FULLYR, BUD_VS_ACT_QTD, BUD_VS_ACT_QTD_PCT, BUD_VS_ACT_YTD, BUD_VS_ACT_YTD_PCT, BUD_VS_LASTYR, BUD_VS_LYR_YTD, BUD_VS_PREV_MTH, BUD_VS_PREV_QTR_QTD, BUD_VS_PREV_QTR_QTD_PCT, BUD_VS_PRMTH_YTD, CURR_ACT, CURR_ACT_QTD, CURR_ACT_YTD, CURR_BUD, CURR_BUD_QTD, CURR_BUD_YTD, CURR_FCAST, CURR_FCAST2, CURR_FCAST2_QTD, CURR_FCAST2_YTD, CURR_FCAST_QTD, CURR_FCAST_YTD, EXTRAPOLATION, FCAST2_FULLYR, FCAST2_VS_ACT2, FCAST2_VS_ACT2_YTD, FCAST2_VS_ACT_CURR, FCAST2_VS_ACT_CURR_PCT, FCAST2_VS_ACT_FULLYR, FCAST2_VS_ACT_QTD, FCAST2_VS_ACT_QTD_PCT, FCAST2_VS_ACT_YTD, FCAST2_VS_ACT_YTD_PCT, FCAST2_VS_BUD_CURR, FCAST2_VS_BUD_FULLYR, FCAST2_VS_BUD_YTD, FCAST2_VS_FCAST_CURR, FCAST2_VS_FCAST_FULLYR, FCAST2_VS_FCAST_YTD, FCAST2_VS_LASTYR, FCAST2_VS_LYR_YTD, FCAST2_VS_LY_ACT2_FULLYR, FCAST2_VS_LY_ACT_FULLYR, FCAST2_VS_LY_ACT_FULLYR_PCT, FCAST2_VS_LY_BUD, FCAST2_VS_LY_BUD_FULLYR, FCAST2_VS_LY_BUD_YTD, FCAST2_VS_LY_FCAST_FULLYR, FCAST2_VS_PREV_MTH, FCAST2_VS_PREV_QTR_QTD, FCAST2_VS_PREV_QTR_QTD_PCT, FCAST2_VS_PRMTH_YTD, FCAST_FULLYR, FCAST_VS_ACT2, FCAST_VS_ACT2_FULLYR, FCAST_VS_ACT2_YTD, FCAST_VS_ACT_CURR, FCAST_VS_ACT_CURR_PCT, FCAST_VS_ACT_FULLYR, FCAST_VS_ACT_QTD, FCAST_VS_ACT_QTD_PCT, FCAST_VS_ACT_YTD, FCAST_VS_ACT_YTD_PCT, FCAST_VS_BUD_CURR, FCAST_VS_BUD_FULLYR, FCAST_VS_BUD_YTD, FCAST_VS_FCAST2_FULLYR, FCAST_VS_LASTYR, FCAST_VS_LYR_YTD, FCAST_VS_LY_ACT_FULLYR, FCAST_VS_LY_ACT_FULLYR_PCT, FCAST_VS_PREV_MTH, FCAST_VS_PREV_QTR_QTD, FCAST_VS_PREV_QTR_QTD_PCT, FCAST_VS_PRMTH_YTD, LASTYR_ACT, LASTYR_ACT2, LASTYR_ACT2_FULLYR, LASTYR_ACT2_YTD, LASTYR_ACT_FULLYR, LASTYR_ACT_QTD, LASTYR_ACT_YTD, LASTYR_BUD, LASTYR_BUD_FULLYR, LASTYR_BUD_QTD, LASTYR_BUD_YTD, LASTYR_FCAST, LASTYR_FCAST2, LASTYR_FCAST2_QTD, LASTYR_FCAST2_YTD, LASTYR_FCAST_FULLYR, LASTYR_FCAST_QTD, LASTYR_FCAST_YTD, PREV_MTH_ACT, PREV_MTH_ACT2, PREV_MTH_ACT_YTD, PREV_MTH_BUD, PREV_MTH_BUD_YTD, PREV_MTH_FCAST, PREV_MTH_FCAST2, PREV_MTH_FCAST2_YTD, PREV_MTH_FCAST_YTD, PREV_QTR_ACT, PREV_QTR_BUD, PREV_QTR_FCAST, PREV_QTR_FCAST2, OLAP_CALC) RULES UPDATE SEQUENTIAL ORDER();

But in my case the Aggregate table is fact table.

Can not start JasperServer. Please see log file. Code:13:16:09,843 ERROR ContextLoader,Thread-1:205 - Context initialization failedorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'maintenanceScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-logging.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerException: Based on configured schedule, the given trigger will never fire.Caused by: org.quartz.SchedulerException: Based on configured schedule, the given trigger will never fire. at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:649) at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:249) at org.springframework.scheduling.quartz.SchedulerFactoryBean.addTriggerToScheduler(SchedulerFactoryBean.java:846) at org.springframework.scheduling.quartz.SchedulerFactoryBean.registerJobsAndTriggers(SchedulerFactoryBean.java:776) at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:599) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:270) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:987) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:909) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:495) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

Hi everyone, I have a view table that has already been aggregated (AGG_CUBEVIEW). Is there is a way that I can tread this table as a fact table and bypassing that aggregator attribute in <Measure>? Regards, Suppachart Code:<Schema name="ABC"> <Cube name="Cubes"> <Table name="AGG_CUBEVIEW" /> ... ... ... <Measure name="Agg Sum" column="AGG_SUM" aggregator="sum" /> </Cube></Schema>