Specifying Latest Period of Time Dimensions

  To define the to-date value for the Dynamic Time Series:

  1. Select the Time dimension in the navigation panel; for example, Year.

  2. In the member select panel, select a member.

  3. Right-click and select View By, and then Dynamic Time Series.

  4. Select a Dynamic Time Series; for example, Q-T-D.

  5. Right-click and select Add to Selection Rules.

  6. In Selection Rules, select the Dynamic Time Series, right-click and select Specify Latest.

  7. From Select Latest Period, select the member for the to-date calculation to be based.

  8. Click OK.

Next, you can define filters to rank or sort the data. Or, if you are finished defining the query, you can apply the query now.

Related Topics

Applying Member Filtering Rules

Deleting Member Selection Rules

Displaying Aliases

Searching for Members

Selecting Attribute Members

Selecting Query Members

Setting the Maximum Number of Members to Preview

Suppressing Shared Members

Using Attributes to Select Base Dimension Members

Viewing Member Information