Question
Coforge
IN
Last activity: 16 Jan 2025 12:18 EST
Will it able to use function alias in Insights in Pega 8.8.5
Hi,
I have requirement to add function alias to get a difference between Current date and Case Creation Date in a Insight in Pega 8.8.5. The steps i followed:
- created a report definition with following requirement.
- created a list data page and referred the created report definition
- Checked 'Allow querying any column' checkbox
but created data page is not displaying when clicking the explore data. Is this correct approach to create insight in Pega 8.8.5 Can anyone help me on this
Pegasystems Inc.
GB
@LakshmiHarsha ⚠ This is a GenAI-powered answer. All generated answers require validation against the provided references.
Below some help on how you can troubleshoot why the data page isn't displaying in Explore Data.
For a data page to appear in the Explore Data drop-down list, it needs to meet all of the following criteria:
- Structure must be set to "List"
- Data must be sourced from a report definition
- No parameters should be set
- "Allow querying any column" checkbox must be selected (which you've already done)
Based on your description, I noticed a few areas we should verify:
- Report Definition Configuration:
- Ensure the report definition's structure type is set to "List"
- Verify that the function alias for date difference is properly configured in the report definition
- Check that all required properties are optimized for reporting and marked as relevant records
- Data Page Setup:
- Confirm there are no parameters set on the data page
- Verify the data page is referencing the report definition correctly
- Ensure the data page has appropriate access controls set
To resolve the issue:
@LakshmiHarsha ⚠ This is a GenAI-powered answer. All generated answers require validation against the provided references.
Below some help on how you can troubleshoot why the data page isn't displaying in Explore Data.
For a data page to appear in the Explore Data drop-down list, it needs to meet all of the following criteria:
- Structure must be set to "List"
- Data must be sourced from a report definition
- No parameters should be set
- "Allow querying any column" checkbox must be selected (which you've already done)
Based on your description, I noticed a few areas we should verify:
- Report Definition Configuration:
- Ensure the report definition's structure type is set to "List"
- Verify that the function alias for date difference is properly configured in the report definition
- Check that all required properties are optimized for reporting and marked as relevant records
- Data Page Setup:
- Confirm there are no parameters set on the data page
- Verify the data page is referencing the report definition correctly
- Ensure the data page has appropriate access controls set
To resolve the issue:
- First, verify the report definition:
- Open the report definition
- Check that the structure is set to "List"
- Ensure all properties used in the function alias are properly exposed
- Then, review the data page configuration:
- Verify there are no parameters defined
- Double-check that the "Structure" is set to "List"
- Confirm the report definition is correctly referenced
- Validate that the data page rule is saved in an accessible ruleset
- If the data page still doesn't appear:
- Clear the clipboard and browser cache
- Try refreshing the Explore Data page
- Verify you have the necessary access rights to view the data
Would you mind checking these settings and checking if you find any discrepancies? Also, it would be helpful if you could confirm:
- Are you able to preview the report definition directly?
- Does the data page show results when tested independently (outside of Explore Data)?
References:
Troubleshooting missing data objects in Explore Data Elements of a Data Page