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.
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
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.