Pentaho Community -

Instead, within 20 minutes, a reply came from "MattC_EE" in Seattle. It read: “Elara, you beautiful baker. You’re trying to feed a number into a text field. Right-click your ‘Sales Amount’ column in the ‘Select Values’ step and change the type to Number. Also, I love croissants. Here’s a screenshot of my fix.”

Years later, when Pentaho moved further into enterprise and the forums quieted down, old-timers would still tell the story of the baker. They’d laugh about the JavaScript step. They’d debate the merits of the "Pentaho BA Server" vs. modern tools.

It began with a baker named Elara in Lyon, France. Elara ran "Le Fournil des Cinq," a small chain of five artisanal bakeries. She loved the smell of sourdough but hated spreadsheets. Every Monday, she would spend six hours manually collating sales from her five shops, cross-referencing flour suppliers, yeast shipments, and the mysterious case of the missing almond croissants (which her nephew swore he didn’t eat). pentaho community

She built her first transformation: "Bakery_Sales_Load." It was a mess. She used "Text File Input" for her ancient cash registers, "Filter Rows" to catch the negative sales from a returned baguette, and a "JavaScript Step" (a controversial choice, as the community would later tease her) to calculate the actual cost of butter.

But they all remembered the lesson:

For the first time, she saw a dashboard: a beautiful, real-time view of her entire empire. The "Sales by Hour" chart showed a gap at 11 AM—a slow period she could fill with a second bake. The "Supplier Comparison" table revealed that one flour vendor was charging 15% more than the others. And the "Mystery Croissant" report? It traced the missing pastries to the exact register, time, and employee ID of her nephew.

Then "Tomasz_P" from Poland, a legendary forum guru who only posted solutions, never questions. He wrote a single line: “For the date mismatch: YYYY-MM-dd HH:mm:ss. Use ‘Select Values’ -> ‘Meta Data’ tab. Attached is your fixed transformation. Next time, sanitize your inputs.” Instead, within 20 minutes, a reply came from

The caption: “Job executed successfully. Delicious.”