It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×12,004
×1,235

question asked: Jan 20 '14, 1:39 a.m.
question was seen: 12,217 times
last updated: Feb 04 '14, 4:11 a.m.

Related questions

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

0
Dhanya Saseendran (88●3●16●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
excel csv

3 answers

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Dhanya Saseendran (88●3●16●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

0
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

0
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

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.