MOVED:Error while creating MDX query in jasperworkbench

[nseetha]

I am using JasperAnalysis-Workbench-3.5.4 version.I have created one cube using this workbench.By clicking the MDX icon,the generated MDX query as follows

   SELECT
[Measures].AllMembers ON COLUMNS,
Hierarchize(([Department Dimension .All departments].[All departments].Children * [subdivision Dimension .All Subdivisions].[All Subdivisions].Children)) ON ROWS
FROM [fcrjasper];

SELECT
[Measures].AllMembers ON COLUMNS,
Hierarchize(([Year Dimension.All years].[All years].Children * [Team Dimension.All Teams].[All Teams].Children)) ON ROWS
FROM [fcrjasper];

SELECT
[Measures].AllMembers ON COLUMNS,
Hierarchize(([Date Dimension .All Dates].[All Dates].Children * [Month Dimension.All months].[All months].Children)) ON ROWS
FROM [fcrjasper];
 
In my cube,I used three dimensions,I am getting three different MDX queries. Is there any way for me to get single MDX query with all these combination as in  Pentaho Anaysis view? like as below

select NON EMPTY {[Measures].[budget]} ON COLUMNS,
  NON EMPTY {([subdivision Dimension.All subdivisions].[All subdivisions], [Department Dimension.All Departments].[All Departments], [Team Dimension.All Teams].[All Teams], [Year Dimension.All years].[All years], [Month Dimension.All months].[All months], [Date Dimension.All Dates].[All Dates])} ON ROWS
from [fcr_new]

Problem faced:

When I am using Japer Server 3.5.0 version and while creating the jasper analysis view using mondrian connection , If I am using the MDX query generated by jasper schema work bench ,follwing error is coming

javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy

javax.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) 

 

 

 

Please provide solution to this problem.

Post Edited by nseetha at 09/16/2009 04:26

Post Edited by nseetha at 09/16/2009 04:28