InetSoft Documentation: Report Table Transformer

Table transformer classes are table lens classes that project a different view into other table lenses. Style Intelligence provides two built-in table transformers, RotatedTableLens and SubTableLens.

RotatedTableLens

The RotatedTableLens transformer switches the rows and columns of the original table. Suppose we have a table represented by a TableLens object, table1:

Jan

Feb

Mar

1

2

3

We can rotate the table, so the rows in the original table become the columns in the new table,

CRM BI tool example

More Dashboard Examples

Dashboard Demo
Register
 layout.addTable(new RotatedTableLens(table1));

This would print a table with the rows and columns switched:

JAN

1

FEB

2

MAR

3

SubTableLens

The SubTableLens transformer extracts parts of a table as a new table. It supports several ways to specify which parts of the table to extract.

Table 6. SubTableLens extraction methods

Constructor

Description

SubTableLens(TableLens, int rows[], int cols[])

The new table consists of the cells at the intersections of the rows and columns.

SubTableLens(TableLens, int row, int col, int numrow, int numcol)

The new table consists of the region defined by the number of rows/columns from the upper-left cell (row, col).

SubTableLens(TableLens, Rectangle region)

The region is equivalent to the above construct parameters where region.x == col, region.y == row, region.width == numcol and region.height == numrow.

Presenters

InetSoft products support the concept of a presenter. A presenter is an object that draws a graphical representation of an object value. A presenter is usually assigned to a particular column of a table. However, it can also be associated with an object type, and then applies to all objects of this type in a document, including the objects added as individual elements using StyleSheet.addObject(Object) and the objects returned from the TableLens.getObject() method. Therefore the presenter is really not strictly a table concept, but is generic to the report. We choose to describe presenters within the context of a table because that is where they are normally used.

InetSoft Viewpoint

"Agile business intelligence is a very important topic that lots of people are talking about now and are beginning to implement in various ways. So there is a lot of industry discussion about agile business intelligence. Often people talk about what you need behind the scenes in the infrastructure to enable maximum agility in your business intelligence and your advanced analytics initiatives.

But agile data access will be the core focus today. It is really the key enabler for agile BI. We will talk about how they complement each other, how agile data access is absolutely essential if you want to go completely agile on the BI front end with reporting, dashboards, and advanced visualization.

We will explain what you need to enable agile data access, and why should you go that route in just a moment in great detail. Well, because it speeds up development and ongoing enhancements and administration of all your BI efforts, whether they be building reports, dashboard development, or developing complex queries.

Without agile data access, you would not really be able to fully achieve the agile BI vision of basically enabling very rapid rollout of complex analytics that are tuned to the needs of each business role and user within your company. Really to enable agile BI in this way, you are supporting more agile business processes helping users to make better decisions more rapidly with analytic applications that are geared to their specific requirements.” - Mark Flaherty, Chief Marketing Officer

Previous: Using Tabular Data in a Report