Vendor Sales

Report based dashboard ..

Workshop - Vendor Sales

Report-based dashboards leverage existing reports created in Pentaho Report Designer or other reporting tools. This approach is ideal when you already have well-designed reports and want to combine them into an interactive dashboard view.

You can simply import these pre-built reports and arrange them in the dashboard layout. The advantage is that you're reusing existing work and maintaining consistency across your reporting environment.

However, this method may be less flexible for real-time modifications since you need to modify the underlying reports to make changes.

After completing this workshop, you will be able to:

• Create an Interactive - prompted dashboard

Dashboard Templates

Creating a dashboard in Dashboard Designer is as simple as choosing a layout template, theme, and the content you want to display.

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 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.

PreviousDashboard Designer NextInventory

Last updated 3 days ago

Was this helpful?