Date/Time Expressions let you a reference a time period or a range of time periods dynamically. These expressions can be created in Calendar Time Dimensions <
> only. These expressions are created in reference to the last member or first member available in the data.
To select one of the pre-defined expressions
- Open the relevant time level node.
- Select one of the expressions nodes under the All member
OR
- Right-Click the level node, navigate to the New Filters menu and pick the requested time expression.

To create a new expression
- Right-click on the time level node and navigate to Time Filters->Custom Range
- Set the number of periods the new expression should return
- Set the numbers of before the last member to begin the count (optional)
- Click Apply

|
Last Year, Last Month (etc) expressions mean the last Member available in the data, not the previous year/month (which are correspondingly called Previous Year and Previous Month).
|