It's all about the answers!

Ask a question

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


Dhanya Saseendran (8821120) | 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
excel csv

3 answers



permanent link
Dhanya Saseendran (8821120) | 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.7k1719) | 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.7k1719) | 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

Your answer


Register or to post your answer.