Localizing Time Dimensions
Configure the time dimensions to display correctly for the locale.
You can configure the displayed format of time dimensions based on locale in the Standard Time Dimensions.cfg file (located by default at Server/Profiles/`<my profile>`/Dataset/Transformation/Time/Standard Time Dimensions.cfg ).
For example, in North America you can express the date May 3rd, 2015 as 5/3/15, or %m/%d/%y . However, in other parts of the world this could be interpreted as %d/%m/%y , or March 5th, 2015 due to an ambiguity in the values. To avoid this situation, an administrator might want to change the displayed format to match the expectations of the users in a locale.
1. Override Default Time Dimensions in Standard Time Dimensions.cfg
To enable this feature, the administrator must override the defaults by either editing the existing time dimensions or by creating new time dimensions with additional parameters.
An example of a modified time dimension follows.
The Format values for Week, Hour, Day, Month, and Hour of Day are set to the defaults in the example.
If these lines are omitted, Data Workbench's behavior won't change and the dimension will be compiled using the defaults.
Transformation Include = TransformationInclude: Extended Dimensions = vector: 1 items 0 = TimeDimensions: Comments = Comment: 0 items Dimensions = map: Day = string: Day Day of Week = string: Day of Week Hour = string: Hour Hour of Day = string: Hour of Day Month = string: Month Week = string: Week Hidden = bool: false Input Time (1970 epoch) = string: x-unixtime Week Format = string: %m/%d/%y Hour Format = string: %x %H:%M Day Format = string: %x Month Format = string: %b '%y Hour Of Day Format = string: %#H:%M Name = string: Visit Time Parent = string: Visit Week Start Day = string: Mon Transformations = vector: 0 items
2. Configure the meta.cfg file
Additionally, it's necessary for the package administrator to add these parameters and their defaults to profile's meta.cfg file. This allows editing from the workstation.
Here's an excerpt from a configured meta.cfg file.
dimensions = vector: 6 items 0 = Template: ... ... 5 = Template: name = string: Time Dimensions value = TimeDimensions: Name = string: Comments = Comment: 0 items Hidden = bool: false Week Format = string: %d/%m/%y Hour Format = string: %x %H:%M Day Format = string: %x Month Format = string: %b '%y Hour Of Day Format = string: %#H:%M</b> Input Time (1970 epoch) = string: Parent = string: Week Start Day = string: Mon Dimensions = map: Hour of Day = string: Hour of Day Day of Week = string: Day of Week Hour = string: Hour Day = string: Day Week = string: Week Month = string: Month
Here is an example of a meta.cfg file in the workstation:
The administrator is then able to go into the File Manager , open the file(s) where the time dimensions are configured (e.g., Standard Time Dimensions.cfg ), and edit them using in the workstation.