Comparison 4 Quarters

Technical name: 0QT_PE_002

Component of the InfoCube: 0PE_C01

Use

This structure displays the comparison values for the last four quarters.

In the structure, the calculation takes the last complete quarter as its starting point since there are complete values available for it. 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 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 Comparison 4 Quarters, the text variable &0T_CQUAT& is taken to represent the current quarter. When the query is executed, the text variables are replaced by the actual quarters or previous quarters. In other words, according to the calculation rule explained above, in a query executed in the third quarter of 2000, current quarter - 1 would be replaced with 2nd quarter 2000 and current quarter - 2 with 1st quarter 2000.