Cognos for Excel - limit of 1000 ?

[jerbi]

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

[jerbi]

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