On the Input tab you select the input for all the basic dates that should initially be created in the Time dimension table. In the example above, the chosen settings will have this effect:
- Dates will be retrieved from the Posting Date column of the Sales Invoice Line fact table. If other tables contain dates, they should most likely be included in the Date Columns list.
- Dates will be spanned, which basically means that any missing dates in the Date Columns tables will be included as well, according to the From and To
- From Minimum Date and To 36 months ahead means all dates, from the minimum date in the Posting Date column and 36 months ahead of current System date will be spanned.
- The Span Dates option can also be used entirely without any input tables.
Please sign in to leave a comment.