Different output for the same RI report when the output format changes. Is this a bug?
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
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
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
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
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
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
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