Ah the fun of a server crash............
It took me four days to get everything up and running again - a day for my apache server - which is still just a temorary fix - a day starting to set up the permanent fix, and two days getting Pentaho sending out emails again.
For some reason, the port I was using for the SMTP server went down/got blocked w/e. Took me two days to realize that I needed to change the port number - talk about feeling dumb -.-
Anywho, I've been working on getting up parameter reports, using the basic report methodologies I've been working on and building the parameters into them. I'd not used the BETWEEN statement before for a MySQL query, so at least I got to learn something new this week, heh.
I've not been able to work on my BIRT integration into Pentaho as of yet because of all the server nastiness, but I'm hoping to get to that next week. I'm also excited about the fact that I am getting another department on board with database systems within the plant... now if they will only cooperate with me instead of trying to be so .... demanding, let's say ;)
Anywho, another goal I have in mind is to learn how to place a calendar into my php code as well as in the .xaction parameters pages. I want to try and make the system easier to work with when entering date ranges.
Ah well, I'll try to post more later.
Subscribe to:
Post Comments (Atom)
2 comments:
Hi Alex,
Nice blog. Interesting to see a Pentaho implementation in progress. I am interested to see how it performs on larger datasets.
Whilst MySQL 5.1 is still in beta, the partitioning option may help performance.
What kind of database size is your Pentaho dataset now?
If you need a testbed/sandbox I would signup for Amazon S3/EC2. I have successfully installed Pentaho onto EC2.
Have Fun
Paul
http://blog.vmdatamine.com
Thanks - I'm just hoping I can get more time to actually write up some of the tutorials I've been thinking about doing, heh.
I'll definitely check out the partitioning option and see what I can cook up with that . Right now, the database I am using is sitting at 48 tables with a few megs of data. Part of the fun I'm going through right now is implementing the system (the front end as well as a Pentaho implmentation) throughout the rest of my plant. Once that happens, the quality as well as the quantity of the data will increase - it will be interesting to see how Pentaho will be able to handle the data as information is added.
For now, I'll still stick to my test server here at the plant for my Pentaho testing. I will be checking out Amazon S3/EC2 further - it looks very promising.
Have you had any luck working with Pentaho's Dashboards or building Datacubes? I've been trying to find some good resources for both, but I've not had much luck =S
Post a Comment