Creating Insight in Pega Infinity 23

General
, ,
1

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

2

@PAVISHAKIT

Please create an association rule to join two tables using Insights.

3

@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. ​​​​​​​

4

@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

5

@RameshSangiliThanks

Created an association rule and added association rule in explore data as mentioned in below link