Frameworkmanager Join Issue

[Joker]

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.

[MFGF]

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.

[Joker]

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