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

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:

Procedure

  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:

Procedure

  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.

Home

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.

GUID-528DB49A-4376-47D9-8E5E-A532D62867BD-low.png

ItemNameFunction
1Home indicatorIndicates 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.
2Getting StartedDisplays 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.
3Current UserShows 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.
4Browse FilesBrings 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.
5Create NewGives 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.
6DocumentationDocumentation for Pentaho products.
7RecentsShows 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.
8FavoritesShows a list of your favorite files for quick access.

Browse

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

ItemNameFunction
1Browse 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.

2Folders

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.

3Files

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.

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

Opened

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

ItemNameFunction
1Opened indicator

Open

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.
2Edit, Save, and Save AsGives 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.
3Report WindowDisplays the file or report that is currently opened, and lets you edit or work with the file.

Schedules

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

ItemNameFunction
1Schedules indicatorIndicates 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.
2Schedule NameLists 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.
3RepeatsDescribes how often the schedule is set to run.
4Source FileDisplays the name of the file associated with the schedule.
5Output LocationShows the location where the scheduled report is saved.
6Last RunShows the last time and date when the schedule was run.
7Next RunShows the next time and date when the schedule will run again.
8StatusIndicates the current Status of the schedule. The state can be either Normal or Paused.
9Blockout TimesLists 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.

IconNameFunction
Refresh iconRefreshRefreshes the list of schedules.
Run Now iconRun NowRuns a selected schedule(s) at will.
Stop Scheduled Task iconStop Scheduled TaskPauses a specified schedule. Use Start Schedule to start paused jobs.
Start Scheduled Task iconStart Scheduled TaskResumes a previously stopped schedule.
Edit Scheduled TaskEdits the details of an existing schedule.
Remove Scheduled Task iconRemove Scheduled TaskDeletes 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.

Administration

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

ItemControl NameFunction
1AdministrationIn 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.
2Users & RolesManage the Pentaho users or roles for the Pentaho Server. Learn more
3AuthenticationSet the security provider for the Pentaho Server to either the default Pentaho Security or LDAP/Active Directory. Learn more
4Mail ServerSet up the outgoing email server and the account used to send reports through email.
5LicensesManage Pentaho software licenses. Learn more
6SettingsManage 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.

Procedure

  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.

Results

The Home page refreshes and appears with your chosen theme.

This sample screen is the Crystal theme:

Crystal theme

Plugins

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