Smartview: retain conditional formatting in case of new members in the hierarchy
One of our customers uses an EPBCS report as a basis for his analysis in Smartview. In his ad hoc analysis a lot of conditional formatting has been used to organise the grid and highlight certain figures. In a next session he simply reopens the excel and refreshes smartview to have it's up to date data. However, to also update the metadata (new members added), the hierarchy has to be closed and drilled down again to reveal new members. This would mean that conditional formatting gets lost..
Is there a way to update the hierarchy to the newest meta data and still retain the existing conditional formatting? Thanks for your 2 cents.