This is the time to prepare your templates and report structure for the new year! You do not need to create new templates for your report. It is possible to reuse existing templates, updating the dimension members for the new year and ensuring that the formatting does not get skewed while updating the dimension members.
How do you keep the formatting of your templates?
To ensure that the formatting of your templates do not get skewed, you need to ensure that the Design Mode settings of your report are unchecked.
The following steps show how to uncheck the Design Mode settings of your report:
Click on the cog button for the relevant data view on the report you would like to update
Select Properties
Select Settings
Uncheck Map axis member
Note: When Map Axis Member Selection Change is selected, all formatting (font, bold, color, etc.) is tied to the member selection. This means that if you move or remove the member selection, the formatting will be moved or removed with it.
The setting to keep formatting on my template is one of the best things i’ve learned in template studio. It makes updates that much quicker and yes reusing templates becomes easy as well. Great feature.
The setting to Keep Formatting constant or dynamic is really important. We learned it a year or so after implementation and it made a huge difference. I highly recommend making it something very front and center of training when doing implementations.