Different output for the same RI report when the output format changes. Is this a bug?

Dhanya Saseendran (88●3●12●21) | asked Jan 20 '14, 1:39 a.m.

Hi,

I have been debugging a RI report looking at the .csv format. Because in the csv the result not grouped and I have 5 rows per object. Have been working with an SME on debugging till we ran the report in excel format which showed the correct grouped result. Do you think this can be filed as a bug.. Or is there some technote somewhere explaining this?

I am attaching the screenshots of the excel 2002 and .csv

3 answers

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Dhanya Saseendran (88●3●12●21) | answered Feb 04 '14, 1:34 a.m.

Hi Francesco,

I raised a PMR. But it seems the csv format will only display result of a query. So the above discrepancy is what is expected :)

Please see more in this link

http://pic.dhe.ibm.com/infocenter/cbi/v10r2m1/topic/com.ibm.swg.ba.cognos.ug_cra.10.2.1.1.doc/c_csvformat.html

Thanks

Dhanya

Comments

Francesco Chiossi commented Feb 04 '14, 4:11 a.m.

Hello Dhanya,

thanks a lot for sharing the solution on the forum.

Best Regards,

Francesco Chiossi

permanent link

Francesco Chiossi (5.7k●1●11●19) | answered Jan 20 '14, 5:43 a.m.

Hello Dhanya,

are the 2 screenshots from the exact same report?
I find it a bit strange that the CSV one has a different order in the columns.

Another interesting thing to know would be from which fields of the data model the data come from.

Best Regards,

Francesco Chiossi

Comments

Dhanya Saseendran commented Jan 20 '14, 9:08 a.m. | edited Jan 20 '14, 9:10 a.m.

Hi Francesco,

I ran the report in csv again to get the same result. The difference comes from these facts- The columns that are missing are having hard coded values or having values from the prompts.

Below are the fields of the data model from which the data is coming. Let me know in case you need more details. - Thank you

permanent link

Francesco Chiossi (5.7k●1●11●19) | answered Jan 21 '14, 8:51 a.m.

Hello Dhanya

there are reports around the web of similar issues with Cognos products, but unfortunately with no mentions of a solution:
http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos-impromptu-l/duplicate-rows-in-csv-output-897006
http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos-l/duplicate-rows-in-csv-format-468611

So there might indeed be a problem with the CSV export functionality on some specific cases.
Maybe you should open a PMR and request to verify if this is caused by a Cognos defect.

Best Regards,

Francesco Chiossi

It's all about the answers!

Related questions

Different output for the same RI report when the output format changes. Is this a bug?

3 answers

Your answer