Can some one tell me difference between Association rule and joins in Reports.
Can some one tell me difference between Association rule and joins in Reports. Why should we use associations ?
***Moderator Edit: Vidyaranjan | Updated Categories***
Accepted Solution
Pegasystems Inc.
US
Hello,
As per my knowledge when you can't achieve the result with joins then we can use multiple association.
For example, If you want to join Class A with Class C where you don't have a common column in them, then we use multiple association.
Ideally simple join and association are same.
Hope this might be helpful to you.
Regards
Mahesh
Pegasystems Inc.
IN
Hi,
Both Join and association rule enable report to present data from two related classes. However associationrules work automatically when a manager or developer is building a report.
Please refer the below link for explanation with example
https://docs-previous.pega.com/when-and-how-create-association-rule-support-reporting
IN
Hi Haritha,
Thank you for your reply.I read the article but that didnt give me what exactly i need. I want to understand why should i use associations when i have joins. In you comments you mentioned However associationrules work automatically when a manager or developer is building a report." could you please make it clear , i mean how difeerent it is from joins.
Accepted Solution
Pegasystems Inc.
US
Hello,
As per my knowledge when you can't achieve the result with joins then we can use multiple association.
For example, If you want to join Class A with Class C where you don't have a common column in them, then we use multiple association.
Ideally simple join and association are same.
Hope this might be helpful to you.
Regards
Mahesh
Pegasystems Inc.
US