Pentaho Business Analytics Cookbook -- Table of Contents -- Pentaho Business Analytics Cookbook -- Credits -- About the Author -- Acknowledgments -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers, and more -- Why Subscribe? -- Free Access for Packt account holders -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Getting Familiar with Pentaho User Console -- Introduction -- Adding content to favorites -- How to do it... -- How it works... -- There's more... -- Removing a content item from the favorites list -- Accessing a solution's folders and files -- How to do it… -- How it works... -- There's more... -- Introducing Pentaho User Console perspectives -- Creating a new solution folder -- Getting ready -- How to do it... -- How it works… -- There's more... -- Think about a good repository design -- Renaming a solution's folder -- Getting ready -- How to do it... -- How it works… -- There's more... -- A brief look into a user's home directory -- Moving a folder to Trash -- Getting ready -- How to do it... -- How it works… -- Showing basic folder properties -- Getting ready -- How to do it... -- How it works... -- See also -- Changing a folder's permissions -- Getting ready -- How to do it... -- How it works... -- See also -- Renaming a file in a folder -- Getting ready -- How to do it... -- How it works… -- Showing a basic file's properties -- Getting ready -- How to do it... -- How it works… -- There's more... -- Changing a file's permissions -- Getting ready -- How to do it... -- How it works… -- See also -- Moving a file to Trash -- Getting ready -- How to do it... -- How it works... -- See also -- Moving a file to a different folder.

Getting ready -- How to do it... -- How it works... -- Restoring content items from Trash -- Getting ready -- How to do it... -- How it works... -- See also -- Permanently deleting content from Trash -- Getting ready -- How to do it... -- See also -- Uploading content to a solution folder -- Getting ready -- How to do it... -- How it works... -- There's more… -- What kind of content can I upload to my BA Server? -- Uploading content from the command line -- 2. Configuring Your BA Server Instance -- Introduction -- Accessing the Administration perspective -- How to do it... -- How it works... -- Creating a new user -- How to do it... -- How it works… -- See also -- Deleting an existing user -- How to do it... -- How it works… -- See also -- Editing an existing user -- How to do it... -- How it works… -- See also -- Creating a new role -- How to do it... -- How it works... -- See also -- Deleting an existing role -- How to do it... -- How it works... -- See also -- Editing an existing role -- How to do it... -- How it works… -- There's more... -- See also -- Managing system roles -- How to do it... -- How it works… -- There's more... -- Things to notice about the authenticated role -- How to bypass the Pentaho BA Server security -- See also -- Configuring authentication through the LDAP server (EE version) -- How to do it... -- How it works... -- See also -- Configuring authentication through the LDAP server (CE version) -- How to do it... -- How it works… -- There's more… -- See also -- Managing the mail server configuration -- How to do it... -- How it works... -- There's more... -- Configuring e-mail to connect to Gmail -- See also -- Cleaning up aged generated files immediately -- How to do it... -- How it works… -- See also -- Scheduling the cleanup of aged generated files -- How to do it... -- How it works... -- See also.

3. Defining BA Server Data Sources -- Introduction -- Creating a new native JDBC data source -- How to do it... -- How it works... -- There's more... -- Adding another database type to the list -- Using advanced configuration parameters -- See also -- Defining a JNDI connection in the BA Server -- Getting ready -- How to do it... -- How it works... -- There's more… -- See also -- Creating a new JNDI JDBC data source -- How to do it... -- How it works… -- There's more... -- Specifying JDBC connection properties manually -- Enabling database connection pooling -- See also -- Updating an existing JDBC data source -- How to do it... -- How it works... -- See also -- Creating a new analysis data source -- How to do it... -- How it works... -- There's more... -- Defining data source parameters manually -- See also -- Updating an existing analysis data source -- How to do it... -- How it works… -- See also -- Creating a new metadata data source -- How to do it... -- How it works... -- There's more… -- Managing localized bundles -- See also -- Exporting an existing data source -- How to do it... -- How it works... -- Creating a new data source from a CSV file using the wizard -- How to do it... -- How it works... -- Deleting an existing data source -- How to do it... -- How it works… -- 4. Defining Business Models with the Pentaho Metadata Editor -- Introduction -- Using a JNDI connection for development -- Getting ready -- How to do it... -- How it works... -- See also -- Managing JDBC database connections -- Getting ready -- How to do it... -- How it works... -- There's more... -- Adding a JDBC Driver -- Using advanced configuration parameters -- Defining the physical layer -- Getting ready -- How to do it... -- How it works... -- See also -- Defining concepts -- Getting ready -- How to do it... -- How it works... -- See also.

Reviewing physical layer tables' columns -- Getting ready -- How to do it... -- How it works... -- See also -- Deriving business models from the physical layer -- Getting ready -- How to do it... -- How it works... -- Reviewing business tables' column properties -- Getting ready -- How to do it... -- How it works... -- See also -- Applying formatting properties to business tables' fields -- Getting ready -- How to do it... -- How it works... -- See also -- Adding new calculated columns to model entities -- Getting ready -- How to do it... -- How it works... -- See also -- Defining joins between business tables' entities -- Getting ready -- How to do it... -- How it works... -- Creating business view categories -- Getting ready -- How to do it... -- How it works... -- Testing metadata layer results -- Getting ready -- How to do it... -- How it works... -- See also -- Applying security to the domain model elements -- Getting ready -- How to do it... -- How it works... -- There's more… -- Linking the Pentaho Metadata Editor security to Pentaho BA Server -- See also -- Publishing metadata definitions to BA Server -- Getting ready -- How to do it... -- How it works... -- 5. Creating Reports Using Pentaho Interactive Reporting -- Introduction -- Creating a simple interactive report -- How to do it… -- How it works... -- See also -- Editing an existing report -- How to do it... -- How it works... -- See also -- Adding groups and totals to reports -- How to do it... -- How it works... -- See also -- Changing the labels in an interactive report -- How to do it... -- How it works... -- Reorganizing table columns -- How to do it... -- How it works... -- Adding filters to limit a report's output -- How to do it... -- How it works... -- There's more... -- Changing or removing the filter -- See also -- Adding prompts to get user input -- How to do it...

How it works... -- There's more... -- Removing unnecessary report prompts -- Changing the prompt's appearance and behavior -- See also -- Exporting reports in the Excel or PDF format -- How to do it... -- How it works... -- 6. Creating Analysis Reports -- Introduction -- Creating and publishing a Mondrian schema -- Getting ready -- How to do it... -- How it works... -- There's more... -- Adding a JDBC driver -- Configuring a JDBC data source to help in the schema design -- See also -- Creating a new analysis report from scratch -- How to do it... -- How it works... -- There's more... -- Changing the way the available field set is displayed -- See also -- Adding subtotals to rows' categories -- How to do it... -- How it works... -- There's more... -- Removing fields from the report table's working area -- Adding graphical indicators to table's cells -- How to do it... -- How it works... -- Changing the columns' sort order -- How to do it... -- How it works... -- There's more... -- Changing a columns' header labels -- Applying formatting rules to measures' values -- See also -- Adding a simple calculated measure -- How to do it... -- How it works... -- There's more... -- Adding other predefined calculated measure types -- Adding a generically calculated measure -- See also -- Creating visualizations with Pentaho Analyzer -- How to do it... -- How it works... -- Exporting reports in the Excel or PDF format -- How to do it... -- How it works... -- Creating an analysis report using Saiku -- Getting ready -- How to do it... -- How it works... -- There's more… -- Installing Saiku from the Pentaho Marketplace -- Adding filters to reports -- Designing good looking visualizations -- 7. Creating Reports Using Pentaho Report Designer -- Introduction -- Configuring JNDI connections for development -- Getting ready -- How to do it... -- How it works... -- See also.

Managing JDBC connections.