The dimension is tagged as “Date-Time”.
The dimension is a single-hierarchy, stored dimension.
The hierarchy is balanced; all level 0 members are of the same generation.
Members are all tagged with the addition (+) consolidator.
Member comment fields for each member contain the following information in the left-most part of the comment. (Details are described in Understanding Date-Time Dimensions.)
The member comment field for the top dimension member includes contains the TI-HIER, TP[ ] specification that contains an array that describes the hierarchy structure.
The member comment field for each member including the top dimension member contains the TI-MBR, TSPAN[ ] specification that includes the date range for the member, with starting date preceding ending date.
Along a generation, date ranges should be contiguous and should increase in ascending order. For example, along the month generation, the date range for each month member must have a starting date that logically follows from the ending date of the previous period. There must be no time gaps, and the span of the parent member must equal the total time span of its children.