kumarsrs
Members-
Posts
41 -
Joined
-
Last visited
kumarsrs's Achievements
-
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
-
getting error trying to execute analytical view
kumarsrs replied to alexeyvasilyev3's topic in Products
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
-
getting error trying to execute analytical view
kumarsrs replied to alexeyvasilyev3's topic in Products
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