Vendor Sales | Pentaho Academy

From the User Console Home Perspective, click Create New -> Dashboard.

2. To select the 2 over 1 template, on the Templates tab, click 2 over 1.

To view the available themes, click the Themes tab.

Keep the default Ruby theme.
Enter a title for the dashboard, click the Properties tab.
Type: Training Demo Dashboard.

Notice the button allowing you to resize the panels and the Refresh Interval field.

To resize the panels, click the Resize Panels button.
Drag the vertical line about an inch to the left to make the Untitled 1 panel smaller, and then in the lower right corner of the canvas.
Click Close.

The blue horizontal and vertical lines, allow you to resize the panels.

You can easily add reports created with Interactive Reporting, Analyzer, and Report Designer to the dashboard by dragging content from the Files pane to a panel on the dashboard.

Alternatively, you can click the Add Content icon on the panel title bar and then select File.

Highlight ‘Untitled1’ dashboard pane.
Click on the dropdown ‘Content’ icon in the top right, and select File.

From the Files pane, Select: European Sales (geo map).

In the Title text box, type European Sales
Click Apply.

To add a report created with Interactive Reporting to the dashboard, from the Browse pane:
Click the main Steel Wheels folder (Public -> Steel Wheels).
Select: Vendor Sales Report (interactive report).
In the Title text box, type Vendor Sales.
Click Apply.

In the bottom pane display the parameters for region and Product Line used in the report.

Later, we will use these parameters as dashboard prompts.

Add a report created with Report Designer to the dashboard, from the Files pane, click Inventory List.
In the Title text box, type Inventory List
Click Apply.

You can create dashboard prompts to apply to the content within the entire dashboard. Dashboard prompts can only be applied to individual reports within the dashboard if the report filter is set up as a parameter.

So .. we're going to create dashboard prompts for Territory and Product Line, then apply the dashboard prompts to the Vendor Sales Report in the dashboard.

To display the Prompt toolbar, from the Objects list in the bottom pane, click Prompts, then click the checkbox for Show Prompt Toolbar.

The Prompts pane appears at the top of the dashboard. You can resize the pane from the General Settings > Properties tab.

Add a prompt, in the bottom pane, click the + icon.

The Name field displays in the Prompt toolbar, therefore it is a good idea to use a prompt such as “Select one or more Territories:” for the Name.

The Control area shows the various types of prompts available: drop-down, list, radio button, checkbox, buttons, text field, or date picker.

The Data area identifies the values for the prompt. You can type a static list of values, create a SQL query to pull the values from a file, or use a metadata list from a defined data source.

The Control Properties area shows different options depending on the type of prompt.

In the Name text box, type: Select one or more Territories:
To create a list of selection buttons, in the Control area, click the Buttons icon.
To use a metadata list for the prompt, in the Data area, from the Type drop-down list, select Metadata List, and then click Select.
To select the Orders data source, click Orders, and then click OK.

The Query Editor window opens.

Create a simple query to pull the list of territories from the Customer table, excluding Null values. In other words, a statement to only return the territories that are not null.

Select: Territory, in the Categories/Columns list:

• Click the plus sign for Customer.

• Click Territory.

• Click the > arrow to move Territory to the Selected Columns.

Specify a condition to return Territory values that are not null:

• Click the middle arrow to move Territory to the Conditions.

• From the Comparison drop-down list, select is not null.

• Click OK.

Click Preview and check that the list is what you expect.

Click Close.
In the Control Properties area:

• From the Display drop-down list, select Horizontal.

• Click the checkbox for Allow multiple selections.

• Click OK.

Apply the Territory prompt to the Vendor Sales Report, from the Objects list in the bottom pane:

• Click Vendor Sales Report.

• From the region Source drop-down list, select Select one or more territories:

• Click Apply.

Test the prompt, on the list of prompt buttons:

• Deselect APAC.

• Select: EMEA.

Repeat the workflow to create a prompt for: Product Line
View the results in the Vendor Sales Report.