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!
If your model is dimensional, you could do this using dimensional functions like previousChild(), etc.
u culd also use functions like ReportDate() and extract functions to get the sysdate, timings .