Create Time Dimension – FAQ

Frequently Asked Questions (FAQ) about The Create Time Dimension App.

Translations

The app data creation is currently available in the following languages:

  • English
  • Dutch
  • Swedish

If you would like to contribute a translation for another language, please send me the following information:

Language name in both English and local

Example: Swedish, Svenska

Header translations for all table headers in the created table.

Example: ‘id’, ‘DateId’, ‘Date’, ‘Local Date String’, ‘Year’, ‘Month’, ‘Day’, ‘Month Name’, ‘Month Name (Short)’, ‘Weekday’, ‘Weekday (Short)’, ‘Day of Week’, ‘Quarter’, ‘Quarter (format)’, ‘Day Of Year’, ‘Week Number’, ‘Week Number (Format)’

Localized names for all months and day names etc in both full and short form. Also, please indicate if the list starts on Sunday or Monday. 

Example: Weekday names full:  ‘Sunday’, ‘Monday’, ‘Tuesday’, ‘Wednesday’, ‘Thursday’, ‘Friday’, ‘Saturday’

Month names short: ‘Jan’, ‘Feb’, ‘Mrt’, ‘Apr’, ‘Mei’, ‘Jun’, ‘Jul’, ‘Aug’, ‘Sep’, ‘Okt’, ‘Nov’, ‘Dec’

Please send them to me on email stefan at this domain or contact me on any of the social networks linked on the home page. Also, please indicate your web site and Twitter handle etc and I will credit your work.

Recap, please send:

  • Language Name
  • Header column names
  • Weekday names long
  • Weekday names short
  • Month names long
  • Month names short

About Excel 2013 and PowerPivot

This app is available for Excel 2013 but the table it creates is most useful when analyzing data in PowerPivot. PowerPivot is currently only supported in Excel 2013 as part of the Microsoft Office Professional Plus offering. It is not available in Office for Windows RT such as on the Microsoft Surface. PowerPivot is built into Excel but the user interface that was standard in 2010 is not enabled by default.

How to start PowerPivot in Excel 2013 and enable the PowerPivot ribbon

Note that you dont actually have to enable the UI unless you want to use it, or perhaps are used to the interaction model from Excel 2010.

Something looks wonky in the app window

If something looks strange, or perhaps the button doesn’t work properly it might be because the page resources hasn’t been loaded properly. Many JavaScript files are located on alternate, cdn sites. If those files aren’t loaded properly upon opening the app, it might lead to missing functionality. It is possible to reload the app page by right-clicking in the interface and then choose reload.

ctd_reload