Aggregate Data Source in Data Page
I have a task to use an Aggregate source in a data page. Please explain why we use it and provide an example.
HCA Healthcare
US
Tata Consultancy Services
IN
@Satya K
Aggregate Sources in Pega data pages allow you to combine data from multiple sources to populate a single data page.
Example:
we have customer table and grades Decision table, and we need to fetch the list of customers and grades tagged to these customers.
we will create a report to fetch customer information and then we will add another source Data Transform in which we will loop through the Primary results, and we will call a decision table which has the grades based on customer rating
our final outcome of the data page will be list of customers with tagged grades.
Eclantiqx
IN
Hello @Satya K,
In Pega, an Aggregate data source in a Data Page allows the use of multiple source rules (like Report Definitions, Data Transforms, Connectors, or Data Flows) to fetch, merge, and populate a composite data structure within the same Data Page context.
It is typically used when the required data spans across multiple systems or data types, and cannot be retrieved through a single source.
Infosys
IN
@Satya K
Mainly we use aggregate sources for combining the multiple results.
Let’s say you want to display a list of active employees in a repeat grid.
1. Create a Data Page:
Name: D_EmployeeList
Structure: List
Object type: HR-Data-Employee
Scope: Thread (default)
Reload if older than: 1 hour (example)
2. Set the Data Source to a Report Definition
Source type: Report Definition
Report name: GetActiveEmployees
3. Create a Report Definition:
Applies to: HR-Data-Employee
Conditions: .Status = "Active"
Select the columns you need: Name, ID, Department, etc.
Usage in UI:
In a section, you can add a repeat grid, and
set its source to .D_EmployeeList.
@Satya K we use an Aggregate data source in a Data Page when we need to combine data from multiple places. Instead of using just one source, it allows us to fetch data from different sources like report definitions, data transforms, or REST connectors and merge them together. This is useful when one source doesn’t give all the needed information. For example, to show patient details, we may pull basic info from the database and insurance info from an API. The aggregate source lets us do this in one data page. It helps organize and reuse data sources efficiently.