4-Quarter Comparison

Technical name: 0QT_PA_009

Component of the InfoCube: 0PA_C01

Use

This structure displays the values for the last four quarters.

In the structure, the calculation starts with the last complete quarter since there are complete values available. A query executed in the second quarter of the year 2000 to compare four quarters would take the values from the four previous complete quarters: 1/00, 4/99, 3/99 and 2/99.

Element

Selection/Formula

Current Quarter -4

(&0T_CQUAT&-4)

Current Quarter -4

(&0CQUART&-4)

Current Quarter -3

(&0T_CQUAT&-3)

Current Quarter -3

(&0CQUART&-3)

Current Quarter -2

(&0T_CQUAT&-2)

Current Quarter -2

(&0CQUART&-2)

Current Quarter -1

(&0T_CQUAT&-1)

Current Quarter -1

(&0CQUART&-1)

In templates/structures that refer to time periods, the time periods are displayed as text variables (such as &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 4-Quarter Comparison, the text variable &0T_CQUAT& is taken to represent the current quarter. When the query is executed, the text variable is replaced by the actual quarters or previous quarters. In other words, according to the calculation rule explained above, a query executed in the third quarter of 2000 would replace current quarter - 1 with "2nd quarter 2000" and current quarter - 2 with "1st quarter 2000 ".