we recently migrated from PB 12.5 to PB 2017 R2. We noticed that when modifying the SQL of a grid DW and going back in design, all the Footer and Summary computed fields are lost and all the computed columns are moved at the rightmost side of the DW, losing all the formatting.
This is a problem, because all the DW with this problem must be recreated from scratch, and this is very time consuming.
Did anyone else have the same problem? Is there a way to fix/bypass it?
Thank you in advance for your reply