Table Expansion in Pentaho CDE

Posted on by By Nikhilesh, in Business Intelligence, Databases, Open Source Business Intelligence, Pentaho | 4

Hello,

we are now working on Table Expansion property of Pentaho CDE. Simple, expanding a Main Table on click and render relevant data in Any Chart / table.

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Get your 30 Days Trail Version

Before stepping into CDE lets start preparing SQL. The below example is developed by using foodmart as Postgres Database. You can see my SQL once you download and import my export in CDE.

Step 1: Prepare your SQL queries for 3 tables.

Step 2: Datasources Panel.

1) Create datasource by giving driver class name, URL and username , Password. Dont forget to name your Datasource.
2) Put your SQL which is prepared in Step 1

Step 3: Layout Panel / Structure

1) Create 2 rows, “MainTable” as row1 and “TableExpansion” as row2.
2) Create 2 columns with in row2 (TableExpansion) , Name column1 & column1 as Table2 and Table3

First let us display main table data and then will continue to look at table expansion.

Step 4: Components Panel

1) Get a table component and provide datasource name and HTML Object.

In this case, row 1 “MainTable” is HTML Object for Main Table in Components Panel.

Believing now you should be able to preview your 1st table data.

Continuing…

Add 2 more table components. These 2 tables shows up the data when you click on “department id” column from Main table.

Be careful with naming convention when you duplicate the table component (provide / change datasource name, htmlobject name and give another name for table component).

Change below values from Advanced Properties of Main Table Component:

  • Expand Container Object = TableExpansion (Row2 name from layout Structure)
  • Expand on Click = true

NO worries, when you preview it seems something odd behaviour like on first view below 2 tables are appearing and when i click on main table the same 2 tables are not showing. Basically those 2 tables should be seen when you click on main table.

Here, we need to apply small CSS code.

.hidden{
display:none;
}

Give this CSS class name on row 2 properties.

Here is the Source Code to download Table Expansion.

Thanks to All.

logo

Best Open Source Business Intelligence Software Helical Insight is Here

logo

A Business Intelligence Framework


0 0 votes
Article Rating
Subscribe
Notify of
4 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments

Worked for me..Thanks!!

1
Reply

Hi! This is really amazing, thanks! but when I set the “TableExpansion” component to be “hidden” it disappears completely from the report, it doesn’t appear anymore.
I downloaded the example but I can’t load it into my system, anyway I can see in the xml that I’m doing the same as you, any idea?

Thanks!

0
Reply

OK, I figured it out.
The thing is that this is wrong:
Expand Container Object = TableExpansion (Row2 name from layout Structure)

should be:

Expand Container Object = TableDetails (Column1 name from layout Structure)

That way it works.

Thanks!

Pablo

0
Reply

Hi,
thank you for this tutorial.

I have these two tables:
– PublicationsPerYear in the first row called YearsTableMain with the rows: year, all, open.
– PublicationsPerYearClass in the second row called ClassTableSlave with the rows: year, class, all, open.

I followed the instructions, but when I click on a row of the main table the second table appears but it is not filtered by year.
All the rows of the second table show up.
I thought that it should be filtered according to the value of the first column (year).
What am I messing up?
Thank you

0
Reply