Before running the Create Date-Time Dimension wizard, consider the following points:
What time period must the database model? You must provide the start and end dates.
What type of calendar fits your business use?
What time-period granularity should the database reflect in its outline? Does business analysis drill down to the week level, or can weeks be omitted because reporting is by month or a higher level? Are any business measures analyzed and reported down to the day level? Are semester or trimester breakdowns required?
Would analysis of data within time relationships be valuable? For example, within a business calendar containing quarters, would the ability to see trends for each closing quarter be useful, such as whether sales increase toward the close of each?
The Create Date-Time Dimension wizard is a powerful tool with many options. Consider some practice runs to better understand the dimensions it builds. See also the topics for each page of this wizard in Oracle Essbase Administration Services Online Help.