Comparison Last 12 Months and 4 Quarters

Technical name: 0QT_PA_101

Component of the InfoCube: 0PA_C01

Use

This structure shows comparative values over the last twelve months and over the last four quarters.

This structure is used in all Human Resources (HR) Web Cockpits and combines the different time views that are possible in the overview and the individual queries in the Web Cockpit.

Element

Selection/Formula

Last month where postings were made

(&0T_CMNTH&.&0T_MYEAR&)

Eleventh month before the current calendar month = variable eleventh month before the current calendar month

(0CYMONTH-11)

Last month where postings were made

&0T_CMNTH&.&0T_MYEAR&

Tenth month before the current calendar month = variable tenth month before the current calendar month

(0CYMONTH-10)

Last month where postings were made

&0T_CMNTH&.&0T_MYEAR&

Ninth month before the current calendar month = variable ninth month before the current calendar month

(0CYMONTH-9)

Last month where postings were made

&0T_CMNTH&.&0T_MYEAR&

Eighth month before the current calendar month = variable eighth month before the current calendar month

(0CYMONTH-8)

Last month where postings were made

&0T_CMNTH&.&0T_MYEAR&

Seventh month before the current calendar month = variable seventh month before the current calendar month

(0CYMONTH-7)

Last month where postings were made

&0T_CMNTH&.&0T_MYEAR&

Sixth month before the current calendar month = variable sixth month before the current calendar month

(0CYMONTH-6)

Last month where postings were made

&0T_CMNTH&.&0T_MYEAR&

Fifth month before the current calendar month = variable fifth month before the current calendar month

(0CYMONTH-5)

Last month where postings were made

&0T_CMNTH&.&0T_MYEAR&

Fourth month before the current calendar month = variable fourth month before the current calendar month

(0CYMONTH-4)

Last month where postings were made

&0T_CMNTH&.&0T_MYEAR&

Third month before the current calendar month = variable third month before the current calendar month

(0CYMONTH-3)

Last month where postings were made

&0T_CMNTH&.&0T_MYEAR&

Second month before the current calendar month = variable second month before the current calendar month

(0CYMONTH-2)

Last month where postings were made

&0T_CMNTH&.&0T_MYEAR&

Previous month = variable previous month

(0CYMONTH-1)

Last month where postings were made

&0T_CMNTH&.&0T_MYEAR&

Current month = variable current month

(0CYMONTH)

Current quarter

&0T_CQAUT&. Quarter &0T_QYEAR&

Current quarter = current quarter-3

(0QUART-3)

Current quarter

&0T_CQAUT&. Quarter &0T_QYEAR&

Current quarter = current quarter-2

(0QUART-2)

Current quarter

&0T_CQAUT&. Quarter &0T_QYEAR&

Current quarter = current quarter-1

(0QUART-1)

Current quarter

&0T_CQAUT&. Quarter &0T_QYEAR&

Current quarter = current quarter

(0QUART)

In templates/structures that refer to time periods, the time periods are displayed as text variables (&0T_CYEAR&, &0T_CQUAT&) in the structures and the preview. When you execute a query, the actual values (calendar year or quarter) are automatically generated.

In the structure Compare Last 12 Months and 4 Quarters, the text variable &0T_CQAUT&. Quarter &0T_QYEAR& is used for Last month where postings were made and Current quarter. When the query is executed, the text variable is replaced by the actual calendar months or quarters. For example, third month before current calendar month is replaced by 3.2001 and current month by 6.2001.