We would like to introduce business Pega report editor too to run some operational reports. Because this tool runs from transactional database we don't want to impact the performance, we would like to use the mirror database and run the reports. My question is can this Pega report editor tool points to PEGADATA schema in mirror database but runs rules from PEGARULES schema?
For reports created on the fly, these are done based on the template reports pyDefaultReport and pyDefaultSummaryReport for that class (or in that class hierarchy). You may want to try enabling this option on those reports and then see.
Please note that you will need to configure the Reports Database for each Data-Admin-DB-Table instance for classes which are available in report editor to create new reports.
I have added Reports Database in my Database table instance. I am able to run the report from the alternate database manually by checking the "Use Alternate Database" checkbox in the report definition. But when I create a new report from Report editor, and see the corresponding report definition, the checkbox "Use Alternate Database" in the Data access tab is unchecked by default.
Is there anything I can do to make this checked automatically in the fly.
As suggested above, I saved the initial report with the checkbox "Use Alternate Database" checked and verified the behavior by running it manually too.
In PDN, I saw this. "For list view and summary view reports, to force the use of a reports database for standard reports (for which the Use alternate database? option is not selected), set the pyUseAlternateDb parameter to true when calling the Rule-Obj-ListView.ShowView or Rule-Obj-SummaryView.ShowView activities.". The activities are the final rules, how can we set the parameter to true.
lot of good information. let me understand onething. If I update pyDefaultReport and summaryreports all the new report definitions will be created in that class will have this alternate checkbox enabled. but how about the existing reports? Is there a way to limit the alternate DB option to only for reports created using report editor tool?
When a developer creates a reports/canned reports i would like to configure where they should run from. please share your thoughts.
Existing reports will have to be manually updated.
When you create a new report in the designer studio, it currently is not defaulted based on the pyDefaultReport or pyDefaultSummaryReport so it would not have "Use alternate database" enabled by default in your case. So as long as they create it in the designer studio, they will be able to toggle whether to use it or not.