I am using the following mdx statement
with member [Measures].[NEPBQ] as 'CoalesceEmpty(([Measures].[PARENT], [Date].CurrentMember), ([Measures].[NEPBQ], [Date].CurrentMember.PrevMember))'
member [Measures].[PARENT QUANTITY] as '([Measures].[NEPBQ], ClosingPeriod([Date.Date].[view_date_dim.Day], [Date.Date].CurrentMember))'
select NON EMPTY {[Measures].[PARENT], [Measures].[NEPBQ], [Measures].[PARENT QUANTITY]} ON COLUMNS,
NON EMPTY Crossjoin(Hierarchize(Union(Union({[Project_Building.Project_Building].[All project_building]}, [Project_Building.Project_Building].[All project_building].Children), [Project_Building.Project_Building].[All project_building].[123-789].Children)), {([Date.Date].[All date], [QUANTITY.QUANTITY].[All quantity])}) ON ROWS
from [Quantities]
I need to find the last quantity specified at the day level. This mdx works fine in analysis services but when used in mondrain-pentaho-jpivot gives "Jpivot Error ....".
At the console i find the following listing
15:09:00,140 ERROR [RequestFilter] cause
javax.servlet.ServletException: javax.servlet.jsp.JspException: An error occurred while evaluating custom action attribute "test" with value "${query01.result.overflowOccured}": An error occurred while getting property "result" from an inst
ance of class com.tonbeller.jpivot.tags.OlapModelProxy (com.tonbeller.jpivot.ola
p.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal
error: Error while executing query [with member [Measures].[NEPBQ] as 'CoalesceE
mpty(([Measures].[PARENT], [Date].CurrentMember), ([Measures].[NEPBQ], [Date].Cu
rrentMember.PrevMember))'
member [Measures].[PARENT QUANTITY] as '([Measures].[NEPBQ], ClosingPeriod([Da
te.Date].[view_date_dim.Day], [Date.Date].CurrentMember))'
select NON EMPTY {[Measures].[PARENT], [Measures].[NEPBQ], [Measures].[PARENT QU
ANTITY]} ON COLUMNS,
NON EMPTY Crossjoin(Hierarchize(Union(Union({[Project_Building.Project_Buildin
g].[All project_building]}, [Project_Building.Project_Building].[All project_bui
lding].Children), [Project_Building.Project_Building].[All project_building].[12
3-789].Children)), {([Date.Date].[All date], [QUANTITY.QUANTITY].[All quantity])
}) ON ROWS
from [Quantities]
])
at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageC
ontextImpl.java:858)
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageCon
textImpl.java:791)
at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:1024)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
14)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(Re
questFilter.java:139)
at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(Reques
tSynchronizer.java:127)
at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.jav
a:263)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilte
r.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
yAssociationValve.java:175)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:432)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
e.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
kerThread.java:112)
at java.lang.Thread.run(Thread.java:534)