Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

Get started with Analyzer Reports

Parent article

Analyzer Reports is an intuitive analytical visualization tool that filters and drills down into business information contained in Pentaho analysis data sources. Use Analyzer Reports if you want to compile data quickly in an interactive environment, perform advanced sorting and filtering of your data, and want to see chart visualizations that include conditional stop-lighting.

View an Analyzer report sample

This section highlights some popular Analyzer capabilities that are available, using the sample report called European Sales located in the Getting Started widget.

Procedure

  1. In the Getting Started widget on the Home page, click the Samples tab.

  2. In the scrolling panel, scroll down and click European Sales and then click Explore.

    European Sales (Geo Map) A new browser window will open. Click the Samples tab to see the report.

Tour the Analyzer panels

You can view the editable version of European Sales in Analyzer by going to the Browse Files page in the User Console. Follow these steps:

Procedure

  1. From the User Console Home page, click the Browse Files button. In the Browsing pane, click to expand the Public folder, then click to expand the Steel Wheels folder.

  2. In the center pane, double-click on European Sales.

    Opened page, Analysis report The Opened page appears with the Analyzer report.
  3. Click the Add More Fields and Rearrange Fields icons on the toolbar to expand the Available Fields and Layout panels.

    ItemNameFunction
    1Opened pageDisplays quick access buttons across the top to create and save a new Analysis Report, Interactive Report, and Dashboard. Opened reports and files show as a series of tabs across the page.
    2Available Fields and Layout panelsUse the Available Fields and Layout panels to drag levels and measures into a report.

    Your report displays changes in the report canvas as you drag items onto the Layout panel.

    Delete a level or measure from your report by dragging it from the Layout panel toward the lower right corner of the report canvas. As you drag it, a trash can icon appears in the lower right corner of the canvas.

    3Report canvasShows a dynamic view of your report as you work to build it. The look of your report changes constantly as you work with Available Fields and Layout panels to refine it.

    The report canvas shows different fields based on the chart type selected.

    4Analyzer toolbar and filtersUse the toolbar functions to undo or redo actions, hide lists of fields, add or hide filters, disable the auto-refresh function, adjust settings, and change the view of your report.

    Use the Filters panel to display a list of filters applied to the active report, or edit or delete filters.

Create your first Analyzer report

The instructions below guide you through the creation of your first Analyzer report, using the Steel Wheels sample data.

Procedure

  1. From the User Console Home page, click Create New, then choose Analysis Report.

  2. Choose the SteelWheels:SteelWheelsSales data source from the Select Data Source dialog box. Click OK.

    A blank Analyzer report appears.
  3. Click and drag the Territory element and drop it into the Rows field. Click and drag the Years element and drop it into the Columns field. Click and drag the Sales element into the Measures field.

    Pivot table, Analysis Report A pivot table with the Territory, Years, and Sales data appears and populates with the information from the server.
  4. Click and drag the Line field and drop it above Territory in the Layout column on the canvas. Right-click the Line column header and select Show Subtotals from the menu that appears.

    Show Subtotals, Analysis Report
  5. Right-click the first Sales column and select Conditional Formatting Data Bar - Green in the menu that appears.

  6. Right-click the same Sales column and select User Defined Measure % of Rank, Running Sum. In the dialog box that appears, select the % of Sales radio button. Click Next.

    Measure field creation
  7. Select the Each Line Column/Row Subtotal (Subtotal is 100%) radio button. Click Done.

    Measure field refinement
  8. Expand the filters canvas by clicking the Show Filters icon. Click and drag the Territory field from the Available Fields panel into the filter canvas.

    The Filter on Territory dialog box appears.
  9. In the Filter on Territory dialog box, select APAC from the list and click the top, right-pointing arrow to move it to the box on the right.

  10. Enable Parameter Name by clicking on the check box in the bottom left of the dialog box. Type region as your parameter name in the text box. Click OK.

    Filter on Territory dialog box The report updates and displays sales data for APAC exclusively.
  11. Click the line that separates each column to adjust it for better viewing. Move the line right or left as needed.

    Sales data, Analysis report
  12. Click the Save As icon in the toolbar. When the Save As dialog box appears, save your report as Territory - Sales in your user folder (be sure you can find this folder again later) and then click Save.

Results

You have successfully created a simple Analyzer report from scratch. You may export the report to one of several different formats or close the report. Pentaho Analyzer guides you through working with complex Analyzer reports.