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