Skip to main content
Hitachi Vantara Lumada and Pentaho Documentation

What's New in Pentaho 6.1


Pentaho 6.1 has a range of capabilities from updated and enhanced features to improved documentation. The highlight of the release is the standardization and expansion of metadata injection enabled transformations. Pentaho 6.1 continues the investments focused on agility and automation with greater flexibility in data services, deeper inline modeling and improvements to the foundational enterprise platform. Along with these feature improvements, Pentaho 6.1 includes performance improvements, ease of use improvements, and documentation improvements.

Metadata Injection Improvements

You can now inject metadata into any field of the following Pentaho Data Integration steps:

  • Inputs – Google Analytics and S3 CSV Input
  • Outputs – S3 File Output, Microsoft Excel Output, and XML Output
  • Transforms and Lookups – Split Field, Stream Lookup, and Value Mapper

Besides increased hardening of the ETL Metadata Injection step, we have also added a new example to the ETL Metadata Injection article. Learn more about the ETL Metadata Injection step.

Hide a Calculated Measure in the Data Model

You can hide a calculated measure in the data model. In the Annotate Stream step, select the Hide this calculated measure in the model check box to include the measure as part of the model, but to hide it from users when the data source is opened in Analyzer. Learn more in Using the Annotate Stream Step.

Publish a Data Model with Hidden Attributes

Hide attributes and calculated measures in Analyzer when creating them on a data model in the Annotate dialog box by setting the Hidden property to 'True' to hide the level in Analyzer. The Hidden property is useful for attributes needed to build a proper data model, but not needed for analytic purposes. Learn more in Creating Attributes.

Edit Calculated Measures in Analyzer

You can now update the properties on a calculated measure created via inline model editing within Analyzer, such as if you want to rename the measure or adjust the MDX formula on the calculation. Also, you can now easily identify calculated measures in the Available fields list by the icon, 'f(x)', which only displays next to calculated measures created in Analyzer via inline model editing. Learn more about Using Calculated Measures in an Analyzer Report.

Show and Hide Available Fields

You can select to hide or show fields in the list of Available fields for a report in Analyzer. Hiding fields is helpful when you want a clear view of only those fields you are interested in for your report. When you hide a field, it is no longer available for selection in the report. Learn more about Hide and Unhide Available Fields.

Pentaho Data Service as a Build Model Source

You can use a Pentaho Data Service as the source in your Build Model job entry, which streamlines the ability to generate data models when you are working with virtual tables. Learn more in Using the Build Model Job Entry.

Added Parameter Pushdown Optimization for Data Services

You can improve the performance of your Pentaho data service through the new Parameter Pushdown optimization technique. This technique is helpful if your transformation contains any step that should be optimized, including input steps like REST where a parameter in the URL could limit the results returned by a web service.  For more information about this optimization technique, see the enhanced data service documentation, especially the Develop and Optimize a Pentaho Data Service article.

Improved JSON Input Performance

The JSON library used by Pentaho Data Integration has been replaced. The new library increases speed by up to 10 times or more, and can now handle file of up to hundreds of MBs in size. Although the library has been updated, the user interface to this functionality is fully backward compatible. Learn more about the JSON Input step.

DI Repository on DI Server Renamed to Pentaho Repository

The DI Repository on the DI Server has been renamed to the Pentaho Repository with improved descriptions for possible new repository connections. This change helps you better understand what to select when connecting a repository. Learn more about Working with Repositories.

Driver Download for Data Services in Pentaho Data Integration

When connecting to a Pentaho Data Service from a non-Pentaho tool, you previously needed to manually download a Pentaho Data Service driver and install it. Now in 6.1, you can use the Driver Details dialog in Pentaho Data Integration to download the driver. Learn more in Use Spoon to Download the Pentaho Data Service JDBC Driver.

New Run Options Window

The Execute a transformation and Execute a job windows in Pentaho Data Integration have been replaced with new Run Options windows. These new windows streamline your interaction while running a transformation or job, especially with the Always show dialog on run option. With this option disabled, the Run Options window does not appear the next time you run your transformation or job. The options currently set are reused until you access the Run Options window again. Learn more about Running a Transformation and Running a Job.

New Run Context Menu

Besides the Action menu or by pressing F8 in Pentaho Data Integration, you can access the Run Options window through the new Run context menu. In this menu, select Run to run your transformation or job, and select Run Options to change any of options before running. Learn more about Running a Transformation and Running a Job.

Platform Improvements

We continued with the foundational improvements to the Pentaho Platform first introduced in Pentaho 6.0. Highlights include continued Karaf hardening and Jackrabbit performance improvements. Learn More about Karaf Performance Tuning and Jackrabbit Repository Performance Tuning.

CTools Documentation Added to Help

We've added CTools documentation to the Help. You can now learn the basics of the Community Dashboard Editor (CDE) with the CDE Quick Start Guide and its companion articles:

Improved Prompting Documentation

We've added new dashboard design documentation for the Date Picker prompt. Learn more about Create a Date Picker Prompt.

CDF API Documentation

A full set of API documentation has been created for OEMs who want to use JavaScript APIs to build custom dashboards with the Community Dashboard Framework (CDF). Learn how to build dashboards with the CDF API Documentation for Developers.

Help Site Improvements

Our Help site has been upgraded to a more responsive version of MindTouch. This upgrade improves content readability and simplifies navigation, along with a better interaction on a mobile device. Learn more about the ​Pentaho 6.1 Help.