Crosstabs editor
by Dario R. Bernabeu, Mariano García Mattío
Pentaho 5.0 Reporting by Example Beginner’s Guide
- Pentaho 5.0 Reporting by Example Beginner’s Guide
- Table of Contents
- Pentaho 5.0 Reporting by Example Beginner’s Guide
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. What is Pentaho Report Designer?
- 2. Installation and Configuration
- 3. Start PRD and the User Interface (UI) Layout
- 4. Instant Gratification – Creating Your First Report with PRD
- Creating your first report with PRD
- Time for action – creating a new report and creating a table based on data sets
- Time for action – configuring the Report Header and Details Header sections
- Time for action – configuring details
- The second half of the report
- Time for action – adding functions
- Time for action – configuring the Details Footer section
- Time for action – adding more details
- Output types
- Time for action – exporting in different formats
- Summary
- 5. Adding a Relational Data Source
- Learning about JDBC driver
- Time for action – configuring drivers
- Creating a new data set
- Time for action – creating a new data set
- Time for action – modifying the header and detail
- Time for action – modifying the report's footer
- Aggregation functions
- Time for action – using functions to configure styles
- Encoding charset
- Summary
- 6. Adding Groups
- 7. Adding Parameters
- 8. Using Formulas in Our Reports
- 9. Adding Charts
- 10. Adding Subreports
- 11. Publishing and Running Reports in Pentaho BA Server
- 12. Making a Difference – Reports with Hyperlinks and Sparklines
- 13. Environment Variables, Stylesheets, and Crosstabs
- 14. PRD Reports Embedded in Web Applications
- Tools and technologies we will be using
- Time for action – installing and starting Apache Tomcat
- Time for action – installing and initiating Eclipse WTP
- Time for action – creating a new Dynamic Web project
- Time for action – creating a Tomcat instance
- Time for action – setting a JNDI/JDBC connection pool
- Time for action – configuration of libraries and the PRD report
- Time for action – creating a context Listener
- Time for action – creating a web client
- Time for action – creating a standalone application
- Summary
- A. Sakila DB Data Dictionary
- B. Pop Quiz Answers
- Chapter 2, Installation and Configuration
- Chapter 3, Start PRD and the User Interface (UI) Layout
- Chapter 4, Instant Gratification – creating your first report with PRD
- Chapter 5, Adding a Relational Data Source
- Chapter 6, Adding Groups
- Chapter 7, Adding Parameters
- Chapter 8, Using Formulas in Our Reports
- Chapter 9, Adding Charts
- Chapter 10, Adding Subreports
- Chapter 11, Publish and Run Reports in Pentaho BA Server
- Chapter 12, Making a Difference – Reports with Hyperlinks and Sparklines
- Chapter 13, Environment, Stylesheets, and Crosstabs
- Chapter 14, PRD Reports Embedded in Web Applications
- Index
In the preceding screenshot we saw the crosstabs editor UI. Now we will describe each of its sections.
- Available Fields: In this section we find all the fields we can add to our Crosstab.
- Crosstab Group: Here we place the fields by which the crosstab will be grouped. For example, if we place the films' ratings here, we will obtain a Crosstab for each rating.
- Row Axis: Here we place the fields to be analyzed horizontally.
- Column Axis: Here we place the fields to be analyzed vertically.
- Data Cell: Here we place the fields that we want to measure (facts). These are the fields that will fill our table, and their value will depend on the intersection of the fields of the rows and columns. For this reason, we also must choose the aggregation criteria for these fields.
Note
When adding fields to the crosstab's sections, the order they appear in is important, as a parent-child hierarchy will be formed for each one that we place in a given section. The order of the hierarchy is descendent; that is, the first field will be the parent and the second will be the child. If there is a third field, it will be the child of the second, and so on.
Starting practice
Now we will create our own crosstab and configure it to obtain a final result as shown in the following screenshot:
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.