Like what you see? Have a play with our trial version.

Overview

These templates allow you to convert dates and timestamps into various formats, which can then be used to build detailed date drill down hierarchies. The list of available formats will vary depending on source database type.

  1. Select the date format you want in your hierarchy and drag the field into an appropriate category.
  2. Set up the meta data as normal
  3. In the bottom of the tab, select the field parameter you want to base your field on. Some of the formats require a timestamp as input, so the list you can choose from will differ depending on the format.
  4. Format your field as normal and save.

 

 

Possible Fields (based on an SQL Server source connection)

Field

Output Type

Input

Date

Date

Date or Date + Time

Year

Integer

Date or Date + Time

Month

Integer

Date or Date + Time

Month Name

Varchar

Date or Date + Time

Day of Month

Integer

Date or Date + Time

Quarter

Integer

Date or Date + Time

Week of Year

Integer

Date or Date + Time

Day of Year

Integer

Date or Date + Time

Day of Week

Integer

Date or Date + Time

Day Name

Varchar

Date or Date + Time

Hour

Integer

Time

Minute

Integer

Time

Second

Integer

Time

Week Start Date

Date

Date or Date + Time

Week End Date

Date

Date or Date + Time

Month Start Date

Date

Date or Date + Time

Month End Date

Date

Date or Date + Time

Year Start Date

Date

Date or Date + Time

Year End Date

Date

Date or Date + Time

See Drill Down Hierarchies for more information.

 

 

 

  • No labels