2 years in same query

[mbrassfi]

Is there a way to a data item that pulls current year information and one that pulls the same information from the prior year, in the same query?

Thanks!

[paddhu]

If your model is dimensional, you could do this using dimensional functions like previousChild(), etc.

[TheDarkKnight]

u culd also use functions like ReportDate() and extract functions to get the sysdate, timings .