kumarsrs

Followed the following steps to retify the problem. Checked the query in JS workbench, once it is successful, Tried in ireport, checked whether for desired result. then tried in server. --- Thanks Kumar SRS

Corrected the MDX Query From SELECT [Measures].AllMembers ON COLUMNS, Hierarchize(([Dim_Curr].[All Dim_Currs]*[Dim_Name].[All Dim_Names])) ON ROWS FROM [sales] to SELECT {[Measures].Invoiced_Amount,[Measures].Qty_Ordered} ON COLUMNS, Hierarchize(([Dim_Curr].[All Dim_Currs] * [Dim_Name].[All Dim_Names])) ON ROWS FROM [sales] --- Thanks Kumar SRS Post Edited by kumarsrs at 07/30/2009 09:53

Hi kschultz I resolved this error by making change in the MDX query Following is the MDX query which gave the same error. SELECT [Measures].AllMembers ON COLUMNS, Hierarchize(([Dim_Curr].[All Dim_Currs]*[Dim_Name].[All Dim_Names])) ON ROWS FROM [sales] then i made a change in {[Measures].AllMembers} to the relavent measure name like {[Measures].Invoiced_Amount,[Measures].Qty_Ordered} that i had used Now the query will be as follows SELECT {[Measures].Invoiced_Amount,[Measures].Qty_Ordered} ON COLUMNS, Hierarchize(([Dim_Curr].[All Dim_Currs] * [Dim_Name].[All Dim_Names])) ON ROWS FROM [sales]

Ya, it is working fine, corrected the MDX query.

I also faced the same problem, when I logined as jasperadmin user. then check the role and permission, some of the permission seem to be missing, i added all the permission which had been listed. then i try save, it was successful.

I also got the same error when i use the MDX Query as SELECT [Measures].AllMembers ON COLUMNS, Hierarchize(([Dim_Curr].[All Dim_Currs].Children * [Dim_Name].[All Dim_Names].Children)) ON ROWS FROM [sales] then i changed the MDX Query as select {[Measures].[invoiced_Amount], [Measures].[Qty_Ordered]} ON COLUMNS, Hierarchize(([Dim_Curr].[All Dim_Currs].Children * [Dim_Name].[All Dim_Names].Children)) ON ROWS from [sales] I can view the analyis, but drill is not shown.

Hi, I can generate the report attached the analyis view(Not_showing_Drilldown.jpg). Attached my schema.xml (myschema.xml) Please let me know why drill down is not coming? Code:SELECT{[Measures].Invoiced_Amount,[Measures].Qty_Ordered} ON COLUMNS,Hierarchize(([Dim_Curr].[All Dim_Currs].Children * [Dim_Name].[All Dim_Names].Children)) ON ROWSFROM [sales]

Madan Was Drill down report is completed?. If yes please share the files used for preparation.

Hi, I am also facing the same problem, please let me know how you solved. Post Edited by kumarsrs at 07/24/2009 08:49

Sherman I am also getting the same error. In the workbench, i can view the result. MDX Query. SELECT [Measures].AllMembers ON COLUMNS, Hierarchize(([New Dimension 1].[All New Dimension 1s].Children * [New Dimension 3].[All New Dimension 3s].Children)) ON ROWS FROM [New Cube 0]; SELECT [Measures].AllMembers ON COLUMNS, Hierarchize([New Dimension 2].[All New Dimension 2s].Children) ON ROWS FROM [New Cube 0]; Attached the schema.xml Post Edited by kumarsrs at 07/24/2009 07:19

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) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) Attached the schema.xml, Please let know the reason for the above exeception. I had used JasperAnaalyis Schema Workbench for the creation of schema, when i try to execute the mdx query, i can get the output.

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) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) Attached the schema.xml, Please let know the reason for the above exeception. I had used JasperAnaalyis Schema Workbench for the creation of schema, when i try to execute the mdx query, i can get the output. Post Edited by kumarsrs at 07/24/2009 04:33

Created MDX Query using workbench, was generting the desired output, when i try to make use of the schema and the MDX queyr in the jasperserver, i am getting error "The following is not a valid MDX Query: Internal error: Virtual file is not readable"

Hi, I am new to analysis(creation of schema) , my requirement is to have 3 breakup Name Country Currency Amt I had created a schema, with 3 dimension currency,country and name, when i try to execute in Mondrian Query, i can find breakup for country and currency and name which is seperated. Code:<Schema name="Accreceivable"> <Cube name="New Cube 0" cache="true" enabled="true"> <Table name="accdetail"> </Table> <Dimension type="StandardDimension" foreignKey="Customer" name="New Dimension 1"> <Hierarchy hasAll="true" primaryKey="Customer"> <Table name="accmast"> </Table> <Level name="New Level 0" column="Customer_Currency" nameColumn="Customer_Currency" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> <Dimension type="StandardDimension" foreignKey="Customer" name="New Dimension 2"> <Hierarchy hasAll="true" primaryKey="Customer"> <Table name="accmast" alias=""> </Table> <Level name="New Level 0" column="Country" nameColumn="Country" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> <Dimension type="StandardDimension" foreignKey="Customer" name="New Dimension 3"> <Hierarchy name="" hasAll="true" primaryKey="Customer"> <Table name="accmast" alias=""> </Table> <Level name="New Level 0" column="Name" nameColumn="Name" uniqueMembers="false"> </Level> </Hierarchy> </Dimension> <Measure name="Ordered Amount" column="Ordered_Amount" datatype="Numeric" formatString="##,###.00" aggregator="sum" visible="true"> </Measure> </Cube></Schema>

Create OLAP Schema and obtained the desired result, SELECT [Measures].AllMembers ON COLUMNS, Hierarchize([New Dimension 0].[New Level 0].Members) ON ROWS FROM [cube]; when i try to use the same in jasperserver, i am getting error as "The following is not a valid MDX Query: Internal error: Virtual file is not readable: repo:/analysis/views/ttt" Attached the screen shot. Please let me know, why i am getting the above error. Post Edited by kumarsrs at 07/23/2009 10:46

JasperAnalysis-Workbench-3.5.4.zip Download URL http://jasperforge.org/plugins/esp_frs/?group_id=112

These drill down comes under analysis for that we need OLAP Schema, manually creating is not a easy stuff, for that I had had download this workbench. Once it is successful , we can move the schema and the query to jasperserver. Post Edited by kumarsrs at 07/23/2009 10:52

Downloaded Workbench working on OLAP Schema prepartion. Post Edited by kumarsrs at 07/23/2009 08:46

Sure....

jasperreports-3.5.2.jar http://sourceforge.net/projects/jasperreports/files/ iReport-nb-3.5.2-windows-installer.exe http://sourceforge.net/projects/ireport/files/

I had created jrxml to generate a output as attachment (drilldown.JPG) Please let me now how to generate a drill down report, i had provided the hyperlink Anchor Name Expression as $F{Name} Bookmark level as 0 Hyperlink target as self Hyperlink type as Localpage Link Parameter as Parameter name Expression Name $F{Name}

Please find the URL http://sourceforge.net/projects/ireport/files/

When i try to deploy in the server, i am getting The selected Jrxml could not be parsed, as a error message. I am using the following Ireport - 3.5.2 Server - 3.5.0 Attached the jrxml file Post Edited by kumarsrs at 07/21/2009 15:34

Right click the field which needs to hyperlink, add a parameter in the "link parameter" tab call it "_report" then give the jasperserver link to the report. Please run in Jasperserver. Post Edited by kumarsrs at 07/21/2009 12:58

Downloaded JR 3.5.2 found the List element, i tried to use the same in the ireport to obtain as mentioned below A A1 A2 A3 B B1 B2 C I am getting as follows A null null null B null null C Attached the jrml file.