Table of Contents
Creating Date/Time Expressions Send comments on this topic.

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).