Category Archives: MDX Examples

MDX Time Calculation example Last Year equivalent week day

This example runs on the adventureworks 2008 R2 database. It returns last year sales aligning week days ie Last years equivalent Saturday with this years equivalent Saturday etc (generally the type of comparison that a retailer might be interested in). … Continue reading

Posted in Analysis Services, MDX Examples, MDX Time calculations | Leave a comment

MDX Time calculation example LY equivalent day

This example is done on the adventureworks 2008 R2 cube. It shows how to calculate the LY equivalent sales lining the same day of the previous year up with the current day. Example: LY sales for 20130515 will be the … Continue reading

Posted in Analysis Services, MDX Examples, MDX Time calculations | Leave a comment