Hi,
I am facing a problem with joins when I am creating a shortcut to a querysubject.
I am creating left outer joins between the tables. When I select data from all the 3 tables it is showing me correct data in report studio report.
Since I had to join the tables A and C so I have created a Shortcut to A and have kept it with C in a folder.
When I select data from table C and A then it is showing me correct data(as per left outer join) in Frameworkmanger(Test sample).When I check the query generated in FM then it is joining only two tables which is what I want. But when i am publishing the package and using the columns from table C and table A, It is giving me different data. When I check the query in report studio I found it contains all the 3 querysubjects even when I am using the queryitems of C and A table.
I have attached the screenshot of the same.
Please help.
Quote from: Joker on 03 Mar 2015 04:02:30 AM
Hi,
I am facing a problem with joins when I am creating a shortcut to a querysubject.
I am creating left outer joins between the tables. When I select data from all the 3 tables it is showing me correct data in report studio report.
Since I had to join the tables A and C so I have created a Shortcut to A and have kept it with C in a folder.
When I select data from table C and A then it is showing me correct data(as per left outer join) in Frameworkmanger(Test sample).When I check the query generated in FM then it is joining only two tables which is what I want. But when i am publishing the package and using the columns from table C and table A, It is giving me different data. When I check the query in report studio I found it contains all the 3 querysubjects even when I am using the queryitems of C and A table.
I have attached the screenshot of the same.
Please help.
My guess would be that the report built in Report Studio is using items from the original Query Subject A rather than the shortcut to Query Subject A? Have you checked your package to make sure that the shortcut to A is included? Have you ensured that the items from A are sourced from the shortcut when building the report?
MF.
Quote from: MFGF on 03 Mar 2015 04:16:49 AM
My guess would be that the report built in Report Studio is using items from the original Query Subject A rather than the shortcut to Query Subject A? Have you checked your package to make sure that the shortcut to A is included? Have you ensured that the items from A are sourced from the shortcut when building the report?
MF.
Hi MFGF,
Thanks a lot Once again. I din not include the shortcut in my package. :P
Regards,
joker