Forum Discussion
Using relationships vs merge join difference
hi, i have a question. When to use the relationships ( one to many, one to one , many t omany etccc) and when to use merge join(inner, outer) ? whn we can join two tables using merge join without ...
HI Anonymous,
When tables contains available relationships, you can direct table fields to build visuals and graphs, records which used in visuals will auto analysis and summarize on current category through existed relationship.
If not exists availed relationship, you can't direct use amount field from different tables, they not summarize so you need to write measure with particular filter conditions manually to display correspond summary result.
Regards,
Xiaoxin Sheng