Get Help and Support
  Help and Support Resources
  Help and Support Resources
Make a Plan
  Get Acquainted with Pentaho Components
    Introducing Pentaho Business Analytics
    Business Analytics
    Data Integration
  Choose Your Workflows
    Introducing Pentaho Workflows and Tracks
      Pentaho Business Analytics
        Evaluate and Learn Pentaho Business Analytics
        Develop Your BA Environment
        Go Live for Production - BA
      Pentaho Data Integration
        Evaluate and Learn Pentaho Data Integration
        Develop Your DI Solution
        Go Live for Production - DI
  Review Supported Technologies
    Components Reference
    JDBC Drivers Reference
  Get Acquainted with Pentaho Components
    Introducing Pentaho Business Analytics
    Business Analytics
    Data Integration
  Choose Your Workflows
    Introducing Pentaho Workflows and Tracks
      Pentaho Business Analytics
        Evaluate and Learn Pentaho Business Analytics
        Develop Your BA Environment
        Go Live for Production - BA
      Pentaho Data Integration
        Evaluate and Learn Pentaho Data Integration
        Develop Your DI Solution
        Go Live for Production - DI
  Review Supported Technologies
    Components Reference
    JDBC Drivers Reference
Install Pentaho Software
  Select Business Analytics (BA) Installation Options
    Introduction
  Install All Components
    Introduction to Pentaho BA Suite Wizard Installation
    Wizard Installation Process Overview
    Prepare Environment
    Install Pentaho BA Suite
    Next Steps
  Install with Your Own BA Repository
    Introduction
    Overview of the Installation Process
    Prepare Environment
    Initialize Repository
    Configure Repository
    Specify Connections
    Start BA Server
    Next Steps
  Use Manual BA Server Installation
    Introduction
    Overview of the Installation Process
    Prepare Environment
    Initialize Repository
    Configure Repository
    Specify Connections
    Prepare Web Application Servers
    Start BA Server
    Next Steps
  Install Only BA Tools
    Introduction
    Overview of BA Design Tool and Plugin Installation Process
    Prepare Environment
    Install BA Design Tools Overview
    Next Steps
  Select Data Integration (DI) Installation Options
    Introduction
  Install All DI Components
    Introduction to DI Wizard Installation
    Wizard Installation Process Overview
    Prepare Environment
    Install PDI
    Next Steps
  Install with Your Own DI Repository
    Introduction
    Overview of the Installation Process
    Prepare Environment
    Initialize Repository
    Configure Repository
    Specify Connections
    Start DI Server
    Next Steps
  Use Manual DI Server Installation
    Introduction
    Overview of the Installation Process
    Prepare Environment
    Initialize Repository
    Configure Repository
    Specify Connections
    Prepare Web Application Servers
    Start DI Server
    Next Steps
  Install Only DI Tools
    Installation of DI Design Tool and Plugins Introduction
    Overview of DI Design Tool and Plugin Installation Process
    Prepare Environment
    Install DI Design Tool and Plugins
    Next Steps
  Select Business Analytics (BA) Installation Options
    Introduction
  Install All Components
    Introduction to Pentaho BA Suite Wizard Installation
    Wizard Installation Process Overview
    Prepare Environment
    Install Pentaho BA Suite
    Next Steps
  Install with Your Own BA Repository
    Introduction
    Overview of the Installation Process
    Prepare Environment
    Initialize Repository
    Configure Repository
    Specify Connections
    Start BA Server
    Next Steps
  Use Manual BA Server Installation
    Introduction
    Overview of the Installation Process
    Prepare Environment
    Initialize Repository
    Configure Repository
    Specify Connections
    Prepare Web Application Servers
    Start BA Server
    Next Steps
  Install Only BA Tools
    Introduction
    Overview of BA Design Tool and Plugin Installation Process
    Prepare Environment
    Install BA Design Tools Overview
    Next Steps
  Select Data Integration (DI) Installation Options
    Introduction
  Install All DI Components
    Introduction to DI Wizard Installation
    Wizard Installation Process Overview
    Prepare Environment
    Install PDI
    Next Steps
  Install with Your Own DI Repository
    Introduction
    Overview of the Installation Process
    Prepare Environment
    Initialize Repository
    Configure Repository
    Specify Connections
    Start DI Server
    Next Steps
  Use Manual DI Server Installation
    Introduction
    Overview of the Installation Process
    Prepare Environment
    Initialize Repository
    Configure Repository
    Specify Connections
    Prepare Web Application Servers
    Start DI Server
    Next Steps
  Install Only DI Tools
    Installation of DI Design Tool and Plugins Introduction
    Overview of DI Design Tool and Plugin Installation Process
    Prepare Environment
    Install DI Design Tool and Plugins
    Next Steps
Configure Pentaho Systems
  Set Up BA Server and Tools
    Introduction
    Configure the BA Server
      Start and Stop BA Server
      Access the User Console
      Manage License Keys for the BA Server
      Specify Data Connections for the BA Server
        Define Native (JDBC) Data Connections for the BA Server
        Define OCI Connections for the BA Server
        Define JNDI Connections for the BA Server
      Define Security for the BA Server
        Use Pentaho Security
      Set Up an Email Server
      Next Steps
    Configure the BA Design Tools
      Start and Stop BA Design Tools
      Specify Data Connections for BA Design Tools
        Define JDBC or OCI Connections For BA Design Tools
        Define JNDI Connections for Report Designer and Metadata Editor
      Next Steps
  Set Up DI Server and Tools
    Introduction
    Configure the DI Server
      Start and Stop the Data Integration Server
      Increase the DI Server Memory Limit
      Access Spoon
      Define Security for the DI Server
        Use Pentaho Security on the DI Server
      Next Steps
    Configure the PDI Design Tools and Utilities
      Start and Stop PDI Design Tools and Utilities
      Increase the Spoon Memory Limit
      Enter Licenses and Connect to the DI Repository
      Next Steps
  Set Up BA Server and Tools
    Introduction
    Configure the BA Server
      Start and Stop BA Server
      Access the User Console
      Manage License Keys for the BA Server
      Specify Data Connections for the BA Server
        Define Native (JDBC) Data Connections for the BA Server
        Define OCI Connections for the BA Server
        Define JNDI Connections for the BA Server
      Define Security for the BA Server
        Use Pentaho Security
      Set Up an Email Server
      Next Steps
    Configure the BA Design Tools
      Start and Stop BA Design Tools
      Specify Data Connections for BA Design Tools
        Define JDBC or OCI Connections For BA Design Tools
        Define JNDI Connections for Report Designer and Metadata Editor
      Next Steps
  Set Up DI Server and Tools
    Introduction
    Configure the DI Server
      Start and Stop the Data Integration Server
      Increase the DI Server Memory Limit
      Access Spoon
      Define Security for the DI Server
        Use Pentaho Security on the DI Server
      Next Steps
    Configure the PDI Design Tools and Utilities
      Start and Stop PDI Design Tools and Utilities
      Increase the Spoon Memory Limit
      Enter Licenses and Connect to the DI Repository
      Next Steps
Walk-Through Tutorials
  Learn About Analysis, Interactive Reports, and Dashboards
    Introduction
    Get Started with Pentaho Reporting Tools
    Tour the Pentaho User Console
    Get Started with Interactive Reports
    Get Started with Analyzer Reports
    Get Started with Dashboard Designer
    Next Steps
  Create Your First Print-Quality Reports
    Introduction to Pentaho Report Designer
    Create a Report with Report Designer
      Design Your Report
      Add a Chart to Your Report
      Add Parameters to Your Report
      Publish Your Report
    Refine Your Report
      More about Row Banding, Data Formatting, and Alignment
    Further Reading
  Get Started with DI
    Introduction
    Use Perspectives Within Spoon
    Create Transformations
      Retrieving Data from a Flat File
        Save Your Transformation
      Filter Records with Missing Postal Codes
      Loading Your Data into a Relational Database
      Retrieving Data from your Lookup File
      Resolving Missing Zip Code Information
      Completing your Transformation
      Run Your Transformation
    Create Jobs
    Schedule Jobs
    Building Business Intelligence Solutions Using Agile BI
      Use Agile BI
      Correct Data Quality
      Create a Top Ten Countries by Sales Chart
      Breaking Down Your Chart by Deal Size
      Wrapping it Up
    Getting Started with PDI and Hadoop
      Pentaho, Big Data, and Hadoop
      About Hadoop
      Big Data Resources
    Why Choose Enterprise Edition?
      Professional, Technical Support
      Enterprise Edition Features
      Certified Software Releases
  Try Instant Template-Based Analysis
    Introduction to Instaview
      What is Instaview?
      Tour Instaview
    Using Instaview
      Connecting to Data in Instaview
      Creating an Analyzer Report in Instaview
      Correcting Data Quality Issues in Instaview
      Clearing and Refreshing the Data Cache in Instaview
      Adding a Filter in Instaview
      Creating Visualizations in Instaview
        Creating a Chart in Instaview
        Creating a Geographic Map in Instaview
      Using Conditional Formatting in Instaview
    Configuring an Existing Instaview
      Opening Existing Instaviews
      Saving an Instaview
      Closing an Instaview
      Deleting an Instaview
      Editing Instaview Data Sources
      Managing Visualizations in Instaview
    Advanced User Topics
      Advanced Analyzer Report Formatting Data in Instaview
        Set Chart Options
      Editing Instaview Data Transformations
      Editing Instaview Metadata Models
  Learn About Analysis, Interactive Reports, and Dashboards
    Introduction
    Get Started with Pentaho Reporting Tools
    Tour the Pentaho User Console
    Get Started with Interactive Reports
    Get Started with Analyzer Reports
    Get Started with Dashboard Designer
    Next Steps
  Create Your First Print-Quality Reports
    Introduction to Pentaho Report Designer
    Create a Report with Report Designer
      Design Your Report
      Add a Chart to Your Report
      Add Parameters to Your Report
      Publish Your Report
    Refine Your Report
      More about Row Banding, Data Formatting, and Alignment
    Further Reading
  Get Started with DI
    Introduction
    Use Perspectives Within Spoon
    Create Transformations
      Retrieving Data from a Flat File
        Save Your Transformation
      Filter Records with Missing Postal Codes
      Loading Your Data into a Relational Database
      Retrieving Data from your Lookup File
      Resolving Missing Zip Code Information
      Completing your Transformation
      Run Your Transformation
    Create Jobs
    Schedule Jobs
    Building Business Intelligence Solutions Using Agile BI
      Use Agile BI
      Correct Data Quality
      Create a Top Ten Countries by Sales Chart
      Breaking Down Your Chart by Deal Size
      Wrapping it Up
    Getting Started with PDI and Hadoop
      Pentaho, Big Data, and Hadoop
      About Hadoop
      Big Data Resources
    Why Choose Enterprise Edition?
      Professional, Technical Support
      Enterprise Edition Features
      Certified Software Releases
  Try Instant Template-Based Analysis
    Introduction to Instaview
      What is Instaview?
      Tour Instaview
    Using Instaview
      Connecting to Data in Instaview
      Creating an Analyzer Report in Instaview
      Correcting Data Quality Issues in Instaview
      Clearing and Refreshing the Data Cache in Instaview
      Adding a Filter in Instaview
      Creating Visualizations in Instaview
        Creating a Chart in Instaview
        Creating a Geographic Map in Instaview
      Using Conditional Formatting in Instaview
    Configuring an Existing Instaview
      Opening Existing Instaviews
      Saving an Instaview
      Closing an Instaview
      Deleting an Instaview
      Editing Instaview Data Sources
      Managing Visualizations in Instaview
    Advanced User Topics
      Advanced Analyzer Report Formatting Data in Instaview
        Set Chart Options
      Editing Instaview Data Transformations
      Editing Instaview Metadata Models
Build Full-Featured Solutions
  Define Initial Data Models
    Introduction
    Get Started with Data Models
    Tour the Data Source Wizard
    Choose A Data Source Type
    Create CSV Data Sources
    Create SQL Query Data Sources
    Create Database Sources
    Tour the Data Source Model Editor
    Edit Data Source Models
    Next Steps
  Create Analysis, Interactive Reports, and Dashboards
    Introduction
    Tour the User Console
    Use Pentaho Interactive Reporting
      Create an Interactive Report
      Filter Reports
        Add Filters to an Interactive Report
          Create Advanced Filters
        Apply a Summary Function
        Apply an Aggregate Function
        Flagging a Filter Constraint for Use as a Dashboard Parameter
        Add a Filter on Date Fields
      Disable Auto Refresh Mode in Interactive Reports
      Enable Row Limits and Query Timeouts
      Refine Your Report
        Edit Report Headers and Footers
        Edit the Report Title
        Reorder and Adjust Columns
      Format Interactive Reports
        Change the Report Template
        Change Page Format and Orientation
        Change a Column Header Name
        Applying Copy/Paste Formatting
        Change the Format of Numeric Values
      Edit Interactive Reports
      Interactive Reports and Report Designer
      Read an Interactive Report in View-Only Mode
      Interactive Reporting Quick Reference
    Use Pentaho Analyzer
      Create a New Analyzer Report
        Add Filters to an Analyzer Report
          Create Date Range Filters
        Add Query Parameters to Analyzer Reports
        Export an Analyzer Report
        Display Member Properties
        Configure Drill-Down Links
        Disable Auto Refresh Mode
        Define Hyperlinks
        Simple Conditional Formatting of Measures
          Conditional Formatting Types
      Analyzer Visualizations
        Set Chart Options
        Display Multi-Charts in Analyzer
        Geography Map Visualizations In Analyzer
          Change Geography Map Visualizations In Analyzer
        Scatter Chart Visualizations In Analyzer
          Change Scatter Chart Visualizations In Analyzer
        Heat Grid Visualizations In Analyzer
          Change Heat Grid Visualizations In Analyzer
    Use Dashboard Designer
      Create a New Dashboard
        Work with the Chart Designer
        Add Data to a Chart
        Work with Pie Charts
        Work with Dial Charts
        Correct Scaling Issues
        Rotate Chart Axis Labels
        Edit a Chart
        Add a Data Table to a Dashboard
        Update the Data Table Display
        Add a Report Designer Report to a Dashboard
        Add an Analyzer Report to a Dashboard
        Add a Web Site to a Dashboard
      Use Prompts on Dashboards
        Add a Prompt to a Dashboard
        Create a Metadata List
        Create a Cascading Prompt
        Edit Prompts
        Link Dashboard Prompts to Analyzer Parameters
      Dashboard Parameters
        Create Chart or Data Table Parameters With the Query Editor
        Dynamic Dashboard Titles
      Use Content Linking to Create Interactive Dashboards
        Link Charts and Data Tables
        Link Columns in a Data Table to Content in other Dashboard Panels
        Create Content to Content Links in an Analyzer Report
        Link an Analyzer Chart to a Report
        Control a Dashboard Parameter From a PRPT Hyperlink
      Add Content to a Dashboard Using Drag-and-Drop
      Adjust White space in Dashboard Panels
      Set the Refresh Interval
    Use Pentaho Mobile
      Set Up Mobile Access
      Get Started with Pentaho Mobile
        Create a Shortcut Using Safari
        Work with the Home Screen
        Navigate Files
        Create and Remove Favorites
        Change Settings
      Work with Pentaho Mobile Tools
        Use the Overlay Toolbar
        Mobile Reports
        Mobile Analyzer
        Mobile Dashboards
    Schedule Reports
      Quartz Cron Attributes
  Design Print-Quality Reports
    Introduction
    How to Start Report Designer
      Start Report Designer on Windows
      Start Report Designer on Linux
      Start Report Designer on OS X
    Report Designer Configuration Directories
      Pentaho Reporting Configuration Files
    Workflow
    Navigate Report Designer
      The Welcome Screen
      The Report Designer Main Toolbar
      Report Designer's Tabbed Views
      The Report Workspace
      The Structure Pane
      The Data Pane
        Function Reference
          Common Functions
          Report Functions
          Summary Functions
          Running Functions
          Advanced Functions
          Chart Data Functions
          Image Functions
          Script Functions
          Deprecated Functions
      The Style Pane
        Style Properties Reference
          Font Styles
          Text Styles
          Text Spacing Styles
          Padding Styles
          Object Styles
          Size & Position Styles
          Links Styles
          Excel Styles
          Sparkline Styles
          Page Behavior Styles
          Border Styles
      The Attributes Pane
        Element Attributes Reference
          Barcode
          Common
          Table of Contents
          Index
          Excel
          HTML
          HTML-Events
          Images
          PDF
          Pentaho
          Query
          Query-Metadata
          Parameter
          Sparkline
          Survey-Scale
          Swing
          Wizard
      The Palette
    Data Sources and Queries
      Supported Data Sources
      Add Data Sources
        Add a JDBC Data Source
          Passing Security Information to a Report over a JDBC Connection
        Add a Metadata Data Source
        Add a Pentaho Data Integration Data Source
        Add an OLAP Data Source
        Add an OLAP (Advanced) Data Source
        Add an XML Data Source
        Add a Table Data Source
        Add Advanced Data Sources
        Add a JNDI Data Source
        Add a MongoDB Data Source
      Create Queries
        Hadoop Hive-Specific SQL Limitations
        Create Queries With SQL Query Designer
        Create Queries With Metadata Query Editor
        Dynamic Query Scripting
        Create Sub-queries With SQL Query Designer
    Add Report Elements
      Report Layout Types
      Add Standard Design Elements
      Align Elements
      Add Bands
      Create Sub-Reports
      Refer to Report Elements by Name or Column Position
      Create a Table of Contents
      Create an Index
    Create Charts
      Choose the Right Chart Type
      Create a JFreeChart Element
      Create a Sparkline Chart
        Sparkline
    Apply Formatting to Report Elements
      Standard Element Formatting
      Create Hyperlinks on Visualizations
        Create a Link to a Report on a Chart
      Paste Formatting
      Morph an Element
      Implement Row Banding
    Perform Calculations
      Use the Formula Editor
        Common Formulas
          Conditional Formatting
          Calculated Dates
          Date and Time Parameters
          Page Numbering
      Summarize Data in Groups
    Output Parameterization
      Simple SQL Output Parameterization
      Advanced SQL Output Parameterization
      Simple Metadata Output Parameterization
      Simple OLAP Output Parameterization
    Integration With the Pentaho BA Server
      Publish to the BA Server
      Edit an Interactive Report
      Hiding Reports
      Link Reports
        Link in Tabs
    Localize a Report
      Use Externalized Message Bundles
    Create Report Design Wizard and Interactive Reporting Templates
      Report Design Wizard Template Design Guidelines
      Interactive Reporting Template Design Guidelines
      Dynamic Element Positioning in Templates
      Template Properties
      Deploy a Template to Report Design Wizard
      Deploy a Template to Interactive Reporting
      Set the Default Interactive Reporting Template
    Troubleshoot Report Designer
      Report Elements With Dynamic Heights Overlap Other Elements
      Columns Unexpectedly Merge When Exporting to Excel
    Tutorials
      Create a Report with Report Designer
        Design Your Report
        Refine Your Report
          More about Row Banding, Data Formatting, and Alignment
        Add a Chart to Your Report
        Add Parameters to Your Report
        Publish Your Report
    Chart Types
      Bar
        Data Collectors
          CategorySet
          PivotCategorySet
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            stacked
            stacked-percent
            horizontal
            bar-borders
            max-bar-width
            series-color
          General
            3-D
            gridlines
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-axis-label-width
            x-axis-label-rotation
            show-labels
            label-rotation
            numeric-format
            text-format
            date-format
            category-margin
            lower-margin
            upper-margin
            item-margin
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Line
        Data Collectors
          CategorySet
          PivotCategorySet
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            line-style
            line-size
            show-markers
            horizontal
            series-color
          General
            3-D
            gridlines
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-axis-label-width
            x-axis-label-rotation
            show-labels
            label-rotation
            numeric-format
            text-format
            date-format
            category-margin
            lower-margin
            upper-margin
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
            Scripting
              Chart Post Processing Script Language
              Chart Post Processing Script
      Area
        Data Collectors
          CategorySet
          PivotCategorySet
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            stacked
            stacked-percent
            horizontal
            series-color
          General
            3-D
            gridlines
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-axis-label-width
            x-axis-label-rotation
            show-labels
            label-rotation
            numeric-format
            text-format
            date-format
            category-margin
            lower-margin
            upper-margin
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Pie
        Data Collectors
          PieSet
        Chart Properties
          Required
            name
            data-source
            ignore-nulls
            ignore-zeros
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            slice-colors
            show-labels
            label-font
            label-format
            rotate-clockwise
            explode-slice
            explode-pct
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            shadow-paint
            shadow-x-offset
            shadow-y-offset
            url-formula
            tooltip-formula
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
            legend-label-format
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Multi-Pie
        Data Collectors
          CategorySet
          PivotCategorySet
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            by-row
            series-color
            show-labels
            label-font
            label-format
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            shadow-paint
            shadow-x-offset
            shadow-y-offset
            url-formula
            tooltip-formula
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Bar Line Combination
        Data Collectors
          CategorySet
          PivotCategorySet
        Chart Properties
          Required
            name
            bar-data-source
            line-data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            stacked
            stacked-percent
            horizontal
            series-color
            max-bar-width
            bar-borders
            ctgry-tick-font
            line-style
            line-size
            show-markers
            line-series
            lines-label-font
            line-tick-fmt
            line-tick-font
          General
            3-D
            gridlines
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-axis-label-width
            x-axis-label-rotation
            show-labels
            label-rotation
            numeric-format
            text-format
            date-format
            category-margin
            lower-margin
            upper-margin
            item-margin
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
            y2-same-as-y-axis
            y2-axis-title
            y2-font
            y2-tick-interval
            y2-tick-font
            y2-min
            y2-max
            y2-tick-period
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Ring
        Data Collectors
          PieSet
        Chart Properties
          Required
            name
            data-source
            ignore-nulls
            ignore-zeros
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            slice-colors
            show-labels
            label-font
            label-format
            rotate-clockwise
            explode-slice
            explode-pct
            section-depth
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            shadow-paint
            shadow-x-offset
            shadow-y-offset
            tooltip-formula
            url-formula
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
            legend-label-format
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Bubble
        Data Collectors
          XYZSeries
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
            pos-title
          Options
            horizontal
            series-color
            max-bubble-size
            show-labels
            label-font
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            anti-alias
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-sticky-0
            x-incl-0
            x-min
            x-max
            x-tick-interval
            x-vtick-label
            x-tick-font
            x-tick-fmt-str
            x-tick-period
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Scatter Plot
        Data Collectors
          TimeSeries
          XYSeries
          XYZSeries
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
            pos-title
          Options
            stacked
            horizontal
            series-color
            dot-height
            dot-width
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            anti-alias
            show-labels
            label-font
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-sticky-0
            x-incl-0
            x-min
            x-max
            x-tick-interval
            x-vtick-label
            x-tick-font
            x-tick-fmt-str
            x-tick-period
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      XY Bar
        Data Collectors
          TimeSeries
          XYSeries
          XYZSeries
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
            pos-title
          Options
            stacked
            horizontal
            series-color
            bar-borders
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            anti-alias
            show-labels
            label-font
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-sticky-0
            x-incl-0
            x-min
            x-max
            x-tick-interval
            x-vtick-label
            x-tick-font
            x-tick-fmt-str
            x-tick-period
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      XY Line
        Data Collectors
          TimeSeries
          XYSeries
          XYZSeries
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
            pos-title
          Options
            stacked
            horizontal
            series-color
            line-style
            line-size
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            anti-alias
            show-labels
            label-font
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-sticky-0
            x-incl-0
            x-min
            x-max
            x-tick-interval
            x-vtick-label
            x-tick-font
            x-tick-fmt-str
            x-tick-period
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      XY Area
        Data Collectors
          TimeSeries
          XYSeries
          XYZSeries
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title-field
            title-font
            pos-title
            chart-title
          Options
            stacked
            horizontal
            series-color
            line-style
            line-size
            show-markers
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            anti-alias
            label-font
            show-labels
            tooltip-formula
            url-formula
          X Axis
            x-axis-title
            x-font
            x-sticky-0
            x-incl-0
            x-min
            x-max
            x-tick-interval
            x-vtick-label
            x-tick-font
            x-tick-fmt-str
            x-tick-period
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      XY Extended Line (XY Step, XY StepArea, XY Difference)
        Data Collectors
          TimeSeries
          XYSeries
          XYZSeries
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
            pos-title
          Options
            ext-chart-type
            stacked
            horizontal
            series-color
            line-style
            line-size
            show-markers
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            anti-alias
            show-labels
            label-font
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-sticky-0
            x-incl-0
            x-min
            x-max
            x-tick-interval
            x-vtick-label
            x-tick-font
            x-tick-fmt-str
            x-tick-period
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Waterfall
        Data Collectors
          CategorySet
          PivotCategorySet
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            horizontal
            series-color
          General
            3-D
            gridlines
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-axis-label-width
            x-axis-label-rotation
            show-labels
            label-rotation
            numeric-format
            text-format
            date-format
            category-margin
            lower-margin
            upper-margin
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Radar
        Data Collectors
          CategorySet
          PivotCategorySet
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            line-size
            head-size
            series-color
            gridline-interval
            radar-web-filled
          General
            3-D
            gridlines
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
          X Axis
            x-font
            show-labels
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
  Create DI Solutions
    Introduction
    Pentaho Data Integration Architecture
    Use Pentaho Data Integration
      Create a Connection to the DI Repository
    Interface Perspectives
      Use Perspectives Within Spoon
      Tour Spoon
        VFS File Dialogues in Spoon
      Model Perspective
      Visualization Perspective
      Instaview Perspective
      Customizing the Spoon Interface
    Terminology and Basic Concepts
      Transformations, Steps, and Hops
      Jobs
      More About Hops
    Create Transformations
      Get Started
      Save Your Transformation
      Run Your Transformation Locally
      Build a Job
    Executing Transformations
      Initialize Slave Servers in Spoon
      Executing Jobs and Transformations from the Repository on the Carte Server
      Impact Analysis
    Working with the DI Repository
      Deleting a Repository
      Managing Content in the DI Repository
        Setting Folder-Level Permissions
          Access Control List (ACL) Permissions
        Exporting Content from Solutions Repositories with Command-Line Tools
      Working with Version Control
        Examining Version History
        Restoring a Previously Saved Version of a Job or Transformation
    Reusing Transformation Flows with Mapping Steps
    Arguments, Parameters, and Variables
      Arguments
      Parameters
        VFS Properties
          Configure SFTP VFS
      Variables
        Variable Scope
          Environment Variables
          Kettle Variables
        Internal Variables
    Rapid Analysis Schema Prototyping
      Creating a Prototype Schema With a Non-PDI Data Source
      Creating a Prototype Schema With a PDI Data Source
      Testing With Pentaho Analyzer and Report Wizard
      Prototypes in Production
    Using the SQL Editor
    Using the Database Explorer
    Unsupported Databases
    Performance Monitoring and Logging
      Monitoring Step Performance
        Using Performance Graphs
      Logging Steps
      Logging Transformations
      Pentaho Data Integration Performance Tuning Tips
    Working with Big Data and Hadoop in PDI
      Pentaho MapReduce Workflow
      PDI Hadoop Job Workflow
      Hadoop to PDI Data Type Conversion
      Hadoop Hive-Specific SQL Limitations
      Big Data Tutorials
        Hadoop Tutorials
          Loading Data into a Hadoop Cluster
            Prerequisites
              Sample Data
            Using a Job Entry to Load Data into Hadoop's Distributed File System (HDFS)
            Using a Job Entry to Load Data into Hive
            Using a Transformation Step to Load Data into HBase
          Transforming Data within a Hadoop Cluster
          Extracting Data from a Hadoop Cluster
          Reporting on Data within a Hadoop Cluster
        MapR Tutorials
          Loading Data into a MapR Cluster
          Transforming Data within a MapR Cluster
          Extracting Data from a MapR Cluster
          Reporting on Data within a MapR Cluster
        Cassandra Tutorials
        MongoDB Tutorials
    Implement Data Services with the Thin Kettle JDBC Driver
    Transactional Databases and Job Rollback
    Interacting With Web Services
    Scheduling and Scripting PDI Content
      Scheduling Transformations and Jobs From Spoon
      Command-Line Scripting Through Pan and Kitchen
        Pan Options and Syntax
          Pan Status Codes
        Kitchen Options and Syntax
          Kitchen Status Codes
        Importing KJB or KTR Files From a Zip Archive
        Connecting to a DI Solution Repositories with Command-Line Tools
        Exporting Content from Solutions Repositories with Command-Line Tools
    Transformation Step Reference
      Big Data
        Avro Input
        Cassandra Input
        Cassandra Output
        CouchDB Input
        Hadoop File Input
        Hadoop File Output
        HBase Input
        HBase Output
        HBase Row Decoder
        MapReduce Input
        MapReduce Output
        MongoDB Input
        MongoDB Output
        Splunk Input
        Splunk Output
        SSTable Output
      Input
        Cassandra Input
        CSV File Input
        Data Grid
        De-serialize From File
        Email Messages Input
        ESRI Shapefile Reader
        Fixed File Input
        Generate Random Credit Card Numbers
        Generate Random Value
        Generate Rows
        Get Data From XML
        Get File Names
        Get Files Rows Count
        Get Repository Names
        Get Subfolder Names
        Get System Info
        Get Table Names
        Google Analytics Input
          Setting Up Google Analytics API
          Google Analytics Plugin Installation
        Google Docs Input
        GZIP CSV Input
        HBase Input
        HL7 Input
        JMS Consumer
        JSON Input
        LDAP Input
        LDIF Input
        Load File Content In Memory
        Microsoft Access Input
        Microsoft Excel Input
        Mondrian Input
        MongoDB Input
        OLAP Input
        OpenERP Object Input
        Palo Cell Input
        Palo Dim Input
        Property Input
        Splunk Input
        RSS Input
        S3 CSV Input
        Salesforce Input
        SAP Input
        SAS Input
        Table Input
        Text File Input
        XBase Input
        XML Input Stream (StAX)
        YAML Input
      Output
        Automatic Documentation Output
        Cassandra Output
        Delete
        HBase Output
        Insert/Update
        JMS Producer
        JSON Output
        LDAP Output
        Microsoft Access Output
        Microsoft Excel Output
        Microsoft Excel Writer
        MongoDB Output
        OpenERP Object Input
        Palo Cell Output
        Palo Dim Output
        Pentaho Reporting Output
        Properties Output
        RSS Output
        S3 File Output
        Salesforce Delete
        Salesforce Insert
        Salesforce Update
        Salesforce Upsert
        Serialize to File
        Splunk Output
        SQL File Output
        Synchronize After Merge
        Table Output
        Text File Output
        Update
        XML Output
      Transform
        Add a Checksum
        Add Constants
        Add Sequence
        Add Value Fields Changing Sequence
        Add XML
        Calculator
        Closure Generator
        Example Plugin
        Get ID From Slave Server
        Number Range
        Replace in String
        Row Denormalizer
        Row Flattener
        Row Normalizer
        Select Values
        Set Field Value
        Set Field Value to a Constant
        Sort Rows
        Split Field to Rows
        Split Fields
        String Operations
        Strings Cut
        Unique Rows
        Unique Rows (HashSet)
        Value Mapper
        XSL Transformation
      Utility
        Change File Encoding
        Clone Row
        Delay Row
        Edit to XML
        Execute a Process
        If Field Value is Null
        Mail
        Metadata Structure of Stream
        Null if...
        Process Files
        Run SSH Commands
        Send Message to Syslog
        Write to Log
      Flow
        Abort
        Append Streams
        Block This Step Until Steps Finish
        Blocking Step
        Detect Empty Stream
        Dummy (do nothing)
        ETL Metadata Injection
        Filter Rows
        Identify Last Row in a Stream
        Java Filter
        Prioritize Streams
        Single Threader
        Switch / Case
      Scripting
        Execute Row SQL Script
        Execute SQL Script
        Formula
        Modified JavaScript Value
        Regex Evaluation
        User Defined Java Class
        User Defined Java Expression
      Lookup
        Call DB Procedure
        Check if a Column Exists
        Check if File is Locked
        Check if Webservice is Available
        Database Join
        Database Lookup
        Dynamic SQL Row
        File Exists
        Fuzzy Match
        HTTP Client
        HTTP Post
        MaxMind GeoIP Lookup
        RESTClient
        Stream Lookup
        Table Exists
        Web Services Lookup
      Joins
        Join Rows (Cartesian Product)
        Merge Join
        Merge Rows (diff)
        Sorted Merge
        XML Join
      Data Warehouse
        Combination Lookup/Update
        Dimension Lookup/Update
      Validation
        Credit Card Validator
        Data Validator
        Mail Validator
        XSD Validator
      Statistics
        Analytic Query
        Group By
        Memory Group By
        Output Steps Metrics
        Reservoir Sampling
        Sample Rows
        Univariate Statistics
      Palo
        Palo Cell Input
        Palo Cell Output
        Palo Dim Input
        Palo Dim Output
      Job
        Copy Rows to Result
        Get Files From Result
        Get Rows From Result
        Get Variables
        Set Files in Result
        Set Variables
      Mapping
        Mapping (sub-transformation)
        Mapping Input Specification
        Mapping Output Specification
      Bulk Loading
        ElasticSearch Bulk Insert
        Greenplum Bulk Loader
        Greenplum Load
        Infobright Loader
        Ingres VectorWise Bulk Loader
        LucidDB Streaming Loader
        MonetDB Bulk Loader
        MySQL Bulk Loader
        Oracle Bulk Loader
        PostgreSQL Bulk Loader
        Teradata Fastload Bulk Loader
      Inline
        Injector
        Socket Reader
        Socket Writer
      Data Mining Steps
        Weka Scoring
        Reservoir Sampling
        ARFF Output
        Univariate Statistics
        Knowledge Flow
        Univariate Statistics
        Weka Forecasting
    Job Entry Reference
      File Encryption
        Decrypt Files With PGP
        Encrypt Files With PGP
        Verify File Signature With PGP
      Big Data
        Amazon EMR Job Executor
        Amazon Hive Job Executor
        Hadoop Copy Files
        Hadoop Job Executor
        Oozie Job Executor
        Pentaho MapReduce
        Pig Script Executor
        Sqoop Export
        Sqoop Import
      General
        Start
        Dummy
        Example Plugin
        Job
        Set Variables
        Success
        Transformation
      Mail
        Get Mails (POP3/IMAP)
        Mail
        Mail Validator
      File Management
        Add Filenames to Result
        Compare Folders
        Convert File Between DOS and Unix
        Copy Files
        Copy or Remove Result Filenames
        Create a Folder
        Create File
        Delete File
        Delete Filenames From Result
        Delete Files
        Delete Folders
        File Compare
        HTTP
        Move Files
        Unzip File
        Wait For File
        Write to File
        Zip File
      Conditions
        Check DB Connections
        Check Files Locked
        Check If a Folder is Empty
        Check Webservice Availability
        Checks If Files Exist
        Columns Exist in a Table
        Evaluate Files Metrics
        Evaluate Rows Number in a Table
        File Exists
        Simple Evaluation
        Table Exists
        Wait For
      Scripting
        JavaScript
        Shell
        SQL
      Bulk Loading
        Bulkload From MySQL Into File
        Bulkload Into MSSQL
        Bulkload Into MySQL
        MS Access Bulk Load
      XML
        Check if XML FIle is Well-Formed
        DTD Validator
        XSD Validator
        XSL Transformation
      Utility
        Abort Job
        Display Msgbox Info
        HL7 MLLP Acknowledge
        HL7 MLLP Input
        Ping a Host
        Send Information Using Syslog
        Send SNMP Trap
        Talend Job Execution
        Truncate Tables
        Wait for SQL
        Write to Log
      Repository
        Check if Connected to Repository
        Export Repository to XML File
      File Transfer
        FTP Delete
        Get a File with FTP
        Get a File With FTPS
        Get a file with SFTP
        Put a File With FTP
        Put a File With SFTP
        SSH2 Get
        SSH2 Put
        Upload Files to FTPS
      Palo
        Palo Cube Create
        Palo Cube Delete
    About PDI Marketplace
    Troubleshooting
      Changing the Pentaho Data Integration Home Directory Location (.kettle folder)
        Changing the Kettle Home Directory within the Pentaho BI Platform
      Kitchen can't read KJBs from a Zip export
      Generating a DI Repository Configuration Without Running Spoon
        Connecting to a DI Solution Repositories with Command-Line Tools
      Unable to Get List of Repositories Exception
        Executing Jobs and Transformations from the Repository on the Carte Server
      Database Locks When Reading and Updating From A Single Table
        Reading and Updating Table Rows Within a Transformation
      Force PDI to use DATE instead of TIMESTAMP in Parameterized SQL Queries
      PDI Does Not Recognize Changes Made To a Table
      Using ODBC
      Sqoop Import into Hive Fails
  Work with Big Data
    Getting Started with PDI and Hadoop
      Pentaho, Big Data, and Hadoop
      About Hadoop
      Big Data Resources
    Configuring Your Big Data Environment
      Setting the Active Hadoop Configuration
        Define Hadoop Connections
        Configure Spoon for MapR
      Creating a New Hadoop Configuration
    Working with Big Data and Hadoop in PDI
      Pentaho MapReduce Workflow
      PDI Hadoop Job Workflow
      Hadoop to PDI Data Type Conversion
      Hadoop Hive-Specific SQL Limitations
      Big Data Tutorials
        Hadoop Tutorials
          Loading Data into a Hadoop Cluster
            Prerequisites
              Sample Data
            Using a Job Entry to Load Data into Hadoop's Distributed File System (HDFS)
            Using a Job Entry to Load Data into Hive
            Using a Transformation Step to Load Data into HBase
          Transforming Data within a Hadoop Cluster
          Extracting Data from a Hadoop Cluster
          Reporting on Data within a Hadoop Cluster
        MapR Tutorials
          Loading Data into a MapR Cluster
          Transforming Data within a MapR Cluster
          Extracting Data from a MapR Cluster
          Reporting on Data within a MapR Cluster
        Cassandra Tutorials
        MongoDB Tutorials
    PDI Hadoop Configurations
      Including/Excluding Classes or Packages for a Hadoop Configuration
    PDI Big Data Transformation Steps
      Avro Input
      Cassandra Input
      Cassandra Output
      CouchDB Input
      Hadoop File Input
      Hadoop File Output
      HBase Input
      HBase Output
      HBase Row Decoder
      MapReduce Input
      MapReduce Output
      MongoDB Input
      MongoDB Output
      Splunk Input
      Splunk Output
      SSTable Output
    PDI Big Data Job Entries
      Amazon EMR Job Executor
      Amazon Hive Job Executor
      Hadoop Copy Files
      Hadoop Job Executor
      Oozie Job Executor
      Pentaho MapReduce
      Pig Script Executor
      Sqoop Export
      Sqoop Import
  Define Initial Data Models
    Introduction
    Get Started with Data Models
    Tour the Data Source Wizard
    Choose A Data Source Type
    Create CSV Data Sources
    Create SQL Query Data Sources
    Create Database Sources
    Tour the Data Source Model Editor
    Edit Data Source Models
    Next Steps
  Create Analysis, Interactive Reports, and Dashboards
    Introduction
    Tour the User Console
    Use Pentaho Interactive Reporting
      Create an Interactive Report
      Filter Reports
        Add Filters to an Interactive Report
          Create Advanced Filters
        Apply a Summary Function
        Apply an Aggregate Function
        Flagging a Filter Constraint for Use as a Dashboard Parameter
        Add a Filter on Date Fields
      Disable Auto Refresh Mode in Interactive Reports
      Enable Row Limits and Query Timeouts
      Refine Your Report
        Edit Report Headers and Footers
        Edit the Report Title
        Reorder and Adjust Columns
      Format Interactive Reports
        Change the Report Template
        Change Page Format and Orientation
        Change a Column Header Name
        Applying Copy/Paste Formatting
        Change the Format of Numeric Values
      Edit Interactive Reports
      Interactive Reports and Report Designer
      Read an Interactive Report in View-Only Mode
      Interactive Reporting Quick Reference
    Use Pentaho Analyzer
      Create a New Analyzer Report
        Add Filters to an Analyzer Report
          Create Date Range Filters
        Add Query Parameters to Analyzer Reports
        Export an Analyzer Report
        Display Member Properties
        Configure Drill-Down Links
        Disable Auto Refresh Mode
        Define Hyperlinks
        Simple Conditional Formatting of Measures
          Conditional Formatting Types
      Analyzer Visualizations
        Set Chart Options
        Display Multi-Charts in Analyzer
        Geography Map Visualizations In Analyzer
          Change Geography Map Visualizations In Analyzer
        Scatter Chart Visualizations In Analyzer
          Change Scatter Chart Visualizations In Analyzer
        Heat Grid Visualizations In Analyzer
          Change Heat Grid Visualizations In Analyzer
    Use Dashboard Designer
      Create a New Dashboard
        Work with the Chart Designer
        Add Data to a Chart
        Work with Pie Charts
        Work with Dial Charts
        Correct Scaling Issues
        Rotate Chart Axis Labels
        Edit a Chart
        Add a Data Table to a Dashboard
        Update the Data Table Display
        Add a Report Designer Report to a Dashboard
        Add an Analyzer Report to a Dashboard
        Add a Web Site to a Dashboard
      Use Prompts on Dashboards
        Add a Prompt to a Dashboard
        Create a Metadata List
        Create a Cascading Prompt
        Edit Prompts
        Link Dashboard Prompts to Analyzer Parameters
      Dashboard Parameters
        Create Chart or Data Table Parameters With the Query Editor
        Dynamic Dashboard Titles
      Use Content Linking to Create Interactive Dashboards
        Link Charts and Data Tables
        Link Columns in a Data Table to Content in other Dashboard Panels
        Create Content to Content Links in an Analyzer Report
        Link an Analyzer Chart to a Report
        Control a Dashboard Parameter From a PRPT Hyperlink
      Add Content to a Dashboard Using Drag-and-Drop
      Adjust White space in Dashboard Panels
      Set the Refresh Interval
    Use Pentaho Mobile
      Set Up Mobile Access
      Get Started with Pentaho Mobile
        Create a Shortcut Using Safari
        Work with the Home Screen
        Navigate Files
        Create and Remove Favorites
        Change Settings
      Work with Pentaho Mobile Tools
        Use the Overlay Toolbar
        Mobile Reports
        Mobile Analyzer
        Mobile Dashboards
    Schedule Reports
      Quartz Cron Attributes
  Design Print-Quality Reports
    Introduction
    How to Start Report Designer
      Start Report Designer on Windows
      Start Report Designer on Linux
      Start Report Designer on OS X
    Report Designer Configuration Directories
      Pentaho Reporting Configuration Files
    Workflow
    Navigate Report Designer
      The Welcome Screen
      The Report Designer Main Toolbar
      Report Designer's Tabbed Views
      The Report Workspace
      The Structure Pane
      The Data Pane
        Function Reference
          Common Functions
          Report Functions
          Summary Functions
          Running Functions
          Advanced Functions
          Chart Data Functions
          Image Functions
          Script Functions
          Deprecated Functions
      The Style Pane
        Style Properties Reference
          Font Styles
          Text Styles
          Text Spacing Styles
          Padding Styles
          Object Styles
          Size & Position Styles
          Links Styles
          Excel Styles
          Sparkline Styles
          Page Behavior Styles
          Border Styles
      The Attributes Pane
        Element Attributes Reference
          Barcode
          Common
          Table of Contents
          Index
          Excel
          HTML
          HTML-Events
          Images
          PDF
          Pentaho
          Query
          Query-Metadata
          Parameter
          Sparkline
          Survey-Scale
          Swing
          Wizard
      The Palette
    Data Sources and Queries
      Supported Data Sources
      Add Data Sources
        Add a JDBC Data Source
          Passing Security Information to a Report over a JDBC Connection
        Add a Metadata Data Source
        Add a Pentaho Data Integration Data Source
        Add an OLAP Data Source
        Add an OLAP (Advanced) Data Source
        Add an XML Data Source
        Add a Table Data Source
        Add Advanced Data Sources
        Add a JNDI Data Source
        Add a MongoDB Data Source
      Create Queries
        Hadoop Hive-Specific SQL Limitations
        Create Queries With SQL Query Designer
        Create Queries With Metadata Query Editor
        Dynamic Query Scripting
        Create Sub-queries With SQL Query Designer
    Add Report Elements
      Report Layout Types
      Add Standard Design Elements
      Align Elements
      Add Bands
      Create Sub-Reports
      Refer to Report Elements by Name or Column Position
      Create a Table of Contents
      Create an Index
    Create Charts
      Choose the Right Chart Type
      Create a JFreeChart Element
      Create a Sparkline Chart
        Sparkline
    Apply Formatting to Report Elements
      Standard Element Formatting
      Create Hyperlinks on Visualizations
        Create a Link to a Report on a Chart
      Paste Formatting
      Morph an Element
      Implement Row Banding
    Perform Calculations
      Use the Formula Editor
        Common Formulas
          Conditional Formatting
          Calculated Dates
          Date and Time Parameters
          Page Numbering
      Summarize Data in Groups
    Output Parameterization
      Simple SQL Output Parameterization
      Advanced SQL Output Parameterization
      Simple Metadata Output Parameterization
      Simple OLAP Output Parameterization
    Integration With the Pentaho BA Server
      Publish to the BA Server
      Edit an Interactive Report
      Hiding Reports
      Link Reports
        Link in Tabs
    Localize a Report
      Use Externalized Message Bundles
    Create Report Design Wizard and Interactive Reporting Templates
      Report Design Wizard Template Design Guidelines
      Interactive Reporting Template Design Guidelines
      Dynamic Element Positioning in Templates
      Template Properties
      Deploy a Template to Report Design Wizard
      Deploy a Template to Interactive Reporting
      Set the Default Interactive Reporting Template
    Troubleshoot Report Designer
      Report Elements With Dynamic Heights Overlap Other Elements
      Columns Unexpectedly Merge When Exporting to Excel
    Tutorials
      Create a Report with Report Designer
        Design Your Report
        Refine Your Report
          More about Row Banding, Data Formatting, and Alignment
        Add a Chart to Your Report
        Add Parameters to Your Report
        Publish Your Report
    Chart Types
      Bar
        Data Collectors
          CategorySet
          PivotCategorySet
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            stacked
            stacked-percent
            horizontal
            bar-borders
            max-bar-width
            series-color
          General
            3-D
            gridlines
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-axis-label-width
            x-axis-label-rotation
            show-labels
            label-rotation
            numeric-format
            text-format
            date-format
            category-margin
            lower-margin
            upper-margin
            item-margin
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Line
        Data Collectors
          CategorySet
          PivotCategorySet
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            line-style
            line-size
            show-markers
            horizontal
            series-color
          General
            3-D
            gridlines
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-axis-label-width
            x-axis-label-rotation
            show-labels
            label-rotation
            numeric-format
            text-format
            date-format
            category-margin
            lower-margin
            upper-margin
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
            Scripting
              Chart Post Processing Script Language
              Chart Post Processing Script
      Area
        Data Collectors
          CategorySet
          PivotCategorySet
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            stacked
            stacked-percent
            horizontal
            series-color
          General
            3-D
            gridlines
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-axis-label-width
            x-axis-label-rotation
            show-labels
            label-rotation
            numeric-format
            text-format
            date-format
            category-margin
            lower-margin
            upper-margin
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Pie
        Data Collectors
          PieSet
        Chart Properties
          Required
            name
            data-source
            ignore-nulls
            ignore-zeros
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            slice-colors
            show-labels
            label-font
            label-format
            rotate-clockwise
            explode-slice
            explode-pct
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            shadow-paint
            shadow-x-offset
            shadow-y-offset
            url-formula
            tooltip-formula
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
            legend-label-format
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Multi-Pie
        Data Collectors
          CategorySet
          PivotCategorySet
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            by-row
            series-color
            show-labels
            label-font
            label-format
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            shadow-paint
            shadow-x-offset
            shadow-y-offset
            url-formula
            tooltip-formula
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Bar Line Combination
        Data Collectors
          CategorySet
          PivotCategorySet
        Chart Properties
          Required
            name
            bar-data-source
            line-data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            stacked
            stacked-percent
            horizontal
            series-color
            max-bar-width
            bar-borders
            ctgry-tick-font
            line-style
            line-size
            show-markers
            line-series
            lines-label-font
            line-tick-fmt
            line-tick-font
          General
            3-D
            gridlines
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-axis-label-width
            x-axis-label-rotation
            show-labels
            label-rotation
            numeric-format
            text-format
            date-format
            category-margin
            lower-margin
            upper-margin
            item-margin
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
            y2-same-as-y-axis
            y2-axis-title
            y2-font
            y2-tick-interval
            y2-tick-font
            y2-min
            y2-max
            y2-tick-period
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Ring
        Data Collectors
          PieSet
        Chart Properties
          Required
            name
            data-source
            ignore-nulls
            ignore-zeros
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            slice-colors
            show-labels
            label-font
            label-format
            rotate-clockwise
            explode-slice
            explode-pct
            section-depth
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            shadow-paint
            shadow-x-offset
            shadow-y-offset
            tooltip-formula
            url-formula
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
            legend-label-format
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Bubble
        Data Collectors
          XYZSeries
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
            pos-title
          Options
            horizontal
            series-color
            max-bubble-size
            show-labels
            label-font
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            anti-alias
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-sticky-0
            x-incl-0
            x-min
            x-max
            x-tick-interval
            x-vtick-label
            x-tick-font
            x-tick-fmt-str
            x-tick-period
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Scatter Plot
        Data Collectors
          TimeSeries
          XYSeries
          XYZSeries
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
            pos-title
          Options
            stacked
            horizontal
            series-color
            dot-height
            dot-width
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            anti-alias
            show-labels
            label-font
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-sticky-0
            x-incl-0
            x-min
            x-max
            x-tick-interval
            x-vtick-label
            x-tick-font
            x-tick-fmt-str
            x-tick-period
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      XY Bar
        Data Collectors
          TimeSeries
          XYSeries
          XYZSeries
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
            pos-title
          Options
            stacked
            horizontal
            series-color
            bar-borders
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            anti-alias
            show-labels
            label-font
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-sticky-0
            x-incl-0
            x-min
            x-max
            x-tick-interval
            x-vtick-label
            x-tick-font
            x-tick-fmt-str
            x-tick-period
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      XY Line
        Data Collectors
          TimeSeries
          XYSeries
          XYZSeries
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
            pos-title
          Options
            stacked
            horizontal
            series-color
            line-style
            line-size
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            anti-alias
            show-labels
            label-font
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-sticky-0
            x-incl-0
            x-min
            x-max
            x-tick-interval
            x-vtick-label
            x-tick-font
            x-tick-fmt-str
            x-tick-period
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      XY Area
        Data Collectors
          TimeSeries
          XYSeries
          XYZSeries
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title-field
            title-font
            pos-title
            chart-title
          Options
            stacked
            horizontal
            series-color
            line-style
            line-size
            show-markers
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            anti-alias
            label-font
            show-labels
            tooltip-formula
            url-formula
          X Axis
            x-axis-title
            x-font
            x-sticky-0
            x-incl-0
            x-min
            x-max
            x-tick-interval
            x-vtick-label
            x-tick-font
            x-tick-fmt-str
            x-tick-period
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      XY Extended Line (XY Step, XY StepArea, XY Difference)
        Data Collectors
          TimeSeries
          XYSeries
          XYZSeries
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
            pos-title
          Options
            ext-chart-type
            stacked
            horizontal
            series-color
            line-style
            line-size
            show-markers
          General
            3-D
            bg-color
            bg-image
            show-border
            border-color
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            anti-alias
            show-labels
            label-font
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-sticky-0
            x-incl-0
            x-min
            x-max
            x-tick-interval
            x-vtick-label
            x-tick-font
            x-tick-fmt-str
            x-tick-period
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Waterfall
        Data Collectors
          CategorySet
          PivotCategorySet
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            horizontal
            series-color
          General
            3-D
            gridlines
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
            url-formula
            tooltip-formula
          X Axis
            x-axis-title
            x-font
            x-axis-label-width
            x-axis-label-rotation
            show-labels
            label-rotation
            numeric-format
            text-format
            date-format
            category-margin
            lower-margin
            upper-margin
          Y Axis
            y-axis-title
            y-font
            y-sticky-0
            y-incl-0
            y-auto-range
            y-min
            y-max
            y-tick-interval
            y-tick-font
            y-tick-fmt-str
            y-tick-period
            enable-log-axis
            log-format
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
      Radar
        Data Collectors
          CategorySet
          PivotCategorySet
        Chart Properties
          Required
            name
            data-source
            no-data-message
          Title
            chart-title
            chart-title-field
            title-font
          Options
            line-size
            head-size
            series-color
            gridline-interval
            radar-web-filled
          General
            3-D
            gridlines
            bg-color
            bg-image
            show-border
            border-color
            anti-alias
            plot-bg-color
            plot-fg-alpha
            plot-bg-alpha
            plot-border
          X Axis
            x-font
            show-labels
          Legend
            show-legend
            location
            legend-bg-color
            legend-border
            legend-font
            legend-font-color
          Scripting
            Chart Post Processing Script Language
            Chart Post Processing Script
  Create DI Solutions
    Introduction
    Pentaho Data Integration Architecture
    Use Pentaho Data Integration
      Create a Connection to the DI Repository
    Interface Perspectives
      Use Perspectives Within Spoon
      Tour Spoon
        VFS File Dialogues in Spoon
      Model Perspective
      Visualization Perspective
      Instaview Perspective
      Customizing the Spoon Interface
    Terminology and Basic Concepts
      Transformations, Steps, and Hops
      Jobs
      More About Hops
    Create Transformations
      Get Started
      Save Your Transformation
      Run Your Transformation Locally
      Build a Job
    Executing Transformations
      Initialize Slave Servers in Spoon
      Executing Jobs and Transformations from the Repository on the Carte Server
      Impact Analysis
    Working with the DI Repository
      Deleting a Repository
      Managing Content in the DI Repository
        Setting Folder-Level Permissions
          Access Control List (ACL) Permissions
        Exporting Content from Solutions Repositories with Command-Line Tools
      Working with Version Control
        Examining Version History
        Restoring a Previously Saved Version of a Job or Transformation
    Reusing Transformation Flows with Mapping Steps
    Arguments, Parameters, and Variables
      Arguments
      Parameters
        VFS Properties
          Configure SFTP VFS
      Variables
        Variable Scope
          Environment Variables
          Kettle Variables
        Internal Variables
    Rapid Analysis Schema Prototyping
      Creating a Prototype Schema With a Non-PDI Data Source
      Creating a Prototype Schema With a PDI Data Source
      Testing With Pentaho Analyzer and Report Wizard
      Prototypes in Production
    Using the SQL Editor
    Using the Database Explorer
    Unsupported Databases
    Performance Monitoring and Logging
      Monitoring Step Performance
        Using Performance Graphs
      Logging Steps
      Logging Transformations
      Pentaho Data Integration Performance Tuning Tips
    Working with Big Data and Hadoop in PDI
      Pentaho MapReduce Workflow
      PDI Hadoop Job Workflow
      Hadoop to PDI Data Type Conversion
      Hadoop Hive-Specific SQL Limitations
      Big Data Tutorials
        Hadoop Tutorials
          Loading Data into a Hadoop Cluster
            Prerequisites
              Sample Data
            Using a Job Entry to Load Data into Hadoop's Distributed File System (HDFS)
            Using a Job Entry to Load Data into Hive
            Using a Transformation Step to Load Data into HBase
          Transforming Data within a Hadoop Cluster
          Extracting Data from a Hadoop Cluster
          Reporting on Data within a Hadoop Cluster
        MapR Tutorials
          Loading Data into a MapR Cluster
          Transforming Data within a MapR Cluster
          Extracting Data from a MapR Cluster
          Reporting on Data within a MapR Cluster
        Cassandra Tutorials
        MongoDB Tutorials
    Implement Data Services with the Thin Kettle JDBC Driver
    Transactional Databases and Job Rollback
    Interacting With Web Services
    Scheduling and Scripting PDI Content
      Scheduling Transformations and Jobs From Spoon
      Command-Line Scripting Through Pan and Kitchen
        Pan Options and Syntax
          Pan Status Codes
        Kitchen Options and Syntax
          Kitchen Status Codes
        Importing KJB or KTR Files From a Zip Archive
        Connecting to a DI Solution Repositories with Command-Line Tools
        Exporting Content from Solutions Repositories with Command-Line Tools
    Transformation Step Reference
      Big Data
        Avro Input
        Cassandra Input
        Cassandra Output
        CouchDB Input
        Hadoop File Input
        Hadoop File Output
        HBase Input
        HBase Output
        HBase Row Decoder
        MapReduce Input
        MapReduce Output
        MongoDB Input
        MongoDB Output
        Splunk Input
        Splunk Output
        SSTable Output
      Input
        Cassandra Input
        CSV File Input
        Data Grid
        De-serialize From File
        Email Messages Input
        ESRI Shapefile Reader
        Fixed File Input
        Generate Random Credit Card Numbers
        Generate Random Value
        Generate Rows
        Get Data From XML
        Get File Names
        Get Files Rows Count
        Get Repository Names
        Get Subfolder Names
        Get System Info
        Get Table Names
        Google Analytics Input
          Setting Up Google Analytics API
          Google Analytics Plugin Installation
        Google Docs Input
        GZIP CSV Input
        HBase Input
        HL7 Input
        JMS Consumer
        JSON Input
        LDAP Input
        LDIF Input
        Load File Content In Memory
        Microsoft Access Input
        Microsoft Excel Input
        Mondrian Input
        MongoDB Input
        OLAP Input
        OpenERP Object Input
        Palo Cell Input
        Palo Dim Input
        Property Input
        Splunk Input
        RSS Input
        S3 CSV Input
        Salesforce Input
        SAP Input
        SAS Input
        Table Input
        Text File Input
        XBase Input
        XML Input Stream (StAX)
        YAML Input
      Output
        Automatic Documentation Output
        Cassandra Output
        Delete
        HBase Output
        Insert/Update
        JMS Producer
        JSON Output
        LDAP Output
        Microsoft Access Output
        Microsoft Excel Output
        Microsoft Excel Writer
        MongoDB Output
        OpenERP Object Input
        Palo Cell Output
        Palo Dim Output
        Pentaho Reporting Output
        Properties Output
        RSS Output
        S3 File Output
        Salesforce Delete
        Salesforce Insert
        Salesforce Update
        Salesforce Upsert
        Serialize to File
        Splunk Output
        SQL File Output
        Synchronize After Merge
        Table Output
        Text File Output
        Update
        XML Output
      Transform
        Add a Checksum
        Add Constants
        Add Sequence
        Add Value Fields Changing Sequence
        Add XML
        Calculator
        Closure Generator
        Example Plugin
        Get ID From Slave Server
        Number Range
        Replace in String
        Row Denormalizer
        Row Flattener
        Row Normalizer
        Select Values
        Set Field Value
        Set Field Value to a Constant
        Sort Rows
        Split Field to Rows
        Split Fields
        String Operations
        Strings Cut
        Unique Rows
        Unique Rows (HashSet)
        Value Mapper
        XSL Transformation
      Utility
        Change File Encoding
        Clone Row
        Delay Row
        Edit to XML
        Execute a Process
        If Field Value is Null
        Mail
        Metadata Structure of Stream
        Null if...
        Process Files
        Run SSH Commands
        Send Message to Syslog
        Write to Log
      Flow
        Abort
        Append Streams
        Block This Step Until Steps Finish
        Blocking Step
        Detect Empty Stream
        Dummy (do nothing)
        ETL Metadata Injection
        Filter Rows
        Identify Last Row in a Stream
        Java Filter
        Prioritize Streams
        Single Threader
        Switch / Case
      Scripting
        Execute Row SQL Script
        Execute SQL Script
        Formula
        Modified JavaScript Value
        Regex Evaluation
        User Defined Java Class
        User Defined Java Expression
      Lookup
        Call DB Procedure
        Check if a Column Exists
        Check if File is Locked
        Check if Webservice is Available
        Database Join
        Database Lookup
        Dynamic SQL Row
        File Exists
        Fuzzy Match
        HTTP Client
        HTTP Post
        MaxMind GeoIP Lookup
        RESTClient
        Stream Lookup
        Table Exists
        Web Services Lookup
      Joins
        Join Rows (Cartesian Product)
        Merge Join
        Merge Rows (diff)
        Sorted Merge
        XML Join
      Data Warehouse
        Combination Lookup/Update
        Dimension Lookup/Update
      Validation
        Credit Card Validator
        Data Validator
        Mail Validator
        XSD Validator
      Statistics
        Analytic Query
        Group By
        Memory Group By
        Output Steps Metrics
        Reservoir Sampling
        Sample Rows
        Univariate Statistics
      Palo
        Palo Cell Input
        Palo Cell Output
        Palo Dim Input
        Palo Dim Output
      Job
        Copy Rows to Result
        Get Files From Result
        Get Rows From Result
        Get Variables
        Set Files in Result
        Set Variables
      Mapping
        Mapping (sub-transformation)
        Mapping Input Specification
        Mapping Output Specification
      Bulk Loading
        ElasticSearch Bulk Insert
        Greenplum Bulk Loader
        Greenplum Load
        Infobright Loader
        Ingres VectorWise Bulk Loader
        LucidDB Streaming Loader
        MonetDB Bulk Loader
        MySQL Bulk Loader
        Oracle Bulk Loader
        PostgreSQL Bulk Loader
        Teradata Fastload Bulk Loader
      Inline
        Injector
        Socket Reader
        Socket Writer
      Data Mining Steps
        Weka Scoring
        Reservoir Sampling
        ARFF Output
        Univariate Statistics
        Knowledge Flow
        Univariate Statistics
        Weka Forecasting
    Job Entry Reference
      File Encryption
        Decrypt Files With PGP
        Encrypt Files With PGP
        Verify File Signature With PGP
      Big Data
        Amazon EMR Job Executor
        Amazon Hive Job Executor
        Hadoop Copy Files
        Hadoop Job Executor
        Oozie Job Executor
        Pentaho MapReduce
        Pig Script Executor
        Sqoop Export
        Sqoop Import
      General
        Start
        Dummy
        Example Plugin
        Job
        Set Variables
        Success
        Transformation
      Mail
        Get Mails (POP3/IMAP)
        Mail
        Mail Validator
      File Management
        Add Filenames to Result
        Compare Folders
        Convert File Between DOS and Unix
        Copy Files
        Copy or Remove Result Filenames
        Create a Folder
        Create File
        Delete File
        Delete Filenames From Result
        Delete Files
        Delete Folders
        File Compare
        HTTP
        Move Files
        Unzip File
        Wait For File
        Write to File
        Zip File
      Conditions
        Check DB Connections
        Check Files Locked
        Check If a Folder is Empty
        Check Webservice Availability
        Checks If Files Exist
        Columns Exist in a Table
        Evaluate Files Metrics
        Evaluate Rows Number in a Table
        File Exists
        Simple Evaluation
        Table Exists
        Wait For
      Scripting
        JavaScript
        Shell
        SQL
      Bulk Loading
        Bulkload From MySQL Into File
        Bulkload Into MSSQL
        Bulkload Into MySQL
        MS Access Bulk Load
      XML
        Check if XML FIle is Well-Formed
        DTD Validator
        XSD Validator
        XSL Transformation
      Utility
        Abort Job
        Display Msgbox Info
        HL7 MLLP Acknowledge
        HL7 MLLP Input
        Ping a Host
        Send Information Using Syslog
        Send SNMP Trap
        Talend Job Execution
        Truncate Tables
        Wait for SQL
        Write to Log
      Repository
        Check if Connected to Repository
        Export Repository to XML File
      File Transfer
        FTP Delete
        Get a File with FTP
        Get a File With FTPS
        Get a file with SFTP
        Put a File With FTP
        Put a File With SFTP
        SSH2 Get
        SSH2 Put
        Upload Files to FTPS
      Palo
        Palo Cube Create
        Palo Cube Delete
    About PDI Marketplace
    Troubleshooting
      Changing the Pentaho Data Integration Home Directory Location (.kettle folder)
        Changing the Kettle Home Directory within the Pentaho BI Platform
      Kitchen can't read KJBs from a Zip export
      Generating a DI Repository Configuration Without Running Spoon
        Connecting to a DI Solution Repositories with Command-Line Tools
      Unable to Get List of Repositories Exception
        Executing Jobs and Transformations from the Repository on the Carte Server
      Database Locks When Reading and Updating From A Single Table
        Reading and Updating Table Rows Within a Transformation
      Force PDI to use DATE instead of TIMESTAMP in Parameterized SQL Queries
      PDI Does Not Recognize Changes Made To a Table
      Using ODBC
      Sqoop Import into Hive Fails
  Work with Big Data
    Getting Started with PDI and Hadoop
      Pentaho, Big Data, and Hadoop
      About Hadoop
      Big Data Resources
    Configuring Your Big Data Environment
      Setting the Active Hadoop Configuration
        Define Hadoop Connections
        Configure Spoon for MapR
      Creating a New Hadoop Configuration
    Working with Big Data and Hadoop in PDI
      Pentaho MapReduce Workflow
      PDI Hadoop Job Workflow
      Hadoop to PDI Data Type Conversion
      Hadoop Hive-Specific SQL Limitations
      Big Data Tutorials
        Hadoop Tutorials
          Loading Data into a Hadoop Cluster
            Prerequisites
              Sample Data
            Using a Job Entry to Load Data into Hadoop's Distributed File System (HDFS)
            Using a Job Entry to Load Data into Hive
            Using a Transformation Step to Load Data into HBase
          Transforming Data within a Hadoop Cluster
          Extracting Data from a Hadoop Cluster
          Reporting on Data within a Hadoop Cluster
        MapR Tutorials
          Loading Data into a MapR Cluster
          Transforming Data within a MapR Cluster
          Extracting Data from a MapR Cluster
          Reporting on Data within a MapR Cluster
        Cassandra Tutorials
        MongoDB Tutorials
    PDI Hadoop Configurations
      Including/Excluding Classes or Packages for a Hadoop Configuration
    PDI Big Data Transformation Steps
      Avro Input
      Cassandra Input
      Cassandra Output
      CouchDB Input
      Hadoop File Input
      Hadoop File Output
      HBase Input
      HBase Output
      HBase Row Decoder
      MapReduce Input
      MapReduce Output
      MongoDB Input
      MongoDB Output
      Splunk Input
      Splunk Output
      SSTable Output
    PDI Big Data Job Entries
      Amazon EMR Job Executor
      Amazon Hive Job Executor
      Hadoop Copy Files
      Hadoop Job Executor
      Oozie Job Executor
      Pentaho MapReduce
      Pig Script Executor
      Sqoop Export
      Sqoop Import
Create and Refine Advanced Data Models
  Work with Relational Data Models
    About this Section
    Knowledge Prerequisites
    A Conceptual Overview of the Pentaho Metadata Editor
      The Physical Layer
      The Business View
      The Abstract Business Layer
      Incorporate Metadata
    Examine the Sample Metadata Model
    Create a New Domain
      Set Up a Database Connection
      Import Physical Tables and Columns
      Import Tables Inside a Schema
      Create a Business Model
      Create Business Tables and Columns
        Remove Unnecessary Business Columns
      Create Relationships between Business Tables
        Create Relationships Using the Editor Graph
        Hadoop Hive-Specific SQL Limitations
      Build a Business View
        Build a Business View Using Manage Categories
          Create a New Category from a Business Table
          Move Columns into Categories
          Add a New Category
          Remove Categories and Columns
    Enrich Your Data — Understanding Metadata Concepts and Properties
      Exceptions to the Rules
      Required Properties
      Apply Concepts and Properties in the Pentaho Metadata Editor
      Apply Self Concepts: Managing Properties on the Model
      The Properties List
      The Properties Editor (Settings)
      Add New Properties
      Remove a Property
      The Concept Editor
      Build Concepts
      Apply Concepts to Business Objects
      Remove the Parent Concept
    Metadata Security
      Configure the Security Service
      Add Column-Level Security Constraints
      Add Global Row-Level Security Constraints
        MQL Formula Syntax For Global Constraints
      Add User or Role Row-Level Security Constraints
        MQL Formula Syntax For User and Role Row-Level Constraints
      Remove Security from Metadata Domain Repository
    Add Security to Metadata Business Objects
      Define Security Settings
      Getting Security Settings Offline
      Change Security Constraints
    Add Row Level Security to a Pentaho Metadata Model
      Apply Data Constraints
    Configure and Manage International Locales
      Set Up Locales
    Import and Export Domains
      Import a Domain
      Export a Domain
    Domain Backup and Recovery
    Metadata Properties Reference
      Out-of-the-Box Properties
        Publish a Domain to a Pentaho BA Server
          Before you Publish Your Domain
          Make a Model Available as a Data Source
      Custom Properties
      Required Properties per Business Object
    Pentaho Metadata Formulas
      Supported Functions
      Supported Operators
      Supported Aggregate Functions
    Troubleshoot Report Designer
      Publish
      Manage Multiple Outer-Joins
        Use the Delay Outer Join Conditions Property
  Work with Multidimensional Data Models
    Introduction
    OLAP Defined
    Pentaho Analysis Enterprise Edition Features
    Workflow Overview
    Dimensional Modeling
      Virtual OLAP Cubes
    Prototype With Data Integration
      Creating a Prototype Schema With a Non-PDI Data Source
      Creating a Prototype Schema With a PDI Data Source
      Testing With Pentaho Analyzer and Report Wizard
      Prototypes in Production
    Create and Modify Mondrian Schemas
      Schema Workbench Notes
      Add a Data Source in Schema Workbench
      Create a Mondrian Schema
        Use MDX Mode and Edit a Schema
        Add Business Groups
        Add Field Descriptions
        Build a Schema and Detecting Errors
      Adapt Mondrian Schemas to Work with Pentaho Analyzer
        Apply Relative Date Filters
        Adjust for Calculated Members and Named Sets
        Add Geo Map Support to a Mondrian Schema
    Analysis Schema Security
      Restrict Access to Specific Members
      Mondrian Role Mapping in the BA Server
        The Mondrian One-To-One UserRoleMapper
        The Mondrian SampleLookupMap UserRoleMapper
        The Mondrian SampleUserSession UserRoleMapper
      Restrict OLAP Schemas Per User
    Configure Analysis Options
      Manage Analysis Data Sources
      Configure the Mondrian Engine (mondrian.properties)
      Change Analyzer Default Behavior
      Assign Analyzer Chart Colors
    Mondrian Cache Control
      Segment Cache Architecture
      Cache Configuration Files
      Modify the JGroups Configuration
      Switch to Another Cache Framework
        Switch to Memcached
          Memcached Configuration Options
        Switch to Pentaho Platform Delegating Cache
        Use a Custom SegmentCache SPI
    Visualize Your Data
      Introduction to the Multidimensional Expression Language (MDX)
        Further Reading
      Create Analyzer Reports
        Create a New Analyzer Report
          Add Query Parameters to Analyzer Reports
          Configure Drill-Down Links
          Display Member Properties
          Disable Auto Refresh Mode
          Define Hyperlinks
          Number Formatting
          Conditional Formatting
            Simple Conditional Formatting of Measures
              Conditional Formatting Types
            Advanced Conditional Formatting With MDX Expressions
              Conditional Formatting Expressions
        Analyzer Visualizations
          Geography Map Visualizations In Analyzer
            Change Geography Map Visualizations In Analyzer
          Scatter Chart Visualizations In Analyzer
            Change Scatter Chart Visualizations In Analyzer
          Heat Grid Visualizations In Analyzer
            Change Heat Grid Visualizations In Analyzer
          Set Chart Options
          Display Multi-Charts in Analyzer
          Drill in Charts
      Use Analysis Cubes in Report Designer
        Add an OLAP Data Source
        Create an MDX Query
    Log Output
      Analysis SQL Output Logging
      Enabling Segment Cache Logging
      View Log Output in Analyzer
    Troubleshooting
      Old Analysis Schemas Still Show Up in Pentaho User Console
      Multi-Byte Characters Don't Appear In PDFs Exported From Analyzer
    Mondrian Schema Element Quick Reference
      AggExclude
      AggFactCount
      AggForeignKey
      AggIgnoreColumn
      AggLevel
      AggMeasure
      AggName
      AggPattern
      AggTable
      CalculatedMember
      CalculatedMemberProperty
      CaptionExpression
      Closure
      ColumnDef
      ColumnDefs
      Cube
      CubeGrant
      CubeUsage
      CubeUsages
      Dimension
      DimensionGrant
      DimensionUsage
      Formula
      Hierarchy
      HierarchyGrant
      InlineTable
      Join
      KeyExpression
      Level
      Measure
      MeasureExpression
      MemberGrant
      NamedSet
      NameExpression
      OrdinalExpression
      Parameter
      ParentExpression
      Property
      PropertyExpression
      Role
      RoleUsage
      Row
      Rows
      Schema
      SchemaGrant
      SQL
      Table
      Union
      UserDefinedFunction
      Value
      View
      VirtualCube
      VirtualCubeDimension
      VirtualCubeMeasure
  Optimize Multidimensional Data Models
    Introduction
    Pentaho Aggregation Designer Overview
    Defining the Data Source
      Defining Additional JDBC Driver Parameters
    Selecting a Model
    Getting Recommendations Using Aggregate Advisor
    Customizing Aggregates
      Customizing an aggregate
      Adding Aggregates
      Deleting Aggregates
    Exporting Aggregates
    Glossary of Terms
      Aggregate
      Aggregate Tables
      Aggregation
      Data Definition Language (DDL)
      Mondrian Schema
      Relational Online Analytic Processing (ROLAP)
      Snowflake Schema
  Work with Relational Data Models
    About this Section
    Knowledge Prerequisites
    A Conceptual Overview of the Pentaho Metadata Editor
      The Physical Layer
      The Business View
      The Abstract Business Layer
      Incorporate Metadata
    Examine the Sample Metadata Model
    Create a New Domain
      Set Up a Database Connection
      Import Physical Tables and Columns
      Import Tables Inside a Schema
      Create a Business Model
      Create Business Tables and Columns
        Remove Unnecessary Business Columns
      Create Relationships between Business Tables
        Create Relationships Using the Editor Graph
        Hadoop Hive-Specific SQL Limitations
      Build a Business View
        Build a Business View Using Manage Categories
          Create a New Category from a Business Table
          Move Columns into Categories
          Add a New Category
          Remove Categories and Columns
    Enrich Your Data — Understanding Metadata Concepts and Properties
      Exceptions to the Rules
      Required Properties
      Apply Concepts and Properties in the Pentaho Metadata Editor
      Apply Self Concepts: Managing Properties on the Model
      The Properties List
      The Properties Editor (Settings)
      Add New Properties
      Remove a Property
      The Concept Editor
      Build Concepts
      Apply Concepts to Business Objects
      Remove the Parent Concept
    Metadata Security
      Configure the Security Service
      Add Column-Level Security Constraints
      Add Global Row-Level Security Constraints
        MQL Formula Syntax For Global Constraints
      Add User or Role Row-Level Security Constraints
        MQL Formula Syntax For User and Role Row-Level Constraints
      Remove Security from Metadata Domain Repository
    Add Security to Metadata Business Objects
      Define Security Settings
      Getting Security Settings Offline
      Change Security Constraints
    Add Row Level Security to a Pentaho Metadata Model
      Apply Data Constraints
    Configure and Manage International Locales
      Set Up Locales
    Import and Export Domains
      Import a Domain
      Export a Domain
    Domain Backup and Recovery
    Metadata Properties Reference
      Out-of-the-Box Properties
        Publish a Domain to a Pentaho BA Server
          Before you Publish Your Domain
          Make a Model Available as a Data Source
      Custom Properties
      Required Properties per Business Object
    Pentaho Metadata Formulas
      Supported Functions
      Supported Operators
      Supported Aggregate Functions
    Troubleshoot Report Designer
      Publish
      Manage Multiple Outer-Joins
        Use the Delay Outer Join Conditions Property
  Work with Multidimensional Data Models
    Introduction
    OLAP Defined
    Pentaho Analysis Enterprise Edition Features
    Workflow Overview
    Dimensional Modeling
      Virtual OLAP Cubes
    Prototype With Data Integration
      Creating a Prototype Schema With a Non-PDI Data Source
      Creating a Prototype Schema With a PDI Data Source
      Testing With Pentaho Analyzer and Report Wizard
      Prototypes in Production
    Create and Modify Mondrian Schemas
      Schema Workbench Notes
      Add a Data Source in Schema Workbench
      Create a Mondrian Schema
        Use MDX Mode and Edit a Schema
        Add Business Groups
        Add Field Descriptions
        Build a Schema and Detecting Errors
      Adapt Mondrian Schemas to Work with Pentaho Analyzer
        Apply Relative Date Filters
        Adjust for Calculated Members and Named Sets
        Add Geo Map Support to a Mondrian Schema
    Analysis Schema Security
      Restrict Access to Specific Members
      Mondrian Role Mapping in the BA Server
        The Mondrian One-To-One UserRoleMapper
        The Mondrian SampleLookupMap UserRoleMapper
        The Mondrian SampleUserSession UserRoleMapper
      Restrict OLAP Schemas Per User
    Configure Analysis Options
      Manage Analysis Data Sources
      Configure the Mondrian Engine (mondrian.properties)
      Change Analyzer Default Behavior
      Assign Analyzer Chart Colors
    Mondrian Cache Control
      Segment Cache Architecture
      Cache Configuration Files
      Modify the JGroups Configuration
      Switch to Another Cache Framework
        Switch to Memcached
          Memcached Configuration Options
        Switch to Pentaho Platform Delegating Cache
        Use a Custom SegmentCache SPI
    Visualize Your Data
      Introduction to the Multidimensional Expression Language (MDX)
        Further Reading
      Create Analyzer Reports
        Create a New Analyzer Report
          Add Query Parameters to Analyzer Reports
          Configure Drill-Down Links
          Display Member Properties
          Disable Auto Refresh Mode
          Define Hyperlinks
          Number Formatting
          Conditional Formatting
            Simple Conditional Formatting of Measures
              Conditional Formatting Types
            Advanced Conditional Formatting With MDX Expressions
              Conditional Formatting Expressions
        Analyzer Visualizations
          Geography Map Visualizations In Analyzer
            Change Geography Map Visualizations In Analyzer
          Scatter Chart Visualizations In Analyzer
            Change Scatter Chart Visualizations In Analyzer
          Heat Grid Visualizations In Analyzer
            Change Heat Grid Visualizations In Analyzer
          Set Chart Options
          Display Multi-Charts in Analyzer
          Drill in Charts
      Use Analysis Cubes in Report Designer
        Add an OLAP Data Source
        Create an MDX Query
    Log Output
      Analysis SQL Output Logging
      Enabling Segment Cache Logging
      View Log Output in Analyzer
    Troubleshooting
      Old Analysis Schemas Still Show Up in Pentaho User Console
      Multi-Byte Characters Don't Appear In PDFs Exported From Analyzer
    Mondrian Schema Element Quick Reference
      AggExclude
      AggFactCount
      AggForeignKey
      AggIgnoreColumn
      AggLevel
      AggMeasure
      AggName
      AggPattern
      AggTable
      CalculatedMember
      CalculatedMemberProperty
      CaptionExpression
      Closure
      ColumnDef
      ColumnDefs
      Cube
      CubeGrant
      CubeUsage
      CubeUsages
      Dimension
      DimensionGrant
      DimensionUsage
      Formula
      Hierarchy
      HierarchyGrant
      InlineTable
      Join
      KeyExpression
      Level
      Measure
      MeasureExpression
      MemberGrant
      NamedSet
      NameExpression
      OrdinalExpression
      Parameter
      ParentExpression
      Property
      PropertyExpression
      Role
      RoleUsage
      Row
      Rows
      Schema
      SchemaGrant
      SQL
      Table
      Union
      UserDefinedFunction
      Value
      View
      VirtualCube
      VirtualCubeDimension
      VirtualCubeMeasure
  Optimize Multidimensional Data Models
    Introduction
    Pentaho Aggregation Designer Overview
    Defining the Data Source
      Defining Additional JDBC Driver Parameters
    Selecting a Model
    Getting Recommendations Using Aggregate Advisor
    Customizing Aggregates
      Customizing an aggregate
      Adding Aggregates
      Deleting Aggregates
    Exporting Aggregates
    Glossary of Terms
      Aggregate
      Aggregate Tables
      Aggregation
      Data Definition Language (DDL)
      Mondrian Schema
      Relational Online Analytic Processing (ROLAP)
      Snowflake Schema
Fine-Tune Pentaho Systems
  Administer BA Server
    Introduction
    Manage Schedules
    Upload and Download from the BA Repository
    Localize Folders and Reports
    Manage Pentaho License Keys from the Command Line
    Maintain the BA Server Manually
    Monitor System Performance Using Pentaho Operations Mart
    Performance Monitoring and Logging
  Define BA Server Advanced Security
    Introduction
    Security Overview
    Supported Technologies
    Advanced Security
      Switch to MS Active Directory
      Switch to LDAP
      Manual MSAD Configuration
      Manual LDAP Configuration
        Implementing Nested Roles in LDAP
        LDAP Properties
      Manual JDBC Connection Configuration
      Manual LDAP/JDBC Hybrid Configuration
      Implement Single Sign-On
        Switch to Central Authentication Service (CAS)
          CAS Property Reference
        Switch to Integrated Windows Authentication (IWA)
      Add Web Resource Authentication
    Restrict or Share Files and Folders
    Secure the User Console and BA Server
      Configure SSL (HTTPS) in the Pentaho User Console and BA Server
        Enable SSL in the BA Server With a Certificate Authority
        Enable SSL in the BA Server With a Self-Signed Certificate
          Trust a Self-Signed Certificate
        Change the BA Server Fully Qualified URL
      Use the Apache Web Server (httpd) For Socket Handling
        Use Apache httpd With SSL For Delivering Static Content
      How to Change the Administrator Role
      Assign Data Source Permissions for the User Console
      Secure SQL Access for Dashboards
    Remove Security by Allowing Anonymous Access
    Troubleshooting
      Increase Security Log Levels in the BA Server
        Enable Extra LDAP Security Logging
      Log Output Analysis
      LDAP Roles Are Not "Admin" and "Authenticated"
      With LDAP Authentication, the PDI Repository Explorer is Empty
      LDAP Incorrectly Authenticates User IDs That Do Not Match Letter Case
        LDAP Authenticates User IDs That Do Not Match Case
  Optimize BA Server Performance
    Introduction
    System Requirements
    Pentaho BA Server Performance Tips
      Move Pentaho Managed Data Sources to JNDI
      Manual Cleanup of the /tmp Directory
      Memory Optimization for the Geo Service Plugin
      Turn Off Audit Logging
      Use Apache httpd With SSL For Delivering Static Content
      Test BA Server Scalability
    Pentaho Reporting Performance Tips
      Cache Report Content
        Result Set Caching
          Result Set Cache Options
      Streamline Printed Output
        Paginated Exports
        Table Exports
        HTML Exports
      Pentaho Reporting Configuration Files
    Pentaho Data Integration Performance Tips
      Upgrade to the Latest Release
      Pentaho Data Integration Performance Tuning Tips
      Limit In-Memory Log Output
      HBase Performance in PDI
    Pentaho Analysis (Mondrian) Performance Tips
      Optimize Your Infrastructure
        Redesign Your Data Warehouse
        Switch to an Analytic Database
        Query Optimization
      Optimize Pentaho Analysis
        Mondrian Cache Control
          Segment Cache Architecture
          Cache Configuration Files
          Modify the JGroups Configuration
          Switch to Another Cache Framework
            Switch to Memcached
              Memcached Configuration Options
            Switch to Pentaho Platform Delegating Cache
            Use a Custom SegmentCache SPI
        Partitioning High-Cardinality Dimensions
        Mondrian Log Analysis
        Configuring Pentaho Analyzer for Large Data Warehouses
        Configuring the Mondrian Engine for Large Data Warehouses
        Redesigning Analyzer Reports for Maximum Performance
      Pentaho Analysis Configuration Files
    Pentaho Data Mining (Weka) Performance Tips
    Vertical Resource Scaling
    Cluster the Application Server
    Change the Java VM Memory Limits
      Increase Memory Limits on Microsoft Windows with a Graphical Installation
      Increase Memory Limits on Linux with a Graphical Install
      Increase Memory Limits with an Archive or Manual Deployment
      Increase the Memory Limit in Aggregation Designer
      Increase the Memory Limit in PDI
      Increase the Memory Limit in Report Designer
      Increase the Memory Limit in Weka
  Troubleshoot BA Server Issues
    Introduction
    General
      JDBC Driver Issues
        Data Conversion Issues With MySQL Driver 5.0.8
        Fixing JTDS varchar(MAX) Limitations in MSSQL 2005
      Examining Log Files
    Upgrade
      Tomcat Logs Report Memory Leaks
      context.xml Changes Do Not Take Effect After Deploying a WAR
      javax.jcr.RepositoryException: no search manager configured for this workspace
      User Console Themes Render Improperly After Upgrade
    Troubleshoot the BA Server
      Library Conflicts
      Report Parameters That Include Accented Characters Fail to Validate
        Modifying server.xml To Work With Accented Characters
      vfs-provider.xml Duplicates
      Varying Context and Data Source Configuration Methods
      Cannot Create Jackrabbit Tables in MySQL
      Unable to Use the Database Init Scripts for PostgreSQL
      JBoss Fails to Start When the Pentaho HSQLDB Sample Database Is Running
      JBoss Fails to Start After Manually Unpacking pentaho.war
      LDAP Incorrectly Authenticates User IDs That Do Not Match Letter Case
        LDAP Authenticates User IDs That Do Not Match Case
      LDAP Roles Are Not "Admin" and "Authenticated"
      With LDAP Authentication, the PDI Repository Explorer is Empty
      Troubleshooting
        Windows Domains Won't Authenticate When Using the JTDS Driver
        Geo Maps partially rendered
    Report Designer and Reporting Engine
      Enable Multi-Valued report Parameters for Metadata-based Queries Created with Previous Versions of Report Designer
      Report Elements With Dynamic Heights Overlap Other Elements
      Columns Unexpectedly Merge When Exporting to Excel
    Analysis
      Old Analysis Schemas Still Show Up in Pentaho User Console
        Removing Mondrian Data Sources
      Multi-Byte Characters Don't Appear In PDFs Exported From Analyzer
        Set a Default Font for PDF Exports
    Data Integration
      Troubleshooting a Corrupted DI Server Repository
        Using the H2 Database Recovery Tool
      Action Sequences That Call PDI Content Won't Run
      Jobs Scheduled on DI Server Cannot Execute Transformation on Remote Carte Server
        Execute Scheduled Jobs on a Remote Carte Server
      Kitchen can't read KJBs from a Zip export
      Using ODBC
      Troubleshooting MonetDB for Instaview
    Metadata
      Publish
      Manage Multiple Outer-Joins
        Use the Delay Outer Join Conditions Property
  Administer DI Server
    Introduction
    Specify Data Connections for the DI Server
      Define Native (JDBC) Database Connections
      Define JNDI Connections for the DI Server
      Define OCI Connections for the DI Server
    Create a Connection to the DI Repository
    Implement Advanced Security for the DI Server
      Configure LDAP for the DI Server
        LDAP Properties
      Manual JDBC Connection Configuration
      Create LDAP/JDBC Hybrid Configuration for the DI Server
      Configure Microsoft Active Directory for the DI Server
      Use Kerberos Authentication to Provide Spoon Users Access to Hadoop Cluster
      Use Kerberos Authentication to Provide Spoon Users Access to MongoDB
    Import and Export PDI Content
      Import Content Into a Repository
        Use the Import Script From the Command Line
      Export Content From the Repository
    Create Clusters
      Configure Carte to Be a Static Slave Instance
      Configure a Dynamic Cluster
        Configure Carte as a Master (Load Balancer)
        Configure Carte to Be a Dynamic Slave Instance
      Create a Cluster Schema in Spoon
      Execute Transformations in a Cluster
      Initialize Slave Servers in Spoon
      Execute Scheduled Jobs on a Remote Carte Server
    Install License Keys Using the Command Line Interface
    Assign Permissions to Use or Manage Database Connections
    List of Server Ports Used by PDI
      Change Service Port Numbers
    Change the DI Server URL
    Logging and Monitoring Operations
      Enable Logging
      Monitor Job and Transformation Results
        slave-server-config.xml
      Use Checkpoints to Restart Jobs
      Data Integration Operations Mart
        Install the DI Operations Mart
        Set Up Database Connections
        Create the DI Operations Mart
        Configure Logging Data Collection
        Update the Logging for the DI Operations Mart
        Load the Sample Data in the DI Operations Mart
          Loading the Sample Reports, Charts, and Dashboards
        Set Up and Distribute the Data Models
        Give Users Access to the DI Operations Mart
        Create Charts, Reports, and Dashboards Using PDI Operations Mart Data
          Create ETL Logging Reports
          Create ETL Logging Charts
          Create ETL Logging Dashboards
        Logging Tables Status for the Data Integration Operations Mart
        Logging Dimensions and Metrics for the Data Integration Operation Mart
        Clean Up Operations Mart Tables
    Contents of the .kettle Directory
      Change the PDI Home Directory Location (.kettle folder)
    Back Up the DI Repository
    Troubleshooting
      Jobs Scheduled on DI Server Cannot Execute Transformation on Remote Carte Server
      Sqoop Import into Hive Fails
  Administer BA Server
    Introduction
    Manage Schedules
    Upload and Download from the BA Repository
    Localize Folders and Reports
    Manage Pentaho License Keys from the Command Line
    Maintain the BA Server Manually
    Monitor System Performance Using Pentaho Operations Mart
    Performance Monitoring and Logging
  Define BA Server Advanced Security
    Introduction
    Security Overview
    Supported Technologies
    Advanced Security
      Switch to MS Active Directory
      Switch to LDAP
      Manual MSAD Configuration
      Manual LDAP Configuration
        Implementing Nested Roles in LDAP
        LDAP Properties
      Manual JDBC Connection Configuration
      Manual LDAP/JDBC Hybrid Configuration
      Implement Single Sign-On
        Switch to Central Authentication Service (CAS)
          CAS Property Reference
        Switch to Integrated Windows Authentication (IWA)
      Add Web Resource Authentication
    Restrict or Share Files and Folders
    Secure the User Console and BA Server
      Configure SSL (HTTPS) in the Pentaho User Console and BA Server
        Enable SSL in the BA Server With a Certificate Authority
        Enable SSL in the BA Server With a Self-Signed Certificate
          Trust a Self-Signed Certificate
        Change the BA Server Fully Qualified URL
      Use the Apache Web Server (httpd) For Socket Handling
        Use Apache httpd With SSL For Delivering Static Content
      How to Change the Administrator Role
      Assign Data Source Permissions for the User Console
      Secure SQL Access for Dashboards
    Remove Security by Allowing Anonymous Access
    Troubleshooting
      Increase Security Log Levels in the BA Server
        Enable Extra LDAP Security Logging
      Log Output Analysis
      LDAP Roles Are Not "Admin" and "Authenticated"
      With LDAP Authentication, the PDI Repository Explorer is Empty
      LDAP Incorrectly Authenticates User IDs That Do Not Match Letter Case
        LDAP Authenticates User IDs That Do Not Match Case
  Optimize BA Server Performance
    Introduction
    System Requirements
    Pentaho BA Server Performance Tips
      Move Pentaho Managed Data Sources to JNDI
      Manual Cleanup of the /tmp Directory
      Memory Optimization for the Geo Service Plugin
      Turn Off Audit Logging
      Use Apache httpd With SSL For Delivering Static Content
      Test BA Server Scalability
    Pentaho Reporting Performance Tips
      Cache Report Content
        Result Set Caching
          Result Set Cache Options
      Streamline Printed Output
        Paginated Exports
        Table Exports
        HTML Exports
      Pentaho Reporting Configuration Files
    Pentaho Data Integration Performance Tips
      Upgrade to the Latest Release
      Pentaho Data Integration Performance Tuning Tips
      Limit In-Memory Log Output
      HBase Performance in PDI
    Pentaho Analysis (Mondrian) Performance Tips
      Optimize Your Infrastructure
        Redesign Your Data Warehouse
        Switch to an Analytic Database
        Query Optimization
      Optimize Pentaho Analysis
        Mondrian Cache Control
          Segment Cache Architecture
          Cache Configuration Files
          Modify the JGroups Configuration
          Switch to Another Cache Framework
            Switch to Memcached
              Memcached Configuration Options
            Switch to Pentaho Platform Delegating Cache
            Use a Custom SegmentCache SPI
        Partitioning High-Cardinality Dimensions
        Mondrian Log Analysis
        Configuring Pentaho Analyzer for Large Data Warehouses
        Configuring the Mondrian Engine for Large Data Warehouses
        Redesigning Analyzer Reports for Maximum Performance
      Pentaho Analysis Configuration Files
    Pentaho Data Mining (Weka) Performance Tips
    Vertical Resource Scaling
    Cluster the Application Server
    Change the Java VM Memory Limits
      Increase Memory Limits on Microsoft Windows with a Graphical Installation
      Increase Memory Limits on Linux with a Graphical Install
      Increase Memory Limits with an Archive or Manual Deployment
      Increase the Memory Limit in Aggregation Designer
      Increase the Memory Limit in PDI
      Increase the Memory Limit in Report Designer
      Increase the Memory Limit in Weka
  Troubleshoot BA Server Issues
    Introduction
    General
      JDBC Driver Issues
        Data Conversion Issues With MySQL Driver 5.0.8
        Fixing JTDS varchar(MAX) Limitations in MSSQL 2005
      Examining Log Files
    Upgrade
      Tomcat Logs Report Memory Leaks
      context.xml Changes Do Not Take Effect After Deploying a WAR
      javax.jcr.RepositoryException: no search manager configured for this workspace
      User Console Themes Render Improperly After Upgrade
    Troubleshoot the BA Server
      Library Conflicts
      Report Parameters That Include Accented Characters Fail to Validate
        Modifying server.xml To Work With Accented Characters
      vfs-provider.xml Duplicates
      Varying Context and Data Source Configuration Methods
      Cannot Create Jackrabbit Tables in MySQL
      Unable to Use the Database Init Scripts for PostgreSQL
      JBoss Fails to Start When the Pentaho HSQLDB Sample Database Is Running
      JBoss Fails to Start After Manually Unpacking pentaho.war
      LDAP Incorrectly Authenticates User IDs That Do Not Match Letter Case
        LDAP Authenticates User IDs That Do Not Match Case
      LDAP Roles Are Not "Admin" and "Authenticated"
      With LDAP Authentication, the PDI Repository Explorer is Empty
      Troubleshooting
        Windows Domains Won't Authenticate When Using the JTDS Driver
        Geo Maps partially rendered
    Report Designer and Reporting Engine
      Enable Multi-Valued report Parameters for Metadata-based Queries Created with Previous Versions of Report Designer
      Report Elements With Dynamic Heights Overlap Other Elements
      Columns Unexpectedly Merge When Exporting to Excel
    Analysis
      Old Analysis Schemas Still Show Up in Pentaho User Console
        Removing Mondrian Data Sources
      Multi-Byte Characters Don't Appear In PDFs Exported From Analyzer
        Set a Default Font for PDF Exports
    Data Integration
      Troubleshooting a Corrupted DI Server Repository
        Using the H2 Database Recovery Tool
      Action Sequences That Call PDI Content Won't Run
      Jobs Scheduled on DI Server Cannot Execute Transformation on Remote Carte Server
        Execute Scheduled Jobs on a Remote Carte Server
      Kitchen can't read KJBs from a Zip export
      Using ODBC
      Troubleshooting MonetDB for Instaview
    Metadata
      Publish
      Manage Multiple Outer-Joins
        Use the Delay Outer Join Conditions Property
  Administer DI Server
    Introduction
    Specify Data Connections for the DI Server
      Define Native (JDBC) Database Connections
      Define JNDI Connections for the DI Server
      Define OCI Connections for the DI Server
    Create a Connection to the DI Repository
    Implement Advanced Security for the DI Server
      Configure LDAP for the DI Server
        LDAP Properties
      Manual JDBC Connection Configuration
      Create LDAP/JDBC Hybrid Configuration for the DI Server
      Configure Microsoft Active Directory for the DI Server
      Use Kerberos Authentication to Provide Spoon Users Access to Hadoop Cluster
      Use Kerberos Authentication to Provide Spoon Users Access to MongoDB
    Import and Export PDI Content
      Import Content Into a Repository
        Use the Import Script From the Command Line
      Export Content From the Repository
    Create Clusters
      Configure Carte to Be a Static Slave Instance
      Configure a Dynamic Cluster
        Configure Carte as a Master (Load Balancer)
        Configure Carte to Be a Dynamic Slave Instance
      Create a Cluster Schema in Spoon
      Execute Transformations in a Cluster
      Initialize Slave Servers in Spoon
      Execute Scheduled Jobs on a Remote Carte Server
    Install License Keys Using the Command Line Interface
    Assign Permissions to Use or Manage Database Connections
    List of Server Ports Used by PDI
      Change Service Port Numbers
    Change the DI Server URL
    Logging and Monitoring Operations
      Enable Logging
      Monitor Job and Transformation Results
        slave-server-config.xml
      Use Checkpoints to Restart Jobs
      Data Integration Operations Mart
        Install the DI Operations Mart
        Set Up Database Connections
        Create the DI Operations Mart
        Configure Logging Data Collection
        Update the Logging for the DI Operations Mart
        Load the Sample Data in the DI Operations Mart
          Loading the Sample Reports, Charts, and Dashboards
        Set Up and Distribute the Data Models
        Give Users Access to the DI Operations Mart
        Create Charts, Reports, and Dashboards Using PDI Operations Mart Data
          Create ETL Logging Reports
          Create ETL Logging Charts
          Create ETL Logging Dashboards
        Logging Tables Status for the Data Integration Operations Mart
        Logging Dimensions and Metrics for the Data Integration Operation Mart
        Clean Up Operations Mart Tables
    Contents of the .kettle Directory
      Change the PDI Home Directory Location (.kettle folder)
    Back Up the DI Repository
    Troubleshooting
      Jobs Scheduled on DI Server Cannot Execute Transformation on Remote Carte Server
      Sqoop Import into Hive Fails
Develop Custom Solutions
  Create Custom Dashboards
    Introduction
    Dashboard Theory
    Dashboard Designer
      Use Dashboard Designer
        Create a New Dashboard
          Work with the Chart Designer
            Rotate Chart Axis Labels
            Correct Scaling Issues
            Work with Dial Charts
            Work with Pie Charts
            Add Data to a Chart
          Add a Data Table to a Dashboard
            Update the Data Table Display
          Add a Report Designer Report to a Dashboard
          Add an Analyzer Report to a Dashboard
          Add a Web Site to a Dashboard
        Use Prompts on Dashboards
          Add a Prompt to a Dashboard
          Create a Metadata List
          Create a Cascading Prompt
          Link Dashboard Prompts to Analyzer Parameters
          Edit Prompts
        Dashboard Parameters
          Create Chart or Data Table Parameters With the Query Editor
        Use Content Linking to Create Interactive Dashboards
          Link Charts and Data Tables
          Link Columns in a Data Table to Content in other Dashboard Panels
          Create Content to Content Links in an Analyzer Report
          Control a Dashboard Parameter From a PRPT Hyperlink
          Dynamic Dashboard Titles
        Saving Dashboards
        Add Content to a Dashboard Using Drag-and-Drop
        Adjust White space in Dashboard Panels
        Set the Refresh Interval
      Create a Dashboard Designer Template
    Community Dashboard Framework (CDF)
  Customize User Console and Tools
    Introduction
    Pentaho User Console Styling
    Create Design Tool Templates
      Create a Dashboard Designer Template
      Create Reporting Templates
        Report Design Wizard Template Design Guidelines
        Interactive Reporting Template Design Guidelines
        Dynamic Element Positioning in Templates
        Template Properties
        Deploy a Template to Report Design Wizard
        Deploy a Template to Interactive Reporting
        Set the Default Interactive Reporting Template
    Extend Pentaho Analyzer with Custom Visualizations
      Create a Pentaho BA Server Plug-in
      Custom Visualizations
        Define the Custom Visualization
      Register the Visualization with Pentaho Visualization API
      Register the Visualization with Pentaho Analyzer
      Register the Created JavaScript Files with Pentaho Analyzer
      Restart the BA Server and Test the Visualization
      Additional Resources
  Embed BA into Web Applications
    Introduction
    Prerequisites
    Integration Samples
    Integrating BA Server Functionality
      Reporting Samples
      Analyzer Samples
      Interactive Reporting Samples
      Action Sequence Samples
      Repository and Scheduler REST APIs
      Integrating Pentaho Mobile for OEM Software Vendors
      Security Integration
    Developer Support
    License Information
  Embed and Extend Reporting
    Introduction
    Required Knowledge and Expertise
    Obtaining the Pentaho Reporting SDK
    Using the Included Eclipse Project
    Embedding the Reporting Engine Into a Java Application
      Overview
      Sample 0: The Base Class
      Sample 1: Static Report Definition, JDBC Input, PDF Output
      Sample 2: Static Report Definition, JDBC Input, HTML Output
    Pentaho Reporting's Capabilities
      Technological Advantages
      Input Types
      Output Types
      Pentaho Report Designer
    Other Embedding Scenarios
      Building a Custom Reporting Tool
      Hacking Pentaho Report Designer
      Embedding the Pentaho BI Platform
    License Information
    Developer Support
    Anatomy of the Pentaho Reporting SDK
    JAR Reference
    Source Code Links
    More Examples
      Sample 3: Dynamically Generated, JDBC Input, Swing Output
      Sample 4: Dynamically Generated, JDBC Input, Java Servlet Output
  Embed and Extend DI
    Getting Started
    Extending Pentaho Data Integration
      Creating Step Plugins
        Maintaining Step Settings
        Implementing the Step Settings Dialog Box
        Processing Rows
          Storing the Processing State
          Working with Rows
          Working With Fields
          Handling Errors
          Understanding Row Counters
          Logging in Transformation Steps
        Deploying Step Plugins
        Sample Step Plugin
        Exploring More Steps
      Creating Job Entry Plugins
        Implementing a Job Entry
        Implementing the Job Entry Settings Dialog Box
        Logging in Job Entries
        Deploying Job Entry Plugins
        Sample Job Entry Plugin
        Exploring More Job Entries
      Creating Database Plugins
        Exploring Existing Database Implementations
        Deploying Database Plugins
        Sample Database Plugin
      Creating Partioner Plugins
        Implementing the Partitioner Interface
        Implementing the Partitioner Settings Dialog Box
        Deploying Partitioner Plugins
        Sample Partitioner Plugin
        Exploring Existing Partitioners
      Debugging Plugins
      Localization
    Embedding Pentaho Data Integration
      Running Transformations
      Running Jobs
      Building Transformations Dynamically
      Building Jobs Dynamically
      Obtaining Logging Information
      Exposing a Transformation or Job as a Web Service
  Create Custom Dashboards
    Introduction
    Dashboard Theory
    Dashboard Designer
      Use Dashboard Designer
        Create a New Dashboard
          Work with the Chart Designer
            Rotate Chart Axis Labels
            Correct Scaling Issues
            Work with Dial Charts
            Work with Pie Charts
            Add Data to a Chart
          Add a Data Table to a Dashboard
            Update the Data Table Display
          Add a Report Designer Report to a Dashboard
          Add an Analyzer Report to a Dashboard
          Add a Web Site to a Dashboard
        Use Prompts on Dashboards
          Add a Prompt to a Dashboard
          Create a Metadata List
          Create a Cascading Prompt
          Link Dashboard Prompts to Analyzer Parameters
          Edit Prompts
        Dashboard Parameters
          Create Chart or Data Table Parameters With the Query Editor
        Use Content Linking to Create Interactive Dashboards
          Link Charts and Data Tables
          Link Columns in a Data Table to Content in other Dashboard Panels
          Create Content to Content Links in an Analyzer Report
          Control a Dashboard Parameter From a PRPT Hyperlink
          Dynamic Dashboard Titles
        Saving Dashboards
        Add Content to a Dashboard Using Drag-and-Drop
        Adjust White space in Dashboard Panels
        Set the Refresh Interval
      Create a Dashboard Designer Template
    Community Dashboard Framework (CDF)
  Customize User Console and Tools
    Introduction
    Pentaho User Console Styling
    Create Design Tool Templates
      Create a Dashboard Designer Template
      Create Reporting Templates
        Report Design Wizard Template Design Guidelines
        Interactive Reporting Template Design Guidelines
        Dynamic Element Positioning in Templates
        Template Properties
        Deploy a Template to Report Design Wizard
        Deploy a Template to Interactive Reporting
        Set the Default Interactive Reporting Template
    Extend Pentaho Analyzer with Custom Visualizations
      Create a Pentaho BA Server Plug-in
      Custom Visualizations
        Define the Custom Visualization
      Register the Visualization with Pentaho Visualization API
      Register the Visualization with Pentaho Analyzer
      Register the Created JavaScript Files with Pentaho Analyzer
      Restart the BA Server and Test the Visualization
      Additional Resources
  Embed BA into Web Applications
    Introduction
    Prerequisites
    Integration Samples
    Integrating BA Server Functionality
      Reporting Samples
      Analyzer Samples
      Interactive Reporting Samples
      Action Sequence Samples
      Repository and Scheduler REST APIs
      Integrating Pentaho Mobile for OEM Software Vendors
      Security Integration
    Developer Support
    License Information
  Embed and Extend Reporting
    Introduction
    Required Knowledge and Expertise
    Obtaining the Pentaho Reporting SDK
    Using the Included Eclipse Project
    Embedding the Reporting Engine Into a Java Application
      Overview
      Sample 0: The Base Class
      Sample 1: Static Report Definition, JDBC Input, PDF Output
      Sample 2: Static Report Definition, JDBC Input, HTML Output
    Pentaho Reporting's Capabilities
      Technological Advantages
      Input Types
      Output Types
      Pentaho Report Designer
    Other Embedding Scenarios
      Building a Custom Reporting Tool
      Hacking Pentaho Report Designer
      Embedding the Pentaho BI Platform
    License Information
    Developer Support
    Anatomy of the Pentaho Reporting SDK
    JAR Reference
    Source Code Links
    More Examples
      Sample 3: Dynamically Generated, JDBC Input, Swing Output
      Sample 4: Dynamically Generated, JDBC Input, Java Servlet Output
  Embed and Extend DI
    Getting Started
    Extending Pentaho Data Integration
      Creating Step Plugins
        Maintaining Step Settings
        Implementing the Step Settings Dialog Box
        Processing Rows
          Storing the Processing State
          Working with Rows
          Working With Fields
          Handling Errors
          Understanding Row Counters
          Logging in Transformation Steps
        Deploying Step Plugins
        Sample Step Plugin
        Exploring More Steps
      Creating Job Entry Plugins
        Implementing a Job Entry
        Implementing the Job Entry Settings Dialog Box
        Logging in Job Entries
        Deploying Job Entry Plugins
        Sample Job Entry Plugin
        Exploring More Job Entries
      Creating Database Plugins
        Exploring Existing Database Implementations
        Deploying Database Plugins
        Sample Database Plugin
      Creating Partioner Plugins
        Implementing the Partitioner Interface
        Implementing the Partitioner Settings Dialog Box
        Deploying Partitioner Plugins
        Sample Partitioner Plugin
        Exploring Existing Partitioners
      Debugging Plugins
      Localization
    Embedding Pentaho Data Integration
      Running Transformations
      Running Jobs
      Building Transformations Dynamically
      Building Jobs Dynamically
      Obtaining Logging Information
      Exposing a Transformation or Job as a Web Service
Upgrade Existing Pentaho Systems
  Explore What's New in BA
    What's New in Pentaho Business Analytics 5.0
  Upgrade BA Systems
    BA Upgrade Introduction
    BA Documentation Overview
    BA Upgrade Overview
    Prepare Upgrade Plan
    Prepare Environment
    Export Data from Old Server
    Import Data to New Server
    Verify Upgrade
    Next Steps
  Explore What's New in DI
    New Features for Pentaho Data Integration
  Upgrade DI Systems
    DI Upgrade Introduction
    DI Documentation Overview
    DI Upgrade Overview
    Prepare Upgrade Plan
    Prepare Environment
    Export Data from Old Server
    Import Data to New Server
    Verify Upgrade
    Next Steps
  Explore What's New in BA
    What's New in Pentaho Business Analytics 5.0
  Upgrade BA Systems
    BA Upgrade Introduction
    BA Documentation Overview
    BA Upgrade Overview
    Prepare Upgrade Plan
    Prepare Environment
    Export Data from Old Server
    Import Data to New Server
    Verify Upgrade
    Next Steps
  Explore What's New in DI
    New Features for Pentaho Data Integration
  Upgrade DI Systems
    DI Upgrade Introduction
    DI Documentation Overview
    DI Upgrade Overview
    Prepare Upgrade Plan
    Prepare Environment
    Export Data from Old Server
    Import Data to New Server
    Verify Upgrade
    Next Steps
View Archives
  Get Documentation for Pentaho Releases
  Get Documentation for Pentaho Releases