Skip to main content

Pentaho+ documentation has moved!

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


Hitachi Vantara Lumada and Pentaho Documentation

Pentaho User Console


Parent article

The Pentaho User Console (PUC) is a web-based design environment where you can analyze data, create interactive reports, dashboard reports, and build integrated dashboards to share business intelligence solutions with others in your organization and on the internet. In addition to its design features, the Pentaho User Console offers a wide variety of system administration features for configuring the Pentaho Server.

Log in to the Pentaho User Console


Get started with the Pentaho User Console by following these steps to log in:


  1. Launch a Web browser and enter the URL of the Pentaho Server.

    The page loads an introductory screen with a Login section.
  2. Enter your user name and password and click Login.

    Pentaho User Console Login You are now logged into the User Console and ready to start creating and running reports and dashboards.

Change your password

Users can change their passwords in PUC if the server is configured with Pentaho security.

Perform the following steps to change your password:


  1. Click the user name menu on the right side of the User Console and select Change Password.

  2. In the Change Password dialog box, enter your existing password in the Old Password field.

  3. Enter your new password in the New Password and Confirm Password fields and click OK.

    NoteIf the Change Password command does not display on the user name menu, clear your browser cache and try again.
    Your password is changed and the Change Password dialog box closes.

About Pentaho User Console Perspectives


The PUC interface uses perspectives to extend your ability to work on different tasks at any given time. By default PUC has the Home, Browse, Opened, Schedules and Administration perspectives. You can also extend certain perspectives with plugins from the Pentaho Marketplace.



After you log in to the User Console, you will see the Home perspective, which serves as the portal for you to access Pentaho tools and features. Home contains easy access buttons so that you can Browse Files, Create New reports and dashboards, view Pentaho Documentation, and quickly open recently viewed or favorite files.



Item Name Function
1 Home indicator Indicates the current User Console perspective that you are using. The Home menu lets you flip easily from page to page, or return to your Home page.
2 Getting Started Displays some resources to help you get familiar with the User Console. The Welcome tab shows an introductory video about Pentaho products. The Samples tab holds a variety of small sample reports and dashboards that you can use to get familiar with the software. The Tutorials tab contains a number of tutorial videos that give you a visual guide to the software.
3 Current User Shows the name of the person currently logged in to the User Console. Clicking the arrow next to the name lets you log out of the User Console.
4 Browse Files Brings you to the Browse Files window, where you can locate your files using the Browsing and Files panes, and manage them using the Actions pane.
5 Create New Gives you the option to create a new report in Pentaho Interactive Reports, Pentaho Analyzer, or Pentaho Dashboard Designer. If you have permissions to work with data sources, this button also gives you the option to create a new data source.
6 Documentation Documentation for Pentaho products.
7 Recents Shows a list of your most recently opened files. Clicking on the star icon next to a recently opened file adds it to your Favorites list.
8 Favorites Shows a list of your favorite files for quick access.



The Browse Files perspective helps you keep your files and folders organized and makes them easier for you to find and work with.

Browsw Files window in PUC


Item Name Function
1 Browse Files indicator

Indicates the current User Console perspective that you are using. Browse Files shows you how to locate your files and folders and the different actions you can do with them.

Displays the Folders, Files, and Actions panes.

2 Folders

Shows a list of folders that you can browse through to locate your files. You can also use the Browsing pane to create new folders or delete old ones.

After you select something in the Browsing pane, the Actions pane populates with a list of things you can do with the folders.

3 Files

Generates and shows a list of all files contained in the folder that is selected in the Browsing pane.

After you select a file, the Actions pane populates with a list of things you can do with the file.

4 Actions The actions displayed depend upon the selection made in the Folders pane, as follows:
  • The Folder Actions pane gives you the ability to:
    • Create, delete, and rename folders.
    • Paste files in a folder.
    • Upload files.
    • Download files.
    • View the Properties, Allow Scheduling, set to Hidden, and control the folder’s permissions for Users and Roles (Manage Permissions, Delete, Write, and Read).
  • The File Actions pane gives you the ability to:
  • The Actions for Trash gives you the ability to:
    • Restore a file in Trash Contents.
    • Permanently delete a file.



The Opened perspective uses plugins to provide access to different analytic capabilities. This perspective activates after you open a file from the Browse Files page. It provides a simple space to work with your files.

Depending on your subscription, you may have access to any of the following plugins:


  • Analyzer
  • Interactive Reports
  • Dashboard Designer
  • CTools

Opened Perspective in PUC


Item Name Function
1 Opened indicator


New Interactive, Analyzer, Dashboard, or Data Source

Indicates the current User Console perspective that you are using. Opened displays the files that you access from the Browse Files pane.

  • Open serves as a quick way to browse for more files to open without leaving the Opened page. These additional files open in new tabs across the Report Window.
  • Quick start buttons to create a new Interactive or Analyzer, Dashboards. You can also use this button to create a new Data Source, if you have permissions to work with data sources.
2 Edit, Save, and Save As Gives you the ability to perform these functions on the active file in the Report Window: edit, save the file with a default name in the same location, or save the file with a different name and in any location on the repository or your desktop.
3 Report Window Displays the file or report that is currently opened, and lets you edit or work with the file.



All of your active scheduled reports appear in the list of schedules, which you can get to by clicking the Home drop-down menu, then the Schedules link, in the upper-left corner of the User Console page.

The list of schedules shows which reports are scheduled to run, the recurrence pattern for the schedule, when it was last run, when it is set to run again, and the current state of the schedule.Schedules Page

Item Name Function
1 Schedules indicator Indicates the current User Console perspective that you are using. Schedules displays a list of schedules that you create, a toolbar to work with your schedules, and a list of times that your schedules are blocked from running.
2 Schedule Name Lists your schedules by the name you assign to them. Click the arrow next to Schedule Name to sort schedules alphabetically in ascending or descending order.
3 Repeats Describes how often the schedule is set to run.
4 Source File Displays the name of the file associated with the schedule.
5 Output Location Shows the location where the scheduled report is saved.
6 Last Run Shows the last time and date when the schedule was run.
7 Next Run Shows the next time and date when the schedule will run again.
8 Status Indicates the current Status of the schedule. The state can be either Normal or Paused.
9 Blockout Times Lists the times when all schedules are blocked from running.

You can edit and maintain each of your schedules by using the controls the following table. See Schedule Reports for more information.

Icon Name Function
Refresh icon Refresh Refreshes the list of schedules.
Run Now icon Run Now Runs a selected schedule(s) at will.
Stop Scheduled Task icon Stop Scheduled Task Pauses a specified schedule. Use Start Schedule to start paused jobs.
Start Scheduled Task icon Start Scheduled Task Resumes a previously stopped schedule.
  Edit Scheduled Task Edits the details of an existing schedule.
Remove Scheduled Task icon Remove Scheduled Task Deletes a specified schedule. If the schedule is currently running, it continues to run, but it will not run again.
Schedule Reports

You can use the Browse perspective to schedule a report to run at regular intervals, on certain dates and times, and with different parameters. See Schedule Reports for more information.



In PUC, the Administration perspective can be used by logged-on users assigned a role that has permissions to administer security can perform system configuration and maintenance tasks.

If you see Administration in the left drop-down menu on the Home page, you can click it to reveal menu items specific to administration of the Pentaho Server. If you do not have administration privileges, Administration does not appear within the console.

Administration perspective in PUC


Item Control Name Function
1 Administration In PUC, open the Administration perspective. The Administration perspective enables you to set up users, configure the mail server, change authentication settings on the Pentaho Server, and install software licenses for Pentaho.
2 Users & Roles Manage the Pentaho users or roles for the Pentaho Server. Learn more
3 Authentication Set the security provider for the Pentaho Server to either the default Pentaho Security or LDAP/Active Directory. Learn more
4 Mail Server Set up the outgoing email server and the account used to send reports through email.
5 Licenses Manage Pentaho software licenses. Learn more
6 Settings Manage settings for deleting older generated files, either manually or by creating a schedule for deletion.
Manage Users and Roles

Add, assign, and delete users/roles in the Manage Users and Manage Roles tabs.

Learn more

Additional Features


In PUC, you can set themes, activate plugins, and access the Data Source Wizard and the Data Source Model Editor.

Setting Themes


The User Console has three themes built in, called Crystal, Ruby, and Sapphire. Ruby is the default theme. To change the theme to Crystal or Sapphire, follow these instructions.

NoteBefore proceeding, save any edits you have made in the User Console to your reports, dashboards, etc.


  1. From any page of the User Console, click View in the upper-left menu bar.

  2. Select Themes, then select the theme you want to use from the drop-down menu.

  3. When prompted, select Yes, Change Theme.


The Home page refreshes and appears with your chosen theme.

This sample screen is the Crystal theme:

Crystal theme



You can activate several plugins in the Pentaho User Console.

  • Pentaho Analyzer: Conceptualize your data, add query parameters and filters, drill-down links, and create visualizations.
  • Pentaho Interactive Reports: Create simple and on-demand operational reports without depending on IT or report developers.
  • Pentaho Dashboard Designer: Create dashboards that help decision makers gain critical knowledge at a glance.
  • CTools: Use a set of community-driven tools to help you develop and define your data structure, which you can then use in dashboards.

Data Source Wizard


The Data Source Wizard helps you define a data source that contains your information and guides you through the creation of your first relational or multidimensional data models for use in creating reports and analysis.

Learn more

Data Source Model Editor


The Data Source Model Editor allows you to change relational and multidimensional data models to make your data more accessible.

Learn more