Hi All,
I have 4 tables to join in FM and each table has one filter prompting for user input. When I joined first 3 tables (A innerjoin B lefouterjoin C), I'm able to apply filters and get results. When I join the 4th table with first three tables (A innerjoin B lefouterjoin C innerjoin D), I'm able to get some records in FM using test sample. However in Report studio, when I apply this package, i'm getting trace back error.
There is no center fact table etc. Joins are like A == B += C == D . Can any one tell me does this type of joins work fine or anything that I need to takecare? Thanks in advance.