About Yearly report

building reports desktopintelligence
2

You have to bring back column “SYSADM.PS_WFA_WKFRCE_FACT.PER_DIM” as a result object. You can then create local report variables for the years 2004 and 2003 using the Business Objects reporter functions: UserResponse and WHERE

For example:

“Flag - Is Previous Year” defined as:

= <Year of Revenue> = ToNumber (UserResponse (...)) -1

You might have to use the Reporter functions ToNumber or FormatNumber to convert the data types properly.

and “Revenue Previous Year” defined as:

= <measure> WHERE ( <Flag - Is Previous Year> = 1 )

For more information on how to use the WHERE function, check out this Reporter FAQ entry.

Andreas :de: (BOB member since 2002-06-20)