These functions return a time period Member which is an ancestor of the current time Member.

 

Syntax

Year( <Time Dimension> )

Quarter( <Time Dimension> )

Month( <Time Dimension> )

Parameters

<Time Dimension> : A Calendar Time Dimension.

Description

Returns the time period Member that is the year, quarter or month of the current <Time Dimension> Member.

---

Syntax

Parent( <Time Dimension> )

Parameters

<Time Dimension> : A Calendar Time Dimension.

Description

Returns the time period Member that is the direct parent of the current <Time Dimension> Member.

---

Examples

Consider the following raw data:

Time	Sales
February 1, 2008	10
February 2, 2008	20
March 1, 2008	30
March 2, 2008	40
April 1, 2008	50

 

Results:

[Time Month]	[Sales]	( [Sales], Quarter([Time Month]) )	( [Sales], Year([Time Month]) )
February	30	100 {30+70}	150 {30+70+50}
March	70	100 {30+70}	150 {30+70+50}
April	50	50 {50}	150 {30+70+50}

Contribution to year: ( [Sales], CURRENT([Time Month]) ) / ( [Sales], YEAR([Time Month]) )

Contribution to quarter: ( [Sales], CURRENT([Time Month]) ) / ( [Sales], QUARTER([Time Month]) )

Contribution to parent: ( [Sales], CURRENT([Time Month]) ) / ( [Sales], PARENT([Time Month]) )