Hi
I have developed report in cognos 8.2 report studio.
When i run the report in PDF format it has taken 10 Min's time of size 20 MB.
Where as same report i have run in excel foramt it took 57 Min's of size 80 MB.
Recrds are 2 millions only
Can u please guide how i can meet my performance level.
Cheers
GG
Do you expect anyone to take interest in 20-80 MB management information? These amounts of data are more in the realm of databases, datawarehouses and ETL processes..
Both these are high affinity processess...more over I think excel has a limit of 65,536 rows per page....ask your admin to change the settings and try. ..but I agree with BLOM....
65,536
is the limit for Excel 2002/2003. The latest Excel 2007 version has a much larger capacity, but information is stored in a different format (xlsx).
What I feel is , the output of Excel from a cognos will be 2002 format.