These functions return a time period Member that relate to the current Time period Member.
Syntax
Current( <Dimension> )
Parameters
<Dimension> : A Dimension
Description
Returns the Member in <Dimension> which is currently in context in the query.
Syntax
Prev( <Time Dimension> [, <N>] )
Parameters
<Time Dimension> : A Calendar Time Dimension
<N> : Number of periods.
Description
Returns the Time period Member in <Time Dimension> which is N periods back from the current Member.
Syntax
Next( <Time Dimension> [, <N>] )
Parameters
<Time Dimension> : A Calendar Time Dimension
<N> : Number of periods.
Description
Returns the Time period Member in <Time Dimension> which is N periods after the current Member.
Syntax
ParallelYear( <Time Dimension> [, <N>] )
ParallelQuarter( <Time Dimension> [, <N>] )
ParallelMonth( <Time Dimension> [, <N>] )
Parameters
<Time Dimension> : A Calendar Time Dimension
<N> : Number of periods.
Description
Returns the Time period Member in <Time Dimension> that reperents the same time period as the current Member, in the previous year, quarter or month.
Examples
Consider the following raw data:
| Time | Sales |
| January 1, 2008 | 10 |
| January 2, 2008 | 20 |
| February 1, 2008 | 30 |
| February 2, 2008 | 40 |
| March 1, 2008 | 50 |
Results:
| [Time Month] | [Sales] | ( [Sales], Prev([Time Month]) ) | ( [Sales], Next([Time Month]) ) |
| January | 30 | | 70 |
| February | 70 | 30 | 50 |
| March | 50 | 70 | |
Growth Rate = ( [Sales], PREV([Time Month]) ) / ( [Sales], CURRENT([Time Month]) )
| [Time Days] | [Sales] | ( [Sales], ParallelMonth([Time Days]) ) |
| January 1, 2008 | 10 | |
| January 2, 2008 | 20 | |
| February 1, 2008 | 30 | 10 |
| February 2, 2008 | 40 | 20 |
| March 1, 2008 | 50 | 30 |
Difference from same day previous month =
( [Sales], CURRENT([Time Days]) ) - ( [Sales], PARALLELMONTH([Time Days]) )