Comparison Previous Year/Current Year

Technical name: 0QT_PA_001

Component of the InfoCube: 0PA_C01

Use

This structure displays the values for the previous year and the current calendar year. It also displays the difference expressed as a percentage and as an absolute value.

Element

Selection/Formula

Previous Year

(&0T_CYEAR&)

Previous year = current calendar year-1

(&0CYEAR&-1)

Current Calendar Year

(&0T_CYEAR&)

Current calendar year = variable current calendar year

(&0CYEAR&)

Difference

Difference = current calendar year-previous year

Difference in %

Difference in % = (current calendar year – previous year) / previous year * 100

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 "Comparison Previous Year/Current Year", the text variable &0T_CYEAR& is used for "previous year" and "current year". When the query is executed, the text variable is replaced by the actual calendar years. For example, "previous year" is replaced by "1999", and "current year" by "2000".