Pentaho Dashboard Designer
Creating a dashboard in Dashboard Designer is as simple as choosing a layout template, theme, and the content you want to display. In addition to displaying content generated from Interactive Reports and Analyzer, Dashboard Designer can also include these content types:
Charts
Simple bar, line, area, pie, and dial charts created with Chart Designer.
Data Tables
Tabular data.
URLs
Web sites that you want to display in a dashboard panel.
Dashboard Designer has dynamic filter controls, which enable dashboard viewers to change a dashboard's details by choosing different values from a drop-down list, and to control the content in one dashboard panel by changing the options in another. This is known as content linking.
In this topic
Get started with the Dashboard Designer
Learn about the Dashboard Designer by viewing a sample dashboard in the User Console.
Complete the following steps to view an editable, sample dashboard containing sales performance data for the example company, Steel Wheels.
Navigate to the User Console Home page.
Click Browse Files.
In the Folders pane, click to expand the Public folder, then click the Steel Wheels folder.
The content of the Steel Wheels folder opens in the Files pane.
In the Files pane, select Sales Performance (dashboard).
In the File Actions pane, click Edit.
The Editing: Sales Performance (dashboard) tab opens.
In the Objects pane, click Prompts, and then select the Show Prompt Toolbar checkbox.
The Prompts section is added to the Editing: Sales Performance (dashboard) tab.
Next, review the function of each of the following areas of the Dashboard Designer user interface.
1
Opened view toolbar
A toolbar that you can use to open, create, edit, save, and print Analyzer Reports, Interactive Reports, and dashboards. The Dashboard Designer shows opened reports and files as a series of tabs across the page.
2
Prompts section
Expandable section containing filters than you can add to the dashboard. The Prompts section appears only when you select the Show Prompt Toolbar checkbox for the Prompts object in General Settings.
3
Browse and Files panes
Panes containing lists of folders and files that you can navigate to find a file with content that you want to add to the open dashboard.
4
Dashboard canvas
A dynamic view of the dashboard that updates as you build the dashboard. You can build the dashboard by adding content, applying filters, and changing object settings.
5
Objects pane
A pane containing settings that you can use to apply templates and themes to the dashboard, show or hide the Prompts section, and edit page and object titles.
Creating dashboards
Dashboards let you combine multiple content types on one page.
You can add Analyzer and Report Designer reports, website content, and existing repository items.
Create a dashboard
You must be logged into the User Console.
From the User Console Home page, click Create New, then select Dashboard.
The name you enter appears in the top-left corner of the dashboard. This name helps you find the dashboard later.
At the bottom of the page, select the Properties tab.
In Page Title, enter a title for the dashboard page.
Select Templates to choose a dashboard layout.
A blank dashboard opens with the layout you selected.
Select Theme to choose a theme.
Dashboard Designer applies the theme.
Add a report from Analyzer
Use these steps to display an Analyzer report in a dashboard panel.
Select a panel in Dashboard Designer.
Select Insert > File.
Find the Analyzer report, then click Select.
The report appears in the dashboard panel.
Export an Analyzer report
You can export an Analyzer report from a dashboard as a PDF, CSV, or Excel workbook.
In the dashboard toolbar, select Actions.
Select an export format:
Export to PDF
Export to CSV
Export to Excel Workbook
Your selection stays as the default format until you change it.
Pentaho User Console downloads the export to your browser’s default download folder.
Add a report from Report Designer
Use these steps to add a report created with Report Designer.
Select a panel in Dashboard Designer.
Select Insert > File.
A browser window opens.
Find the report file.
Click Select to place the report in the dashboard panel.
Use the pagination arrows at the top of the report. They let you scroll through long reports.
The report file name appears under Content in the edit pane.
Sample report in dashboard
If the report has required parameters, enter values for them. If you do not, the report renders blank.
Add a website
Use these steps to show website content in a dashboard panel.
Select a panel in Dashboard Designer.
Select Insert > URL.
The Enter Web site dialog opens.
Enter the website URL, then click OK.
To change the URL later, select Edit.
Drag-and-drop content
Use these steps to add an existing chart, table, or file to a dashboard panel.
In the left pane in the User Console, under Files, find the content.
Drag the content into a blank dashboard panel.
The content title turns green when you can drop it.
Repeat step 2 until the dashboard shows all content you want.
To swap content between panels, drag one panel’s title bar onto another panel.
If you drop content onto a panel that already has content, Dashboard Designer replaces the existing content.
Create a chart
Within a dashboard, you can present data visually with bar, pie, line, dial, and area charts. To create a chart, first use the Query Editor to select a data source on which the chart is based. After defining the data source, use the Chart Designer to create a chart that presents the data in the dashboard. The following tutorials include the basic steps for creating a dashboard chart.
In this guide:
Use Query Editor
Learn how to use the Query Editor to retrieve dynamic data from a data source so that you can include the data in a new dashboard chart.
Complete the following steps to select a source and define data from that source to use in the Orders by Country {parm} chart. The Orders by Country {parm} chart is shown in the sample dashboard containing sales performance data for the example company, Steel Wheels.
Navigate to the User Console Home page.
Click Browse Files.
In the Folders pane, click to expand the Public folder, and then click the Steel Wheels folder.
The content of the Steel Wheels folder opens in the Files pane.
In the Files pane, select Sales Performance (dashboard).
In the File Actions pane, click Edit.
The Editing: Sales Performance (dashboard) tab opens.
In the Editing: Sales Performance (dashboard) tab, navigate to the Orders by Country {parm} pane.
Click the Insert Content icon, and then click Chart.
The following image shows the Insert Content icon and the Chart option.
Location of the Insert Icon and Chart list option in the Query Editor. ItemName1
Insert Content
2
Chart
A warning opens for discarding current content.
Click OK.
The Select a Data Source window opens.
Select Orders and click OK.
The Query Editor window opens.
In the Categories / Columns pane, click to expand the Customer list.
Select Territory, and then click the top right arrow to add the Territory column to the top right table.
The following image shows the Territory option that you select in the Categories / Columns pane, the top right arrow that you click to add the Territory column to the top right table, and the top right table where you add the Territory column.
Location of the Territory option, top right arrow, and Territory column in the Query Editor. In the Categories / Columns pane, click to expand the Orders list.
Select Total, and then click the middle right arrow to add the Total column to the middle right table.
Click Preview to preview the table with data from the source that you selected in the columns that you added.
The following image shows the Preview window that contains a table with order data in the Territory and Total (SUM) columns.
Preview window in the Query Editor. Click Close to close the Preview window.
Click OK.
The Chart Designer window opens.
Next: Use Chart Designer.
Use Chart Designer
After defining the data for the new chart with the Query Editor, you are ready to create the visual layout for the chart using the Chart Designer.
This part of the tutorial assumes you have followed the steps in Use Query Editor to define the data for the examples shown in the following steps.
In Chart Designer, under Data, click the drop-down arrow to display the data selection menu:
Data panel Data FieldDescriptionSeries Column
Series display as the individual columns on a bar chart and as individual lines in a line chart. Area charts display each series as a point.
Category Column
Categories display as bars or groups of bars on the x-axis (horizontal axis). In line charts, categories are usually associated with time periods. In area charts, the x-axis displays the category labels. If you do not want to display categories, choose None.
Values Column
The value determines the height of columns in a bar chart and the height of lines in a line chart. In area charts, the y-axis values determine the heights of the points. The value is always numeric.
A preview of the chart appears in a box in the upper-right corner of the Chart Designer as you select your options.
Chart designer preview Under Chart Type, click the type of chart applicable for your data. If you are unsure which chart type is best for displaying your data, see Chart types. In this tutorial, Bar Chart is selected.
By default, pie and dial charts display in animated Flash mode. You can turn animation off by disabling the Animated check box in the Chart Designer. Animated charts can highlight key data points. For example, you may want to apply animation if a data point reaches a critical value, such as high or low sales numbers. If you selected a pie or dial chart, see Pie charts or Dial charts.
Under Theme, select a theme from the list. In this tutorial, the Default theme is selected.
The theme is applied to your chart.
Enter the labels for the Chart Title, X Axis Title (horizontal axis), and Y Axis Title (vertical axis).
Entries appear in the chart preview.
Chart preview x and y axis Click Apply to see the chart preview.
Click OK to display your chart in the dashboard panel.
The revised chart now appears in the dashboard.
Chart types
The following guidelines may help you determine which chart type is best suited for the data you want to present in your dashboard:
Bar charts
If you want to compare items during a specific time period, consider using a bar chart.
Keywords to think about when creating a bar chart are compare or rank.
For example, if you want to compare items sold to show which one made the most profit, you might create a bar chart that ranks the products from the lowest to highest profit. The bar's length determines its ranking. The label identifies the item.
Bar chart data can be presented horizontally or vertically depending on your requirements.
Pie charts
If you are comparing parts of a whole, consider using a pie chart. It gives dashboard consumers an immediate visual clue of the relative sizes of the shares of a whole.
Keywords associated with pie charts include portion, share, and percentage.
For example, if you want to demonstrate the proportion of the company's budget spent on health insurance, use a pie chart. Categories are represented by individual slices. To make the chart easier to read, limit the number of slices to five.
The size of the slice in a pie chart is determined by the value as shown in the following example:
You can animate a pie chart if you want its pieces to be exploded. This means that the individual slices of the pie can be pulled away from the rest of the pie.
To animate a pie, enable the Animated check box in the Chart Designer.
Line charts
Line charts are useful for showing changes over time.
Keywords associated with data that is best suited for a line chart are trend, growth, and decline.
If, for example, you want to show how product sales have changed over five years, use a line chart. The slope of the line helps users quickly identify the direction of the trend.
Dial charts
Dial charts are often associated with Key Performance Indicators (KPIs). Dial charts are circular and contain a scale, a needle, and one or more dial sectors.
The dial sector is used to identify a specified area on a dial chart using a particular color. For example, you could have a dial plotting inventory with a minimum dial value of 10000 and a maximum dial value of 50000. There could be a red dial sector for the region between 2000 and 4000 indicating that if the needle is in this area, there is a danger of a supply inventory shortage.
For dial charts to display correctly, you must enter values for your range and the chart title.
In the example below, the dial chart preview is displaying ranges associated with sales. Notice that each dial sector is represented by a color: red, yellow, or green. The needle is positioned in the 220796.48 range, indicating that total orders, while not stellar, are not near the danger zone indicated by the red sector in the dial.
You can change the color of a dial sector by clicking the small down arrow in the color boxes associated with Range. Select a color from the palette so that you can preview it on your dial chart.
Click Apply to preview your dial chart. Click OK to place your dial chart into the dashboard.
Area charts
Area charts can be used to show a comparison of the same thing during different points in time.
Area charts are not designed to provide exact data, but they do give users visual clues of the relative sizes of the items they are representing.
Modify charts
After creating a chart, you can modify it in these ways:
Edit a chart
Use these steps to edit a chart:
In the Dashboard Designer, select the panel that displays the chart.
In the upper-right corner of the panel, click Edit Content.
Chart Designer opens.
Click Edit Query.
Query Editor opens.
Edit the query as needed, then click OK.
Chart Designer opens.
Select the data definitions to build the chart.
Optional: Change the chart type and theme.
Click Apply to preview the chart.
Click OK to show the chart in the dashboard.
Rotate axis labels
Use these steps to rotate chart axis labels:
In Chart Designer, display your chart.
Under Label Rotation, select Diagonal or Vertical, then click Apply.
Click OK to show the chart in the dashboard panel.
Adjust numeric scaling
Use scaling when long numeric values affect chart display.
Scaling is available for all chart types except pie.
Preview your chart in Chart Designer.
Under Scale, open the drop-down list and select a scaling option.
In the example below, the scaling option is 1 million. Hover over bars to see actual values.
Scaling in chart Click OK to show the chart in the dashboard.
Adjust white space in dashboard panels
Sometimes you must adjust the white space in dashboard panels (or the filter panel), so that content appears correctly. Use these steps to adjust white space.
In the lower pane, click General Settings and then click the Properties tab.
Click Resize Panels.
The white space between the dashboard panels turns blue.
Adjust the panel size by clicking and holding the left mouse button down as you move the blue lines (white space) around. Release the mouse button when you are satisfied with the positioning of the panel.
Click Close in the lower-right corner of the dashboard to exit resize layout mode.
Examine the dashboard contents to make sure they are placed correctly.
You can return to the resize layout mode if you need to make additional changes.
Set the refresh interval
The content in your dashboard may need to be refreshed periodically if users are examining real-time data. You can set refresh intervals for individual panels on your dashboard or for the entire dashboard.
To set the refresh interval for individual panels in the dashboard, click the Edit button and the choose the panel that contains the content you want refreshed in the Objects panel.
Under Refresh Interval (sec) enter the interval time in seconds and click Apply.
Optional: If you want the entire dashboard to refresh, click the Prompts tab in the dashboard and set your refresh interval.
Save a dashboard
You must be in Edit mode to save a dashboard.
Click the Save As button (floppy disk and pencil icon) to open the Save As dialog box.
In the File Name text box, type a file name for your dashboard.
Enter the path to the location where you want to save the dashboard.
Alternatively, use the Up and Down arrows or click Browse to locate the solution (content files) directory in which you will save your dashboard.
Click Save.
The report saves with the name specified.
Print a dashboard
You can print a dashboard or save it in PDF format from Dashboard Designer.
From User Console Home, click Create New, then Dashboard.
Navigate to the dashboard that you want to print or create a new dashboard.
Click on the print icon in the tool bar.
Print dashboard icon In the Print Preview Settings window, select paper size and page orientation.
Print Preview Settings window Note: You can make changes to the reports in the dashboard after it opens in the new tab.
Print dashboard preview with sample graphs After making the needed selections, click the Print button to open the browser's print dialog.
Select the same settings in the browser’s print dialog as you made in the Print Preview Settings window.
Use the browser’s print dialog to either save the report as PDF or print the dashboard.
Print dashboard browser's print dialog box The dashboard is printed.
Advanced topics
Use these features to go beyond basic Dashboard Designer setup and use.
In this topic
Set dashboard parameters
Dashboard panels can pass parameters into reports, charts, URLs, and data tables.
Use parameters to filter data, drive prompts, and link panels together.
Understand where parameters come from
Some content defines its own parameters.
For example, an .xaction or .prpt can expose parameters and default values.
You’ll see them under Parameters in the dashboard Edit pane.
Parameter names in the source file are fixed.
You can’t rename them.
You can’t add or remove them.
Other panel types let you define your own parameters.
For example, charts created with Chart Designer, embedded URLs, and data tables.
For these, you can set both the parameter name and value.
Get started with the Query Editor
When you place a chart in a dashboard panel, you use the Query Editor.
The Query Editor retrieves data from a database for your chart or data table.
Add conditions to filter the data.
Use parameters if you plan to:
Use dashboard prompts.
Link one panel to another.
Example: link a pie slice selection to an adjoining data table.
The data table can update when someone clicks a pie slice.
You do this by using a parameter in the query condition.
Create chart or data table parameters
Create a parameter by entering a name in curly braces in the Value field.
Example: {TERRITORY}.
Set a default value (source) for the parameter.
Example: NA (North America).
When the chart or data table runs, it uses the current parameter value.
Dashboard consumers can change the value through prompts or interactions.
To define multiple default values, separate them with a pipe (|).
Example:
NA|EMEA|APAC
If you want a static query value, don’t use curly braces.
This disables Default (value) because there is no parameter.
Add dynamic dashboard titles
Dashboard panels can show their current parameter values in the panel title.
The title now shows the parameter values.
Limits
On Windows, URL parameters are limited to 2,048 characters.
This limit excludes the URL path itself.
Use prompts on dashboards
Prompts filter dashboard data based on user input.
Use prompts to show the right slice of data.
Example: show EMEA sales instead of NA.
To filter dashboard content, the target content must include at least one parameter.
In this section (prompts)
Get started with dashboard prompts
In the dashboard page, select Edit (the pencil icon).
The Objects pane appears.
Under General Settings, select Prompts.
The Prompts pane appears on the right.
To display a prompt toolbar to users of the dashboard, enable Show Prompt Toolbar.
The prompt toolbar appears at the top of the dashboard.
Select Add.
The Prompts dialog box appears.
Enter a display name for the control label, such as
Region.Optional: Enable Display Name as Control Label.
Select a control type:
Drop-down: Users select one value from a drop-down list.
List: Users select one or more values from a scrolling list.
Radio button: Users select one value from radio buttons.
Check box: Users select one or more values from check boxes.
Button: Users select one or more values from buttons.
Text field: Users enter a text string or number.
Date picker: Users select values based on calendar dates.
Your dashboard now has a prompt.
Edit prompts
Locate the prompts pane at the top of the panes in the dashboard.
Find the prompt you want to change.
Select an alternative prompt from the drop-down menu next to the prompt.
The dashboard updates to match the new prompt selection.
Other prompt types
In addition to standard dashboard prompts, you can use:
Toolbar prompts
Date prompts
List prompts
Create a toolbar prompt
Toolbar prompts let users refine report results in a dashboard.
Open a dashboard that contains at least one parameterized report.
Select Edit Content to open the editing options.
In the Objects pane, select Prompts.
Enable Show Prompt Toolbar.
Select Add.
The Prompt dialog box appears.
In the Name field, enter the title for the prompt toolbar.
In the Control box, select the control type.
Under Type, ensure Static List is selected.
Customize toolbar prompts
In the Data box, select Add.
The List Value dialog box appears.
In the Label field, enter the option name as you want it to appear.
In the Value field, enter the parameter source name.
If you are using the Steel Wheels sample, enter
Classic Cars.Add labels and values for each parameter you want to filter. Select Close.
If you are filtering an Analyzer report and using a static list, you can add the option All. This option drops the filter from the report and shows all values.
Under Control Properties > Initially Selected, choose which item appears first in the prompt list.
Choose Use First Value to default to the first list value. Choose Specify to set a specific value.
Select OK.
In the Objects pane, choose the report you want to filter. Select the Parameters tab and choose the correct Source for the parameter.
The source should match the name of your prompt.
Select Save.
Create a date prompt
The date picker prompt lets users select values based on calendar dates.
When you create a date picker prompt, you must set a date format. The default format is yyyy-MM-dd.
The date picker prompt uses Dojo date formats. In the past, this component was based on the jQuery datepicker. To support legacy formats, old formats are converted automatically.
Not all formats are supported or make sense when a date is selected. Anything with less granularity than a unit of "day" defaults to the Dojo format. Use formats from d to y that the date picker control supports. For example, yyyy-MM-dd, yy-M-d, and d/MM/yyyy are valid.
As a result, the pattern can be any combinations of the following patterns of years, quarters, months, and days:
G
era
AD
y or yy
year (two digit)
16
yyy or yyyy
year (four digit)
2016
q or Q
quarter (one digit)
1
M
month numeric (no leading zero)
1
MM
month numeric (two digit)
01
MMM
month name short
Jan
MMMM
month name long
January
d
day of month (no leading zero)
4
dd
day of month (two digit)
04
D
day of the year
4
E
day of the week
2
Create a list prompt
When you create a metadata list, you define a query to retrieve a list of display names and corresponding values from a metadata data source provided by your administrator.
You must have a data table or chart that contains at least one parameter. Otherwise, the prompt control will not work.
In the dashboard page, under General Settings, select Prompts.
The Prompt Editor appears on the right.
To display a prompt toolbar to users of the dashboard, enable Show Prompt Toolbar.
A placeholder for the prompt toolbar appears at the top of the dashboard.
Select Add to add a prompt.
The Prompts dialog box appears.
In the Prompts dialog box, enter a Name for your prompt.
Under Data Type, choose Metadata List.
Select Select to choose the data source that contains the content you need, then select OK.
The Query Editor opens.
In the Query Editor, build a query to choose either:
A single column, which represents both a name and a value
Two columns, representing the display names and corresponding values
If a single-column query is defined, the values of that column are used for both display names and values.
Select OK to exit the Query Editor.
Your options appear under Selected Items in the Prompts dialog box.
Under Control Properties, enter a default Label and Value for the initially selected option.
Select a Label to display in the prompt control.
This is the user-friendly name that users will see in the dashboard.
Select the Value.
This is the value in the database that is associated with the label.
Optional: Choose a Display type.
Some prompt controls let you choose the position of prompt options. If you have a long list of options, such as a list of cities, options may not appear correctly in the user console unless you change Display to Horizontal.
Select OK.
The list of values appears in the prompts toolbar in the dashboard.
Create a cascading list prompt
A cascading prompt changes based on the value a user selects. For example, when the value in the drop-down list Country changes, that prompt is automatically applied to the second prompt, City, which changes its values.
This task uses the example of creating a country-city cascading prompt.
For Type, select Metadata List to create the drop-down prompt
Country.
Filter from metadata list For Type, select SQL List, which includes a parameter, ${selected_country}, in its associated query for the check box prompt
City.
Filter from SQL list Set the Default Value for the
selected_countryparameter toUSAwith New York City (NYC) as the initially selected value for the check box prompt.
To link the City prompt to the Country prompt, choose another Source for the selected_country parameter. Choose the Country prompt as the alternate source. When the prompts are linked, users can choose a country, then choose one or more cities in that country.
Using this example, you can now add a data table, chart, or other content in the dashboard that can be driven by the prompt you created. If you add a pie chart to the dashboard, the pie chart can show the percentage of sales per city. In the Query Editor, create a parameter, {City}, with an extended default value: NYC|Las Vegas. The resulting pie chart displays values for New York City and Las Vegas. Under the Parameters tab associated with the pie chart, change the Source value for the City parameter to the City prompt.
When the report is saved, dashboard users can see results for a country and multiple cities in that country.
Link dashboard prompts to Analyzer parameters
The instructions below explain how to parameterize an Analyzer report.
Note: This process only applies to dashboards that include parameterized Analyzer reports. You must have a query parameter in the Analyzer report to proceed.
In your Analyzer report, right-click a field you want to link to, then select Filter.
The Filter dialog box opens. In this example, data will be filtered by Territory.
Analyzer filter Enter a name for the parameter in the Parameter Name field and select its checkbox to enable it.
Select the values you want associated with the parameter. Use the arrow buttons to add and remove values.
Select OK to save and close the Filter dialog box.
Be sure to save your report.
In the upper-left corner of the report, confirm that a filter is in use.
Optional: Select Edit (pencil) to change the filter, or Delete (X) to remove it.
Create a dashboard and drag the Analyzer report into a panel.
The parameter name appears under Parameters.
If a Between operator is parameterized, two parameters are automatically created with the suffixes
_STARTand_END.Add a filter to the dashboard based on the parameter you created in your Analyzer report.
The filter appears in the dashboard.
Use data tables in a dashboard
Use a data table to show query results in a dashboard panel.
Data tables are interactive. Viewers can sort, resize, and reorder columns.
Add a data table to a dashboard
Select a panel in the Dashboard Designer.
Select Insert > Data Table.
Select a Data Source opens.
Select a data source.
Select OK.
The Query Editor opens.
Build your query.
Expand a category to show its columns.
Select the column you want.
Select the yellow arrow to add it to Selected Columns.
Add conditions.
Use conditions to filter results. You can add multiple conditions.
Under Combine, select the operator: and, or, and not, or or not.
Under Comparisons, select the comparison operator, such as
=,<, or>.Optional: For numeric columns, select an aggregation type:
SUM: Sum of valuesCOUNT: Count of valuesAVG: Average of valuesMIN: Minimum valueMAX: Maximum value
Select Preview at any time to review results.
Add one or more Order By columns.
Order By controls sorting of the returned rows.
Select OK.
The data table appears in the selected dashboard panel.
Update the data table display
Edit the data table display directly in the dashboard panel.
Sort, show, or hide columns
In a column header, select the drop-down arrow.
Select Sort Ascending or Sort Descending.
Optional: Clear a column checkbox to hide that column.
Resize a column
Select the right edge of the column header.
Drag left or right.
Reorder columns
Drag a column header to the new position.
Use pagination
Use pagination to page through large result sets.
Use content linking to create interactive dashboards
Depending on your needs, you can create a static dashboard, which contains content in each panel that is separate but related. For example, you may provide users with a bar chart that contains total sales figures by region. Additionally, you may provide a data table that displays sales details for each state in a specific region. You may also want to provide sales data associated with each salesperson in a specific region. The content in your dashboard is useful to dashboard consumers, but to make it more interactive, you may want to consider using content linking.
The content linking features in dashboards allow you to associate (link) content in one dashboard panel to content on another dashboard panel as long as query parameters have been defined. These features are particularly helpful for drilling down or for dynamic filtering; for example, when dashboard consumers explode a single slice in a pie chart to launch content in a data table associated with that pie slice. In this instance, dashboard consumers are moving from a summary view to a detailed view interactively.
You can use content linking if your dashboard panel contains a data table, chart, .xaction, .prpt, and Analyzer report.
In this section (content linking)
Getting started with query parameters
Query parameters are required for content inside a dashboard panel to receive values used to filter data from a filter control.
They are also required when receiving values from content in other dashboard panels that are broadcasting values through content linking.
How you define query parameters depends on the content type in your dashboard panels:
You are defining parameters in an Analyzer report
You are defining parameters for a chart or data table
Use the Query Editor to define your parameterized query. Then see Link charts and data tables and Link columns in a data table to other dashboard panels.
Link charts and data tables
The instructions below explain how to create links to charts and data tables in a dashboard. Adjust the examples shown in these instructions, as necessary, when working with your own data.
Create a simple dashboard that contains a chart and a data table.
At this point, none of the content has been linked and you have a "static" dashboard.
Simple dashboard In the pie chart in this example, you want the data table on the right to update with the values associated with a pie chart slice when dashboard consumers click that slice (NA, APAC, Japan, and EMEA).
For example, if a report consumer clicks the EMEA slice, the data table will display values associated with EMEA and nothing else.
To get the correct filter display, you must first create a parameterized query that drives the content in the data table.
Click the Edit button to open the Edit pane at the bottom of the screen.
Within the Objects pane, choose the report you want to parameterize.
Parameterizing a query, as described here, allows you to pass values dynamically and update the chart based on events triggered by other elements of the dashboard such as a user choosing an item from a filter control or following links defined in content associated with another panel in the dashboard.
Click the {p} button next to the Title box.
The parameters will populate after the title in the Title box.
Click the Parameters tab and ensure that the parameter name is linking to the correct source.
Click Apply.
The new source for the parameter corresponds to the title of the dashboard panel that contains the chart as shown in the example above. This new source will now drive the display in the data table.
Click the Edit button (pencil icon) to exit edit mode.
The filters will appear after the panel titles.
Save your dashboard.
See Save a dashboard.
When users click a pie slice or bar in a chart, the data table displays content associated with that specific pie slice or bar.
The currently applied filters appear after the title.
Link columns in a data table to other dashboard panels
The instructions below show you how to link a chart to a column in a data table. You must adjust the instructions when working with your own data.
Create a simple dashboard that contains a data table and a bar chart.
At this point, none of the content has been linked and you have a "static" dashboard.
Notice the data table in the example here. You want dashboard consumers to click a product in the Product Line column and have the bar chart update with information about sales by territory for that specific product line.
Link on column Add a parameterized condition to the query for the bar chart by specifying a parameter name in curly braces in the Value text box. Then provide a default value for that parameter in the Default text box.
In the example here, a parameter called Productline with a default value of Classic Cars has been created.
Parameter query In the Chart Designer, set the data definitions for the series, category and values columns associated with your bar chart and click OK.
Under General Settings, choose the data table and click the Content Linking tab. Enable content linking on the column in your data table that will filter content in your chart.
Each of the columns in a data table can broadcast values to other dashboard components.
Value as link Under General Settings, choose the chart and click the Parameters tab. Click the down arrow in the Source text box to display another source for the parameter you created.
In the example below, notice that Order Details - Product Line (the name of the dashboard panel that contains the data table) can now be selected as a source for the Productline parameter.
Select a new source Save your dashboard.
In the data table, choose an item in the column that has content linking enabled.
The content in the chart updates in response to the item that was clicked in the data table.
In the example below, the Product Line column was enabled for content linking.
Link an Analyzer report
You can create content-to-content links from Analyzer content in a dashboard.
Use content linking to pass values into parameters on other dashboard panels.
Link from a chart (graphic element)
You can create content-to-content links between an Analyzer chart and any other parameterized report such as a Report Designer report, a data table, or another Analyzer report.
Below are general instructions for linking an Analyzer chart to a report. You must adjust the instructions when working with your own data.
Create a simple dashboard that contains an Analyzer chart and a parameterized report.
The example here displays an Analyzer chart and an Analyzer report displayed as a table view. At this point, none of the content has been linked and you have a "static" dashboard.
Hypothetically, if you want users to be able to click a bar in the bar chart and update the Analyzer table view, the table must contain at least one parameter. In the example below, there are two parameters (LINE and TERRITORY) associated with the Analyzer table.
Parameter created for LINE Under General Settings, choose the Analyzer chart, then click the Content Linking tab.
Click the check box (or check boxes) next to the field/column name you want enabled for content linking, and then click Apply.
Chart content linking Under General Settings, choose the Analyzer report (table view) and click the Parameters tab.
Click the down arrow in the Source text box to display another source for the parameters you created.
In the example below, notice that Sales by Line (the name of the dashboard panel that contains the chart) can now be selected as a source for both the TERRITORY and LINE parameters.
Select source on Parameters tab Save your dashboard.
See Save a dashboard.
In this example, content linking is applied when users double-click a bar in the bar chart.
The data table updates and displays sales details for a product line in a specific territory.
Link from a hyperlink in a table
Below are general instructions for creating content links in an Analyzer report (inside a dashboard) that can be used to drive the query parameter values of content in other dashboard panels. You must adjust the instructions when working with your own data.
Create a simple dashboard that contains an Analyzer report and a data table.
At this point, none of the content has been linked and you have a "static" dashboard.
In the example here, when content linking is achieved, the list of territories (APAC, EMEA, Japan, and NA) will become hyperlinks that, when clicked, will update a customer details data table.
To get the correct filter display, a parameterized query that drives the content in the data table must be created.
Content linking for a table Add a parameterized condition to the query for the data table by specifying a parameter name in curly braces in the Value text box. Then provide a default value for that parameter in the Default text box.
In the example here, a parameter called TERRITORY with a default value of NA has been created. Parameterizing a query, as described here, allows you to pass values dynamically and update the chart based on events triggered by other elements of the dashboard such as a user choosing an item from a filter control or following links defined in content associated with another panel in the dashboard.
Query on territory Under General Settings, choose the Analyzer report. Click the Content Linking tab then click the check box next to the field/column name you want enabled for content linking. Click Apply.
In the Analyzer report, the values under the Territory become hyperlinks.
Hyperlinks in Analyzer table Under General Settings, choose the data table and examine its available parameters. Click the drop-down arrow in the Source text box to display and choose a new source value for the available parameter, then click Apply.
Save your dashboard.
In the example below, content linking was applied. When users click a territory hyperlink in the Analyzer report, the data table updates and displays customer-related details associated with that specific territory exclusively.
Link a report from Report Designer
The instructions that follow show you how a link inside a Report Designer report (.prpt) can drive a parameter in content on another dashboard panel. You must adjust the instructions when working with your own data.
You must have a report (.prpt) that contains a hyperlink before you can complete this task. See Pentaho Report Designer for instructions about adding hyperlinks to a report.
Create a simple dashboard that contains a
.prptreport and a data table.At this point, none of the content has been linked and you have a "static" dashboard. Notice the report (
.prpt) in the example. You want dashboard consumers to click a territory (APAC, EMEA, etc.) hyperlink and update the data table with information about that specific territory.
Report Designer content linking Under General Settings, choose the report (
.prpt) and click the Content Linking tab.Click the checkbox next to the field you want used for content linking.
Add a parameterized condition to the query for the data table by specifying a parameter name in curly braces in the Value text box. Then provide a default value for that parameter in the Default text box.
In the example, a parameter called TERRITORY with a default value of NA has been created.
Filter parameter Parameterizing a query, as described here, allows you to pass values dynamically and update the data table based on events triggered by other elements of the dashboard such as a user choosing an item from a filter control or following links defined in content associated with another panel in the dashboard.
Under General Settings, choose the data table and click the Content Linking tab.
Click the drop-down arrow in the Source text box to display another source for the parameter you created.
In the example, notice that Product Line Share by Territory - Territory (the name of the dashboard panel that contains the
.prpt) is now selected as a source for the Territory parameter.
Select parameter Save your dashboard.
See Save a dashboard.
When content linking is achieved, the data table updates when a link in the report (.prpt) is clicked as shown in the example.
Create Dashboard Designer templates
Follow these steps to create a new Dashboard Designer template.
You must migrate this template manually when you upgrade. The template files are stored in the Dashboard Designer plugin directory. The Pentaho upgrade procedure does not migrate custom templates.
Stop the Pentaho Server.
Navigate to the
/pentaho/server/pentaho-server/pentaho-solutions/system/dashboards/templates/xul/directory.If you want to remove templates that you will never use:
Delete their corresponding XUL files.
Remove the corresponding files from the HTML sibling directory.
Copy the existing XUL file that most closely resembles the template layout you want to create.
Give the new XUL file a name that starts with a two-digit number.
Add a short description of its dimensions.
All Dashboard Designer templates follow this naming convention.
Create a
.propertiesfile that corresponds to the one you copied.Put one item in it:
<name=><Description here>.Description here is the display name of this template.
Create a thumbnail graphic that fits the same dimensions as the other PNG thumbnails in this directory.
Give it the same name as the previous two files, with a PNG extension.
You should now have three new files with the same base name:
.xul.properties.png
Edit the new
.xulfile and change the box attributes to match your template specifications:A vbox node creates a column.
An hbox node creates a row.
A box element defines an individual panel in each row.
Both height and width define static widths in pixels.
The flex size attribute defines a percentage of the total width of the dashboard.
Ensure each box, vbox, and hbox node has a unique
id.For more details about XUL elements, see the official XUL documentation: http://developer.mozilla.org/en/XUL_Reference.
Save and close all open files, then start the Pentaho Server.
Test your new template and adjust its configuration.
You now have a custom Dashboard Designer template deployed to your Pentaho Server.
Back up your custom templates so you can reapply them after upgrades.
Secure SQL filter function access
The Dashboard Designer has a SQL filter for greater control over a database query. By default, this feature is restricted to administrative users.
Perform the following steps to change these settings:
Ensure the Pentaho Server is not currently running; if it is, run the
stop-pentahoscript.Open the
/pentaho-solutions/system/dashboards/settings.xmlfile with a text editor.Locate the following line and modify it accordingly:
Note: Values are separated by commas, with no spaces between roles.
Locate the following line and modify it accordingly:
Note: Values are separated by commas, with no spaces between user names.
Save and close the text editor.
Restart the Pentaho Server with the
start-pentahoscript.
The SQL filter function is now available in Dashboard Designer to the users and roles you specified.
Last updated
Was this helpful?