tag:blogger.com,1999:blog-1618421239231350212.post603198933236461750..comments2022-12-05T00:40:04.139-08:00Comments on Business Intelligence Blog: Mondrian + MySQL SetupFeris Thiahttp://www.blogger.com/profile/09347092787298962659noreply@blogger.comBlogger47125tag:blogger.com,1999:blog-1618421239231350212.post-44726349754998735642015-03-27T08:25:35.379-07:002015-03-27T08:25:35.379-07:00Hi - Is FoodMart a Pentaho proprietary database? C...Hi - Is FoodMart a Pentaho proprietary database? Can we use it to build visualization in any other tool?Richahttps://www.blogger.com/profile/03440846213309122115noreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-87196580451987419242015-03-12T03:37:45.177-07:002015-03-12T03:37:45.177-07:00I am getting this error when i click on jPivot Piv...I am getting this error when i click on jPivot Pivot table, could you please help me how to reslove this<br /><br />balachandraks@gmail.com<br /><br />JPivot had an error ...<br /><br />org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.wcf.utils.SoftException: javax.xml.transform.TransformerConfigurationException: javax.xml.transform.TransformerException: java.io.FileNotFoundException: C:\Program%20Files\Apache%20Software%20Foundation\Tomcat%208.0\webapps\mondrian\WEB-INF\jpivot\toolbar\htoolbar.xsl (The system cannot find the path specified)Balachandra Shttps://www.blogger.com/profile/13844026111371352864noreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-26929855219611677412014-08-11T03:22:06.932-07:002014-08-11T03:22:06.932-07:00Excellent blog. Could you please guide us on how t...Excellent blog. Could you please guide us on how to install mondrain 3.7 as well along with pre-requesties? FoodMart + MySQL. We tried the same steps but couldn't. Only older version of mondrian could be configured. <br />harihttps://www.blogger.com/profile/10533917194903818436noreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-48455703472432858952012-03-24T11:23:27.096-07:002012-03-24T11:23:27.096-07:00Hi,after doing all that, i'm getting this
JPiv...Hi,after doing all that, i'm getting this<br /><b>JPivot had an error ...<br /><br />org.apache.jasper.JasperException: javax.servlet.jsp.JspException: javax.servlet.jsp.JspException: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Unable to create envelope from given source:</b><br /><br />org.apache.jasper.JasperException: javax.servlet.jsp.JspException: javax.servlet.jsp.JspException: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Unable to create envelope from given source: <br /> at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:500)<br /> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:395)<br /> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)<br /> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br /> at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)<br /> at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:264)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)<br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)<br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br /> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<br /> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<br /> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)<br /> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)<br /> at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)<br /> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)<br /> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)<br /> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)<br /> at java.lang.Thread.run(Unknown Source)TuyetPhamhttps://www.blogger.com/profile/12367996643482599475noreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-34870019998344889762012-03-12T12:32:36.539-07:002012-03-12T12:32:36.539-07:00Thanks... very good this post...Thanks... very good this post...cristhianhttps://www.blogger.com/profile/01077589753523102545noreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-43553657665911348022011-12-12T08:47:32.354-08:002011-12-12T08:47:32.354-08:00how to get the load time on mondrian?how to get the load time on mondrian?masunohttps://www.blogger.com/profile/08923360334810317073noreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-36425061204061302062011-06-13T18:00:13.625-07:002011-06-13T18:00:13.625-07:00Could you please give steps for connecting PostGre...Could you please give steps for connecting PostGre SQL database in Mondrian.<br /><br />I've Schema file and database file.sunmoonhttps://www.blogger.com/profile/15711389714458533605noreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-29894997088250442762011-05-23T10:02:52.832-07:002011-05-23T10:02:52.832-07:00Hi Ankur,
It's still very generic to me. How ...Hi Ankur,<br /><br />It's still very generic to me. How do you design your schema ? Are you using Schema Workbench ? Can you execute MDX in the Schema Workbench ? If so.. post your schema here, will you ?<br /><br />Regards,<br /><br />FerisJust Another Bloggerhttps://www.blogger.com/profile/06816384987383854878noreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-28300808842081734352011-05-23T00:08:57.362-07:002011-05-23T00:08:57.362-07:00Hi Ferris,
I have setup mondrian and trying to ru...Hi Ferris,<br /><br />I have setup mondrian and trying to run it on my sales data. But it is throwing the following error. Can you please help me with this.<br /><br /><br />JPivot had an error ...<br /><br />org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspTagException: 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 instance of class com.tonbeller.jpivot.tags.OlapModelProxy (com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[Order Count]} ON COLUMNS, {([Status].[All Status], [State].[All States])} ON ROWS from [SalesCube] ])<br /><br />org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspTagException: 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 instance of class com.tonbeller.jpivot.tags.OlapModelProxy (com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[Order Count]} ON COLUMNS,<br /> {([Status].[All Status], [State].[All States])} ON ROWS<br />from [SalesCube]<br />])<br /> at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)<br /> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)Ankurnoreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-14261066921555405052010-12-12T20:58:45.642-08:002010-12-12T20:58:45.642-08:00Hi Feris Thia,
Is that possible to run it on PHP?...Hi Feris Thia,<br /><br />Is that possible to run it on PHP? Other than that, how can i integrate with open report/ jasper report? really appreciate if you could give me some guideline/info to do this.stevenjackalnoreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-34552960584443235602010-11-28T00:16:35.790-08:002010-11-28T00:16:35.790-08:00can u help me to resolve my problem??
if i click ...can u help me to resolve my problem??<br /><br />if i click link for jPivot, will showing <br />JPivot had an error ...<br /><br />org.apache.jasper.JasperException: javax.servlet.jsp.JspException: /WEB-INF/queries/mondrian.jsp(10,7) equal symbol expected<br /><br />org.apache.jasper.JasperException: javax.servlet.jsp.JspException: /WEB-INF/queries/mondrian.jsp(10,7) equal symbol expected<br /> at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)<br /> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)<br /> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)<br /> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br /> at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)<br /> at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)<br /> at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)<br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)<br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br /> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<br /> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<br /> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)<br /> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)<br /> at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)<br /> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)<br /> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)<br /> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)<br /> at java.lang.Thread.run(Thread.java:619)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-86480500120018003372010-09-24T04:26:08.241-07:002010-09-24T04:26:08.241-07:00i followed every steps to install mondrian and i c...i followed every steps to install mondrian and i copied mysql jar file too. but when i am running , following error comes.. please five some idea..<br /><br />JPivot had an error ...<br /><br />org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: Could not load Jdbc Driver com.mysql.jdbc.Driver<br />org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: Could not load Jdbc Driver com.mysql.jdbc.Driver<br /> at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)<br /> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)<br /> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)<br /> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)Unknownhttps://www.blogger.com/profile/14766491490906513114noreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-6572600971178524922010-08-22T19:31:38.183-07:002010-08-22T19:31:38.183-07:00Hi,
am using
tomcat 6...
mondrian 3..
Oracle,
I w...Hi,<br />am using<br />tomcat 6...<br />mondrian 3..<br />Oracle,<br /><br />I would like to display the output of all mdx queries in the same file<br /><br />When I click<br /> on this link {Various queries formatted using the Mondrian tag-library}, I got the following error<br />the others links are working <br />except also for xml/a test<br />----------------------------<br />HTTP Status 500 -<br /><br />type Exception report<br /><br />message<br /><br />description The server encountered an internal error () that prevented it from fulfilling this request.<br /><br />exception<br /><br />org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException<br /> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)<br /> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)<br /> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)<br /> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)<br /> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br />root cause<br /><br />javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException<br /> org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)<br /> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)<br /> org.apache.jsp.taglib_jsp._jspService(taglib_jsp.java:121)<br /> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)<br /> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br /> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)<br /> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)<br /> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)<br /> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br />root cause<br /><br />java.lang.NullPointerException<br /> mondrian.rolap.RolapConnection.execute(RolapConnection.java:642)<br /> mondrian.web.taglib.ResultCache.getResult(ResultCache.java:79)<br /> mondrian.web.taglib.ResultCache.getDOM(ResultCache.java:90)<br /> mondrian.web.taglib.TransformTag.doEndTag(TransformTag.java:58)<br /> org.apache.jsp.taglib_jsp._jspx_meth_mdx_005ftransform_005f0(taglib_jsp.java:225)<br /> org.apache.jsp.taglib_jsp._jspService(taglib_jsp.java:91)<br /> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)<br /> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br /> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)<br /> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)<br /> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)<br /> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br />note The full stack trace of the root cause is available in the Apache Tomcat/6.0.29 logs.<br />best<br />rimAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-22591320367573642762010-08-09T04:17:04.683-07:002010-08-09T04:17:04.683-07:00thanks, this is my first project using Mondrian.thanks, this is my first project using Mondrian.Domain Murahhttp://jagoster.comnoreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-24691690372630905952010-08-05T08:15:45.172-07:002010-08-05T08:15:45.172-07:00Hi Anonymous,
Currently I don't have any samp...Hi Anonymous,<br /><br />Currently I don't have any sample for Oracle.<br /><br />Our domains are SQL Server and MySQL. Sorry for that, we don't have enough proficieny in Oracle.<br /><br />Regards,<br /><br />FerisFeris Thiahttps://www.blogger.com/profile/05761000353335286188noreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-64530231539480327452010-07-29T05:57:59.196-07:002010-07-29T05:57:59.196-07:00hi
i want to use my own database created in oracl...hi<br /><br />i want to use my own database created in oracle.<br /><br />plz let me know the details steps.<br /><br />thanks<br />sumeetAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-32320553553593106522010-06-22T21:31:56.516-07:002010-06-22T21:31:56.516-07:00how to conect Mondrian with Oraclehow to conect Mondrian with OracleAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-3601170247909872892010-06-19T21:27:35.663-07:002010-06-19T21:27:35.663-07:00Many thanks to all of you who find this article us...Many thanks to all of you who find this article useful !<br /><br />Regards,<br /><br />FerisFeris Thiahttps://www.blogger.com/profile/05761000353335286188noreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-20419749932931449062010-05-10T00:34:43.985-07:002010-05-10T00:34:43.985-07:00Very useful, Thank you very much.Very useful, Thank you very much.山高人为峰(金峰)https://www.blogger.com/profile/09990993493584533504noreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-84226468098080736402010-01-18T18:15:51.357-08:002010-01-18T18:15:51.357-08:00Thanks for taking the time to document this proces...Thanks for taking the time to document this process. You've saved me a lot of time and your instructions were dead on. <br /><br />For folks having issues - I used the mysql query browser to build the Foodmart table. It may make things a bit easier.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-10106665603675954992009-09-16T06:15:10.752-07:002009-09-16T06:15:10.752-07:00Hi,
I found your blog useful. I have managed to ma...Hi,<br />I found your blog useful. I have managed to make connections to my own database, which is on MySQL. The problem i face now is related to "drill THROUGH".<br />I have not been able to find a solution. Each time I click on drillthrough i get the green arrow, but when i click on the green arrow, i get blank files. I am using an open source tool called OpenI. Do you have any idea what sort of settings or changes in query i need to make?<br /><br />thanks<br />anonymosAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-23406975589112868962009-09-14T00:12:59.738-07:002009-09-14T00:12:59.738-07:00hi all,
i am new to mondrian, while deploying th...hi all,<br /> i am new to mondrian, while deploying the mondrian on tomcat, i am getting the following error.<br /> JPivot had an error ...<br /><br />org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Can not find Default Member with name "[Time.Weekly].[All Time.Weeklys].[1997]" in Hierarchy "Time.Weekly"<br /><br />Can you please help me on thisUnknownhttps://www.blogger.com/profile/06595926580556587349noreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-85793804610660177292009-09-13T21:50:10.795-07:002009-09-13T21:50:10.795-07:00when i tried to extract the foodmart_mysql.tar.gz ...when i tried to extract the foodmart_mysql.tar.gz file, i am getting the file corrupted error.Please help me on this?Unknownhttps://www.blogger.com/profile/06595926580556587349noreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-44346464181814233212009-09-11T08:57:04.271-07:002009-09-11T08:57:04.271-07:00PLEASE ANSWER...
Is it possible to put another da...PLEASE ANSWER...<br /><br />Is it possible to put another database instead of FoodMart or is this just an example where you can try samo operations like drill,...?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1618421239231350212.post-48067305784743631912009-08-24T05:18:07.448-07:002009-08-24T05:18:07.448-07:00Mondrian uses "ISO-8859-1" encoding for ...Mondrian uses "ISO-8859-1" encoding for xmla responses. As such , you get such results even though there is utf-8 encoding in mysql.<br /><br />HOW TO CHANGE RESPONCE TO UTF-8MoRLOKnoreply@blogger.com