Book Image

Pentaho Analytics for MongoDB

By : Bo Borland
Book Image

Pentaho Analytics for MongoDB

By: Bo Borland

Overview of this book

<p>Pentaho Analytics for MongoDB will teach you MongoDB and Pentaho integration points and developer skills needed to create turnkey analytic solutions that deliver insight and drive value for your organization.<br /><br />Starting with how to install, configure, and develop content in both Pentaho and MongoDB, this book will give you the complete range of skills needed to gain insight into MongoDB data using Pentaho Business Analytics.&nbsp; You will learn about MongoDB data models and query techniques, which are covered in combination with the provided sample MongoDB database. You then advance to data integration, analysis, and reporting using Pentaho.<br /><br />You will learn how to use Pentaho Data Integration to blend and enrich data from additional sources. From this blended data, you will develop professional-looking reports and analysis views that are visual and interactive. Lastly, we will cover the Pentaho web portal and web interfaces for deploying analytics out to a broader set of consumer users.</p>
Table of Contents (15 chapters)
Pentaho Analytics for MongoDB
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Creating a report prompt


Prompts and parameterization can be used to create more flexible and dynamic PRD reports. Report prompts allow a user to filter report data based on values selected or entered in the prompt display. Query parameters accept the prompt values selected by the user and use those values to filter the report data. PRD offers different prompt display types including: value lists, radio buttons, checkboxes, selection buttons, textbox, textarea, and date picker. Prompt values can be driven by static tables or dynamic queries.

Our clickstream data contains the referring_url field with values for three referring websites: www.123.com, www.abc.com, and www.xyz.com. We want to give users the ability to filter the clickstream report by the referring website. In this section, we enhance our existing report by adding a list prompt sourced by a MongoDB query on referring_url.

Creating a new parameter

The first step is to define a new parameter. Parameters are defined in the Parameters...