Question
Wipro
US
Last activity: 20 May 2016 7:39 EDT
Report Editor Tool
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?
Sri.
Pegasystems
IN
From 7.1.6, a report definition can run against a "Reports DB" or "Alternate DB" as defined in the Data-Admin-DB-Table instance for that particular class.
Please refer - https://community.pega.com/knowledgebase/release-note/use-alternate-database-report-source
Would this address your issue?
Wipro
US
Will this work with Reporting editor tool as well? I see that it is with report definition rules/list views. How does this work with editor tool where report definitions are created on fly?
Sri.
Pegasystems
IN
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.
Updated: 18 May 2016 21:05 EDT
UHG
US
Hi All,
Michael Inman Rajiv Nistala Celeste Dufresne @
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.
Hi All,
Michael Inman Rajiv Nistala Celeste Dufresne @
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.
Thanks
Susheel
Did you save a copy of "pyDefaultReport" and "pyDefaultSummaryReport" with "Use alternative database" checked in to your class hierarchy that you're trying to create a new report of?
Just to be clear, are you using the Report browser to create a new report (from Case manager portal?) if so you won't be creating Summary Views or List Views, you're creating Report Definitions.
Wipro
US
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.
Sri.
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.