Reporting Quiz-3
Hi,
Could you please explain the answer for this question. To me it looks like less information provided in Question:
Which of the following cases would likely require joining classes? (Choose One)
A list of all cases created by operator along with their work status
Average turnaround time of flow actions, categorized by Performer
A list of all cases categorized by the cover ID (pxCoverInsKey) that the cases are part of
A list of all workbasket assignments grouped by the Operator who is performing the action
Posted: 5 years ago
Posted: 5 years ago
Thanks make sense.
Posted: 4 years ago
And another question on the same quiz.
Which of the following requires optimizing a property? (Choose Two)
To use the property as a filter criteria
To display pagelist result in a report
Correct!
To display the property in a column
To improve the performance
Does the lesson actually say that you need to optimize a pagelist before you include it in a report? To me this wasn't explicit.
Thanks
First option - case table will hold properties, pxCreateOperator, pyWorkStatus, pzInsKey, pyID --- all in one table, no need to join.
Second option - all in one table, no need to join. pyPerformActionTime and Performer information is in the same table.
Third option - (correct option) - If you want to display the name of parent case pyLabel, and the pyWorkStatus of the parent case as part of the report so that it's more than just the ID... you would need to join to the table that holds that case info. In many situations this might be a join on the same table by joining pzInsKey with pxCoverInsKey. The instance key is the column we join on, the instance key is not visually appealing or informative to business users. So you will use it to join but display different fields from the parent case and subcases.
Fourth option - all in one table. The assignment workbasket table has that information.