About duplicate rows

[priyanka]

Hi,
could anyone please tell what is setting for removing duplicates.In my report,I am using sum function and if...then statement to extract rows but its taking duplicate records i.e instead of taking 4 taking 8 records.and doing sum twice.

[MFGF]

Hi,
could anyone please tell what is setting for removing duplicates.In my report,I am using sum function and if...then statement to extract rows but its taking duplicate records i.e instead of taking 4 taking 8 records.and doing sum twice.

Hi,

You need to provide more info for us to be able to help you. Can you show us an example of the kinds of values in your query, and what is happening vs what you want to happen? What version of Cognos are you using? Is the data relational or dimensional?

MF.

[priyanka]

I am using sum(If ([Product].[Product_line].[STATUS] IN ('Success'))
THEN (1)
ELSE (0) ) .But its extracting 8 records instead of 4.

[MFGF]

I am using sum(If ([Product].[Product_line].[STATUS] IN ('Success'))
THEN (1)
ELSE (0) ) .But its extracting 8 records instead of 4.

You need to provide more info for us to be able to help you. Can you show us an example of the kinds of values in your query, and what is happening vs what you want to happen? What version of Cognos are you using? Is the data relational or dimensional? The above is not an example of the rows in your query, nor is it an example of what is getting returned vs what you want to get returned. We can't see your data or your report. In fact, you haven't answered any of the questions we asked. To help you, I will list some questions below:

What do the 8 records getting returned look like?
What do the 4 records you desire look like?
What items of data exist in your query?
What values exist in each item?
What version of Cognos are you using?
Are you using a relational or a dimensional package?

MF.

[priyanka]

Thanks for reply.My problem is resolved now.Now I need to retain reports in cognos for 1 year.I think for this report vies is required.Could you please tell me how report view is created and should I need to include that in schedule for the report i.e  in option save the report as report view.

[MFGF]

Thanks for reply.My problem is resolved now.Now I need to retain reports in cognos for 1 year.I think for this report vies is required.Could you please tell me how report view is created and should I need to include that in schedule for the report i.e  in option save the report as report view.

What was the resolution?
What version of Cognos BI are you using? Wow - I have asked you that three times now, and still no answer. Why are you so reluctant to divulge even the smallest tidbit of pertinent information? Please answer these questions then we can advise on the best way to create a report view.

MF.

[priyanka]

Sorry .I am using cognos 10.1.1 version.In my reports filter condition was wrong so I was getting wrong records.I used wrong table in filter so getting 8records instead of 4.

[MFGF]

Sorry .I am using cognos 10.1.1 version.In my reports filter condition was wrong so I was getting wrong records.I used wrong table in filter so getting 8records instead of 4.

Now moved to the Cognos 10 board. Why did you post it in the Cognos Analytics (Cognos 11) board if you have 10.1.1?

MF.