Hi All,
While creating reports i am not getting the data as per the joins created in Fm. It is showing the whole data from the tables without joining data the data from the two tables. I have created joins in Database layer and created query subjects in Business Layer and created shortcuts of them and added to presentation layer in FM.
Thanks
By "whole data" you mean the cross-product of the two tables, i.e. every row in table 1 joined to every row in table 2?
Have you tried running a similar test query in FM and did it work there?
What does the generated SQL look like - does it have a join as you would expect from your model?
Could it be that what you include in the report doesn't need the join in order to satisfy the request? Minimized SQL in action perhaps?
The SQL that gets generated will only use the join when it is needed to satisfy the layout. If you choose a field from table A only it will query table A only. If you choose a field from table A and also a field from table B it will include the join.
It might also be that you are getting an unwanted query split - ie generating a stitch query where it is inappropriate to do so. Did you follow best-practice modelling guidelines when creating the relationships and cardinalities within your model?
MF.