If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to avoid some of the data twice in report studio 10.2

Started by vignesvar, 22 Sep 2015 06:19:33 AM

Previous topic - Next topic

vignesvar

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

BigChris

Check your joins as well - sounds like got something linked that's bringing duplicate data

vignesvar

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. 

gosoccer

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. :) :)


naqsa

Adding filter to 'remove parent entries' may help.

cognostechie

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.

vignesvar

Thank you Team,
   Report working fine. Joins were 1..n. Thank you for your reply.
Have a nice day.