Comments on Business Intelligence Blog: Mondrian + MySQL Setup

how to get the load time on mondrian?

2011-12-12T08:47:32.354-08:00

how to get the load time on mondrian?

Could you please give steps for connecting PostGre...

2011-06-13T18:00:13.625-07:00

Could you please give steps for connecting PostGre SQL database in Mondrian.

I've Schema file and database file.

Hi Ankur, It's still very generic to me. How ...

2011-05-23T10:02:52.832-07:00

Hi Ankur,

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 ?

Regards,

Feris

Hi Ferris, I have setup mondrian and trying to ru...

2011-05-23T00:08:57.362-07:00

Hi Ferris,

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.

JPivot had an error ...

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] ])

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]
])
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)

Hi Feris Thia, Is that possible to run it on PHP?...

2010-12-12T20:58:45.642-08:00

Hi Feris Thia,

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.

can u help me to resolve my problem?? if i click ...

2010-11-28T00:16:35.790-08:00

can u help me to resolve my problem??

if i click link for jPivot, will showing
JPivot had an error ...

org.apache.jasper.JasperException: javax.servlet.jsp.JspException: /WEB-INF/queries/mondrian.jsp(10,7) equal symbol expected

org.apache.jasper.JasperException: javax.servlet.jsp.JspException: /WEB-INF/queries/mondrian.jsp(10,7) equal symbol expected
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)

i followed every steps to install mondrian and i c...

2010-09-24T04:26:08.241-07:00

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

JPivot had an error ...

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
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
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

Hi, am using tomcat 6... mondrian 3.. Oracle, I w...

2010-08-22T19:31:38.183-07:00

Hi,
am using
tomcat 6...
mondrian 3..
Oracle,

I would like to display the output of all mdx queries in the same file

When I click
on this link {Various queries formatted using the Mondrian tag-library}, I got the following error
the others links are working
except also for xml/a test
----------------------------
HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause

javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.taglib_jsp._jspService(taglib_jsp.java:121)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause

java.lang.NullPointerException
mondrian.rolap.RolapConnection.execute(RolapConnection.java:642)
mondrian.web.taglib.ResultCache.getResult(ResultCache.java:79)
mondrian.web.taglib.ResultCache.getDOM(ResultCache.java:90)
mondrian.web.taglib.TransformTag.doEndTag(TransformTag.java:58)
org.apache.jsp.taglib_jsp._jspx_meth_mdx_005ftransform_005f0(taglib_jsp.java:225)
org.apache.jsp.taglib_jsp._jspService(taglib_jsp.java:91)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.29 logs.
best
rim

thanks, this is my first project using Mondrian.

2010-08-09T04:17:04.683-07:00

thanks, this is my first project using Mondrian.

Hi Anonymous, Currently I don't have any samp...

2010-08-05T08:15:45.172-07:00

Hi Anonymous,

Currently I don't have any sample for Oracle.

Our domains are SQL Server and MySQL. Sorry for that, we don't have enough proficieny in Oracle.

Regards,

Feris

hi i want to use my own database created in oracl...

2010-07-29T05:57:59.196-07:00

hi

i want to use my own database created in oracle.

plz let me know the details steps.

thanks
sumeet

how to conect Mondrian with Oracle

2010-06-22T21:31:56.516-07:00

how to conect Mondrian with Oracle

Many thanks to all of you who find this article us...

2010-06-19T21:27:35.663-07:00

Many thanks to all of you who find this article useful !

Regards,

Feris

Very useful, Thank you very much.

2010-05-10T00:34:43.985-07:00

Very useful, Thank you very much.

Thanks for taking the time to document this proces...

2010-01-18T18:15:51.357-08:00

Thanks for taking the time to document this process. You've saved me a lot of time and your instructions were dead on.

For folks having issues - I used the mysql query browser to build the Foodmart table. It may make things a bit easier.

Hi, I found your blog useful. I have managed to ma...

2009-09-16T06:15:10.752-07:00

Hi,
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".
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?

thanks
anonymos

hi all, i am new to mondrian, while deploying th...

2009-09-14T00:12:59.738-07:00

hi all,
i am new to mondrian, while deploying the mondrian on tomcat, i am getting the following error.
JPivot had an error ...

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"

Can you please help me on this

when i tried to extract the foodmart_mysql.tar.gz ...

2009-09-13T21:50:10.795-07:00

when i tried to extract the foodmart_mysql.tar.gz file, i am getting the file corrupted error.Please help me on this?

PLEASE ANSWER... Is it possible to put another da...

2009-09-11T08:57:04.271-07:00

PLEASE ANSWER...

Is it possible to put another database instead of FoodMart or is this just an example where you can try samo operations like drill,...?

Mondrian uses "ISO-8859-1" encoding for ...

2009-08-24T05:18:07.448-07:00

Mondrian uses "ISO-8859-1" encoding for xmla responses. As such , you get such results even though there is utf-8 encoding in mysql.

HOW TO CHANGE RESPONCE TO UTF-8

Hi, I cannot load the tables correctly, the script...

2009-08-19T09:14:26.489-07:00

Hi, I cannot load the tables correctly, the script crashes when trying to load the records for time_by_day table

Thanks

Hi all, THANK YOU VERY MUCH!! I was getting craz...

2009-07-08T02:13:02.973-07:00

Hi all,

THANK YOU VERY MUCH!!
I was getting crazy with mondrian deployment..

Your post is the best I've found over the hundreds I've read..

It's very well explained, and a newbie like me can understand it fast.

Again, many thanks.

Ana

Hai Guys, I dont want to use jpivot as my ui i wa...

2009-07-07T04:13:56.311-07:00

Hai Guys,

I dont want to use jpivot as my ui i wanna use olap datagrid from flex as ui and mondrian any have idea on this please reply me.

Greetings, Special Thanks to Feris for guiding u...

2009-07-01T22:57:57.365-07:00

Greetings,

Special Thanks to Feris for guiding us through the world of Mondrian.

For others, if your "JPivot with arrows" is working but
"JPivot pivot table" is not working,
I suggest you properly replace the old driver strings with:
...
jdbcDriver="com.mysql.jdbc.Driver"
jdbcUrl="jdbc:mysql://localhost/FoodMart?user=root&password=yourPassWord"
...
in all the "mondrian\WEB-INF\queries\*.jsp" files in all places.

While arrows.jsp has only one place to replace,
files like mondrian.jsp has three places to replace in the same way.

Also, modify "mondrian\WEB-INF\mondrian.properties" file so that it looks like:
...
Provider=mondrian;Jdbc=jdbc:mysql://localhost/FoodMart?user=root&password=yourPassWord;
JdbcDrivers=com.mysql.jdbc.Driver;
...

Above fixed many of my Mondrian problems, if not all.
Hope this helps :-)

Hi Quadri,

Sorry for late reply...

...

2009-01-04T19:49:00.000-08:00

Hi Quadri,

Sorry for late reply...

It seems that you haven't configured Mondrian as XMLA (XML for Analysis) provider and web context connection string.

I have written a section of wiki articles detailing configurations for each sample to work.

You can find these articles at http://pentaho-en.phi-integration.com/mondrian/configuring-mondrian-sample.

The article come with brief description and some screenshots to get better understandings.

Regards,

Feris

Comments on Business Intelligence Blog: Mondrian + MySQL Setup

how to get the load time on mondrian?

Could you please give steps for connecting PostGre...

Hi Ankur, It's still very generic to me. How ...

Hi Ferris, I have setup mondrian and trying to ru...

Hi Feris Thia, Is that possible to run it on PHP?...

can u help me to resolve my problem?? if i click ...

i followed every steps to install mondrian and i c...

Hi, am using tomcat 6... mondrian 3.. Oracle, I w...

thanks, this is my first project using Mondrian.

Hi Anonymous, Currently I don't have any samp...

hi i want to use my own database created in oracl...

how to conect Mondrian with Oracle

Many thanks to all of you who find this article us...

Very useful, Thank you very much.

Thanks for taking the time to document this proces...

Hi, I found your blog useful. I have managed to ma...

hi all, i am new to mondrian, while deploying th...

when i tried to extract the foodmart_mysql.tar.gz ...

PLEASE ANSWER... Is it possible to put another da...

Mondrian uses "ISO-8859-1" encoding for ...

Hi, I cannot load the tables correctly, the script...

Hi all, THANK YOU VERY MUCH!! I was getting craz...

Hai Guys, I dont want to use jpivot as my ui i wa...

Greetings, Special Thanks to Feris for guiding u...

Hi Quadri,Sorry for late reply... ...

Hi Quadri,

Sorry for late reply...

...