Adding Relative Dates

Name

Enter the relative date source name.

Description

Enter a description of the relative date.

Reference

Turn on the Most Recent Date radio button to use the most recent data entered in the cube from the source data as the reference date.
Turn on the Least Recent Date radio button to use the first date entered in the cube from the source data as the reference date.
Turn on the From Params radio button to use a date specified as a Build Parameter. Choose a parameter from the list. If you select a parameter whose value does not change when new data is added to the cube, you can have a relative date that also does not change.

Comparison Level

Choose the granularity level; Year, Quarter or Month. The list on the right updates to reflect the selection. It contains all elements corresponding to the selected level of granularity for the specified Simulation data. The relative date is identified in red text.
Click on each element in the list you wish to include in the definition. The elements are all relative to the current relative date.

Remove Intermediate Levels

Turn this checkbox on to disable the incorporation of higher granularity levels than the selected comparison level. The first hierarchy level becomes the comparison level.
Turn this checkbox off to allow the higher granularity levels. For example, if you choose Month for the granularity of the comparison level, years and quarters are included over the months in the hierarchy.

Enable Refinement

If the comparison level is Year or Quarter, turn this checkbox on to incorporate lower levels of detail to the granularity selected within the hierarchy.

Refinement Level

If the granularity for comparison is Year or Quarter and you have enabled Refinement, choose a refinement level from the list. You can only refine at lower levels so if you choose Quarter as the comparison granularity, the only available level of refinement is Month.

From Beginning

Turn on the From Beginning radio button to define a set of elements that start with the first element of the comparison level and ends when the user determines.For example, to compare this period to previous years for a year-to-date relative date, define the comparison level as Year and the refinement level as Month. Then turn on the From Beginning radio button and select from the first month of the year to the current month from the elements in the list.

Last N

Turn on the Last N radio button to define a set of N consecutive elements.For example, to have a relative data that compares the last 12 rotating months, select Month as the refinement level, turn on the Last N radio button, and select the last 12 months from the elements in the list.

Reference

Choose a month and year for the reference date. The reference date highlights in red text in the element lists. Relative shifts are calculated from this date. The default is the current month and year.During cube building, the actual value is substituted for this value. Depending on the reference, this can be the most recent date, the oldest date, or an assigned date.

From

Choose a month and year for the From date for the element lists. This is the lower end of the range for the simulation elements.

To

Choose a month and year for the To date for the element lists. This is the upper end of the range for the simulation elements.

Preview

Preview the result of the relative date definition using the simulation data.