Property Optimization | Declare Index Rule DataPega - Pega 8.6 | Pega Training

[@subhalaxmiroutray8544]

Hi Harsha, I have some doubts , can you please help me with this
1: Cases are getting created in pega platform from external system , what needs to be done for better performance
2: How we can export exposed properties to higher environment
3:In a report ,there is declare index join.Client wants to see the previous value of index value in report before the declare index has been created .How can we pull the previous data (4month back data)from declare index join which has been created recently.

[@HarshaTrainingsacademy]

1. **Cases Created from External System for Better Performance:**
- Implement efficient data mapping and processing techniques to optimize the performance of case creation from external systems.
- Utilize asynchronous processing and batch processing mechanisms to handle large volumes of case creation requests without impacting system performance.
- Consider implementing data validation and deduplication mechanisms to ensure data integrity and prevent unnecessary case creation.
- Optimize the configuration of case types, data models, and workflows to streamline the case creation process and minimize processing overhead.
- Monitor system performance regularly and fine-tune configuration settings as needed to maintain optimal performance.
2. **Exporting Exposed Properties to Higher Environment:**
- Use the Data Import/Export wizard or Data-Admin-DB-Table instances to export exposed properties from lower environments (e.g., development or testing) to higher environments (e.g., production).
- Ensure that the appropriate access controls and permissions are configured to allow the export of exposed properties to higher environments.
- Validate the exported data in the target environment to ensure consistency and accuracy before proceeding with production deployment.
3. **Retrieving Previous Data from Declare Index Join:**
- Implement historical data retrieval mechanisms, such as historical data tables or snapshots, to capture and retain previous index values over time.
- Use historical data queries or custom SQL queries to retrieve data from the declare index join based on specific timestamp or date range criteria.
- Ensure that the declare index join configuration includes the necessary historical data retention settings to enable retrieval of previous index values.
- Collaborate with database administrators or Pega platform experts to optimize the performance of historical data retrieval queries and minimize impact on system resources.
Feel free to ask if you need further clarification or assistance with any of these topics!

[@kirankumar6960]

Can we call 5 report definition through activity and at a time one report should be call if possible how

[@HarshaTrainingsacademy]

Yes, you can call multiple report definitions through an activity in Pega. To achieve this, you can use the "Call Rule" method in the activity to invoke the report definitions one by one. However, you can only execute them sequentially, meaning one report will be executed after the other.
Here's how you can call five report definitions sequentially from an activity:
1.Create an Activity:
Open Pega Designer Studio and navigate to the "Records" tab.
Create a new activity or use an existing one to call the report definitions.
2.Call Rule for Report Definitions:
Inside the activity, add the "Call Rule" method for each of the five report definitions you want to invoke.
For each "Call Rule" method, select "Rule-Obj-Report-Definition" as the class and provide the name of the report definition you want to call.
3.Save and Run:
Save the activity, and you can now run it to execute the report definitions in sequence.
When you run the activity, it will call the report definitions one after the other, in the order you have specified in the "Call Rule" methods. The results of each report will be available in the clipboard, and you can further process or use them as needed within the activity.
Keep in mind that calling multiple report definitions in sequence may have an impact on performance, depending on the complexity and size of the reports. If you need to perform operations that require the results of these report definitions simultaneously, you may consider using parallel processing techniques, but that would involve a more complex implementation.....Thank You !!!!
Regenerate