Dear All,
I'm working cognos 10.2, When I got a cross table report in report studio. I generate report based on resource and client wise data. When I got resource wise data It retrieved correct results but client wise report I got some of the activity Id twice it is results example actual he entered 3 means client wise report I got 6 as result. Rest of the activities are showing exact results. Where is this mistake happened in our cognos or backend software? Here we are using MySQL as back-end. Please help to solve this issue.
Note : When I check manually query to that table it showed exact result like 3.
Thanking you,
Regards,
VIGNESVAR.A
Check your joins as well - sounds like got something linked that's bringing duplicate data
Hi BigChris,
Thank you very much for your quick reply, I will check that but I have a doubt If join problem means we got number of activities going to wrong. I'm a right? Here I got only one activity showing wrong result that means twice it is original value.
Check two things:
1) In your Framework Model, make sure the Associations are set correctly for your Relationships. Like (1-1 or 1-n). Check your business need.
2) Check the Report Query to see which Column is causing the issue. If your Framework Manager Subject Query (Business View) is not showing dups, then it is your Report Query.
Hope this helps. :) :)
Adding filter to 'remove parent entries' may help.
Quote from: gosoccer on 23 Sep 2015 02:53:35 PM
Check two things:
1) In your Framework Model, make sure the Associations are set correctly for your Relationships. Like (1-1 or 1-n). Check your business need.
2) Check the Report Query to see which Column is causing the issue. If your Framework Manager Subject Query (Business View) is not showing dups, then it is your Report Query.
Hope this helps. :) :)
The data that you see in the Business View is only a guideline of how the data will appear and does not guarantee that the same results will be seen in the Reports. The
SQL generated by the report could be very different than what you see in the Model query subjects.
The proper way to test this would be to check the values in both the tables in the DB, check the joins defined in FM between those two tables and check whether it is causing many-to-many joins. Also check whether there is another query that is coming in between and causing that extra data in the report. A cross join can also cause this.
Thank you Team,
Report working fine. Joins were 1..n. Thank you for your reply.
Have a nice day.