Pentaho Analytics

Version: 9.5.x
Audience: anonymous
Part Number: MK-95PDIA004-06

Pentaho Analytics
Pentaho User Console
Log in to the Pentaho User Console
Change your password
About Pentaho User Console Perspectives
Home
Browse
Run files in background
Opened
Schedules
Schedule Reports
Schedule a Report
Quartz cron attributes
Edit a Schedule
Delete a Schedule
Manage Schedules
Prevent Scheduling of a Single Report or File
Prevent Scheduling by Setting Blockout Times
Schedule Deletion of Generated Files
Set Up Emails for Scheduled Reports
Set up the Mail Server page
Administration
Manage Users and Roles in PUC
View sample users, default roles, and permissions
Add Users
Change User Passwords
Set password requirements
Delete Users
Set the Authentication Method
Assign Users to Roles
Add Roles
Assign Permissions to Roles
Delete Roles
Assign Roles to Users
Additional Features
Setting Themes
Plugins
Data Source Wizard
Data Source Model Editor
Pentaho Analyzer
Get started with Pentaho Analyzer
Creating Analyzer reports
Create an Analyzer report
View and edit Analyzer reports
Visualizations for Analyzer
Continuous scale axis
Column and bar charts
Line and area charts
Pie and sunburst charts
Scatter chart visualization
Heat grid visualization
Geo map visualization
Chart Options for Analyzer reports
General tab in Chart Options
Axis tab in Chart Options
Legend tab in Chart Options
Other tab in Chart Options
Advanced tab in Chart Options
Display the member properties of a field or level
Adding filters to an Analyzer report
Add filters to an Analyzer report
Create date range filters
Create a comparison filter on a numeric level
Create a string filter on a level
Create a filter on measure values
Working with Analyzer fields
Where does the data come from?
Fields in Analyzer
Types of fields in Analyzer
About field hierarchies
View the definition of a field
Viewing and editing field properties
View and edit field properties
View a level with member properties in a report
Editing measure properties
Rename a field
Working with the Available Fields list
View the List of Available fields
Add a field to a report
Editing units of measure in a report
Move fields in a report
Remove Fields in a Report
Hide and unhide fields
Hide a field
View hidden fields
Unhide a field
Format field options
Managing fields in large reports
Troubleshooting: Your report does not display data
Working with Analyzer measures
About measure properties in Analyzer
View or update base measures
View or update inline calculated measures
Add a calculated measure to the data source
Set Analyzer report options
Working with rows where the number cell is blank
Set blank measure display
Show rows or columns when measures are blank
What happens when there is no number field on the report?
Turn on drill-through links
Options for totals
Freeze column headers and row labels
Export an Analyzer report
Advanced topics
Defining hyperlinks
Create hyperlinks to a report in the Pentaho Repository
Create hyperlinks to URLs
Add query parameters to Analyzer reports
Applying conditional formatting to measures
Apply conditional formatting to measures
Conditional formatting types
Apply advanced conditional formatting with MDX expressions
Conditional formatting expressions
Use calculated measures in Analyzer reports
Creating a calculated measure in a report
Editing a calculated measure in the report
Open the New Calculated Measure dialog box
Tips for using calculated measures
Export an Analyzer report through a URL
Troubleshooting
Pentaho Interactive Reports
Get started with Pentaho Interactive Reports
Create an Interactive Report
Edit your interactive report
Customize an Interactive Report
Reorder and adjust columns
Change a column header name
Design report headers and footers
Change the format of the data values
Copy and paste formatting
Customize page format and orientation
Change page format
Change page orientation
Use a different report template
Read and export in view-only mode
Build large reports
Distinct values
Row limits and query timeouts
Auto refresh mode
Advanced topics
Group and Filter Data in Interactive Reports
Group data
Add filters
Filter on date fields
Flag a filter as a dashboard parameter
Create advanced filters in Interactive Reports
Apply a summary function
Apply an aggregate function
Pentaho Dashboard Designer
Get started with the Dashboard Designer
Creating dashboards
Create a dashboard
Add a report from Analyzer
Export an Analyzer report
Add a report from Report Designer
Add a website
Drag-and-drop content
Create a chart
Use Query Editor
Use Chart Designer
Chart types
Bar charts
Pie charts
Line charts
Dial charts
Area charts
Modify charts
Edit a chart
Rotate axis labels
Adjust numeric scaling
Adjust white space in dashboard panels
Set the refresh interval
Save a dashboard
Advanced topics
Set dashboard parameters
Getting started with the Query Editor
Creating chart or data table parameters
Add dynamic dashboard titles
Use prompts on dashboards
Get started with dashboard prompts
Edit prompts
Other prompt types
Create a toolbar prompt
Customize toolbar prompts
Creating a date prompt
Create a list prompt
Create a cascading list prompt
Link dashboard prompts to Analyzer parameters
Use data tables in a dashboard
Add a data table to a dashboard
Updating the data table display
Use content linking to create interactive dashboards
Getting started with query parameters
Link charts and data tables
Link columns in a data table to other dashboard panels
Link an Analyzer report
Create graphic element links to a report
Create hyperlinks to a report
Link a report from Report Designer
Create Pentaho Dashboard Designer templates
Secure SQL filter function access
Data Source Wizard
Before using the Data Source Wizard
Get started with the Data Source Wizard
Choose a data source type
Create a CSV data source
Create a SQL query data source
Create a database table source
Create a database table data source for reporting only
Create a database table data source for reporting and analysis
Data Source Model Editor
Get started with the Data Source Model Editor
Tour the Data Source Model Editor
Add member properties to a level
Edit multidimensional data source models
Assign geographic properties
Assign time dimension properties
Use ordinal columns
Properties of time dimension levels
Delete a data source
Data Source Model Editor tips
Troubleshooting possible analytics issues
Multi-byte characters do not appear in PDFs exported from Analyzer
Geo Maps partially rendering
Cannot change Administrator password in PUC

Back to home page