Question & Answer
Question
Error in Planning Analytics for Excel when trying to open a big Excel report that contains millions of cells:
IBM Framework for Office:
Cognos.Office.Tm1.Connections.DataLimitExceededException
Cognos.Office.Tm1.Connections.DataLimitExceededException
Answer
Set CellSetMaxSize parameter located in:
C:\Users\<userid>\AppData\Local\Cognos\Office Connection\CognosOfficeReportingSettings.xml
For example:
<setting name="CellsetMaxSize">5000000</setting>
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m50000000KzKhAAK","label":"Planning Analytics for Microsoft Excel->Reporting"},{"code":"a8m0z000000blfjAAA","label":"Troubleshooting"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
21 September 2021
UID
ibm16398622