Author Archives: ditchie2013

About ditchie2013

A Microsoft SQL Server Analysis Services developer.

Time in Analog using the built in geometry CLR functionality in SQL Server

This is an upgrade to a piece of code that I wrote in 2004 which did the same thing using ascii characters. It can be read here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=33357 See attached document. time in analog using geometry Run the code and … Continue reading

Posted in SQL, TSQL | Leave a comment

MDX Performance improvement on MAX aggregation

Today I offered what I think was quite a clever solution to improve a fellow community members MDX query using a MAX aggregation. It took his query time down from 8 minutes to a fraction of a second 😉   … Continue reading

Posted in Analysis Services, MDX Performance | Leave a comment

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

MDX Scope VS Pre Aggregated measures.

MDX Scope VS Pre Aggregated measures. So I looked into the use of Scope in MDX and compared it to using pre aggregated measures in the cube. I am a big fan of handling any type of row level business … Continue reading

Aside | Posted on | 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