Posted: 30 Jan 2017 21:33 EST Last activity: 16 Oct 2018 12:03 EDT
Report Design Quiz Question SSA 7.2
You are creating a report that uses data from two classes.
You are creating a report that uses data from two classes. Which of the following reporting requirements requires the use of a subreport?
A. Columns to display are: Manager, Name, Count of operators that report to each manager.
B. Columns to display are: Operator Name, Last updated Case ID, Last updated Case Status, Update Date.
C. Columns to display are: Operator Name, Operator Division, Count of Purchase Requests created by the operator. Filter the results by unresolved status.
D. Columns to display are: Operator Name, Operator Division, Count of Purchase Requests created.
You use an aggregate function in a subreport to determine the count of divisions to which the operator belongs.
Why are the other answers wrong?
I ran through the lesson twice, and I'm looking for a clear and concise explanation about differentiating (when to use) between class joins, association rules, and subreports. I understand each concept well but I have trouble with reading a high level and possibly vague scenario and determining which strategy to use.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Answers B, C and D can be created without using two different tables. However in order to create the first report we will need to access the work and operator tables. In addition, we will need to aggregate the data for the operator.
Hope this helps,
Self-Study Support Team
Posted: 5 years ago
Posted: 10 Feb 2017 12:19 EST
Paul Aquino (aquip0916)
I am assuming the Manager and Name come from the Work- table as there are no fields with those name in the other tables. You would need to create a sub report that would count the number of operators that report to each manager. No doubt this is a tricky question.
In addition, the other options available can all be done with one class. All of those properties are available to the class associated with the case (or work). Probably should have used the word class associated with the case rather than work table.
Sorry for the confusion,
Pega Academy Self Study Support Team
Posted: 4 years ago
Posted: 8 Dec 2017 8:50 EST
Yuliana Olkhovska (JuliaO52)
At all, after all this investigations I guess logic should be as following
Subreport S should select from Operator fields:
- F1 = ReportTo - it is OperatorID value of Manager
- F2 = count(OperatorID) - it is count of operators that reports to manager ReportTo directly
where ReportTo is not null
1) join subreport S to the Operator class O on O.OpeartorID = S.F1
2) select fields O.Name (as ManagerName) and S.F2 (as count of operators that reports to manager)
The last concern is that it is not connected with explanation from quiz which says "You use an aggregate function in a subreport to determine the count of divisions to which the operator belongs."