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
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