Maximum number of Rows and Columns in Report output

[R Ambre]

Hi All,

Does any one have idea ,how many maximum number columns and rows Cognos report output (For excel and for HTML) support ?
(Crosstab as well as List)

[Lynn]

Hi All,

Does any one have idea ,how many maximum number columns and rows Cognos report output (For excel and for HTML) support ?
(Crosstab as well as List)

Cognos is not an ETL tool. What are you trying to achieve?

[BigChris]

I was going to write something along those lines Lynn, but I knew you'd bite  ;D

Everyone repeat after me....



....COGNOS IS NOT AN ETL TOOL.....COGNOS IS NOT AN ETL TOOL.....COGNOS IS NOT AN ETL TOOL....COGNOS IS NOT AN ETL TOOL....

[Lynn]

 ;D ;D ;D ;D ;D ;D ;D ;D ;D

[R Ambre]

Of Course I know Cognos is not an ETL Tool ;)
In our project we have requirement where user is generating CSV file using Cognos Reports.

# Columns required to render in report are almost 200.
Hence I asked this question.

[BigChris]

But that's not a Cognos report...that's just a data dump. You might as well just get the info from the database. having said all that, I don't know of any restriction in the number of columns you can have.

[Lynn]

Yup, that's a data dump. I would suggest you find out what that user wants to do with all that data to see if there is an alternative solution to their problem that might be more robust and automated than whatever plot they are hatching.

Sadly, there are many short-sighted organizations who take the just-get-it-done-no-matter-how-stupid approach. I feel your pain.

Having said all that, I agree with Chris that I doubt you'll find any stated restriction in terms of columns or rows. The limitations will likely be based on physical file size limitations, or memory required to open the file (which could vary from one user to another), time required to produce/download the file, or other aspects along that line of thinking.

[R Ambre]

Thank you Lynn