Category Archives: TSQL

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 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 by | 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