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
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
