Recent changes to newshttp://sourceforge.net/p/mondrian/news/2012-10-08T21:06:48ZNew Releases, Docs, Training Now Available!2012-10-08T21:06:48Z2012-10-08T21:06:48ZJulian Hydehttp://sourceforge.net/u/jhyde/http://sourceforge.net524da603ab86b33d98611426308b82f350c68a54Community Connection: New Pentaho Data Integration, Pentaho Reporting Releases Available
================================================== ==================
Pentaho Data Integration 2.4 Released
--------------------------------------------------
We are proud to announce the release of Pentaho Data Integration 2.4. This exciting new release features significant improvements in performance, scalability and ease-of-use.
Highlights of this release include:
*Remote monitoring and execution of transformations
*Clustering support
*Unified job and transformation editor
*Numerous new steps and transformation objects
*And much, much more...
Thanks to all of our contributors who helped in the development and testing
of this fantastic new release.
Download Pentaho Data Integration 2.4 at http://www.pentaho.org/download/ today!
Modified Javascript Values Step: Community Addition to PDI 2.4
-------------------------------------------------------------------
Every once in a while we get big donations in terms of source code in the Kettle project. One of these donations came in the form of a new and improved JavaScript engine for Kettle. It was written by Martin Lange who needed a high performance Javascript engine for one of his clients. Martin is one of the people behind German company Proconis, http://www.proconis.de/.
The new Javascript engine step has achieved huge performance compaired to the regular &quot;Javascript Value&quot; by using the core Rhino embedding system to create new conversion functions. In the new step, Martin has extended the Javascript function library with new efficient functions, including date handling. Not only does this provide serious performance gains but we can also start building a more re-usable library. The system is easier to re-use because it no longer relies on the internal Value objects exposed by the Kettle environment, but rather leverages Javascript itself.
If that is not enough, Martin created a new tabbed user interface, http://www.pentaho.com/images/kettle_javascript.jpg, to allow for multiple scripts to be loaded and executed, with pre and post execution scripts, color coding and much more. This is the initial release of the new step, but I'm sure we'll hear much more about this step in the future.
Cheers,
Matt, Kettle Founder and Chief Architect
Pentaho Report Designer 1.2 RC1 Available
-------------------------------------------------------------------
We're happy to tell you that Pentaho Report Designer 1.2 RC1 is now available for download at http://www.pentaho.org/download/latest. We would really like to get as much testing and feedback as possible from everyone to make this the best release possible, so please feel free to hit the forums at http://forums.pentaho.org/forumdisplay.php?f=142
with your bug reports, questions and comments!
Highlights of Pentaho Report Designer 1.2:
* Easily begin report creation using templates with the embedded Pentaho Report Design Wizard.
* Access data sources including relational, OLAP (Mondrian aka Pentaho Analysis), XML and Java methods.
* Preview and Run reports in PDF, HTML, Excel, CSV and RTF.
* Publish reports directly to the Pentaho server.
Subreports Beefed Up in Pentaho Reporting 0.8.8
-------------------------------------------------------------------
Pentaho Reporting maintenance release 0.8.8-01 is now available http://sourceforge.net/project/showf...ckage_id=45618 from Sourceforge.net. This release stabilized greatly the new subreporting features, as detailed in the release notes http://sourceforge.net/project/shown...group_id=51669. Note that the subreporting functionality is not yet available in the Pentaho platform or design tools.
Improvements to Pentaho Reporting 0.9.0
-------------------------------------------------------------------
If you missed the release last month, The Pentaho Reporting 0.9.x codeline is ushering in the new era of reporting. This release is a full rewrite of the old codebase, incompatible with all previous releases, and as of yet, incompatible with the Pentaho platform. With this release, we shift our reporting paradigm from absolutely-positioned, banded reports into document oriented reports. This month, we have released Pentaho Reporting 0.9.0-02 http://sourceforge.net/project/showf...ckage_id=45618, the first maintenance release to provide fixes to our 0.9.x codeline. Fixes include stabilizing subreports, better support for empty datasets and much more.
Try it out http://sourceforge.net/project/showf...ckage_id=45618 and give your feedback in the forums http://forums.pentaho.org/forumdisplay.php?f=125!
Pentaho Reporting 0.9.x Roadmap: What's Your Take?
---------------------------------------------------
Next up on the Pentaho Reporting 0.9.0 roadmap - Charting.
For the charting, we are currently in the process of collecting the requirements for the chart-components. It would be a great help to get you, the reporting community, to send our feedback, suggestions and feature requests http://forums.pentaho.org/forumdisplay.php?f=125, so that the result is closer to the user's needs.
At the moment, Thomas, the project founder and lead architect, is planning to include chart-backends for:
* JFreeChart (the standard charting engine in Java)
* OpenOffice Charts (for perfect exports for OpenOffice documents)
* JCharts (an alternative Java charting engine)
* Dojo.Charting (AJAX Charting for HTML exports)
What we are looking for? FEEDBACK http://forums.pentaho.org/forumdisplay.php?f=125!
* What chart types should have priority (should be implemented first)?
* What use cases should we address?
* Is there anything special we should take care of?
And more generally:
*What do our users expect from a reporting engine?
*What can be improved on today's reporting engine (any engine!)?
TDWI Radio News: Open-Source BI, Moving Beyond the Myths
-------------------------------------------------------------------
The Data Warehouse Institute recently interviewed Pentaho CEO Richard Daley, inquiring about the affairs and future of Open Source Business Intelligence. Tune in to this TDWI Radio News interview http://www.esj.com/business_intellig...torialsID=8302 to learn:
*What's included in Pentaho's technology stack
*Which companies are using Pentaho's tools
*How Daley &amp; Co. make their money
*How far down the road Pentaho is looking
Pentaho Finalist in Jolt Product Excellence Awards
-------------------------------------------------------------------
For the past 16 years, the Dr. Dobb's Jolt Product Excellence Awards have been presented annually to showcase products that have &quot;jolted&quot; the industry with their significance and made the task of creating software faster, easier, and more efficient. This year, Pentaho has been chosen as a finalist in the Enterprise Tools category!
Dr. Dobb's Awards and Events Manager Rosalyn Lum comments &quot;Competition to stay ahead is fierce and competition fosters innovation. This year's Jolt Award finalists represent those companies that keep innovation alive.&quot;
Congrats Pentaho team and Pentaho community! The final selections will be announced in March at the 20th Software Development Conference &amp; Expo West at the Santa Clara Convention Center. Go here http://dmnnewswire.digitalmedianet.c...fterinter=true for the whole story.
New Tech Tips Online
-------------------------------------------------------------------
Two super tech tips published this month - thanks to Mike and Chris for making the effort to share their expertise with the rest of us!
MDX Calculations:Set Functions
http://community.pentaho.org/techtip/articles/mdx_calculations_set_functions.php
Using AJAX to Drive Dependent Report Parameters
http://community.pentaho.org/techtip...rameters.ph p
February Training Sessions
-------------------------------------------------------------------
It's not too late to sign up for February training sessions with Pentaho. Pentaho Training sessions offer the fastest route to becoming a &quot;solution-ready&quot; developer with the Pentaho Open BI Suite.
Building Analytic Solutions Using Pentaho
http://www.pentaho.com/elqNow/elqRedir.htm?ref=http://www.regonline.com/118034
Orlando, FL USA
February 6 - February 9
Operational Business Intelligence Using Pentaho
http://www.pentaho.com/elqNow/elqRedir.htm?ref=http://www.regonline.com/118041
Orlando, FL USA
February 19 - February 22
Building Analytic Solutions Using Pentaho
http://www.pentaho.com/elqNow/elqRedir.htm?ref=http://www.regonline.com/119644
Toronto, Canada
February 26 - March 1
Working with the Projects
-------------------------------------------------------------------
Not sure where to find all the tools you need to be a committer in the Pentaho projects? Here's an on-ramp to contributing to the projects, the locations of the core tools of a successful Pentaho developer:
* Downloads - http://www.pentaho.org/download/
* Get the Source Code - http://community.pentaho.org/getthecode/
* The Forums - http://forums.pentaho.org/
* Issue Tracking with JIRA - http://jira.pentaho.org
* Documentation Wiki - http://wiki.pentaho.org
* Tech Tips - http://community.pentaho.org/techtip/
Where do you start? Email communityconnection@pentaho.org [mailto:communityconnection@pentaho.org].
JFreeReport's Name is Changing
-------------------------------------------------------------------
As announced roughly a year ago, we are planning to rebrand JFreeReport to make it part of Pentaho Reporting. This change should be non-disruptive, and will not affect the projects java namespace or technical documentation.??What you will see is a new logo, a changed community subdomain, and high-level references to Pentaho Reporting rather than JFreeReport.??This change is being made in partnership with jfree.org, and the jfreechart project to avoid potential community confusion.
Thank you for your patience while we make the transition.
Meet the Team
-------------------------------------------------------------------
Will Gorman
Pentaho Software Developer
Tell us a little about your engineering career to date.
I started my career at GE Research, where I worked on projects ranging from
aircraft engine expert systems to medical informatics focused on predicting
Alzheimer's progression.
When did you first become interested in open source?
Back in college, I started dabbling with Linux for my server needs.
Since then, I've released most of my spare time software projects as open
source. Two projects that I'm most proud of are JAIMBot, a AOL IM Robot
architecture and and ImageIM, a plugin for GAIM that allows people to send
screenshots easily over IM.
What projects do you work on at Pentaho?
My focus to date has been working within Pentaho's BI Platform, specifically
user interface and security enhancements.
What do you like most about working for Pentaho?
My favorite part about working here are the people I work with. The
engineers here are top notch and their passion for open source is
infectious. We work together in an open lab environment, which makes each
day extremely entertaining.
What do you do in your spare time?
In addition to spending time with my wife and son, I'm always coming up with
ideas to work on in my spare time. One of my favorite hobbies is
BattleBricks, a competitive Lego robotics group that I started with a group
of friends.
Pentaho Open BI Suite 1.2 GA Now Available2012-10-08T21:06:48Z2012-10-08T21:06:48ZJulian Hydehttp://sourceforge.net/u/jhyde/http://sourceforge.net11b3e52dc9a3966cdad2189bc7be031b2d8fb286
Pentaho Community Connection
===========================================================================
---------------------------------------------------------------------------
Pentaho Open BI Suite 1.2 GA Now Available
---------------------------------------------------------------------------
Happy Holidays -- Pentaho Open BI Suite 1.2 is Generally Available!
We have reached the finish line! Pentaho 1.2 is now generally available.
Together,
* we have gone through three release candidates,
* found 925 issues and enhancements,
* and resolved 650 (over 70%) of the reported issues and enhancements.
Although we are moving on to the next version, we will continue to improve
the 1.2 release with better documentation and updates for critical
improvements and issues. The Release Candidate forum will be locked for new
posts; however, the content will be searchable and available. Additionally,
we have improved our documentation (see the Introducing... the Documentation Wiki
in this newsletter).
Download the 1.2 release now at http://www.pentaho.org/download/latest.php !
We thank you for your support and help through this year of intense
development and growth. Stay tuned for announcements concerning more ways
for you to get involved with the project!
---------------------------------------------------------------------------
Introducing... the Documentation Wiki
---------------------------------------------------------------------------
In conjunction with the release of Pentaho Open BI Suite 1.2 GA, the Pentaho
team has moved all of the project documentation to a new wiki format. We are
excited to have all documentation in a format that encourages community
collaboration, feedback and contributions.
Check out the new documentation at http://wiki.pentaho.org . Feel free to
comment and give us feedback at http://forums.pentaho.org/forumdisplay.php?f=236
on the new wiki in our documentation forum.
---------------------------------------------------------------------------
Advanced Implementation Workshop: A Unique Opportunity
---------------------------------------------------------------------------
Pentaho is a business intelligence platform in the extreme. Its many
standards-based interfaces provide almost unlimited flexibility and the
ability to integrate BI into a variety of enterprise architectures, both up
and down the stack.
The Advanced Imlpementation Workshop is an intensive hands-on workshop,
guided by the Pentaho development and product management teams, giving
participants insight into the design philosophy and deployment scenarios
intended for Pentaho and supported by Pentaho Management Services.
Emphasis is placed on points of integration with 3rd-party security APIs,
application servers, portals and source code control systems.
This is a 3 day workshop, offered January 30, 2007 to February 1, 2007. Cost
is $995 USD per attendee; attendance is limited. Take advantage of this
unique opportunity and register today at http://www.regonline.com/Checkin.asp?EventId=117047 .
---------------------------------------------------------------------------
Pentaho Featured on Google Code
---------------------------------------------------------------------------
Google Code (http://code.google.com) is featuring Pentaho's AJAX-based integration with the Google Maps API.
Pentaho's example was selected as a compelling and innovative example of the flexibility and power of the Google Maps API.
To see the Google Maps integration in action, download the Pentaho Open BI Suite Pre-Configured Installation (PCI) demo
at http://www.pentaho.org/download/latest.php .
In the samples that ship with the PCI, navigate to Solutions, Samples, Steel Wheels, Dashboards, Google Maps. There you will find an interactive
sample that demonstrates mapping with Pentaho Dashboards and Pentaho sample data.
Download the Pentaho demo and test drive Google Maps integration today at http://www.pentaho.org/download/latest.php .
---------------------------------------------------------------------------
Software Quality Reporting for JIRA Now Available
---------------------------------------------------------------------------
Software Quality Reports for JIRA/Bugzilla (SQR) provides reporting and
analysis on top of the very popular JIRA and Bugzilla issue tracking
systems. SQR is an out-the-box, packaged solution built upon the Pentaho
Open BI Platform. It provides an end to end solution for delivering valuable software quality
information to product managers, project managers, development managers, and software engineers.
Software Quality Reports includes:
* Extract Transform and Load (ETL) Mappings
* ETL Jobs
* Reporting Data Models (ie, Dimensional Models, staging tables, summary tables, aggregates)
* OLAP Schema Definitions
* Operational Reports
* Analytic Reports
Take a look at SQR for JIRA today at http://sourceforge.net/projects/qareports/ .
---------------------------------------------------------------------------
Latest Project Releases
---------------------------------------------------------------------------
We're proud to announce the release of the next generation in open source
reporting - JFreeReport 0.9.0. Download the 0.9.0 version
http://sourceforge.net/project/downloading.php?group_id=51669&amp;filename=jfreereport-0.9.0-01.zip
and test drive the new engine today.
---------------------------------------------------------------------------
New Training Offered
---------------------------------------------------------------------------
Pentaho training is growing to cover the critical needs of Pentaho
developers and users! New content and expanded sessions make Pentaho training even more
comprehensive and packed with everything you need to be &quot;solution-ready&quot;.
Check out the sessions available at http://www.pentaho.com/services/training/
in early 2007.
---------------------------------------------------------------------------
Pentaho Project Forums
---------------------------------------------------------------------------
Visit the new Pentaho projects forums at http://forums.pentaho.org/.
The JFreeReport, Mondrian, Kettle, WEKA and Pentaho forums now share the
same community home - a faster, more customizable environment, conducive to
collaboration and project development.
Send us your thoughts on the new forums via our Migration Support Forum at
http://forums.pentaho.org/forumdisplay.php?f=136 .
---------------------------------------------------------------------------
Get Involved!
---------------------------------------------------------------------------
Beta Program Team Members Wanted!
We are looking for active community members and partners to participate in
upcoming Beta programs. By participating in Beta programs, you will gain
early access to the latest Pentaho product offerings and get the chance to
work directly with the Pentaho development team.
Go here for more details: http://www.pentaho.com/beta/
...
Weigh in on the Hefty Job of Internationalization
It is our mission to build the best toolset for the development community
around the best business intelligence suite. With the introduction of the
documentation wiki, we have encountered new localization challenges.
Read about it here, http://forums.pentaho.org/showthread.php?t=49970,
and weigh in, your opinion matters!
==============================================================
About Pentaho
Thanks for your interest in the Pentaho project and helping us make Open Source Business Intelligence a reality and a great alternative to proprietary closed source vendors! Contact us with comments, suggestions, issues and praise.
For previous issues of this newsletter, visit the Pentaho Community Newsletter Archives at http://community.pentaho.org/newsletter/archive.php .
Email: communityconnection@pentaho.org
Forums: http://forums.pentaho.org
Pentaho Community Connection
Pentaho - The Open Source Business Intelligence Company
Direct +1 407-812-OPEN | www.pentaho.org
Mondrian Project Forums are Open For Business2012-10-08T21:06:48Z2012-10-08T21:06:48ZJulian Hydehttp://sourceforge.net/u/jhyde/http://sourceforge.net272f6ad5cc94eb22ead522034628a683fe148588The new Mondrian forums are at http://mondrian.pentaho.org/forum !
Pentaho, Mondrian, Kettle, JFreeReport and WEKA now share the same forum home - a full-featured, super fast, personalizable forum home! Many thanks to our community beta testers who have been trying out the new forum software and providing feedback throughout the testing period.
In the interest of making this the best possible resource for our community, we have migrated the threads from all prior forums into the new forums. If you are already a member of these projects, visit the Migration FAQ at http://community.pentaho.org/faq/forum_migration_faq.php to learn how to use your existing account or merge your multiple accounts. If you are new to the community, register for a new account and welcome to the Pentaho projects.
All of the project leaders, the project teams and the Pentaho Community Connection are thrilled to be bringing an awesome new set of collaboration tools to you, our community. Please give us your comments, questions and concerns on the new forums in our Migration Support Forum at http://forums.pentaho.org/forumdisplay.php?f=136 . We love to get your feedback!
Finally, check out the Migration FAQ for more improvements coming in 2007!
kind regards &amp; welcome to the new forums!
Pentaho Community Connection Mondrian Forums are Moving!2012-10-08T21:06:47Z2012-10-08T21:06:47ZJulian Hydehttp://sourceforge.net/u/jhyde/http://sourceforge.nete450a62aab6489d0620e951eb80d855f9c8a0d38Pentaho Community Connection
--------------------------------------------------------------
We are pleased to announce that on December 10, 2006, we will be moving the Pentaho project forums to a new, faster, more full-featured forum site. This move includes the forums for the Pentaho project, the Mondrian project, the Kettle project and the JFreeReport project.
The objective for moving the project forums is simple and sincere - we wish to provide the very best community environment for all of our communities to work, play and develop in. All of the project forums have room to grow toward this objective. Each project (ie., Mondrian, Kettle, Pentaho) will have it's own portal into the forums for those community members who wish to remain focused on the individual project. We also now have the added benefit of providing integrated resources for the community that is using multiple Pentaho projects or the entire BI suite.
We are very well aware that moving a project's forums is very much like moving a home for an open source project, and have taken care to &quot;pack all the valuables&quot; carefully. Our first effort at making sure the community is informed and involved is this pre-announcement of the move. We are asking for your comments, concerns and feedback on our plan for handling the move. You can review the Forum Migration FAQ ( http://community.pentaho.org/faq/forum_migration_faq.php ), and post your thoughts in the Migration Support Forum at http://forums.pentaho.org/index.php?option=com_simpleboard&amp;amp;Itemid=275&amp;amp;func=showcat&amp;amp;catid=49 . We will migrate the Migration Support Forum and keep it live for 90 days after the move or until we feel that all communities have settled in to their new forums comfortably.
We also invite anyone in the community to preview the test forum site that we have set up to validate the move. Email communityconnection@pentaho.org for instructions on how to access the test site.
--------------------------------------------------------------
--------------------------------------------------------------
About Pentaho
Thanks for your interest in the Pentaho project and helping us make Open Source Business Intelligence a reality and a great alternative to proprietary closed source vendors! Contact us with comments, suggestions, issues and praise.
For previous issues of this newsletter, visit the Pentaho Community Newsletter Archives at http://community.pentaho.org/newsletter/archive.php .
Email: communityconnection@pentaho.org
Forums: http://forums.pentaho.org
Pentaho Community Connection
Pentaho - The Open Source Business Intelligence Company
Direct +1 407-812-OPEN | www.pentaho.org Pentaho News: New Releases, Pentaho Solutions2012-10-08T21:06:47Z2012-10-08T21:06:47ZJulian Hydehttp://sourceforge.net/u/jhyde/http://sourceforge.net54d12cbd8885f7d205091c87410d507f4770e58e
Pentaho Community Connection
--------------------------------------------------------------
Pentaho Releases First Milestone Build of Pentaho Metadata
--------------------------------------------------------------
Pentaho has released the first milestone release of Pentaho Metadata(PMD)
including the new Metadata Editor(PME)!
Released under the Mozilla Public License (MPL), Pentaho's new open source
metadata capabilities enable administrators to define a layer of abstraction
to shield the common business user from the complexities of underlying
databases. Administrators leverage their deep understanding of source
systems to convert complex tables, relationships, indexes, and other
concepts foreign to a business user, into a user-friendly model reflecting
how they think of their business - in terms like customers, products and
markets. These &quot;business views&quot; can be further enriched by defining security
parameters that limit data access to authorized users, default formatting
for data fields, column suppression, and additional translations for
business views used in multi-lingual deployments.
Pentaho Metadata is built using the Common Warehouse Metamodel (CWM)
standard created by the Object Management Group (OMG) to allow for
interoperability with existing metadata stores as well as third-party
databases, metadata repositories, and ETL tools. Pentaho's metadata-driven
query engine uses JDBC and ANSI standard SQL to allow for the broadest
possible choice of proprietary and open source databases including Oracle,
IBM DB2, Microsoft SQL Server, MySQL, PostgreSQL and others.
Download the first milestone release, documentation and source from
http://www.pentaho.org/download/latest.php .
Send us your feedback in our Metadata forum at http://forums.pentaho.org/ .
--------------------------------------------------------------
Pentaho Introduces Web-based Ad Hoc Query and Reporting
--------------------------------------------------------------
We are pleased to announce new web-based ad hoc query and reporting
capabilities for the Pentaho Reporting module of Pentaho's BI suite. The new
functionality utilizes an innovative new open source metadata layer that
facilitates self-service query and reporting by shielding end users from the
complexities of underlying databases and thereby lowering the technical
barriers to customized report creation.
Pentaho now provides tailored reporting capabilities for application
developers, power users, and business users alike within a common
architecture and report format. Read more about it in the
press release
( http://www.pentaho.org/news/releases/20061121_web_based_ad_hoc_query_and_reporting.php ), or
preview the new web-based ad hoc query and reporting tool in a recorded demonstration at
http://www.pentaho.com/products/demos/ .
--------------------------------------------------------------
New Open Source Solution Available: Software Quality Reports For JIRA
--------------------------------------------------------------
We are happy to release another great solution into the open source business
intelligence (BI) arena: Software Quality Reports for JIRA! This is an
extension to the Software Quality Reports for Bugzilla solution.
Software Quality Reports for JIRA/Bugzilla (SQR) provides reports and analysis on top of the very popular
JIRA and Bugzilla issue tracking systems. Implemented as a &quot;solution&quot; built using the Pentaho BI Suite, it
provides an end to end solution for delivering valuable software quality information to product managers, project
managers, development managers, and software engineers.
Software Quality Reports includes:
• Extract Transform and Load (ETL) Mappings
• ETL Jobs
• Reporting Data Models (ie, Dimensional Models, staging tables, summary tables, aggregates)
• OLAP Schema Definitions
• Operational Reports
• Analytic Reports
Take a look at SQR for JIRA today at http://sourceforge.net/projects/qareports/ .
Post your comments and feedback in the project forums at http://sourceforge.net/forum/?group_id=172805 .
--------------------------------------------------------------
--------------------------------------------------------------
About Pentaho
Thanks for your interest in the Pentaho project and helping us make Open Source Business Intelligence a reality and a great alternative to proprietary closed source vendors! Contact us with comments, suggestions, issues and praise.
For previous issues of this newsletter, visit the Pentaho Community Newsletter Archives at http://community.pentaho.org/newsletter/archive.php .
Email: communityconnection@pentaho.org
Forums: http://forums.pentaho.org
Pentaho Community Connection
Pentaho - The Open Source Business Intelligence Company
Direct +1 407-812-OPEN | www.pentaho.org
Pentaho News: Mondrian 2.2, Cube Designer Released2012-10-08T21:06:47Z2012-10-08T21:06:47ZJulian Hydehttp://sourceforge.net/u/jhyde/http://sourceforge.netfad9aa0faa7274825889a3deafd7817a086ac924Pentaho Community Connection
----------------------------------------------------------
Mondrian 2.2 and Pentaho Cube Designer Released
----------------------------------------------------------
Mondrian 2.2RC1 is now available for download! The release includes a new Pentaho Cube Designer, as well as numerous performance and scalability enhancements.
Pentaho Cube Designer allows administrators to quickly design and deploy OLAP applications. Its wizard-driven, graphical user interface walks administrators through the steps of connecting to relational data sources, defining analytical dimensions, and identifying measures or “facts” for analysis.
Mondrian 2.2RC1 also contains enhancements designed to improve performance and scalability, and deliver optimal performance across a wide variety of production configurations. These enhancements include improvements for handling large dimensions in Oracle databases, and SQL optimizations for the MySQL database.
Download the latest Mondrian release and the new Pentaho Cube Designer from http://www.pentaho.org/download/latest .
----------------------------------------------------------
Pentaho Sites Continue to Improve: New Web Sites For Mondrian, JFreeReport and Kettle
----------------------------------------------------------
The Pentaho web team is pleased to announce the launch of updated web site navigation and branding for several of our projects - Mondrian, JFreeReport, and Kettle!
By moving to one common navigation for these projects, we hope to help our community jump from project to project more seamlessly. Over time you will also notice the organization of content within each project more closely align, making it even easier to find content where you would expect to see it.
Our goal is to provide an environment that makes communicating with the Pentaho team and contributing to the Pentaho projects compelling, comfortable and fun! The new home pages are one step toward offering integrated, scalable, full-featured web tools to the communities that support the Pentaho projects.
The Pentaho web team has been busy over the past few months making improvements to the Pentaho web site, both for looks and for performance. The team managed to move the entire web site to a faster, more secure, more stream-lined architecture with virtually no loss of site availability in September. The new web sites for Mondrian, JFreeReport and Kettle are a major milestone for October.
Use the following links to bookmark the new web sites, and remember to update your old bookmarks that have changed!
Mondrian: http://mondrian.pentaho.org/
JFreeReport: http://jfreereport.pentaho.org/
Kettle: http://kettle.pentaho.org/
----------------------------------------------------------
Don't Miss This Webinar! MySQL and Mondrian, the Best Delivery For Analytics
----------------------------------------------------------
Join Julian Hyde, founder of the Mondrian project, and the MySQL team for &quot;OLAP for MySQL using Pentaho Mondrian&quot;, Tuesday, October 24, 2006 at 10:00 am PDT, 1:00 pm EDT, 17:00 GMT.
In this Web Seminar you will get a look at:
*The Mondrian OLAP project, which provides high-performance, interactive OLAP on top of MySQL
*OLAP technologies including dimensional data models, query languages, and OLAP schemas
*Case Studies
*Why Pentaho-MySQL is the best way to deliver OLAP and analytical solutions
Register now for this webinar at http://www.mysql.com/news-and-events/web-seminars/mysql-olap-pentaho-mondrian.php .
----------------------------------------------------------
Pentaho Welcomes Optaros to the Pentaho Partner Program
----------------------------------------------------------
Please join the Pentaho team in welcoming Optaros, a proven consulting services company with deep expertise in open source technology, to the Pentaho Partner Program.
An active and contributing participant in the global open source community, Optaros helps organizations assemble and deploy next generation internet applications. Optaros’s unique application assembly approach goes beyond the traditional “build versus buy” decision to maximize agility, cost efficiency, and speed of delivery. This innovative approach has delivered success for Optaros clients around the globe including Swisscom Mobile, Biogen, and The New York Times.
For more about Optaros, go to http://www.optaros.com. To read the full partner press release, visit http://www.pentaho.org/news/releases/20061010_optaros_joins_pentaho.php .
----------------------------------------------------------
This Week's Tech Tip: The If statement and PREPARE: Building Flexible, Secure and Scalable Solutions
----------------------------------------------------------
This tech tip covers two powerful features in the action sequence that help platform users build flexible, secure, scalable solutions. The tip covers the If Statement, a conditional component, and the PREPARE statement, an alternative method of replacing parameters in an SQL where clause.
This short read is a must for all Pentaho platform developers and users. Try it out at http://community.pentaho.org/techtip/articles/if_statement_prepare_building_solutions.php .
==========================================================
About Pentaho
Thanks for your interest in the Pentaho project and helping us make Open Source Business Intelligence a reality and a great alternative to proprietary closed source vendors! Contact us with comments, suggestions, issues and praise.
For previous issues of this newsletter, visit the Pentaho Community Newsletter Archives.
Email: communityconnection@pentaho.org
Forums: http://www.pentaho.org/discussion
Pentaho Community Connection
Pentaho - The Open Source Business Intelligence Company
Direct +1 407-812-OPEN | www.pentaho.org
Pentaho News: Happy Anniversary, Pentah Nation!2012-10-08T21:06:47Z2012-10-08T21:06:47ZJulian Hydehttp://sourceforge.net/u/jhyde/http://sourceforge.net1b977288fded973a5abb3ff5009b41de00a1c897
Pentaho Community Connection
------------------------------------------------------------------------------------------
Happy Anniversary, Pentaho Nation! Pentaho is Two Years Old!
------------------------------------------------------------------------------------------
Thank you, Pentaho Nation, for an amazing first two years! Here is a short thank you note from the CEO, Dick Daley:
Congratulations and thank you on behalf of the Pentaho team. Together, in only two years, we’ve built out an entire open source business intelligence (BI) suite, that’s now the most popular and widely-used in the world. The Pentaho community has helped us improve the quality, enhance the functionality, simplify the deployment, and deliver the product in multiple languages.
Thank you again for being part of the Pentaho community. We look forward to working with you in the future.
Regards,
Richard
To read about the challenges, milestones and successes in Pentaho's first two years, visit http://www.pentaho.org/news/releases/20061018_pentaho_two_year_anniversary.php .
------------------------------------------------------------------------------------------
Pentaho Open BI Suite 1.2 Release Candidate 3 Available for Download
------------------------------------------------------------------------------------------
We thank you for the last three months of testing and feedback on the release candidates for Pentaho BI Suite 1.2. We have made it to the home stretch: release candidate 3 has been released and the generally available (GA) release has been planned. Here’s how we’ve done.
* 427 bugs have been reported against the release candidates; 327 of them have been closed as of RC 3
* 59% of the issues were rated severe or greater
* Average severity ranking for all RC bugs is 3.57 (on a 6 point scale with 6 being the most severe)
Download RC 3 today! In addition to the bug fixes listed in the online release notes and change log ( https://sourceforge.net/project/shownotes.php?group_id=140317&amp;amp;release_id=456313 ), this release includes
* a variety of security fixes to protect against SQL injection and the malicious publishing of reports and action sequences
* updates to the German, Chinese, and Dutch translations
* update to JFreeReport 0.8.7-9
We are in the home stretch and need your continued support and contributions in the form of testing and suggestions. Thanks for making Pentaho the most popular open source BI project!
Download Pentaho Open BI Suite 1.2 RC3 today at http://www.pentaho.org/download/latest.html .
------------------------------------------------------------------------------------------
Release Candidate 3 Includes Google Maps Integration!
------------------------------------------------------------------------------------------
Penthao Open BI Suite 1.2 Release Candidate 3 includes an improvement to Pentaho Dashboards that provides live, dynamic integration with Google Maps!
The integration leverages new Pentaho AJAX components to provide interactive geographical visualization capabilities, facilitating the deployment of location intelligence applications that enable in-depth geographic-based analysis of business patterns.
To see the Google Maps integration in action, download the Pentaho Open BI Suite Pre-Configured Installation (PCI). In the samples that ship with the PCI, navigate to Solutions, Samples, Steel Wheels, Dashboards, Google Maps. There you will find an interactive sample that demonstrates mapping with Pentaho Dashboards and Pentaho sample data.
Download release candidate 3 and test drive Google Maps integration today at http://www.pentaho.org/download/latest.html.
------------------------------------------------------------------------------------------
Pentaho Joins IBM Partner Program
------------------------------------------------------------------------------------------
We are pleased to announce Pentaho has joined IBM’s Partner Program, and that Pentaho Open BI Suite and Pentaho BI Suite Professional Edition are now validated on IBM’s popular DB2 9 database. This partnership opens new markets for Pentaho, and provides IBM and its partners with an attractive opportunity to expand its presence in international markets and in the small- and medium-sized (SMB) business market.
Read the full press release at http://www.pentaho.org/news/releases/20061017_pentaho_ibm_partner.php .
===========================================================================================
About Pentaho
Thanks for your interest in the Pentaho project and helping us make Open Source Business Intelligence a reality and a great alternative to proprietary closed source vendors! Contact us with comments, suggestions, issues and praise.
For previous issues of this newsletter, visit the Pentaho Community Newsletter Archives.
Email: communityconnection@pentaho.org
Forums: http://www.pentaho.org/discussion
Pentaho Community Connection
Pentaho - The Open Source Business Intelligence Company
Direct +1 407-812-OPEN | www.pentaho.org
Pentaho News: pentaho Roadmap 2007 Now Available2012-10-08T21:06:47Z2012-10-08T21:06:47ZJulian Hydehttp://sourceforge.net/u/jhyde/http://sourceforge.netf78a93a81974ec49d9fad0a28d4ea84c6657e94dPentaho Community Connection
--------------------------------------------------------------------------
Pentaho Roadmap 2007
--------------------------------------------------------------------------
The Pentaho Roadmap for 2007 is HERE! The major investment themes of 2007
for Pentaho include ease of use, maintenance and administration, and
platform extensions.
Check out the roadmap at
http://community.pentaho.org/roadmap/.
Let us know what you think! Email your comments, questions or concerns to
mailto:roadmap@pentaho.org.
--------------------------------------------------------------------------
Satyam and Pentaho Strike Strategic Alliance
--------------------------------------------------------------------------
Pentaho and Satyam are pleased to announce a strategic alliance to deliver
technology and implementation expertise to address the full spectrum of
business intelligence market needs across all verticals and geographies.
With a large pool of Satyam employees providing consulting and business
development expertise around Pentaho’s Open BI Suite, this alliance
represents the largest consulting partnership in the open source BI market.
Click here
http://www.pentaho.org/news/releases/20061107_pentaho_satyam_strike_strategic_alliance.php
to read the full press release.
--------------------------------------------------------------------------
Case Study: Unionfidi S.C. Deploys Balanced Scorecard Application Powered by
Pentaho
--------------------------------------------------------------------------
Unionfidi S.C. has deployed Pentaho’s Open BI Suite to deliver a balanced
scorecard, reporting, and analysis application that provides vital
information and decision support to multiple departments. Two Heads I.T., a
Pentaho Certified Partner, led the implementation and drove the project from
initial requirements to deployment in only eight weeks.
Check out the case study with additional details on Unionfidi S.C.’s
implementation of Pentaho, available at http://www.pentaho.com/products/demos.
--------------------------------------------------------------------------
&quot;OLAP for MySQL using Mondrian&quot; Webinar Replay Available
--------------------------------------------------------------------------
Pentaho and MySQL provide a great combination to deliver world-class OLAP
applications on an open source foundation using Pentaho’s Mondrian OLAP
project and MySQL 5.
In this Web Seminar you will get a look at:
*Pentaho’s Mondrian OLAP project, which provides high-performance,
interactive OLAP on top of MySQL
*OLAP technologies including dimensional data models, query languages, and
OLAP schemas
*Case Studies
*Why Pentaho-MySQL is the best way to deliver OLAP and analytical solutions
Visit
http://www.mysql.com/news-and-events/on-demand-webinars/pentaho-20061024.php
to play this webinar at your convenience, on-demand!
--------------------------------------------------------------------------
Latest Releases
--------------------------------------------------------------------------
Mondrian and JFreeReport rolled out new releases early this month. Download
Mondrian 2.2.2
http://prdownloads.sourceforge.net/mondrian/mondrian-2.2.2.zip?download
or
JFreeReport 0.8.7-10
http://sourceforge.net/project/showfiles.php?group_id=51669&amp;package_id=45618
today.
--------------------------------------------------------------------------
Upcoming Training Events
--------------------------------------------------------------------------
Two courses being offered for the months of November and December:
Building Analytic Solutions with Pentaho
* Orlando, FL USA, Dec 12-15
http://www.pentaho.com/services/training/
* Paris, France, Nov 20 - 23
http://www.bpm-conseil.com/Formation_Pentaho_Analysis.pdf
(French only)
Operational Reporting using the Pentaho BI Platform
*Paris, France, Nov 27 - 29
http://www.bpm-conseil.com/Formation_Pentaho_Reporting.pdf
(French only)
--------------------------------------------------------------------------
Internationalization Updates
--------------------------------------------------------------------------
We have new Simplified Chinese additions to our translated documentation.
Click the links below to download:
*Pentaho Dashboard Building
http://prdownloads.sourceforge.net/pentaho/Pentaho_Dashboard_Building_zh_CN_1.2RC3.pdf?download
*Pentaho Cube Designer User Guide
http://prdownloads.sourceforge.net/mondrian/Pentaho_Cube_Designer_User_Guide_zh_CN_0.7.0.pdf?download
--------------------------------------------------------------------------
New Tech Tips
--------------------------------------------------------------------------
Trend Lines in Mondrian
http://www.nicholasgoodman.com/bt/blog/2006/10/31/trend-lines-in-mondrian/
Take a look at forecasting with trend lines in Mondrian.
MDX Calculations: Previous Period Growth
http://community.pentaho.org/techtip/articles/mdx_calculations_previous_period_groth.php
Learn how to implement some common MDX calculations using the
SteelWheelsSales sample cube.
MDX Calculations:Percentage Shares and Allocations
http://community.pentaho.org/techtip/articles/mdx_calculations.php
The second article in the series on common MDX calculations.
Pentaho News: Training Sessions Available2012-10-08T21:06:47Z2012-10-08T21:06:47ZJulian Hydehttp://sourceforge.net/u/jhyde/http://sourceforge.net77445a0278bf252b8d82fd77cc61ed46272537b3Pentaho Community Connection
---------------------------------------------------------------
Two Pentaho Training Sessions Available in 2006!
---------------------------------------------------------------
What better way to gear up for 2007, than to dig into the details of the Pentaho Open BI Suite in an in-depth training course in 2006! Pentaho is pleased to offer two training sessions before year end, covering Pentaho essentials that will jumpstart your BI application development. Both courses are being offered in Orlando, Florida, USA.
Operational Reporting Using the Pentaho BI Platform, Nov. 13 - 15, 2006
This intensive 3-day course focuses on the knowledge and skills needed to create and customize Pentaho reports and to deploy them via portals and e-mail. Students learn basic and intermediate design techniques for Pentaho Reporting (JFreeReport) using the Pentaho Report Designer and Report Design Wizard. Pentaho Design Studio is introduced and is used to create action sequence definitions that perform &quot;bursting&quot; of reports to email recipients based on database lookups and business rules. Parameterization of reports is also covered along with techniques for implementing custom parameter pages.
Building Analytic Solutions with Pentaho, Dec. 12 - 15, 2006
This four-day course provides students with the practical knowledge needed to design, build and implement OLAP-based solutions using Pentaho Data Integration (Kettle), Pentaho OLAP (Mondrian) and the Pentaho BI platform. The focus is on development of essential skills, including the ability to design a basic star schema and populate it using Pentaho Data Integration transformations, the knowledge required to create an OLAP schema definition as well as the techniques required to configure end-user access over the web and through Excel. The basics of OLAP security and performance optimization are also covered.
Visit http://www.pentaho.com/training or email training@pentaho.org to register for this course. Register now, space is limited!
---------------------------------------------------------------
Pentaho Recognized as Open Source BI Leader by Entiva Group
---------------------------------------------------------------
Pentaho has been recognized as the leader in the open source business intelligence (BI) market by Entiva Group, the first analyst firm to concentrate exclusively on the use of open source software to improve business operations. The recognition came in an independent and unsolicited report titled &quot;Pentaho Gives Open Source Business Intelligence a Boost&quot; and is available free at http://entivagroup.com/content.php .
The report evaluates Pentaho's architecture, functionality and deployability as well as considerations for organizations evaluating Pentaho for BI. It specifically singles out the stability, ease of use, integrated architecture and industry-standard compliance of the Pentaho platform.
Go Pentaho!
---------------------------------------------------------------
This Week's Tech Tip: Chris Webb Introduces MDX Calculations: Previous Period Growth
---------------------------------------------------------------
This week's tech tip comes form Chris Webb, a well-known figure in the Microsoft Business Intelligence community, regularly contributing to newsgroups and online discussion forums, and who has spoken at several international conferences.
Chris submits his first tutorial in a planned series on MDX queries, calculations and general use. You won't want to miss this series if you are just getting your feet wet with Mondrian!
Get Chris's article at http://community.pentaho.org/techtip/articles/mdx_calculations_previous_period_groth.php.
=====================================================================
About Pentaho
Thanks for your interest in the Pentaho project and helping us make Open Source Business Intelligence a reality and a great alternative to proprietary closed source vendors! Contact us with comments, suggestions, issues and praise.
For previous issues of this newsletter, visit the Pentaho Community Newsletter Archives.
Email: communityconnection@pentaho.org
Forums: http://www.pentaho.org/discussion
Pentaho Community Connection
Pentaho - The Open Source Business Intelligence Company
Direct +1 407-812-OPEN | www.pentaho.org
Pentaho News: SUSE Linux Enterprise 10 Certification2012-10-08T21:06:47Z2012-10-08T21:06:47ZJulian Hydehttp://sourceforge.net/u/jhyde/http://sourceforge.netd7330e92daa69f40d45b764d344ce66eddec57d4Pentaho Community Connection
-----------------------------------------------------------------------
Pentaho Announces SUSE Linux Enterprise 10 Certification
-----------------------------------------------------------------------
It's official - we've completed certification of the Pentaho Open BI Suite on both the server and desktop editions of SUSE Linux Enterprise 10 from Novell. Together, Pentaho and SUSE Linux Enterprise provide a compelling solution leveraging open source software to provide superior functionality and value compared to proprietary alternatives.
Visit Pentaho News at http://pentaho.org/index.php?option=com_content&amp;task=view&amp;amp;id=171&amp;Itemid=238 to read the full press release.
-----------------------------------------------------------------------
RC Days Update ... from the Front Lines
-----------------------------------------------------------------------
News update about our RC Days community outreach! From Tony D., Pentaho Application Development Manager:
The launch of RC Days put the Pentaho project into hyper drive, racing towards the long awaited release of the Pentaho Open BI Suite version 1.2. There has been lots of activity: bugs found and squashed, enhancements logged, and the definition of a planet is being reconsidered (not that we had anything to do with that)! Check out the statistics below.
* 141 issues (bugs, improvements, features requests, and tasks) entered
* 61% of the new issues were bugs; 77% of the new bugs are resolved
* 38% of entered issues severely impacted functionality or performance; 58% of those have been resolved
We’ve done a lot and have more work to do. We thank the community members that have given feedback via the forums.
If you have not participated in the RC days, now is your chance. Check out the Dev Zone at http://www.pentaho.org/devzone for more info on RC Days, or visit http://jira.pentaho.org/jira to browse open or resolved cases for the next release candidate. Every contributed bug, suggestion, or critique makes Pentaho the leading open source BI project! Now back to your regularly scheduled newsletter.
Anthony
Pentaho App Dev Manager (aka Head Geek Wrangler)
-----------------------------------------------------------------------
This Week's Tech Tip: Dynamically Generating a Cross Tab Report, Part I
-----------------------------------------------------------------------
We recently received a monster (in a great way!!) of a tech tip from Nic Guzaldo, a self-taught Pentaho expert and supporter. I spent a day or so getting my head around what Nic had accomplished (with many exclamations of &quot;wow, I didn't know we could do THAT!&quot;), and figured I should break it up into a series of articles for easier consumption.
This first article of the series focuses on creating a query that will not only demonstrate setting up regular data for a cross tab report, but also use user input to determine the number of columns in the query.
In the second half of this solution, we will continue with Nic's example and use the generated resultset as input to a dynamically generated report spec, to create a Pentaho report that allows a variable number of columns, dynamically generated report name, nice output names for external files and other goodies!
Start test driving this jam-packed solution at http://www.pentaho.org/index.php?option=com_content&amp;task=view&amp;id=173&amp;Itemid=276.
-----------------------------------------------------------------------
Pentaho Community Strong Show at LinuxWorld, Thank You!
-----------------------------------------------------------------------
FIrst feedback from our Chief Geek, James D., at the LinuxWorld Conference &amp; Expo in San Francisco this week: &quot;The Pentaho team is feeling the love from the community!&quot;. James and the rest of the team in SF would like to extend a very warm thank you to the Pentaho community for showing up and taking over the Pentaho booth at the show.
Historically Pentaho has attracted ginormous amounts of attention at trade shows, either because we are an extremely compelling BI team or because we have been known to hire show girls to work the booth (I suspect it's a little of both). LinuxWorld SF has been no exception, according to the team. The difference at LinuxWorld this week is that the crowd has been engaged, entrenched Pentaho community members. We are very proud to have such a committed, enthusiastic group banging on our projects; once again, many thanks to those members in SF supporting the team.
========================================================================
About Pentaho
Thanks for your interest in the Pentaho project and helping us make Open Source Business Intelligence a reality and a great alternative to proprietary closed source vendors! Contact us with comments, suggestions, issues and praise.
Email: communityconnection@pentaho.org
Forums: http://www.pentaho.org/discussion
Pentaho Community Connection
Pentaho - The Open Source Business Intelligence Company
Direct +1 407-812-OPEN | www.pentaho.org