Time dimensions

For transfer of parameters for a time filter, when specifying a separator in the formatting instructions, it is assumed that it is a period limited by the two times specified. If no separator is specified, the specified value is interpreted as an absolute period (day, week, month, quarter, year).

The following characters are supported for separating the day, month and year in a filter value:

Characters

Example

Note

.

24.01.2008

The point may be combined with a space, e.g., 24. 01. 2008

<Space>

24 January 2008

 

/

24/January/2008

Slash may not be used as a separator between two times, e. g.
valid: 01/08/2007-01/09/2007
Invalid: 01/08/2007/01/09/2007

-

24-January-2008

Minus sign may not be used as a separator between two times.
Valid: 24-01-2008/24-01-2008
Invalid: 24-01-2008-24-01-2008

The formatting instructions for time filters should not contain any of the special characters full stop, comma, slash, backslash, and minus sign as these characters will be replaced by spaces during the evaluation If this results in several spaces in succession, these will be replaced by a single space.

Ensure that the parameter expression does not contain any unwanted ambiguities in terms of the separator within a time and the selected separator between two times.

The default formatting instructions for filter values specifying time periods are language-specific and identical to the default formatting instructions used in the filter dialogs of the PPM analysis component.

Default formatting instructions for absolute periods

Depending on the language specified when logging in, the following default formatting instructions apply to the interpretation of time filter specifications for absolute periods (day, week, month, quarter, year):

Default formatting instructions for filter values based on days

Language

Format

Example

Effective time period

German

dd MM yy

01.05.07

1.5.2007, 0:00 to 1.5.2007, 23:59

German

dd M yy

1.5.07

1.5.2007, 0:00 to 1.5.2007, 23:59

German

dd MMMM yy

10. May 07

1.5.2007, 0:00 to 1.5.2007, 23:59

English

dd MM yy

01.05.07

1.5.2007, 0:00 to 1.5.2007, 23:59

English

dd M yy

1.5.07

1.5.2007, 0:00 to 1.5.2007, 23:59

English

dd MMMM yy

10. May 04

1.5.2007, 0:00 to 1.5.2007, 23:59

Default formatting instructions for filter values based on weeks

Language

Format

Example

Effective time period

German

'KW'ww yy

KW10 07

5.3.2007, 0:00 to 11.3.2007, 23:59

German

'KW'ww yyyy

KW10 2007

5.3.2007, 0:00 to 11.3.2007, 23:59

German

'KW'ww/yyyy

KW10/2007

5.3.2007, 0:00 to 11.3.2007, 23:59

German

ww 'WOCHE' yy

10 WOCHE 07

5.3.2007, 0:00 to 11.3.2007, 23:59

German

ww 'WOCHE' yyyy

10 WOCHE 2007

5.3.2007, 0:00 to 11.3.2007, 23:59

English

'CW'ww yy

CW10 07

5.3.2007, 0:00 to 11.3.2007, 23:59

English

'CW'ww yyyy

CW10 2007

5.3.2007, 0:00 to 11.3.2007, 23:59

English

'WEEK' ww yy

WEEK 10 07

5.3.2007, 0:00 to 11.3.2007, 23:59

English

'WEEK' ww yyyy

WEEK 10 2007

5.3.2007, 0:00 to 11.3.2007, 23:59

Default formatting instructions for filter values based on months

Language

Format

Example

Effective time period

German

MM yy

08/07

1.8.2007, 0:00 to 31.8.2007, 23:59

German

MM yyyy

08 2007

1.8.2007, 0:00 to 31.8.2007, 23:59

German

MMM yy

Okt 07

1.10.2007, 0:00 to 31.10.2007, 23:59

German

MMM yyyy

Okt 2007

1.10.2007, 0:00 to 31.10.2007, 23:59

German

MMMM yy

Oktober 07

1.10.2007, 0:00 to 31.10.2007, 23:59

German

MMMM yyyy

October 2007

1.10.2007, 0:00 to 31.10.2007, 23:59

English

MM yy

08/07

1.8.2007, 0:00 to 31.8.2007, 23:59

English

MM yyyy

08 2007

1.8.2007, 0:00 to 31.8.2007, 23:59

English

MMM yy

Oct 07

1.10.2007, 0:00 to 31.10.2007, 23:59

English

MMM yyyy

Oct 2007

1.10.2007, 0:00 to 31.10.2007, 23:59

English

MMMM yy

October 07

1.10.2007, 0:00 to 31.10.2007, 23:59

English

MMMM yyyy

October 2007

1.10.2007, 0:00 to 31.10.2007, 23:59

Default formatting instructions for filter values based on quarters

Language

Format

Example

Effective time period

German

M 'QUARTAL' yy

1. Quartal 07

1.1.2007, 0:00
bis 31.3.2007, 23:59

German

'Q'M yy

Q3/04

1.7.2004, 0:00
bis 31.3.2007, 23:59

German

'Q'M yyyy

Q4-1999

1.10.1999, 0:00
bis 31.3.2007, 23:59

English

'QUARTER' M yy

QUARTER 1 07

1.8.2007, 0:00 to 31.8.2007, 23:59

English

'Q'M yy

Q3/04

1.10.2007, 0:00 to 31.10.2007, 23:59

English

'Q'M yyyy

Q4-1999

1.10.2007, 0:00 to 31.10.2007, 23:59

Default formatting instructions for filter values based on years

Language

Format

Example

Valid period

German
English

yy

07

1.1.2007, 0:00 to 31.12.2007, 23:59

German
English

yyyy

2007

1.1.2007, 0:00 to 31.12.2007, 23:59

If you specify the year with two digits, the previous century is assumed automatically if the resulting year is 80 years in the past. Otherwise, the current century is assumed. If you specify the year with one digit, the constant value 2000 is added.

Example

TIME=2007

Default formatting instructions for discrete periods

If a separator is identified in the formatting instructions, a period limited by the two specified times is assumed. The following default formatting instructions are applicable for specifying the interval limits:

Format

Example

Period

D M yy HH:mm

1/03/04 14:30-2/03/04 8:29

1.3.2004 14:30:00
to 2.3.2004 8:29:59

D MM yy HH

3 04 05 12-5 06 05 15

3.4.2005 12:00:00
to 5.6.2005 15:59:59

D M yy

4-07-03/6-08-03

4.7.2003 0:00:00
to 6.8.2003 23:59:59

ddMMyy HH:mm

010300 12:00-010300 23:40

1.3.2000 12:10:00
to 1.3.2000 23:40:59

ddMMyy HH

070499 8-080499 16

7.4.1999 8:00:00
to 8.4.1999 16:59:59

ddMMyy

040506-050607

4.5.2006 12:00:00 AM
to 5.6.2007 11:59:59 PM

D MMM yy HH:mm

4. Mar 04 7:00-7. Apr 04 14:00

4.3.2004 07:00:00 AM
to 7.4.2004 02:00:59 PM

D MMM yy HH

6-Jun-01 0/24-Dec-01 23

6.1.2001 12:00:00 AM
to 24.12.2001 11:59:59 PM

D MMM yy

14/Mar/70-14/Mar/00

14.3.1970 12:00:00 AM
to 14.3.2000 11:59:59 PM

D MMMM yy HH:mm

4. March 04 7:00-Line break
7. April 04 14:00

4.3.2004 07:00:00 AM
to 7.4.2004 02:00:59 PM

D MMMM yy HH

6-June-01 0/Line break
24-December-01 23

6.1.2001 12:00:00 AM
to 24.12.2001 11:59:59 PM

D MMMM yy

14/March/70-14/March/00

14.3.1970 12:00:00 AM
to 14.3.2000 11:59:59 PM

Example:

TIME:-=010300 12:00-010300 23:40

User-defined formatting instructions

Characters

Meaning

Type

Example

G

Era

Text

AD

Y

Year

Figure

2007

M

Month

Text or figure

July or 07

d

Day

Figure

10

E

Day of the week

Text

Tuesday

D

Day of the year

Figure

365 (corresponds to 31.12.)

F

Day of the week in the current month

Figure

2 (unique with day of the week, e.g., second Tuesday in the current month)

w

Calendar week

Figure

27

W

Week of the month

Figure

4

Examples:

TIME(yyyyMMdd HHmmss):-=20040101 080000-20040824 173000

TIME(dd MMMM yyyy HH:mm:ss):-=01. January 2004 8:00:00-24. August 2004 17:30:00