Question
Virtusa
LK
Last activity: 10 Oct 2024 13:22 EDT
Creating Insight in Pega Infinity 23
Hi,
I have requirement to join two data tables and create a report in Pega Infinity 23.The steps i followed:
- created a report definition and joined two data tables
- created a list data page and referred the created report definition
- changed the data page status to API
but created data page is not displaying when clicking the explore data button. Is this correct approach to create insight with two tables? Can any one help me on this
Accepted Solution
Updated: 10 Oct 2024 0:35 EDT
Pegasystems Inc.
CA
Please create an association rule to join two tables using Insights.
Virtusa
LK
@RameshSangiliThanks
Created an association rule and added association rule in explore data as mentioned in below link
https://docs.pega.com/bundle/platform/page/platform/reporting/specifying-classes-explore-data.html
Pegasystems Inc.
IN
@PAVISHAKITTo create insights in Pega Infinity 23, the Data Page source should be a Report Definition. However, there are specific criteria that the Data Page must meet to be available in the 'Explore Data' menu. The Data Page should have a 'List' structure, source from a Report Definition, have no parameters, and be marked as queryable using the 'Allow querying any column' checkbox. If these criteria are not met, the Data Page will not appear in the 'Explore Data' menu.
Virtusa
LK
@thulg Thanks for the reply .Now i can view the data page in Explore data. But it is only displaying if i uncheck 'Allow querying any column' checkbox in the data page. Now i am facing different issues
Issue 1:Table option is not Displaying in "Display as" field
Issue 2:Joined table columns are not displaying in available fields(those properties are optimized properties)
Can you please help me to resolve this issue