Pivot table columns collapse after reload
Article Number: 000032628 | Last Modified: 2019/10/22
After reload, expanded columns collapse. The layout has stayed after reload till 11.20 SR 7.
In later versions the columns collapse after a reload.
It is necessary to state the collapse/expand information on the load order of the values in the dimension. When the load order is random, a consistent load order needs to be established in the script.
The correct way to secure a consistent behaviour regarding collapse/expand status of a dimension in a pivot table, is to base the collapse/expand information on the load order of the values in the dimension.
The solution is to initially load in the script the field that builds up the dimension so that a consistent load order is established.