How to change First day of the week setting after week dimension already created.
its currently greyed out
Solved
How to change First day of the week after week dimension already created
+1- Apprentice Author
Best answer by Jack
Hi
The First day of the week selection is locked once the Week dimension has been created. It's intentional because every block built on top of Week depends on those specifics, so the setting can't be changed in place.
To change it, you'll need to either:
- Delete just the
Weekdimension from Calendar settings, save your changes and re-add it with the newFirst day of the week - Delete and recreate the whole Calendar (only if you want to change other locked Calendar attributes too)
Just to note that either of these choices may result in lost inputs for any Metric dimensioned on Week (or on anything dimensioned on the full Calendar, if you go that route). Any formulas, views, imports or blocks referencing Week or its properties will need a review/rebuild afterwards.
- Employee
- Answer
Hi
The First day of the week selection is locked once the Week dimension has been created. It's intentional because every block built on top of Week depends on those specifics, so the setting can't be changed in place.
To change it, you'll need to either:
- Delete just the
Weekdimension from Calendar settings, save your changes and re-add it with the newFirst day of the week - Delete and recreate the whole Calendar (only if you want to change other locked Calendar attributes too)
Just to note that either of these choices may result in lost inputs for any Metric dimensioned on Week (or on anything dimensioned on the full Calendar, if you go that route). Any formulas, views, imports or blocks referencing Week or its properties will need a review/rebuild afterwards.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.