SetFocus BI/SQL Master's Program Tip (from student alumnus question): when PREVMEMBER alone isn't enough in MDX

A rather common requirement in OLAP reporting is to show sales for a specific day, and for the previous day. Using AdventureWorks as an example, if we wanted to see sales by city for a specific date (e.g. March 1, 2004) and then show sales for the previous day (as a generic calculation), we can use the MDX PREVMEMBER statement and write the following MDX code: