Details
In this section, we will describe the process for creating a data grid with transactional information from multiple child tables. We will use our standard training fictitious holiday company dataset.
This dataset includes people cyprus mobile phone numbers who have potentially had multiple bookings, multiple insurances and multiple communications.
Example table structure:
image00-2.png
What are we trying to do?
We are trying to create a grid that has a person’s name and address together with the last destination they visited, the date on which they visited, the last insurance they bought and the date on which they bought it.
Previously…
Previously in Discoverer a user would have had to use the Recency Wizard to create an aggregated version of the fields needed from the second transactional table in order to create the required grid.
From the Q3 2016 release we can create these aggregated fields directly within the grid itself.But now…
In the People grid below we have firstly added in the customer personal details we need and then added in the first two fields from the Bookings table (Destination and Booking Date).