O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Calculating today's date using the string functions

Calculating today's date is one of those problems every BI developer encounters sooner or later. It is also a repeatedly asked question on Internet forums, probably because books don't cover this topic at all or at least not with concrete examples.

The reason behind this might be in the very nature of the calculation the result of the query executed by a reader on a particular date must inevitably differ from the result shown in the book. An additional reason might be that the implementation of the Date dimension in Adventure Works surely differs in some cases from the Date dimension in a concrete project that the reader is working on. There are just too many options with the formatting of dates. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required