These articles are about the Pentaho BI from versions 3.8 to 4.8.
For the time being (Nov 2013) these are the ones I recommend using because version 5.0 implements a ‘database repository (Jackrabbit)’ and it really messes datasource and program updates with import/output steps that are not clear yet (you can check the Pentaho forums).
And it’s released tools (PDI, PME, PRD) are not backward compatible.
Don’t let the beautifull blue design lure you into migration, its not time yet.
These are notes about Pentaho BI community edition (CE) Suite. Each page contains instructions, reference links and tips to start using these great open source projects.
- Install the Pentaho BI Server
- Modify databases to MySQL. Add your Database too.
- Set Up New Add-Ins Like Saiku
- Add your Users
- Prepare your ‘Production’ Server
- Install PDI/Kettle and Agile PDI in a Development Environment
- Install Pentaho Design Studio
- Install Mondrian Schema Editor
- Install Pentaho Metadata Editor
- Install Report Designer
- Install the Dashboard Editor
- Install Pentaho/Mondrian Aggregation Designer
- Additional tools
- Install Weka
These are upgrade instructions:
4.54.8– Tools Update
- Pentaho CE 4.8 – BI Server Update
On each post links were offered to study simple and advanced cases for each tool. Two step by step examples are offered for interagtion beetween applications:
- Bubble Report
Used: BI Server, SQL Query, Report Designer with a Bubble Graph. Parameter interfacing.
- Bullet Graph Dashboard
Used: BI Server, PDI Datasource (ETL), MDX & SQL DataSources. CDE Dashboard creation. Bullet Graph -Stephen Few- Widget. CSS modification. Variable value interfacing.
Can you give me some idea/examples on how do I use Kettle queries in CDE?
Working on a step by step cde using sql, mdx and pdi. please be patient.
Thanks.All your articles are great for exploring Pentaho BI.Keep the good work.
Do you have CDE sample working with Kettle Query data source or can sent me steps to do that?
Pingback: Install Pentaho 4.5 CE as service on Windows 7 x64 | Dot …
Hi… Could you please post an example with MDX query+ date range parameter in CDE
Please Post any installation document for windows based Pentaho Bi server configuration .
@ balaji ::
Hope this blog post will help you.
Hi Balaji k,
The best resource I’ve got for Windows using several databases was http://www.prashantraju.com/
But currently time the page is down. Hope it come back as it is a great resource.
In any case in a couple of weeks the CE 5.0 will be released and it seems like there will be lot of changes so if youre not in a hurry its better to wait for the new material (in the pentaho wiki you can read about what’s coming)
Your guide to deploy Pentaho is very useful.
First of all, thanks so much for your hard work to write your blog.
A few days trying to create a new template based on the saiku_small.prpt for the report to use it saiku-reporting. Set saiku adhoc using the script https://github.com/pmalves/ctools-installer/blob/master/ctools-installer.sh
The Internet is not found instructions on how to create templates for saiku-reporting. Tried to replace the logo saiku in the template saiku_small.prpt on a different logo, after I saved in Pentaho Report Designer the edited file saiku_small.prpt and uploaded it to the folder pentaho-solution/system/saiku-adhoc\resources\templates. In the editor saiku reporing I chose the template saiku_small, but the application is an error HTTP Status 400 – Bad Request.
Also strange is that if I open the template saiku_small.prpt in the editor Pentaho Report Designer and store it without changes, then this template can also not be used.
Any ideas how to edit the standard templates saiku?
nice guide blog.
but have you an example for a drillthrough dashboard CDE which it can open another file
so if i click A bar Chart object it can open another Chart with a paramater from the chart before
Edit the CDE Sample Dashboard, Good Luck
this is very good nice article. this is very useful for Pentaho students.
This is very nice article. This is very use ful for Pentaho Learners.
hi sir. i want to do Pentaho training.
Pentaho ONlINE TRAINING Thanks for providing valuable information.
Pingback: Update Pentaho BI Server CE from 5.2 to 5.3. It works for 5.3 to 5.4 too. | Interesting IT Tip's
Hello! I want to upgrade from 4.8 to 6.0. I know it can not be done directly but through 5.x.x
Do you have any step-by-step tutorial to do so? I found official tutorials from 5.x.x to 6.0 but nothing from 4.8 to 5.x.x community edition.
Thank you very much!
Im copying this answer from another post:
I haven´t done such a big upgrade but 4.8 to 5.0 was a big change, I didn’t notice big changes with 6.x, but got bored with exporting and importing work from the repository and checking what no longer worked.
I dont have a test suit for BI.
I guess it will take you a couple of attempts, take note that it works to upgrade not backwards, If you miss something you’ll have to start all over.
– Look and Feel (depends on what did you change)
– Report migration (easy but some funtions needs tunning)
– Dashboards (same as above but its harder as library gets depretaded)
– PDI (easy)
– Saiku needs tunning
– .xactions got deprecated
– You loose the web reporter
Sometimes will be easy to replace some of your work rather than migrate them.
You should end with a nicer experience in usability.