Report Design Quiz Question SSA 7.2
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.
Accepted Solution
Pegasystems Inc.
US
Paul
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,
Sean
Self-Study Support Team
PwC
UA
Hedes,
Can you please explain why we need here Work- table? The explanation of the answer in quizz makes me even more puzzed. It says
Hedes,
Can you please explain why we need here Work- table? The explanation of the answer in quizz makes me even more puzzed. It says
Correct!You use an aggregate function in a subreport to determine the count of divisions to which the operator belongs.
How count of divisions of operator is connected with "Manager, Name, Count of operators that report to each manager."?
Pegasystems Inc.
US
Julia
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,
Sean
Pega Academy Self Study Support Team
PwC
UA
Sean, thanks for your answer
Just FYI.
In https://collaborate.pega.com/question/subreports-report-design-quiz-ssa-72 I was provided with example from course that indicates which class should be used here. It is Operator class where property RouteTo is Manager ID to which current instance of operator directly reports
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
Report should
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."