Author Topic: Cognos for Excel - limit of 1000 ?  (Read 1097 times)

Offline jerbi

  • Full Member
  • ***
  • Join Date: May 2019
  • Posts: 6
  • Forum Citizenship: +0/-0
Cognos for Excel - limit of 1000 ?
« on: 05 Dec 2019 10:10:09 am »
Hello,

I used Cognos Analysis for Microsoft Excel with Excel 2010 and I had no problem.
I have to install a new server and I would like to install again this solution for a client. I'm with Cognos 11.1 and I have found IBM Planning Analytics for Microsoft Excel. Now I use Excel 2016.

With the same file as before, I can connect and play a query. But when my query bring me back more than 1000 records, I receive a nice error "RSV-SRV-0040 The report server encountered an internal error...". And until 1000 records, it works.

Is there any limit anywhere ?

Thank you for your ideas

Offline jerbi

  • Full Member
  • ***
  • Join Date: May 2019
  • Posts: 6
  • Forum Citizenship: +0/-0
Re: Cognos for Excel - limit of 1000 ?
« Reply #1 on: 09 Dec 2019 10:07:29 am »
Hi,

There is an option in the IBM Planning Analytics menu called "Limit number of lines displayed". The default value is 500, but by increasing this value, my problem is solved. I don't understand the link between the limit observed at 1000 and these 500 but it works.

Bye