Category Archives: MDX Time calculations

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

Multi select – friendly time calculations in Analysis Services.

Multi select – friendly time calculations in Analysis Services. By Duane Dicks – ditchie@gmail.com SSAS is blessed with a variety of built in time calculations, as well as many methods of creating your own calculations, for when your time dimension … Continue reading

Posted in Analysis Services, MDX Performance, MDX Time calculations, SQL, TSQL | Leave a comment