Time Editor

image_pdfimage_print

The Time Editor is a new feature in the Jedox 7.0 Modeler that allows the user to rapidly create a time-based dimension while defining various settings. Besides generating an element hierarchy based on the user’s settings, the Time Editor will also create several attributes with additional information about the time dimension’s elements.

Enabling the Time Editor

To enable the Time Editor, the user must first assign a specific dimension to the type “Time”. This can be done in the “Advanced” section of a dimension’s properties page.

Please note that after defining the type “Time” for a dimension, the type can not be changed again.

After setting the dimension type, a new tab “Time Editor” will be displayed.

Time Editor Settings

1. Years

Defines the range of the years

2. Levels

Sets the levels for which elements will be created:

  • Year
  • Year – Quarter
  • Year – Quarter -Month
  • Year – Quarter -Month – Month_YTD
  • Year – Quarter -Month – Day
  • Year –Month
  • Year –Month – Month_YTD
  • Year -Month – Day

3. Fiscal Year Start

Setting for additional hierarchy with fiscal year elements.

4. Additional Elements

Creates additional elements for the checked options:

  • Additional Data Element on Year level (yyyy-~)
  • Additional Data Element on Month level (yyyy-MM-~)
  • Additional Global Data Element
  • Opening Period (yyyy-00)
  • Special Periods (possible values: 13, 14, 15, or 16)

5. Current Year Hierarchies

Creates additional elements for the checked options:

  • Year-To-Date: the values of a year will be accumulated from the beginning of the year up to a date.
  • Year-To-Go: the values of a year will be accumulated from a date up to the end of the year.
  • Quarter-To-Date: the values of a quarter will be accumulated from the beginning of the quarter up to a date.
  • Quarter-To-Go: the values of a quarter will be accumulated from a date up to the end of the quarter.
  • Month-To-Date: the values of a months will be accumulated from the beginning of the month up to a date.
  • Month-To-Go: the values of a months will be accumulated from a date up to the end of the month.

6. Rolling Months

Setting for additional hierarchy with rolling months.

7. Weeks: Week hierarchy

Setting for additional hierarchy with week elements.

  • First day of the week:

Defines the 1st day of the week.

  • Minimum of days in first week:

Defines how many days are needed for the 1st week of the year.

8. Mode

  • Extend dimension:

The updated dimension includes all already existing elements and additional the newly created elements.

  • Rebuild dimension:

The updated dimension includes only the newly created elements.

9. Update Dimension

Creates the elements of the time-based dimension according to the settings.

 

Time dimension update procedure

When clicking “Update Dimension”, the dimension is updated based on settings made by the user. If the settings require new elements/hierarchies to be created, they will be inserted into the existing hierarchy accordingly. Note that the Time Editor will not delete any existing elements; if, for example, the user changed the settings to exclude a certain year, data associate with that year is not deleted. After the update has finished, the user will be shown a detailed log of the procedure.

image_pdfimage_print
Was this post helpful?
NoYes (+2 rating, 6 votes)
Loading...