IBM Support

Dynamic report cannot be generated due to the set expression exceeding 32767 characters

Question & Answer


Question

When customer tries to use PAfE to create a dynamic report he gets the following error.
image 4079

Cause

This is a limitation of Planning Analytics for Excel. 

 

Answer

We recommend defining subsets in the cube view as selecting less elements will help resolving this issue.
  • Launch Architect and open the cube view that was giving the error when opened as dynamic report
  • Double click each dimension and make sure a subset is selected
  • Save the view and try creating the dynamic report again

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m0z000000GoRcAAK","label":"Troubleshooting->Planning Analytics For Excel"}],"ARM Case Number":"TS003791560","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
11 June 2020

UID

ibm16223928