Pentaho Business Analytics Cookbook

Pentaho Business Analytics Cookbook

By : Sergio Ramazzina

Buy this Book

Pentaho Business Analytics Cookbook

By: Sergio Ramazzina

Buy this Book

Overview of this book

<p>Pentaho Business Analytics 5 is a complete open source business intelligence suite, providing data integration, OLAP, reporting, data visualization, and data mining features.  Pentaho Business Analytics Cookbook provides you with a valuable and detailed set of recipes that illustrate all the features of Pentaho Business Analytics 5, the new version of the popular BI platform. The book provides clear illustrations and simple examples, helping you learn the core topics visually.</p>

Pentaho Business Analytics Cookbook

Credits

About the Author

Acknowledgments

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

Getting Familiar with Pentaho User Console

Introduction

Adding content to favorites

Accessing a solution's folders and files

Creating a new solution folder

Renaming a solution's folder

Moving a folder to Trash

Showing basic folder properties

Changing a folder's permissions

Renaming a file in a folder

Showing a basic file's properties

Changing a file's permissions

Moving a file to Trash

Moving a file to a different folder

Restoring content items from Trash

Permanently deleting content from Trash

Uploading content to a solution folder

Configuring Your BA Server Instance

Introduction

Accessing the Administration perspective

Creating a new user

Deleting an existing user

Editing an existing user

Creating a new role

Deleting an existing role

Editing an existing role

Managing system roles

Configuring authentication through the LDAP server (EE version)

Configuring authentication through the LDAP server (CE version)

Managing the mail server configuration

Cleaning up aged generated files immediately

Scheduling the cleanup of aged generated files

Defining BA Server Data Sources

Introduction

Creating a new native JDBC data source

Defining a JNDI connection in the BA Server

Creating a new JNDI JDBC data source

Updating an existing JDBC data source

Creating a new analysis data source

Updating an existing analysis data source

Creating a new metadata data source

Exporting an existing data source

Creating a new data source from a CSV file using the wizard

Deleting an existing data source

Defining Business Models with the Pentaho Metadata Editor

Introduction

Using a JNDI connection for development

Managing JDBC database connections

Defining the physical layer

Defining concepts

Reviewing physical layer tables' columns

Deriving business models from the physical layer

Reviewing business tables' column properties

Applying formatting properties to business tables' fields

Adding new calculated columns to model entities

Defining joins between business tables' entities

Creating business view categories

Testing metadata layer results

Applying security to the domain model elements

Publishing metadata definitions to BA Server

Creating Reports Using Pentaho Interactive Reporting

Introduction

Creating a simple interactive report

Editing an existing report

Adding groups and totals to reports

Changing the labels in an interactive report

Reorganizing table columns

Adding filters to limit a report's output

Adding prompts to get user input

Exporting reports in the Excel or PDF format

Creating Analysis Reports

Introduction

Creating and publishing a Mondrian schema

Creating a new analysis report from scratch

Adding subtotals to rows' categories

Adding graphical indicators to table's cells

Changing the columns' sort order

Adding a simple calculated measure

Creating visualizations with Pentaho Analyzer

Exporting reports in the Excel or PDF format

Creating an analysis report using Saiku

Creating Reports Using Pentaho Report Designer

Introduction

Configuring JNDI connections for development

Managing JDBC connections

Managing ETL connections

Using layouts to simplify report development

Using style sheets to consistently manage fields' formats

Changing field properties at runtime with formulas

Using input parameters

Using groups to define report aggregations

Using functions to add calculated fields

Using subreports to embed content

Embedding microcharts in reports with sparklines

Adding charts to our report

Creating Dashboards

Introduction

Creating a simple dashboard from scratch

Adding prompts to get user input

Creating a multiple-content dashboard

Linking different content and enabling interaction

Creating dashboards using CDE

Scheduling Content

Introduction

Scheduling task execution

Updating schedule properties

Deleting schedules

Executing a scheduled task ahead of time

Filtering schedules in the schedule entries list

Running a user's tasks in the background

Checking schedule execution

Stopping running executions

Preventing the creation of schedules by content

Preventing the creation of schedules by setting blockout time intervals

Working with Pentaho Mobile BI

Introduction

Accessing BA server from a mobile device

Accessing folders and files

Adding files to favorites

Changing the default startup screen

Customizing Pentaho BA to Meet Your Business Needs

Introduction

Adding a company's logo to the Pentaho User Console login page

Using themes to customize Pentaho User Console

Adding new languages to Pentaho User Console

Checking Pentaho BA Server logs from inside of Pentaho User Console

Easily managing content in Pentaho Solution

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Permanently deleting content from Trash

Suppose we are sure that the content in the Trash folder is no longer needed. Let me show you how we can permanently delete this unwanted content from the Trash folder, freeing up some space in the solution.

Getting ready

Apart from what we specified as general advice to be followed in these chapter's recipes in the introduction of this chapter, the following advice must be followed to apply concepts in the current recipe. If the user's target folder or content items we're going to permanently delete were located in public folders, the user must be a member of the administrator role or the owner of the content items and target folders we are deleting.

How to do it...

To permanently delete content from the Trash folder one item at a time, we must perform the following steps:

Go to the solution explorer and browse the solution's folder structure for the Trash folder. Instead of the normal folder icon, the trash folder is indicated with a trash icon.
Select the trash folder by clicking on it.
Select either the file or the folder we want to delete permanently from the Trash Content list.
From the Actions for Trash menu, select Permanently Delete.
A warning dialog box appears warning us that we are going to permanently delete the selected file or folder (depending on what we are going to delete) and that this action cannot be undone.
If we press the Yes, Permanently Delete button, the selected content item is immediately deleted from the Trash folder, and it will never be accessible again.
If we press the No button, we will be taken back to the Trash folder and our content will not be deleted.

To permanently delete all the content from the Trash folder in an easy way all at once, we must to the following:

Go to the solution explorer and browse the solution's folder structure for the Trash folder. Instead of the normal folder icon, the Trash folder is indicated with a trash icon.
From the Actions for Trash menu, select Empty the Trash.
A warning dialog box appears warning us that we are going to permanently delete all the items from the Trash and that this action cannot be undone.
If we click on the Yes, Empty Trash button, all the content items are immediately deleted from the Trash folder and it will never be accessible again.
If we click on the No button, we will be taken back to the Trash folder and our content will not be deleted.

Pentaho Business Analytics Cookbook

By : Sergio Ramazzina

Pentaho Business Analytics Cookbook

By: Sergio Ramazzina

Overview of this book

Related Content you might be interested in

Current Title:

Pentaho Business Analytics Cookbook

Permanently deleting content from Trash

Getting ready

How to do it...

See also